Product Manager Aaron Bertrand talks about the three improvements in the latest version of SentryOne Plan Explorer, 19.0.2.
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 walks through a quick and simple way to use Extended Events and the new XEvent Profiler to review queries on your system.
Download the slide deck from Aaron Bertrand's latest presentation, "Fix Slow Queries. Fast."
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
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.
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.
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.
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.
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.
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 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.
Aaron Bertrand introduces Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.
Guest author Sander Stad walks through PSDatabaseClone, a Powershell alternative to provisioning copies of databases through restore or scripting.
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.