SQL Server Blog

The Data Platform has expanded – your usage & knowledge of it needs to as well

February 27th, 2018

In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Services..

Read More

SQLSaturday 725–Victoria, Canada

February 2nd, 2018

SQLSaturday is in town for he first time in Victoria, Canada on Saturday March 03, 2018. As such the SQL..

Read More

SQL Server 2017 STRING_AGG

December 21st, 2017

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

Read More

SQL Server 2017 – Automatic Tuning

September 11th, 2017

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

Read More

SQL Server 2017 – Resumable Online Index rebuilds

September 11th, 2017

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

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

SQL Server on Linux

March 9th, 2016

Microsoft has made a huge announcement about SQL Server on Linux. Read more ……

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