Category : SQL Server - SentryOne Team Blog

Category: SQL Server

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

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

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."

T-SQL Tuesday #86 : Sorting a Stacked Chart

T-SQL Tuesday #86 : Sorting a Stacked Chart

Melissa Connors (@MelikaNoKaOi) wonders why she can't sort items in a Power BI Stacked Chart in a post for this month's T-SQL Tuesday about Connect items.

T-SQL Tuesday #86 : My Favorite Connect Items

T-SQL Tuesday #86 : My Favorite Connect Items

For T-SQL Tuesday #86, Aaron Bertrand (@AaronBertrand) highlights a few of his favorite bugs and feature requests on Microsoft's improvement site, Connect.

January Webinars Focus on Azure and Containers

January Webinars Focus on Azure and Containers

Kevin Kline (@kekline) invites you to three webinars coming up in January: A two-part series on the Azure platform, with Gavin Payne; and a session from Paul Stanton on running SQL Server inside Docker containers.

Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE… Originally