always on

  1. Home
  2. always on
  3. (Page 2)

Why Your SQL Server’s Network Connection Matters

If you’re using SQL Server 2012’s hot new AlwaysOn Availability Groups feature, your databases will go offline when your network connection does – even if you’re using asynchronous replication. This is not a bug.  This is working as designed – and it’s important to understand the underlying concepts. Nothing to see here, I'm just going…
Read More

SQL Server Always On Availability Groups in AWS

Many companies are investigating a move into cloud hosting. With the recent release of SQL Server 2012, these very same companies are also looking at a migration to SQL Server 2012 to take advantage of readable secondaries. Combining Amazon Web Services and SQL Server 2012 seems like a perfect match. Unfortunately, there are some gotchas,…
Read More

An Introduction to SQL Server Clusters

Clustering
335 Comments
The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. Today, I’ll tell you what clusters are, what they’re…
Read More
Menu