DevX Tips Bank: SQL Server

SQL Injection Tips, Part 3

Language: SQL, Expertise: Intermediate: SQL injection is probably the …

SQL Injection Tips, Part 2

Language: SQL, Expertise: Intermediate: Learn more about how to avoid …

Secure Your Data in SQL 2016 with Row Level Security (RLS)

Language: SQL, Expertise: Advanced - Learn to implement restrictions …

Get a User that has Deleted Rows with SQL

Language: SQL, Expertise: Intermediate - Finding a user who has …

How to Read Environment Variables in SQL Server Using T-SQL

The xp_cmdshell extended stored procedure in SQL Server enables you to read environment …

Displaying the Row Number in a SELECT Query with SQL Server 2005

SQL Server 2005 introduced a function that is very handy when you want the result set …

Retrieving Table Size in SQL Server

Use this handy tip to determine the size of your SQL Server tables, which can be very …

Choosing a Large-Text Data Type for SQL Server Table Columns

SQL Server offers several different data types for storing large amounts of data in table …

Discover Long-Running Queries

Let SQL Server tell you which queries take the longest to run.

Find All User-Defined Functions in a SQL Server Database

This query returns all the user-defined functions in the specified database.

Table Variables Are More Efficient than Temporary Tables In Some Cases

Using @TABLE rather than temporary tables improves performance for small tables …

Rebuild All Table Indexes in a SQL Server Database with One Command

An undocumented stored procedure lets you refresh all the table indexes in a SQL Server …

Explore the Statements and Parameters Passed to SQL Server

Find out exactly what statements and parameters are passed to SQL Server.

Execute a Block of Text in SQL Server Management Studio

In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks …

Executing Marked Text in SQL Server Management Studio

In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks …