The Curious Engineer

All blogs / Databases

MSSQL Tiger Team

learn.microsoft.com/en-us/archive/blogs/sql_server_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.

DatabasesLinux / UnixPerformance / optimizationMicrosoft blogsMSDN archive

’15’16’17’18’19’20’21’22’23’24’25’26
Posts
167 from 10 Feb 2015 to 29 Mar 2019
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sql_server_team/feed.xml

2019 4

  1. We have moved!
  2. We are moving!
  3. Let’s talk about trace flags
  4. Replica Failover within the Secondary Availability Group in a Distributed Availability Group

2018 23

  1. SQL Server 2017 on Linux: Support for third-party AD providers
  2. Failover Detection Utility - Availability Group Failover Analysis Made Easy
  3. String or Binary data would be truncated: replacing the infamous error 8152
  4. SQL Server 2019 CTP 2.0 New Features – Columnstore support for sp_estimate_data_compression_savings
  5. SQL Server 2019 Preview
  6. Developer’s Choice: Hinting Query Execution model
  7. SQL Server on Linux: ADAuth issues 3: Could not obtain information about Windows NT group/user ‘CONTOSO\user’
  8. SQL Server on Linux: ADAuth issues 2: Common AD Login Issues
  9. SQL Server on Linux: ADAuth issues 1: Issues with joining a VM to a domain
  10. Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS
  11. SQL Server Availability Groups – Enhanced Database Level Failover
  12. Behavior Change for VSS Backups on VMs with Basic Availability Groups
  13. Predicate Pushdown and why should I care?
  14. TEMPDB – Files and Trace Flags and Updates, Oh My!
  15. Optimizing Replication Agent profile parameters for better performance
  16. Clustered Columnstore Index: Massively Parallel Trickle Insert
  17. SQL Server 2016/2017: Availability group secondary replica redo model and performance
  18. Replication Enhancement – Improved Distribution Database Cleanup
  19. Replication Enhancement – Distribution Database in Availability Group
  20. SQL Server Replication Enhancement – Dynamic Reloading of Agent Profile Parameters
  21. More Showplan enhancements – UDFs
  22. More Showplan enhancements – Row Goal
  23. Analyze Synchronous Commit Impact on High Commit Rate Workloads

2017 62

  1. Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."
  2. New in SSMS - Always On Availability Group Latency Reports
  3. Upgrade your SQL Server to scale before adding new hardware
  4. How we made backups faster with SQL Server 2017
  5. Perfect statistics histogram in just few steps
  6. Making parallelism waits actionable
  7. New Showplan enhancements
  8. Monitoring SQL Server and Azure SQL DB Session at DBA Fundamentals PASS VC
  9. SQL Server Tiger at PASS Summit 2017
  10. SQL Server 2012 Service Pack 4 (SP4) is now available!
  11. Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7
  12. Choosing the right server memory for restore and recovery of memory-optimized databases
  13. Persisting statistics sampling rate
  14. New in SSMS: Searching in Showplan
  15. New in SSMS: Performance Dashboard built-in
  16. Correlating xEvents with DMVs
  17. SQL Server 2016, Minimal logging and Impact of the Batchsize in bulk load operations
  18. Loan Chargeoff Prediction Solution Templates are Live in Cortana Intelligence Solutions Gallery
  19. Indirect Checkpoint and tempdb – the good, the bad and the non-yielding scheduler
  20. SQL Server Diagnostics (Preview)
  21. Columnstore Index: How do I find tables that can benefit from Clustered Columnstore Index
  22. SQL Server Migration Assistant (SSMA) v7.4 is now available
  23. Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017
  24. SQL Server 2017 Showplan enhancements
  25. Azure Database Migration Service now available for preview
  26. New in SSMS: Query Performance Troubleshooting made easier!
  27. Programmatically find SQL Server TCP ports
  28. Community driven Enhancements in SQL Server 2017
  29. SQL Server Mysteries: The Case of the Not 100% RESTORE…
  30. HADR Virtual Chapter – Monitoring Always On Availability Groups
  31. FILESTREAM issues with SQL Server on Windows 10 creators update
  32. SQL Saturday 613: Tiger Team sessions
  33. Troubleshooting High HADR_SYNC_COMMIT wait type with Always On Availability Groups
  34. DEA 2.0 Technical preview: Release Overview – Database Experimentation Assistant
  35. CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016
  36. Considerations when tuning your queries with columnstore indexes on clone databases
  37. Understanding data security in cloned databases created using DBCC CLONEDATABASE
  38. Easy way to get statistics histogram programmatically
  39. Columnstore Index – How to Estimate Compression Savings
  40. Columnstore Index - List of blogs on columnstore index published by SQL Server Product Team
  41. Released: Data Migration Assistant (DMA) v3.1
  42. SQL Server vNext Management Pack Demo
  43. SQL Server Migration Assistant (SSMA) v7.3 is now available
  44. MSSQLTIGER and February PASS Virtual Conferences
  45. Getting more statistics information programmatically
  46. Tigers Down Under at Difinity, Ignite and SQL Saturday
  47. Upgrading a Replication Topology to SQL Server 2016
  48. Data Migration Assistant (DMA) v3.0 is now available
  49. SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption
  50. Introducing VDC_Complete for Backup and Restore applications using SQLVDI
  51. Unicode strings and implicit conversions
  52. Columnstore Index: SQL Server 2016 – Improved DMV performance
  53. Change Tracking Cleanup – Part 2
  54. Columnstore Index Performance: SQL Server 2016 – Window Aggregates in BatchMode
  55. Columnstore Index Performance: SQL Server 2016 – String Predicate Pushdown
  56. Columnstore Index Performance: SQL Server 2016 – Aggregate Pushdown
  57. Columnstore Index Performance: SQL Server 2016 – No Performance Cliff
  58. Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates
  59. MSSQLTIGER and January 2017 PASS Virtual Conferences
  60. Columnstore Index Performance: BatchMode Execution
  61. SQL Server Performance Dashboard Reports unleashed for Enterprise Monitoring !!!
  62. Columnstore Index Performance: Rowgroup Elimination

