News

T-SQL Smarts -- Preventing Injection Attacks . Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack.
Quickstart: Scale compute in dedicated SQL pool (formerly SQL DW) - T-SQL Scale compute in dedicated SQL pool (formerly SQL DW) using T-SQL and SQL Server Management Studio (SSMS). Scale out compute ...
As you can see, SQL Server 2012 introduces many new and interesting improvements. Many of these functions will be easy to understand for .NET developers since they're borrowed from the .NET Framework.
T-SQL Tips -- GO # and WHILE Loops. Two quick tricks: populating a table with data quickly, and boosting performance with WHILE loops. By Joshua Jones; 07/12/2010 ...