Hacks

SQL Server - How to remotely stop, start and list Windows services

August 7st, 2016
0
CLR Monitoring Hacks Database SQL Server

Using sequences in user defined functions in SQL Server

April 28th 2016
0
Database SQL Server Query Development Hacks

SQL Server - Querying instance information in Windows Registry using sys.dm_server_registry and xp_instance_regread

April 23th 2016
0
Hacks DMVs and Catalog Views Little Known Features Database SQL Server

How to retrieve the largest value between multiple columns in a SQL Server table

April 2th 2016
4
Hacks Database SQL Server Query Development

How to identify the port used by the instance of SQL Server

August 30st, 2015
5
Maintenance Hacks DMVs and Catalog Views Database SQL Server

The undocumented SQL Server extended procedures

August 27st, 2015
0
Maintenance Database Hacks SQL Server Little Known Features

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
Little Known Features Integrations Data Formatting and Validation JSON, XML, CSV and Excel Database Query Development SQL Server Hacks