Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in SQL 2016

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 […]

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 […]

I ran across a bug in SSMS 2016 CTP 2 back in August.  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 Jordan, so I just added some comments […]

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 […]