SentryOne Team Blog
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

When Does it Pay for a DBA to Have an Associate Degree?

When Does it Pay for a DBA to Have an Associate Degree?

Melissa Connors (@MelikaNoKaOi) slices the data from Brent Ozar's 2017 Data Professional Salary Survey for Microsoft SQL Server professionals.

Data Mining the 2017 Data Professional Salary Survey

Data Mining the 2017 Data Professional Salary Survey

Demonstrating data mining, Lori Edwards takes a look at some decision trees against the data collected from Brent Ozar's Data Professional Survey.

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.

Rob Farley : Estimated Number of Rows to be Read

Rob Farley : Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

SentryOne and SQL Server Agent Jobs

SentryOne and SQL Server Agent Jobs

SQL Server Agent jobs: from basic maintenance tasks to checking health, status, and regularly scheduled processes, what would we do without them?

SQL Server v.Next : STRING_AGG Performance, Part 2

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand (@AaronBertrand) starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

It's 2017; What Am I Doing With My Life?

It's 2017; What Am I Doing With My Life?

Melissa Connors (@MelikaNoKaOi) reflects on personal and career goals accomplished in 2016 and discusses what's next in goals for 2017.

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.

2016 : Community Influencer of the Year

2016 : Community Influencer of the Year

Aaron Bertrand looks back on the past year, and hands out his first Community Influencer of the Year award.

SQL Server v.Next : STRING_AGG() performance

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.