Monthly Archives: March 2015

*Let me start with a disclaimer, this is not the right solution for most people.* So I ran into a situation where most times a OLTP database was using only 20MB of log space at a time.  I’ll have to … Continue reading →

I went to the SQL Saturday in Richmond, had a fabulous time, my first time at a SQL Saturday.  PASS (Professional Association of SQL Server http://www.sqlpass.org/) and the local user SQL Server user groups help organize the SQL Saturday events, vendors help … Continue reading →

One of the first tools that was a lifesaver in my role as an Accidental DBA was sp_whoisactive from Adam Machanic.  The situation was SQL server was unresponsive and we were trying to sort out what was happening.  The Activity … Continue reading →

I heard the term “Accidental DBA” and knew there were kindred souls out there.  For me has worked out as, “You’re not afraid of the database? Congratulations, you’re the new expert.”  This always made me feel like something was wrong, after … Continue reading →