Robert L. Davis

Robert L.
Davis
2 7 9

Robert is currently working as a Principal Database Architect at DB Best Technologies.

He is a SQL Server Certified Master, MVP, and an experienced DBA, evangelist, speaker, writer, and trainer. He has worked with SQL Server for 15+ years. He recently worked for Outerwall, Idera Software, and Microsoft, He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.
 
Robert is co-founder and co-leader of the PASS Security Virtual Chapter.

Specialties:

Performance tuning, troubleshooting, disaster recovery, high availability, T-SQL

Current Roles:

Principal Database Architect

Education:

Microsoft Certified Master, Microsoft

Certifications:

SQL Server MVP, Microsoft

 

Articles
Your First Public Presentation 1

Making Your First Public Presentation

Have you ever found yourself sitting at a conference like the SQL PASS Summit or your local SQL Saturday listening to a dynamic speaker making a complex topic seem simple and found yourself thinking that you wish you could do that? If you are like me, you have.

Being a Good #SQLHelp(er)
If you are active on Twitter, you may have found your way to the SQLHelp hash tag and seen the high level of interaction. SQLHelp has become a popular method of getting quick answers to SQL questions.
diagram of asynchronous mirroring
Database Mirroring for Disaster Recovery 5
If you’re currently using log shipping for disaster recovery, consider using asynchronous mirroring instead. Asynchronous mirroring offers enhanced manageability and more features, making it an attractive option.
Comparative Review: Database Schema Comparison Tools 2
The author tests four tools for comparing database schemas: Red Gate Software’s SQL Compare 9.0, ApexSQL’s ApexSQL Diff, xSQL Software’s xSQL Object, and Microsoft Visual Studio 2010 Ultimate’s Schema Compare tool.
Screenshot of SQL Server Log Shipping example
3 Log Shipping Techniques
Although log shipping isn’t as widely used as it once was, it’s still a vital tool that has many applications. Here are three techniques that can save you time and make working with log shipping painless.
Hardening SQL Server 3
You can better protect your SQL Server instances and the data they contain by reducing their surface area and controlling access to them. Here’s how.
Review: ScriptLogic Security Explorer for SQL Server
With Security Explorer, you can manage security for the whole enterprise, not just SQL Server.
Comments
Using Windows Server Failover Clustering with SQL Server: Are You Clusterphobic?
October 11, 2014

Clustering does NOT require Enterprise for anything. Nor does it require SA. Clustering is fully supported on Standard Edition of Windows Server 2012 R2 and has been supported...

Setting permissions on a database mirror database snapshot
March 13, 2012
One caveat to remember is that if they have access to the principal server through another login, they will get the permissions of that user in the database even though they are...
Vendor-mandated regular database shrinking
December 1, 2011
One of my [least] favorite arguments is, "I read on a blog post that it's not that bad." This was actually in regards to using clustered nonsequential GUIDs on all...
Comparative Review: Database Schema Comparison Tools
September 15, 2011
Thanks SQLFRNDZ! i like your article. It goes into a depth level I could not with this type of article.
Hardening SQL Server
September 15, 2011
Hi dbird, thanks for the comment! Definitely, the older it the SQL Server version, the harder it is to add different components. This is an area where the SQL team have made...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....More
Feb 12, 2016
blog

Your Data’s Rate of Decay

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×