More in Database High Availability

  • Nov 17, 2011

    SQL Server 2012 Release Candidate Offers New Capabilities

    Microsoft's SQL Server 2012 Release Candidate 0 is now available for download and include new capabilities over the SQL Server Denali CTP3 release....More
  • Hints and Tips yellow road sign
    Sep 19, 2011

    Practical Tips for Initializing Replication Snapshots

    I’ve recently spent a bit of time helping a client initialize snapshots for a number of production databases....More
  • Aug 29, 2011

    Reasons not to configure automatic failover for database mirroring

    There are a few reasons why you may choose not to configure automatic failover....More
  • datacenter switch showing multiple white cords
    Aug 2, 2011

    An Overview of SQL Server High Availability Options 2

    There’s no doubt that availability is one of the most important if not the most important job for the database administrator. However, choosing the right options isn’t always easy because there’s a lot of different options and each is designed for a different purpose....More
  • Jun 29, 2011

    Don’t Confuse High Availability with Disaster Recovery

    I recently spoke at WindowsIT Pro’s Keeping Mission-Critical Applications Available online event. My session, High Availability Isn’t Disaster Recovery, focused on a number of topics and concepts to the point where I wanted to provide a blog post with additional resources and links....More

From the Blogs
detetecitve dressed in black looking at data
Sep 24, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 7: Detecting Primary Replica Ownership

In my mind, there are two logical ways that you might want to have your code check to see if the Primary Replica of a given AG database is currently hosted on a particular server or not...More
Two women looking a man's computer monitor
Sep 17, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....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) ×