Sometimes it’s advantageous to add an index with the same key as another index on the same table.
This query will quickly return database and log sizes for review, and adjustment as necessary.
One of the most important things you can do as a DBA is to keep tabs on the errors reported…
Last summer I set up Change Data Capture for a client to track changes to their application database to apply…
As a DBA, one of the things I struggled with was gathering all my important system information in one place,…
An interesting problem develops when the standard default collation for SQL Server isn’t appropriate. Working with clients here in the…
When SQL Server Agent runs its tasks it normally does so using the context of the service account you assigned…
The most important lesson I learned in flight training was in managing priorities: 1. Aviate 2. Navigate 3. Communicate First,…
One of the first things a pilot is taught is to use checklists. Everything from preflight to tie down after…