Tip : SQL Server 2016 Advanced JSON Techniques – Part 1

I show some interesting maintenance opportunities for Service Broker queues available in SQL Server 2016.

I talk about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).

I show how to map all of those CONVERT style numbers to specific formats.

I show the most efficient way to return a grouped running MAX or MIN.

In this tip, I dynamically generate msiexec /x commands to use when add/remove programs fails.