Robert L. Davis

Robert L.
Davis
0 6 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
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 4
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 2
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 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
Mar 17, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 6

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....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) ×