Category : SQL Server - SentryOne Team Blog

Category: 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.

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.

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.

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

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.

Latest Builds of SQL Server 2012

Latest Builds of SQL Server 2012

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

15 SQL Server Performance Counters to Monitor

15 SQL Server Performance Counters to Monitor

When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.

T-SQL Tuesday #86 : What The Heck Is Wrong With My String/Binary Data?

T-SQL Tuesday #86 : What The Heck Is Wrong With My String/Binary Data?

For T-SQL Tuesday #86, Lori Edwards promotes one of the most frustrating SQL Server error messages in existence, "String or binary data would be truncated."