Tag Archives: high availability

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

Failover

Posted on July 29, 2016 by

I saw a note from someone that had a database set up in a High Availability (HA) configuration for production. This person had received an 823 error on the primary server, but a failover hadn’t occurred. This wasn’t a critical … Continue reading →

Posted in Editorial | Tagged

Zero Downtime for 2016

Posted on February 15, 2016 by

I’ve never felt that zero downtime is possible for a system over any length of time. There are no shortage of companies that seek to prove me wrong, and some are doing very well. For example, when is the last … Continue reading →

Posted in Editorial | Tagged ,

T-SQL Tuesday #60 – Something New Learned

Posted on November 11, 2014 by

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL Tuesday party, started by Adam Machanic (B|T)., has been amazing and lots of fun for me. This month, Chris Yates … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Multiple AGs

Posted on November 4, 2014 by

Today was my pre-con with Allan Hirt on AlwaysOn. It was great, and I learned a few things. I knew a bit about AGs, but Allan has a ton of experience, and he talked about some architectural things that I … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Downtime

Posted on March 3, 2014 by

Most of us that work with technology hate downtime. We don’t want a system that we’re using to go down. We don’t want any software that we depend on to fail when we need it. Most of all, we don’t … Continue reading →

Posted in Editorial | Tagged , ,

The Decision to Fail

Posted on June 7, 2013 by

We have a number of automated technologies that we can us to seamlessly move from primary to secondary systems without human intervention. SQL Server incorporates a number of these, and many companies use them to ensure their applications are highly available. However things don’t … Continue reading →

Posted in Editorial | Tagged ,

Understanding HA

Posted on May 22, 2013 by

I’ve learned a lot about high availability (HA) and disaster recovery (DR) over the last two decades. Some of the things I’ve learned were from studying, some from experimentation and practice, and a few from hard lessons when some part of a … Continue reading →

Posted in Editorial | Tagged ,

AlwaysOn and Contained Databases in SQL Server 2012

Posted on July 14, 2012 by

This talk is mostly based on contained databases in SQL Server 2012. The first part of the talk goes over the problems with current database movement, the idea of containment, and the implementation in SQL Server 2012. There are demos … Continue reading →

Posted in Presentations | Tagged , , , | 1 Comment

The High Availability Poll

Posted on June 29, 2012 by

The cost of building highly available databases dropped with the introduction of Database Mirroring in 2005. Without the need to purchase identical hardware for a spare system, it became much easier and less expensive to set up extra systems that … Continue reading →

Posted in Editorial | Tagged | 2 Comments