SQL Server with Mr. Denny:

High Availability

August 10, 2016  4:00 PM

It’s the cloud, it’s highly available. Do I need to worry about HA and DR?

Denny Cherry Denny Cherry Profile: Denny Cherry
Cloud Computing, Clustering/High availability, High Availability

Short answer: Yes. While yes the cloud is highly available and services that are taking offline due to hardware failures, host server reboots due to patching, etc. can your application survive being down for several minutes in the middle of the day?

August 1, 2016  4:00 PM

SQL Azure != SQL Server

Denny Cherry Denny Cherry Profile: Denny Cherry
AWS, AWS EC2, Azure, Capacity planning, Disaster Recovery, High Availability, SQL Azure, SQL Database, SQL Server, Windows Azure

This may come as shocking news to some, but Microsoft SQL Server and Microsoft Azure SQL DB (Azure SQL Database, Azure SQL DB, SQL Azure Database, or whatever name you know it as) are very much not the same thing.  They may look similar and they may act similar, but they are very much not the same...

October 7, 2015  4:00 PM

Basic Database Mirroring Monitoring

Denny Cherry Denny Cherry Profile: Denny Cherry
Database mirroring, Disaster Recovery, DR, High Availability, Monitoring, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

If you have database mirroring setup and running, you'll notice that it has a lack of built in monitoring. And if you have a lot of databases having monitoring for each potential state that each database can be in can flood you with email if the network between sites goes down and comes back up. ...

July 22, 2015  6:00 PM

Updating All Jobs To Check For AG Primary Replica

Denny Cherry Denny Cherry Profile: Denny Cherry
High Availability, Job scheduling, SQL job scheduler, SQL scripts, SQL Server

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each server, then modify the jobs on each server to...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: