Making SSMS Pretty : My Dark Theme
I share the settings file for the dark theme I use for presentations in SQL Server Management Studio (SSMS).
Monthly Archive: June 2015
FORMAT() is nice and all, but…
I compare multiple date formatting techniques, demonstrating again that FORMAT() is not worth the convenience.
SQL Server 2016 : sys.dm_exec_function_stats
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.
SQL Server 2014 Service Pack 1 Cumulative Update #1 is available!
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)...
SQL Server 2014 RTM Cumulative Update #8 is available!
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...
T-SQL Tuesday #67 : New Backup and Restore Extended Events
For T-SQL Tuesday #67, I describe a new way to track backup and restore operations using Extended Events in SQL Server 2016.
How not to call Hekaton natively-compiled stored procedures
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.
Protecting Yourself from SQL Injection in SQL Server – Part 2
Tip : Protecting Yourself from SQL Injection in SQL Server – Part 2