SentryOne Team Blog
The Architecture of Azure Data Platform Applications

The Architecture of Azure Data Platform Applications

Kevin Kline and Ben Lezin hold a short Q & A with Gavin Payne and Mike Wood about Azure architecture and improvements.

Erin Stellato : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato : Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.

The Relativity of Server Health

The Relativity of Server Health

Maintaining a good server health status is critical to your SQL estate performance. Jason Hall discusses why 'healthy' is not a relative measurement.

Image credit clipartsgram.com.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

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

Latest Builds of SQL Server v.Next

Latest Builds of SQL Server v.Next

Find out the build number of each SQL Server v.Next CTP as it is released, discover where to download, and how to get details on new fixes and features.

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

T-SQL Tuesday #87 : Shiny New Toys

T-SQL Tuesday #87 : Shiny New Toys

For T-SQL Tuesday #87, Aaron Bertrand (@AaronBertrand) talks about two shiny new toys used for disassembling and reassembling strings: STRING_SPLIT() and STRING_AGG().

Latest Builds of Management Studio

Latest Builds of Management Studio

February 13th, 2017: Find information about the builds of SQL Server Management Studio and SSDT in their new release cycle approach, and locate the latest build of SSMS for previous versions.

Overview of Columnstore Indexes in SQL Server

Overview of Columnstore Indexes in SQL Server

Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.

Follow-up #1 on leading wildcard seeks

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

One way to get an index seek for a leading %wildcard

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.

Photo credit: badgreeb_records

SQL Server Alerts : Best Practices

SQL Server Alerts : Best Practices

Strategies and best practices for SQL Server alerts. Alert priorities, avoiding alert fatigue, and having a solid overall strategy are key.

Erin Stellato : Compression and its Effects on Performance

Erin Stellato : Compression and its Effects on Performance

Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

Photo credit: rsdio