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

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

Speaking at SQL PASS Summit 2014 29 Jun 2014
I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering a half day session on administering BI systems and a regular session on techniques for indexing. If you were selected to speak this year, congratulations. I look forward to attending many of your ...