SQL Server Blog

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.

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.

The Data Migration Assistant is the replacement for SQL Server Upgrade Advisor

SQL Saturday #630 is back in town for 2017 in Brisbane

As a data platform guy, I need to be aware of a lot of technologies and how they relate and fit into environments. In this post I will take you through the installation of Power BI Desktop to allow you to start your journey with Power BI.

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.