AlwaysOn Availability Groups

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

Arc Enabled Data Services – 11

January 10th, 2023

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

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

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 #456 – Auckland

August 31st, 2015

SQLSaturday is a free day of SQL Server Training, If you are a SQL Server Professional these are great days to come along to learn about SQL Server from Industry focused professionals. This also provides a great day to network with other like minded SQL Server Professionals in your area.

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

SQLSaturday #296โ€“Melbourne

February 26th, 2014

SQLSaturday is coming to Australia again in 2014. This time it kicks off with SQLSaturday #296 in Melbourne on Saturday 5th April. If you are in the Melbourne area and would like some free SQL Server training from some MVP’s, MCM’s and speakers who are well regarded in the SQL Server community then register now.

Read More

Expanding AlwaysOn Availability Groups with Replication Subscribers

January 31st, 2013

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.

Read More
Blog

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.

Search