I share the settings file for the dark theme I use for presentations in SQL Server Management Studio (SSMS).
Monthly Archive: June 2015
I compare multiple date formatting techniques, demonstrating again that FORMAT() is not worth the convenience.
I show the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.
Microsoft has released Cumulative Update #1 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3067839 121 fixes listed publicly at time of publication (141 total)...
Microsoft has released Cumulative Update #8 for SQL Server 2014. See this blog post for more information. KB Article: KB #3067836 38 fixes listed publicly at time of publication (40 total) Build number is...
For T-SQL Tuesday #67, I describe a new way to track backup and restore operations using Extended Events in SQL Server 2016.
I take a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Tip : Protecting Yourself from SQL Injection in SQL Server – Part 2