Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in Windows Server

Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance or a SQL Server Availability Group) is regarding an incorrect network binding order.  You will see this presented as a warning in the Cluster Validation Report.  There […]

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 […]

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 […]

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 […]

  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. […]

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, […]

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 […]

I recently had the need to move the quorum for a cluster to a new SAN drive.  It’s a quite simple thing to do, but some of the options and locations of the cluster resources itself are a little hidden in Windows 2008.  Let’s just walk through the basic steps. The first thing you need to do […]

How to create a DSN on Windows 64bit for your 32bit application

How Ryan Adams became a DBA and his involvement in the SQL community