Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was
April 7, 2015
Author: Jason Brimhall
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index
January 21, 2015
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason
January 6, 2015
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That
November 20, 2014
Capture the Flag – Trace Flags
One of the things that would be nice to know is around the trace flags that can be enabled in
November 11, 2014
ArithAbort and SQL Agent Failures
A mystery staring arithabort. I was coding along one day, working on rolling out some monitoring for a client—monitoring that
August 5, 2014
Synonyms in SQL Server – Good and Bad
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server
July 1, 2014