SentryOne Team Blog
SQL Server 2016: Latest Builds

SQL Server 2016: Latest Builds

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Glenn Berry : Reasons to Upgrade to SQL Server 2017

Glenn Berry : Reasons to Upgrade to SQL Server 2017

Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose the newer version. Continue reading…

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

For his first post on SQLPerformance.com, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

Devon Leann Ramirez highlights how the Index Analysis tab in SentryOne Plan Explorer helps with index creation for T-SQL Tuesday #101.

Webinar: Developing Your First Presentation

Webinar: Developing Your First Presentation

Andy Yun talks about his SQLSaturday Madison session on presenting your own first presentation, and invites you to attend a webinar on the topic on April 18th.

Erin Stellato : Automatic Index Management in Azure SQL Database

Erin Stellato : Automatic Index Management in Azure SQL Database

Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.

SQLSaturday #724 – Madison, WI

SQLSaturday #724 – Madison, WI

Two of our favorite Andys are gearing up for this weekend's #SQLSatMadison. Here Andy Yun talks about the event, the sessions that he will be presenting, and also talks about Andy Mallon's session.

Tech Outbound Ship Shape Challenge Update 1

Tech Outbound Ship Shape Challenge Update 1

Jason Hall recounts the journey so far for his Tech Outbound Ship Shape Challenge.

Rob Farley : Dealing with date and time instead of datetime

Rob Farley : Dealing with date and time instead of datetime

Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.

Reaching for the cloud with SentryOne & Managed Instance

Reaching for the cloud with SentryOne & Managed Instance

John Martin announces the latest release of the SentryOne platform, which includes support for Azure SQL Database Managed Instance.

Customize SentryOne Message Text

Customize SentryOne Message Text

Customize your alert messages in SentryOne so you can send those messages to help-desk ticket or other management systems.

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.

Paul White : Row Goals Part 4 : Anti Join Anti Pattern

Paul White : Row Goals Part 4 : Anti Join Anti Pattern

Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti join.

John Sirmon Joins SentryOne

John Sirmon Joins SentryOne

SentryOne announced that John Sirmon has joined its Product Team as Senior Product Manager. Sirmon comes to SentryOne after nearly two decades with Microsoft, most recently as Senior Program Manager with the Azure Customer Advisory Team. Sirmon will be responsible for product initiatives related to Advanced Analytics, Big Data, and Business Intelligence, both on-premises and

Rob Farley : When DISTINCT <> GROUP BY

Rob Farley : When DISTINCT <> GROUP BY

Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule.