"SQL Performance Tuning" will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval.

T-SQL code is highly integrated with the rest of SQL Server. It executes using "native" data types, so data returned from the storage engine doesn't need to undergo expensive type conversions ...

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...

UNSAFE code isn't restricted in any way, including using unmanaged code. Using UNSAFE could compromise SQL Server, so only users who are members of the sql_admins role can even permit UNSAFE ...

David Litchfield, a security researcher, wrote the exploit code that was used as part of the infamous SQL Slammer worm that hit in 2003.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

T-SQL code is highly integrated with the rest of SQL Server. It executes using "native" data types, so data returned from the storage engine doesn't need to undergo expensive type conversions prior to ...