Robert_L_Davis.jpg

Robert L Davis

Robert L Davis is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for more than 13 years, and recently started his own consulting company, SQL DBA Master. He recently served as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software. Prior to that he served as Program Manager for the SQL Server Certified Master Program and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter, was the primary author of "Pro SQL Server 2008 Mirroring," and was a Charter Member of the Idera ACEs program. He often speaks at SQL Server events and writes articles and product reviews for SQL Server Magazine. Robert is married, has two German Shepherds, and is an avid writer, blogging about SQL Server at http://www.SQLSoldier.com and writing horror fiction. You can find him on Twitter as @SQLSoldier.
http://www.sqldbamaster.com http://feeds.feedburner.com/Sqlsoldier?format=xml

Blog posts RSS

Return Max or Min Value of a Group of Columns as a Single Column 16 Jun 2016
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to provide a list ...

AG Worker Thread Blocked by Log Backup 06 Jun 2016
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email stating that system thread with session ID 44 had been blocked for at least 599 seconds (10 minutes, basically). This was in the middle of the night, and I looked into the ...

Attendee Questions from My #24HoP Presentation 02 Jun 2016
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate the questions that were asked. We did not have time for all questions, so I want to answer all of the questions here. Some of these were answered in the session, but not all. Q1: I see ...

What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it? 01 Jun 2016
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the one database onto a LUN for another database. I blame an errant mouse-click. As soon as I deleted the LUN, I realized the name was wrong. The LUN held the log file for a production database. ...

What is the max/min size of a decimal data type? 01 Jun 2016
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and email a report of identity columns that are approaching the limits of their data type. The minimum and maximum values for most numerical data types are documented in Books online, but ...