SentryOne Team Blog
Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley : Using AT TIME ZONE to fix an old report

Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

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.

Follow-up #1 on leading wildcard seeks

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

One way to get an index seek for a leading %wildcard

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

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

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.