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