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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
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
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) ×