Sites Microsoft


Cumulative Update #4 for SQL Server 2016 RTM

Publié le 18 janvier 2017 sur microsoft sql server release services
 

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

Publié le 12 janvier 2017 sur Microsoft SQL Server database engine blog
 

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

Publié le 12 janvier 2017 sur css sql server engineers
 

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?

Publié le 10 janvier 2017 sur Microsoft SQL Server database engine blog
 

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

Publié le 10 janvier 2017 sur sql server team blog
 

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?

Publié le 9 janvier 2017 sur css sql server engineers
 

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

Publié le 5 janvier 2017 sur sql server team blog
 

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

Publié le 5 janvier 2017 sur sql server security blog
 

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

Publié le 4 janvier 2017 sur sql server team blog
 

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)

Publié le 4 janvier 2017 sur microsoft sql server release services
 

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

Publié le 4 janvier 2017 sur microsoft sql server release services
 

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

Publié le 3 janvier 2017 sur Microsoft SQL Server database engine blog
 

  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

Publié le 2 janvier 2017 sur Microsoft SQL Server database engine blog
 

Columnstore Index Performance: Rowgroup Elimination Thanks Sunil Agarwal SQL Server Tiger Team

Columnstore Index Perfomance: Column Elimination

Publié le 2 janvier 2017 sur Microsoft SQL Server database engine blog
 

Columnstore Index Performance: Column Elimination Thanks Sunil


Pages :