High Availability

So far in this series of posts, you have been able to deploy and configure your newly provisioned Azure Arc-enabled..

SQLSaturday is back in town in Wellington for the first time since April 14, 2012 (SQLSaturday 136) when it was..

We are pleased to announce the Master Class Schedule for 2018. This In Person Instructure led training is delivered by International renowned Consultant, Presenter and Trainer – Edwin Sarmiento here in Brisbane in February 2018. Find out more to register for you seat on this training course only available 1 time in Australia in 2018……

SQLSaturday Auckland #655 is on Saturday 2nd September, 2017 in Auckland. As part of this event on Friday 1st September 2017 you can register for a full day of HA/DR training.

SQL Server brings another enhancement to Availability Groups for us to use resources more appropriately.

With the release of SQL Server 2016 and Windows Server 2016, we are able to create Availability Groups across domains or in Non-Domain environments. To achieve this we need to use certificates for each instance in the Availability Group to be able to communicate with each other.

With the release of WIndows Server 2016 & SQL Server 2016, we received the support for a Non-Domain Cluster allowing us to create an Availability Group on workgroup servers.

Applying SQL Server Services Packs to your environment is very important. The approach on when to apply service packs has changed over time, and makes it very important to have the process included into your support windows. This post takes you through how to apply a Service Pack into an Availability Group environment.

SQLSaturday 509 in Brisbane is bring your a precon event on Friday 27th May, 2016 as part of the SQLSaturday event. Registrations are open.

Managing Security with AlwasyOn Availability Groups needs some extra time and consideration for the environment to work. In this T-SQL Tuesday article Warwick talks about some of the things that need to be considered and implemented to allow for this to work in your AG Environment. Read on …..

SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. How many database can you reasonable add? it depends on the resources available and the workload, but you can come up with a reasonable estimate as Warwick explains

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has been around in SQL Server for quite some time and allows you to scale out your environment. Warwick Rudd explains how to join these technologies together.