SQL Server next version CTP 1.2 now available
As part of our rapid preview model, Microsoft is excited to announce that the next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.2 is now available on both Windows and Linux. In CTP 1.2 we implemented bug fixes and adde …
Announcing the SQL Server v.Next Early Adoption Program
What is the SQL Server Early Adoption Program (SQL EAP)? The SQL Server Early Adoption Program (SQL EAP) is a Microsoft program started in January 2017 to help both customers and partners adopt the next version of SQL Server before general availability …
Last Cumulative Update #16 for SQL Server 2012 SP2
The 16th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or s …
Cumulative Update #7 for SQL Server 2012 SP3
The 7th cumulative update release for SQL Server 2012 SP3 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or se …
Cumulative Update #1 for SQL Server 2016 SP1
The 1st cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or se …
Cumulative Update #4 for SQL Server 2016 RTM
The 4th cumulative update release for SQL Server 2016 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or se …
Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates
SQL product team has made significant improvements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blog series focuses on the performance improvements done as par …
Pssdiag & Sqldiag Manager update
We are releasing a new version of Pssdiag & Sqldiag Manager which supports SQL Server 2016. It was originally published on https://diagmanager.codeplex.com. But we just moved it to github under Microsoft organization repo. New location …
SQL Server R Services – Why did we build it?
Author: Nellie Gustafsson This is the first post in a series of blog posts about SQL Server R Services. We want to take you behind the scenes and explain why we have built this feature and deep dive into how it works. Future posts will include details …
Announcing Columnstore Indexes and Query Store support in Database Engine Tuning Advisor
The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune fro …
Why can’t I get a parallel plan when rebuilding my index?
In support, we frequently have customers who call us and want to find out why a particular query doesn’t use parallelism. Recently, we had a user who wanted to know why his index rebuild didn’t use parallelism. In some cases, No …
How six lines of code + SQL Server can bring Deep Learning to ANY App
The What Part Deep Learning is a hot buzzword of today. The recent results and applications are incredibly promising, spanning areas such as speech recognition, language understanding and computer vision. Indeed, Deep Learning is now changing the very …
Getting Started with Always Encrypted using PowerShell
In the previous articles from the Always Encrypted blog series, we demonstrated how to configure Always Encrypted using SQL Server Management Studio. In this article, we will show you how to configure Always Encrypted from the command line, using Power …
Welcome 2017! Recap of top SQL Server posts of 2016
We start off the new year with a quick recap of our most popular posts on this blog channel from the year just concluded. Here are the posts that got the most number of views from our readers during 2016, in increasing order of readership: 10. SQL Serv …