Who are the sysadmins in SQL Server?

Sysadmins are pretty much powerful in the SQL Server environment. They can put the whole SQL Server infrastructure under their control. That said, it is important to know who else has this fixed server role. Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a […]

Read More »

SQL Server Restart Notification

If you ever wanted to be notified by email when your SQL Servers are restarted, here is a script which will do just that using sp_procoption which sets stored procedures for autoexecution.   What it does: This script sets up a stored procedure in the master database. sp_procoption is used to configure the stored procedure […]

Read More »

Enable Dedicated Administrator Connection in SQL Server 2012

Introduction Microsoft introduced Dedicated Administrator Connection (DAC) feature in SQL Server 2005. Using DAC feature a database administrator can connect to an SQL Server Instance when SQL Server stops responding to normal connections. During such scenarios using DAC feature a DBA can connect to the instance to troubleshoot and kill processes which are causing issues. […]

Read More »