MSSQL Tiger Team
This is the official web log for the SQL Server engineering team – we focus on learning customer workloads running on SQL Server, integrating that feedback to enhance the product, and provide guidance on using SQL Server to solve customers' business challenges.
SQL Server 2016 – Added information on TempDB Spill events – Showplan
For those that have some experience analyzing query plans, you probably have come across spills to...
Author: Pedro Lopes (PL) Date: 10/28/2015
@@VERSION and SERVERPROPERTY – What changed?
With the recent release of SQL Server 2014 SP1 CU3 and SQL Server 2014 RTM CU10, you will notice...
Author: Pedro Lopes (PL) Date: 10/22/2015
How we moved from on-premise to Azure Virtual Machine
We had previously blogged about moving some of our on-premise SQL Server environments which manages...
Author: Amit Banerjee Date: 10/21/2015
Released: System Center Management Pack for SQL Server and Replication (6.6.2.0)
We are happy to announce that a new version of SQL Server and Replication Management Packs has been...
Author: SQL Server Engineering Team Date: 10/19/2015
MSSQLTIGER at SQL PASS Summit 2015
The SQL PASS Summit is round the corner and we are quite excited about it. The Microsoft SQL Server...
Author: Amit Banerjee Date: 10/13/2015
Comparison Tool released with latest SSMS
The ability to compare plans is something that a lot of people have to do for troubleshooting...
Author: Pedro Lopes (PL) Date: 10/12/2015
Multi-fold increase in throughput for big gateway query compiles in SQL Server
There are some exciting new changes in the database engine that dramatically improves query...
Author: Ajay.MSFT Date: 10/09/2015
Cardinality Estimation for Correlated Columns in SQL Server 2016
When we introduced the new CE back in SQL Server 2014, several changes were done regarding the...
Author: Pedro Lopes (PL) Date: 10/02/2015
New extended events for database recovery progress
In yesterday's blog post, I talked about a new extended event for backup and restore. Continuing...
Author: Ajay.MSFT Date: 09/23/2015
New extended event to track backup and restore progress
Backup and restore are long running tasks in SQL Server with limited insights into progress. Often a...
Author: Ajay.MSFT Date: 09/22/2015
Record breaking performance numbers for SQL Server 2014
Record breaking performance numbers were recently published for SQL Server 2014 for various hardware...
Author: Ajay.MSFT Date: 09/11/2015
We are running the latest bits
Microsoft SQL Server continues its transformational journey by pushing out some key features which...
Author: SQL Server Engineering Team Date: 08/27/2015
Encryption options in RESTORE HEADERONLY
Backup Encryption was introduced in SQL Server 2014 as way to encrypt the data while creating a...
Author: Ajay.MSFT Date: 08/10/2015
IO Statistics now available for queries that use Columnstore indexes
Prior to SQL Server 2014 Service Pack 1, if you turned on STATISTICS IO for queries that touch...
Author: Ajay.MSFT Date: 08/10/2015
Eliciting your feedback about upgrading SQL Server
SQL Server DBAs - The SQL Server engineering team needs you and your input! We're running a...
Author: SQL Server Engineering Team Date: 08/07/2015
MS15-058 SQL Server Security Bulletin Released
A security bulletin for SQL Server has been released on 7/14/2015. This applies to SQL Server 2008,...
Author: SQL Server Engineering Team Date: 07/21/2015
Upcoming end of support for SQL Server 2005
Please note that SQL Server 2005 will be out of extended support on Apr 12, 2016. If you are still...
Author: Ajay.MSFT Date: 05/27/2015
Nonclustered Columnstore Index on Base Table Partitioned by Computed Column
If you have SQL Server 2012 and created a NCCI on a base table partitioned by a computed column, you...
Author: Ebru1 Date: 05/21/2015
Secondary Replica may go into suspended state if you alter the readability property of the Availability Group and page compression is enabled
Please apply one of the fixes mentioned at the bottom of this blog page or employ one of the...
Author: Ajay.MSFT Date: 05/18/2015
SQL Server 2014 Service Pack 1 is now available
Approximately one year ago, we launched SQL Server 2014. Today, May 15, we are pleased to announce...
Author: Ajay.MSFT Date: 05/18/2015
Upgrading to SQL 2014: Report Server version mismatch
We wanted to let you know of a potential issue that you may experience when upgrading from SQL 2012...
Author: Mariusz Michal Cichomski Date: 03/20/2015
Best practices for maximum performance and scalability gains for SQL Server workloads
We have worked with our colleagues in CSS to publish a KB article that lists recommended...
Author: Ajay.MSFT Date: 02/10/2015