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.
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.
With the release of SQL Server 2016 RC0, we are looking at what has changed with the installation processes of SQL Server 2016. In particular in this post we are having a look at what has changed with the installation process for Management tools. Read more…..
We are getting closer to the actual release of SQL Server 2016. Are you getting excited about what is coming? In this article we have a look at what is new with SQL Server 2016 Release Candidate 0 that is now available for download. Read more ……
SQL Server 2016 is introducing a new feature Live Query Statistics (LQS) to assist you by providing visible live query statistics of your SQL statements from within SQL Server Management Studio. In this article Warwick introduces you to the feature and shows that using SSMS 2016 against a SQL Server 2014 Instance the new feature can be used.
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.