SentryOne Team Blog
Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.

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.

Latest Builds of SentryOne Software

Latest Builds of SentryOne Software

Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists.

Latest Builds of Management Studio

Latest Builds of Management Studio

Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.

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 2016

Latest Builds of SQL Server 2016

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

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.