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

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.

Partner Spotlight: Sarpedon Quality Lab

Partner Spotlight: Sarpedon Quality Lab

The SentryOne Global Partner Network is pleased to highlight Sarpedon Quality Lab, our Partner Spotlight for this month. Sarpedon is a consulting and training partner of SentryOne. Sarpedon was established in 2009 by Andreas Wolter, MS MVP. The Frankfurt-based company focuses on high performing OLTP Systems and big Data Warehouse Architectures with an emphasis on

Analyzing VertiPaq Memory Usage in SSAS Tabular in BI Sentry

Analyzing VertiPaq Memory Usage in SSAS Tabular in BI Sentry

Steven Wright digs into some of the new enhancements in the BI Sentry dashboard, which focus on highlighting VertiPaq memory issues in Tabular mode.