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

T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed 09 Aug 2016
It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall (Blog|@sqlrnnr). Jason has challenged us to spend some time sharpening a skill and then blog about it. For my participation, I found myself needing to get ...

T-SQL Tuesday #80 – SQL Birthday Present 12 Jul 2016
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and happens to fall on the hosts birthday. First order of business is to wish our host, Chris Yates (blog|@YatesSQL), a very happy birthday! The next order of business is to hand out ...

Possible Infinite Recompile Was Detected for SQLHANDLE 01 Jul 2016
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log. Sounds bad, but they never lined up with any detected errors or failures, and I always seemed to have more important things to focus on so I let it slide. Well, today was a slow day — being the ...

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 ...