Robert L. Davis

Robert L. Davis is a program manager for Microsoft’s SQL Server Master Certification program and was previously a senior production DBA at Microsoft. He's a SQL Server 2008 Certified Master and coauthor of Pro SQL Server 2008 Mirroring (Apress). Follow Robert on Twitter: @SQLSoldier

Articles by Robert L. Davis
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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×