Disaster Recovery

Arc Enabled Data Services – 12

January 10th, 2023

In the previous post, we introduced you to how Azure Arc-enabled SQL MI provides High Availability based on the tier..

Read More

SQLSaturday 706–Wellington

January 29th, 2018

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

Read More

Master Class Training Schedule – 2018

November 21st, 2017

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

Read More

SQLSaturday Auckland #655 – HA/DR Precon

July 20th, 2017

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.

Read More

SQL Server 2017: Read Scale-Out Availability Group

July 4th, 2017

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

Read More

Configuring Availability Groups to use Certificates

July 4th, 2017

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.

Read More

How to build a Non-Domain Cluster

July 4th, 2017

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.

Read More

Applying SQL Server Service Packs

April 1st, 2017

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.

Read More

SQLSaturday 509 Brisbane

March 2nd, 2016

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

Read More

Tail of the Log

August 20th, 2015

Tail of the Log is an important aspect of SQL Server databases for recovery purposes. In this article Warwick will introduce you to what it is and how to make it useful to you in your environment.

Read More

T-SQL Tuesday #63 – How do you Manage Security

February 3rd, 2015

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

Read More

AlwaysOn Availability Groups: What not to do when adding databases

April 6th, 2014

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

Read More

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.