High Availability and Disaster Recovery (HA/DR) is an area that every SQL Server DBA needs to be comfortable with, especially when dealing with mission-critical database systems. One cannot wait until a real disaster strikes before learning how to deal with it. This advanced, deep-dive course is designed for SQL Server DBAs and system administrators to […]
Last year, I started writing an article that was supposed to be a series for Installing, Configuring and Managing Windows Server Failover Cluster using Windows PowerShell. The first of the series came out on July 2013 (which ended up being the last article I wrote for the year 2013 on MSSQLTips.com.) Since then, I’ve been involved […]
This is a recording of the Microsoft Canada TechDays TV episode I back in 20-Mar-2012. The video walks you thru converting your database mirroring and log shipping configurations to SQL Server 2012 Always On Availability groups, providing database availability and maximizing your investments by allowing read-only access to database replicas. You can download the resources […]
If you’ve been playing with SQL Server “Denali” AlwaysOn, you probably have seen the new PowerShell cmdlets for managing the new AlwaysOn feature. However, as SQL Server 2012 RC0 has been made available for download, you need to watch out for these “breaking changes” for AlwaysOn (I call them breaking changes because if you are […]
In my previous blog post, I talked about high availablity and disaster recovery (HADR) and how it is more than just the underlying technology that keeps the entire strategy intact. In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I […]
