Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.
I tested this on a SQL Server 2008 instance, having a normal connection, as seen in the lower status bar:
Right click in the query window, and select “Change Connection”. In the dialog, now add the text “Admin:” before the server name, as shown below.
When you connect, you’ll have an admin connection, which you can see in the status bar.
Pretty cool.