DMV

Accessing the registry from TSQL on SQL Server 2012 and 2008R2

by SteveStedman
March 25, 2012March 25, 2012
TSQL, TSQL 2012

With SQL Server versions 2008R2 and 2012, you can access the registry to get the settings for the current instance of SQL Server. Here is how… Read More »Accessing the registry from TSQL on SQL Server 2012 and 2008R2

New DMV in SQL Server 2012 sys.dm_server_services

by SteveStedman
March 23, 2012March 23, 2012
2 Comments
SQL 2012

One of the new Dynamic Management Views introduced in SQL Server 2012 is the dm_server_services which returns info on the services running that are associated with SQL… Read More »New DMV in SQL Server 2012 sys.dm_server_services