SQL Server 2016 Advanced JSON Techniques – Part 1
Tip : SQL Server 2016 Advanced JSON Techniques – Part 1
Monthly Archive: October 2015
Service Broker Enhancements in SQL Server 2016
I show some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.
New SERVERPROPERTY Options to Help Phase Out @@VERSION
I talk about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Build a cheat sheet for SQL Server date and time formats
Tip : Build a cheat sheet for SQL Server date and time formats
Maintaining a grouped running MAX (or MIN)
I show the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.
Cleanly Uninstalling Stubborn SQL Server Components
Tip : Cleanly Uninstalling Stubborn SQL Server Components