SentryOne Blog

Kevin Kline shares more about the history of PASS and the assembling of the original board of directors.
May 1, 2019 | Kevin Kline | SentryOne 0
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
Guest author Dustin Dorsey shows how to prepare for a migration to Azure SQL Database by sending SentryOne monitoring data to the DTU calculator.
With Azure SQL Data Warehouse and SentryOne, migrate to Azure with confidence and receive breakthrough cloud analytics performance at the best price.
Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.
April 23, 2019 | SQLPerformance.com | SQL Server, ColumnStore 0
The Top SQL tab in the SentryOne Monitoring Platform has many different ways to view collected queries and search for executions. Find out how to navigate Top SQL.
April 22, 2019 | Patrick Kelley | Tips and Tricks 0
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
April 13, 2019 | Aaron Bertrand | T-SQL, CodeStock, SQL Server 0
The user documentation for the new SentryOne Test product is now available on the SentryOne Docs website.
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
April 10, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Poor-quality data is a common problem that affects companies of all sizes in all industries. Understanding where to implement data validation tests to solve for it is another challenge.
April 9, 2019 | John Welch | SentryOne, SentryOne Test 0
Glenn Berry talks about the AMD EPYC CPUs now found in Azure Virtual Machines (in some regions) and their usage in balanced SQL Server workloads.
April 8, 2019 | SQLPerformance.com | Azure 0
In April 2018, SentryOne opened its first international office with the establishment of its EMEA headquarters in Dublin, Ireland.
April 5, 2019 | Bob Potter | SentryOne, SentryOne EMEA 0
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
If you help your customers manage their data estate, you could be the one taking the brunt of their frustration when their data doesn’t provide the value they expect.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
March 29, 2019 | SQLPerformance.com | T-SQL, SQL Server 0

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More