Protecting Yourself from SQL Injection in SQL Server – Part 1
Tip : Protecting Yourself from SQL Injection in SQL Server – Part 1
Monthly Archive: May 2015
Tracing Usage of Trace Flags
After a presentation at SQLintersection, I show how to monitor when users are turning trace flags on and off.
Query Data from Extended Events in SQL Server
Tip : Query Data from Extended Events in SQL Server
T-SQL Tuesday #66 : Babysitting a Slow Backup or Restore
For T-SQL Tuesday, I discuss undocumented trace flags that provide additional diagnostics to troubleshoot slow backup or restore operations.
SQL Server 2016 : JSON Support
I walk through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.
COD Hotfixes available for SQL Server 2014 (SSIS Unpivot and Clustered Columnstore)
Microsoft has released a hotfix (12.0.2504) which includes two fixes. KB #2999809 : FIX: Poor performance when a query contains table joins in SQL Server 2014 – this actually has to do with segment...