Robert L. Davis

Robert L.
Davis
5 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
Jul 17, 2017
Sponsored

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×