SentryOne Team Blog
A new series on performance-related SQL Server myths

A new series on performance-related SQL Server myths

Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.

Visual Studio : Resolving the LoadGeneratorLocationError

Visual Studio : Resolving the LoadGeneratorLocationError

Melissa Connors (@MelikaNoKaOi) walks through a workaround for the LoadGeneratorLocationError logged in locally executed Visual Studio Load Tests.

Presenting at Battle of the Beards

Presenting at Battle of the Beards

Join John Martin and other great speakers presenting a range of technology sessions at Battle of the Beards in Cardiff on the 29th of March.

Event Log Management Tools in SentryOne

Event Log Management Tools in SentryOne

Melissa Connors (MelikaNoKaOi) walks through some key features of the event log management tools in SentryOne for Windows Event Logs as well as SQL Server.

Books Online Consolidation

Books Online Consolidation

Aaron Bertrand (@AaronBertrand) explains the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.

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.

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().

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