SentryOne Team Blog (blogs.sentryone.com)
Features and Fixes in SentryOne Plan Explorer 19.0.2

Features and Fixes in SentryOne Plan Explorer 19.0.2

Product Manager Aaron Bertrand talks about the three improvements in the latest version of SentryOne Plan Explorer, 19.0.2.

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.

Webinar Follow-Up: Setting SQL Server Performance Baselines and Alerts

Webinar Follow-Up: Setting SQL Server Performance Baselines and Alerts

Kevin Kline shares the Q&A from our recent "Setting SQL Server Performance Baselines and Alerts" webinar and highlights additional resources you can reference on the topic of baselining and alerting.

A Million Little Things: Ending the Blame Game

A Million Little Things: Ending the Blame Game

Spending too much time determining who and what is at fault for poor database performance? Richard Douglas shares how SentryOne can help you to end the blame game and bring teams and organizations together faster to resolve performance problems before they affect the reputations of you and your company.

SQL Sentry Essentials provides top-rated database monitoring for customers with smaller environments

SQL Sentry Essentials provides top-rated database monitoring for customers with smaller environments

With the release of SQL Sentry Essentials, SentryOne partners can now offer a powerful database performance monitoring solution for customers who need to monitor 5 or fewer SQL Server instances.

SQL Sentry Essentials: Powerful Database Performance Monitoring for 5 or Fewer SQL Server Instances

SQL Sentry Essentials: Powerful Database Performance Monitoring for 5 or Fewer SQL Server Instances

SentryOne SQL Sentry Essentials, a new SQL Sentry edition that provides essential performance monitoring for up to 5 database instances, including SQL Server, Azure SQL Database, and Windows, is now available. Kevin Kline provides a breakdown of the product's features, who it's ideal for, and how to purchase it.

Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019

Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019

Kevin Kline shares the Q&A from our recent webinar, "The Top 4 Data Technology Trends Every DBA Should Know About in 2019," as well as resources that provide a deeper dive into some of the trends covered.

Mine the SentryOne Database for CPU Usage—Per Server, Per Day

Mine the SentryOne Database for CPU Usage—Per Server, Per Day

Justin Randall shows how to write a custom query to mine performance counters over a trailing number of days from the SentryOne database.

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.

Essential Performance Monitoring for SQL Server

Essential Performance Monitoring for SQL Server

SentryOne Product Manager Andy Mallon introduces SQL Sentry Essentials, a new edition of our flagship monitoring platform that's the right size and the right price for database environments of up to 5 targets.