Removing the default trace – Part 3 Aaron Bertrand finishes up his series on replacing the default trace with views to simplify consumption and a caveat about reports in SSMS. Aaron Bertrand ◆ April 22, 2020 0
New Metadata-Only Column Changes in SQL Server 2016 Paul White investigates the new metadata-only column data type changes possible in SQL Server 2016 when using data compression. Paul White ◆ April 17, 2020 3
Bandwidth-friendly Query Profiling for Azure SQL Database This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database. Greg Gonzalez ◆ April 15, 2020 0
An approach to index tuning – Part 2 Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server. Erin Stellato ◆ April 13, 2020 1
Fundamentals of table expressions, Part 1 Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL. Itzik Ben-Gan ◆ April 8, 2020 0
Removing the default trace – Part 2 Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session. Aaron Bertrand ◆ April 6, 2020 0
SQL Server 2019 Cumulative Update #4 SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The build number is 15.0.4033.1. Aaron Bertrand ◆ March 31, 2020 0
An approach to index tuning – Part 1 Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations. Erin Stellato ◆ March 26, 2020 8
Please help with STRING_SPLIT improvements Aaron Bertrand pushes for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help! Aaron Bertrand ◆ March 20, 2020 8
Finding Distinct Values Quickly Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019. Paul White ◆ March 17, 2020 1
SQL Server 2019 Cumulative Update #3 SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6. Aaron Bertrand ◆ March 13, 2020 0
