Category : SQL Server - SentryOne Team Blog

Category: SQL Server

Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

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

Latest Builds of Management Studio

Latest Builds of Management Studio

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.

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.

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.

Latest Builds of SQL Server 2012

Latest Builds of SQL Server 2012

Updated March 21st, 2017 : SQL Server 2012 is now at Service Pack 3. Read this post to see what you should know before deploying.

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

Updated January 18th, 2017 : See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

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.

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.