SQL Server - How to remotely stop, start and list Windows services August 7st, 2016 0 Database CLR Hacks Monitoring SQL Server
Using sequences in user defined functions in SQL Server April 28 2016 0 Database Query Development Hacks SQL Server
SQL Server - Querying instance information in Windows Registry using sys.dm_server_registry and xp_instance_regread April 23 2016 0 Database DMVs and Catalog Views Little Known Features Hacks SQL Server
How to retrieve the largest value between multiple columns in a SQL Server table April 2 2016 4 Database Query Development Hacks SQL Server
How to identify the port used by the instance of SQL Server August 30st, 2015 3 Database DMVs and Catalog Views Hacks Maintenance SQL Server
The undocumented SQL Server extended procedures August 27st, 2015 0 Database Little Known Features Hacks Maintenance SQL Server
How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing to the bank and exporting to XML 25 July 2015 3 Database Query Development Data Formatting and Validation Little Known Features Hacks Easy SQL Server