Articles by Warwick Rudd

Prior to the release of SQL Server 2017, if you were wanting to perform any form of grouped concatenation we..

The decisions we make based on our first impression or first look at someone, a situation, or a problem we are faced with can dictate which path we take next. This may not always be the best course of action to take. In this post I am going to introduce you to a scenario that can easily get you making the incorrect assumptions…….

  Guest Post by Hamish Watson (B|T). This post is a guest post at SQL Masters Consulting. I chose to..

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

With the introduction into the market by Microsoft the Azure data centers around the globe, this has changed the way..

SQL Server 2016 introduced the Query Store, which makes a big difference in assisting us in monitoring and understanding what..

SQL Server 2017 brings some great new features to assist with performance and maintenance out of the box. In this post we are having a look at Resumable Online Index Rebuilds

Database DevOPs is not a new concept, however with the advances in recent times proper attentention to Database DevOPs can make your life easier and be very beneficial to the business

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 Database DevOPs training.

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.