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 …
Released: System Center Management Pack for SQL Server, Replication, AS, RS, Dashboards (6.7.15.0)
We are happy to announce new updates to SQL Server Management Pack family. All Management Packs are available in all 11 languages! Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server Database Engine …
Released: Public Preview for SQL Server vNext Management Pack
We are happy to announce that the brand-new management pack for SQL Server vNext is ready to go. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! Please download the public preview bits at: https://ww …
Columnstore Index Performance: Batch Mode Execution
Just posted the following blog as part of SQL Tiger team blog. I will continue with this series with many other performance specific changes done in SQL Server 2016 Columnstore index Performance: BatchMode Execution Thanks Sunil Agarwal
Columnstore Index Performance: Rowgroup Elimination
Columnstore Index Performance: Rowgroup Elimination Thanks Sunil Agarwal SQL Server Tiger Team
Columnstore Index Perfomance: Column Elimination
Columnstore Index Performance: Column Elimination Thanks Sunil