SQL 2016
-
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read on the internet so this video is aimed at both answering the questions and debunking some false information you might find out there. We want concrete answers to the following questions, so we’ll demonstrate them…
-
SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download a preview now. I am on a technical list where I saw someone inquire about the support for Windows authentication or if SQL authentication would be the only choice. Those of you that know me…
-
Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3
I ran across a bug in SSMS 2016 CTP 2 back in August where you cannot open an Availability Group. If you try to right click and look at the properties of a 2014 availability group using the SSMS 2016 CTP you’ll get an error. The bug had already been submitted by my friend Trayce…
-
SSMS 2016 CTP 2.2 Setup Failure 0x81f40001
I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). The exact version as shown in the error is 13.0.0407.1 but in SSMS it returns 13.0.407.1. As some of you may know, one of the new things in SQL 2016 is that Microsoft decoupled the…