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

Oklahoma City User Group Presentation Files 14 Jul 2015
Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL Server Mythconceptions and Mythteries. The files from my presentation are attached below for download. The zip file contains my slide deck and demo code from the session. ...

Error Creating Remote Distributor When Creating a Local Distributor 16 Apr 2015
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the replication ...

T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode 14 Apr 2015
It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you want to join in the blog party, take a look at Mike’s announcement for an explanation of the topic and rules for participating: T-SQL Tuesday #065 – Teach ...

Patching Master Data Services 13 Apr 2015
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS front-end on a new server with the intent to use an existing SQL Server 2014 (Enterprise Edition) database engine for the back-end. Unsurprisingly, I ran into some ...

Performance Counters: Why It Depends 18 Aug 2014
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to ...