SentryOne Team Blog (blogs.sentryone.com)
Paul White : Grouped Aggregate Pushdown

Paul White : Grouped Aggregate Pushdown

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.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 3, with plenty of enhancements back-ported from recent SQL Server 2016, 2017, and 2019 updates.

Sharing two T-SQL slide decks from CodeStock

Sharing two T-SQL slide decks from CodeStock

Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.

SentryOne Test Documentation on SentryOne Docs

SentryOne Test Documentation on SentryOne Docs

The user documentation for the new SentryOne Test product is now available on the SentryOne Docs website.

Itzik Ben-Gan : Row Pattern Recognition in SQL

Itzik Ben-Gan : Row Pattern Recognition in SQL

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.

Why, When, and How to Validate Your Data

Why, When, and How to Validate Your Data

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. SentryOne Test is designed to solve problems at every stage of the data lifecycle.

Glenn Berry : AMD EPYC Processors in Azure Virtual Machines

Glenn Berry : AMD EPYC Processors in Azure Virtual Machines

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.

SentryOne Marks One Year Anniversary of Dublin Office

SentryOne Marks One Year Anniversary of Dublin Office

In April 2018, SentryOne opened its first international office with the establishment of its EMEA headquarters in Dublin, Ireland. To mark the location’s first anniversary, SentryOne CEO Bob Potter reflects on the reasons why Dublin was chosen for this key development and its ongoing success.

Paul White : IGNORE_DUP_KEY slower on clustered indexes

Paul White : IGNORE_DUP_KEY slower on clustered indexes

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.

Help Your Customers Stop Bad Data with SentryOne Test

Help Your Customers Stop Bad Data with SentryOne Test

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. Data testing and validation are vital to ensuring the accuracy of the data that your customers are using to make business decisions, yet many businesses balk at the amount of time and effort required to complete these tasks. Now you can offer a better solution with SentryOne Test.

Filtered Indexes and INCLUDEd Columns

Filtered Indexes and INCLUDEd Columns

Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.

Helping Customers Track Data Origin

Helping Customers Track Data Origin

SentryOne partners, you can provide your customers with significant value, saving them time and money, by offering an easy way to fully document databases, including data lineage. Understanding the source of data, and how the source of data has changed over time, is critical to ensuring compliance with data privacy regulations such as GDPR, HIPAA, and CASL, as well as executing on established business rules.

A Historical Account of the Professional Association of SQL Server (PASS), Part 1: Foundation

A Historical Account of the Professional Association of SQL Server (PASS) Lately, I've been asked many questions about the history and foundation of PASS. As an "old-timer", I like to think it's my prerogative to wax poetic about the old days. But it's also important to be able to answer those questions asynchronously and in […]

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.

Data Validation for All—Introducing SentryOne Test

Data Validation for All—Introducing SentryOne Test

SentryOne Test, our new SaaS-based data test and validation solution, has been released into public preview. Find out how to take advantage of special preview pricing.