SentryOne Team Blog
Speaking in May-June: Boston, San Diego, Atlanta, and Nashville

Speaking in May-June: Boston, San Diego, Atlanta, and Nashville

Whilst On the Road I've been traveling heavily to speak at SQL Server events for the last few months and had a great time at recent stops such as Colorado Springs, a three-city tour in Oregon, and Philadelphia. I learned some interesting things about Oregon while visiting there, since it was my first trip in

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

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

Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the costs behind stream aggregates when the data needs to be sorted first.

T-SQL Tuesday #102 : Giving Back

T-SQL Tuesday #102 : Giving Back

Aaron Bertrand gives some scattered thoughts about how he has contributed to the SQL Server community throughout his career.

Tech Outbound Ship Shape Challenge Update 2

Tech Outbound Ship Shape Challenge Update 2

This is the second update for my Tech Outbound Ship Shape Challenge. If you are catching up, the challenge is to lose 56 pounds of unhealthy body mass. I started the beginning of March, and I now have about 3 months left to reach the goal. In my last update I reported a loss of

SentryOne Dives into DevOps with Pragmatic Works Software

Three years ago, longtime colleague Brian Knight, CEO of Pragmatic Works Software (PWS), and I had our first real conversation about the possibility of joining forces. We agreed that there was great potential, but the timing was not ideal – both companies were going through significant changes at the time – so we agreed to

SentryOne Partner Spotlight: Sabin IO

SentryOne Partner Spotlight: Sabin IO

Sabin IO, part of our Global Partner Network. Simon and the Sabin IO team are true professionals that provide valuable insight and expertise to their clients. Their deep understanding of the complete Microsoft data platform gives them the unique ability to provide consulting, architecture services, and managed services to the benefit of their customers.

Global Partner Network, Six New Partners

Global Partner Network, Six New Partners

Six new companies have joined the Global Partner Network. The Global Partner Network was established in 2017 to provide a single point of contact between SentryOne and the experienced Master Service Providers (MSPs), resellers and training and technology partners across the globe that use SentryOne to deliver superior server performance monitoring for their customers.

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.