SentryOne Team Blog (blogs.sentryone.com)

SQLPerformance.com

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."
Tim Radney : Azure SQL Database Performance Tuning Options

Tim Radney : Azure SQL Database Performance Tuning Options

Tim Radney explains some of the nuances of performance tuning your workloads in Azure SQL Database and Azure SQL Database Managed Instance.

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan : T-SQL bugs, pitfalls, and best practices – determinism

Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.

Erin Stellato : Use XEvent Profiler to capture queries in SQL Server

Erin Stellato : Use XEvent Profiler to capture queries in SQL Server

Erin Stellato walks through a quick and simple way to use Extended Events and the new XEvent Profiler to review queries on your system.

Charlotte SQL Server User Group : Fix Slow Queries. Fast.

Charlotte SQL Server User Group : Fix Slow Queries. Fast.

Download the slide deck from Aaron Bertrand's latest presentation, "Fix Slow Queries. Fast."

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan : Closest Match, Part 3

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.

Scalar UDF Inlining in SQL Server 2019

Scalar UDF Inlining in SQL Server 2019

Aaron Bertrand introduces Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.

Sander Stad : Cloning Databases with PSDatabaseClone

Sander Stad : Cloning Databases with PSDatabaseClone

Guest author Sander Stad walks through PSDatabaseClone, a Powershell alternative to provisioning copies of databases through restore or scripting.

Glenn Berry : Using Intel Optane Storage for SQL Server

Glenn Berry : Using Intel Optane Storage for SQL Server

Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.

Itzik Ben-Gan : Closest Match, Part 2

Itzik Ben-Gan : Closest Match, Part 2

Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.

Erin Stellato : Using Track Causality to Understand Query Execution

Erin Stellato : Using Track Causality to Understand Query Execution

Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events.

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.

Glenn Berry : Security Features in SQL Server 2017

Glenn Berry : Security Features in SQL Server 2017

Glenn Berry talks about a few of the security features in SQL Server 2017 and reminds us to always test and validate the performance impact.

Itzik Ben-Gan : Closest Match, Part 1

Itzik Ben-Gan : Closest Match, Part 1

Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.

Paul White : Join Estimation using Histogram Coarse Alignment

Paul White : Join Estimation using Histogram Coarse Alignment

Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.