SQL Server Blog

22 January 2018

Why I've Joined SQL Masters Consulting as a Data Platform Consultant

22 December 2017

SQL Server 2017 STRING_AGG

Comparison with For XML Path

15 December 2017

Life and Technology

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

23 November 2017

Your data is at risk .......

...... because of FearOps

22 November 2017

Master Class Training Schedule - 2018

SQL Server Always On: The Senior DBA's Field Guide

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

8 October 2017

Azure VM Sizes for your SQL Server Workloads

12 September 2017

SQL Server 2017 – Automatic Tuning

12 September 2017

SQL Server 2017 – Resumable Online Index rebuilds

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

14 August 2017

Embracing Database DevOPs

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

21 July 2017

SQLSaturday Auckland #655 – DevOPs Precon

Creating a Database Deployment pipeline using DevOPs

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.

21 July 2017

SQLSaturday Auckland #655 - HA/DR Precon

Guide to HA/DR That can save your Bacon

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.

5 July 2017

SQL Server 2017: Read Scale-Out Availability Group

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

5 July 2017

Configuring Availability Groups to use Certificates

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.

5 July 2017

How to build a Non-Domain Cluster

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.

5 July 2017

Data Migration Assistant

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

12345678910 Last
Scroll to Top