SentryOne Team Blog (blogs.sentryone.com)

Category : SQL Server

Slides and Scripts – SQL Server Internals and Architecture at Music City Code

Slides and Scripts – SQL Server Internals and Architecture at Music City Code

I had the pleasure of presenting my popular session, SQL Server Internals and Architecture, at the Music City Code conference.

T-SQL Tuesday #90 : Shipping Database Changes

T-SQL Tuesday #90 : Shipping Database Changes

Aaron Bertrand (@AaronBertrand) recounts the way he implemented database changes in a distributed SQL Server system a decade ago.

They Did it Again – The Release of SQL Server 2017

Not only has the Microsoft SQL Server engineering team added more and stronger leadership, outstanding individual engineers and staff members, but it is also radically moving its entire development process into a "cloud-first" ethos. Now, I'd like to show one of the most salient results of this new development process-accelerated product releases. It was only […]

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Visualizing Data Compression: See it for Yourself

Visualizing Data Compression: See it for Yourself

Melissa Connors (@MelikaNoKaOi) explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.

Performance Myths : Clustered vs. Non-Clustered Indexes

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

What’s Up in the SentryOne Cloud

What’s Up in the SentryOne Cloud

Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard!

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.

SQL Server Named 2017 DBMS of the Year

Way back in the summer of 2014, I told you about how I used DB-Engines.com to determine the popularity of various data management tools and vendor platforms. Plus, by adding in an analysis Google Trends I can see where the overall trends that I'm interested in are headed. Staying up with the trends isn't just […]

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.

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.

Introducing the SQL Server Database Experimentation Assistant

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. READ MORE… Originally Posted February 08, 2017