There is an old DBA joke, that goes something like this: You either need to have a good backup strategy, or a really good resume. But all joking aside, many people responsible for a SQL Server database find out too …

Do you have the right backup and recovery strategy? Read more »

It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job history to find specific agent jobs that have been run. To help speed that process up, …

TSQL Script to Display Agent Job History Read more »

In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even …

SQL Server – Dedicated Admin Connection (remote DAC) Read more »