2016 53

  1. Columnstore Index Performance: Column Elimination
  2. A walkthrough of Loan Classification using SQL Server 2016 R Services
  3. Split update operation can result in higher number of replicated commands
  4. SQL Server 2016 SP1: Know your limits
  5. Extended per-operator level performance stats for Query Processing
  6. Clustered Columnstore Index in Azure SQL Database
  7. Developers Choice: Query progress - anytime, anywhere
  8. Developers Choice: Programmatically identify LPIM and IFI privileges in SQL Server
  9. Developers Choice: USE HINT query hints
  10. SQL Server 2016 SP1: Things you should know
  11. Developers choice: Columnstore index in Standard and Express Edition with SQL Server 2016 (SP1)
  12. Developers Choice: CREATE OR ALTER
  13. New Showplan XML properties in SSMS October Release
  14. Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP table for Analytics?
  15. In-Memory OLTP: Is your database just in memory or actually optimized for memory?
  16. Columnstore Index: Which Columnstore Index is right for my workload?
  17. Columnstore index: Why do we refer to it as In-Memory Analytics?
  18. Migrating SAP workloads to SQL Server just got 2.5x faster
  19. Integrating PolyBase with Cloudera using Active Directory Authentication
  20. Filestream RsFx Driver fails to load after installing SQL Server 2016 with CU2 on Windows Server 2016 with SecureBoot ON
  21. Change Tracking Cleanup–Part 1
  22. Something for the SQL Server Backup Vendors
  23. MSSQLTIGER Team at the PASS Summit
  24. Understanding the requirements for SeSecurityPrivilege to SQL setup account on remote fileserver when default backup folder is set to UNC path
  25. Transactional Replication and Always On Availability Groups Support Update
  26. Improving Concurrency & Scalability of SQL Server workload by optimizing database containment check in SQL 2014\SQL 2016
  27. Operator progress changes in LQS
  28. Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016
  29. MSSQLTIGER and July PASS Virtual Conferences
  30. Memory grant related diagnostics
  31. Dynamic Memory Object Scaling
  32. New defaults for model and user databases in SQL Server 2016
  33. #AskSQLTiger Twitter Chat on June 27
  34. MSSQLTIGER and June PASS Virtual Conferences
  35. Performance Improvements in SQL Server Dashboards Management Pack
  36. MSSQLTIGER and May PASS Virtual Conferences
  37. MSSQLTIGER is back in Europe
  38. Boosting Update Statistics performance with SQL 2014 & SQL 2016
  39. MSSQLTIGER at SQLNEXUS and SQLBITS
  40. Clarifications on KB 3120595
  41. MSSQLTIGER and April PASS Virtual Conferences
  42. April updates to Plan Comparison Tool
  43. MSSQLTIGER at SQL Saturday Redmond
  44. New DMF for retrieving input buffer in SQL Server
  45. SQL Server 2016: Changes in default behavior for autogrow and allocations for tempdb and user databases
  46. Added per-operator level performance stats for Query Processing
  47. What’s new with SSMS Plan Comparison Tool?
  48. Addressing large memory grant requests from optimized Nested Loops
  49. Index Usage DMV behavior updated
  50. Several improvements to DBCC CHECKDB to make it run faster
  51. SQL Server 2014 is FIPS 140-2 compliant
  52. SQL Server Remote Blob Storage (RBS) Credential Store Symmetric Key Rotation
  53. Windows Enforcement of Authenticode Code Signing and Timestamping impact on SQL Server

2015 25

  1. SQLIO Disk Subsystem Benchmark Tool is being retired
  2. SQL Server 2016 – Added information on TempDB Spill events – xEvents
  3. Transactional Replication to Azure SQL DB is now in public preview.
  4. SQL Server 2016 – Added information on TempDB Spill events – Showplan
  5. @@VERSION and SERVERPROPERTY – What changed?
  6. How we moved from on-premise to Azure Virtual Machine
  7. Released: System Center Management Pack for SQL Server and Replication (6.6.2.0)
  8. MSSQLTIGER at SQL PASS Summit 2015
  9. Comparison Tool released with latest SSMS
  10. Multi-fold increase in throughput for big gateway query compiles in SQL Server
  11. Cardinality Estimation for Correlated Columns in SQL Server 2016
  12. New extended events for database recovery progress
  13. New extended event to track backup and restore progress
  14. Record breaking performance numbers for SQL Server 2014
  15. We are running the latest bits
  16. Encryption options in RESTORE HEADERONLY
  17. IO Statistics now available for queries that use Columnstore indexes
  18. Eliciting your feedback about upgrading SQL Server
  19. MS15-058 SQL Server Security Bulletin Released
  20. Upcoming end of support for SQL Server 2005
  21. Nonclustered Columnstore Index on Base Table Partitioned by Computed Column
  22. Secondary Replica may go into suspended state if you alter the readability property of the Availability Group and page compression is enabled
  23. SQL Server 2014 Service Pack 1 is now available
  24. Upgrading to SQL 2014: Report Server version mismatch
  25. Best practices for maximum performance and scalability gains for SQL Server workloads