Clustering
-
Architecture VC AlwaysOn Questions Answered
On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. Obviously we focused on the technology from an architectural standpoint. We discussed a lot of things that come into play when designing an AlwaysOn infrastructure whether it be FCIs and/or AGs. We answered questions…
-
SQL HA and DR Training in Oklahoma City
I’ll be doing a precon for SQLSaturday #422 in Oklahoma City on August 28th, 2015 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Precon in Columbus OH
I’ll be doing a precon for SQLSaturday #421 in Columbus Ohio on July 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Planning a High Availability and Disaster Recovery Plan in Puerto Rico
I’ll be doing a precon for SQLSaturday #373 in Puerto Rico on May 8th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Planning a High Availability and Disaster Recovery Plan in Madison, WI
I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
PASS 24HOP AlwaysOn Questions Answered
I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event. You can view the session recording HERE if you missed it. The session was a preview of the full session I will be presenting at the PASS Summit 2014 this November. I will be presenting the full…
-
HA and DR Precon in Denver
I’ll be doing a precon for SQLSaturday #331 in Denver Colorado on September 19th, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups, and more.…
-
HA and DR Precon in Baton Rouge
I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups,…
-
Cannot Failover Nodes Using TempDB on Local Storage
I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature. If you are unfamiliar with the new feature in SQL 2012 that allows you store TempDB on a local drive in a failover cluster you can read more here. Here is a screen…
-
Local TempDB on SQL 2012
This post has been sitting in the draft folder for way too long, March of last year to be precise. So although this is no longer new information, it has not been talked about all that much. I’m talking about the new feature in SQL Server 2012 that allows you to put TempDB on local…
-
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive. Let’s just walk through the basic steps. The first thing you need to do is get the new drive added to the cluster and…
-
syspolicy_purge_history Job Fails
The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists of the following three steps. First to check to see if PBM is enabled and exit if it is not. Run the msdb.dbo.sp_syspolicy_purge_history system stored procedure to clear the history Use…