Robert L. Davis

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
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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Health check note on computer keyboard
Jul 28, 2014
Sponsored

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 6

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....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) ×