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.
Thanks for visiting! This blog has now been migrated to:...
Date: 03/29/2019
This blog is in the process of being migrated to one of the new consolidated SQL Server and Azure...
Date: 03/04/2019
One of the most confusing aspects of SQL Server configuration is often trace flags. There are lots...
Date: 01/14/2019
A distributed availability group (distributed AG) is a special type of availability group that spans...
Date: 01/09/2019
In the past, SQL Server on Linux has required SSSD to be configured for AD Authentication to work....
Date: 11/26/2018
To analyze the root cause for the failover of an Availability group, users are required to perform...
Date: 11/19/2018
In the recent announcement at Ignite 2018 on the release of SQL Server 2019 CTP 2.0, the new Big...
Date: 10/24/2018
Next up for new Storage Engine area features in SQL Server 2019 is an update to the...
Date: 10/22/2018
Earlier this week, we announced SQL Server 2019 Public Preview at Microsoft Ignite. All the features...
Date: 09/26/2018
Over the years you have read a number of blogs advocating for or against trace flags that influence...
Date: 09/19/2018
SQL Server on Linux: ADAuth issues 3: Could not obtain information about Windows NT group/user ‘CONTOSO\user’
AD authentication is a popular mechanism for login and user authentication. It works very well in...
Date: 09/06/2018
AD authentication is a popular mechanism for login and user authentication. It works very well in...
Date: 09/05/2018
AD authentication is a popular mechanism for login and user authentication. It works very well in...
Date: 09/04/2018
[UPDATE as of 2018/11/21 at the end.] Prior to SQL Server for Linux 2017 CU10 the package...
Date: 08/29/2018
Database level health detection failover (DB_Failover) option for Availability Groups was introduced...
Date: 07/25/2018
This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go...
Date: 07/20/2018
If you follow this blog, you know that in the last couple years, we have been adding more...
Date: 07/06/2018
TL;DR – Update to the latest CU, create multiple tempdb files, if you're on SQL 2014 or earlier...
Date: 06/29/2018
When SQL Server replication is used on environments with high traffic OLTP systems, users often need...
Date: 06/26/2018
A traditional scenario of loading data into CCI is a nightly load from one or more data files...
Date: 06/04/2018
When availability group was initially released with SQL Server 2012, the transaction log redo was...
Date: 06/01/2018
Replication Distribution database is the perhaps the most important entity in the entire replication...
Date: 04/30/2018
SQL Server replication uses the publisher, distributor, and subscriber paradigm to provide logical...
Date: 04/19/2018
With SQL Server 2017 Cumulative Update 3, we introduced an improvement to SQL Server Replication...
Date: 02/24/2018
As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet...
Date: 02/20/2018
As I shared before, we have been working for over a year to make showplan the one-stop-shop for...
Date: 02/19/2018
Recently the SQL Server Always On Support team at Microsoft CSS published a blog on analyzing the...
Date: 02/08/2018
Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."
Update as on 3/28 at the bottom of the page. The title of the blog may throw someone off a little....
Date: 12/11/2017
With SQL Server 2012 we introduced Always On Availability Groups, and the Always On Availability...
Date: 12/07/2017
In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can...
Date: 11/29/2017
In my previous blog post on enhancements in SQL Server 2017, we briefly introduced improved backup...
Date: 11/22/2017
A similar question about statistics came to the team twice this week: why does updating with...
Date: 11/21/2017
During PASS we announced changes to how users will be able to make parallelism waits more actionable...
Date: 11/10/2017
If you follow this blog, you have seen that in the past few releases we have continuously included a...
Date: 11/08/2017
On 10/17/2017, we delivered a webinar session titled "Comprehensive Guide for Monitoring SQL Server...
Date: 10/18/2017
The SQL Server team will again be at the Summit this year. If we are not speaking or co-speaking in...
Date: 10/12/2017
SQL Server Product Team is excited to bring you the final release of SQL Server 2012 Service Packs,...
Date: 10/05/2017
Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7
Backup Compression and Transparent Data Encryption (TDE) have been two immensely valuable and...
Date: 09/20/2017
Recovering database with memory-optimized tables involves hydrating the contents of checkpoint files...
Date: 08/28/2017
When SQL Server creates or updates statistics and a sampling rate is not manually specified, SQL...
Date: 08/11/2017
Have you ever analyzed a somewhat big plan? And while doing so did you ever wish you could search...
Date: 08/08/2017
Back in 2007, we released the Microsoft SQL Server 2005 Performance Dashboard Reports, which were...
Date: 08/07/2017
Since the inception of xEvents there has been the need to occasionally correlate data from xEvent...
Date: 08/02/2017
One of the design goals of SQL Server 2016 was to improve performance and scalability of the engine...
Date: 08/01/2017
A charged off loan is a loan that is declared by a creditor (usually a lending institution) that an...
Date: 06/30/2017
Indirect checkpoint was first introduced in SQL Server 2012 to provide predictable database recovery...
Date: 06/27/2017
EDIT (1/10/2018): As of yesterday, this preview service was shutdown. SQL Server customers...
Date: 06/23/2017