SentryOne Team Blog (blogs.sentryone.com)
First public preview of SQL Server 2019 : CTP 2.0

First public preview of SQL Server 2019 : CTP 2.0

Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.

Introducing SentryOne Certified Training

Introducing SentryOne Certified Training

We are excited to provide SentryOne users and partners with access to our new, on-demand training program! Learn about all of the features available to you with the SentryOne data performance management platform—take the entire course or view sessions individually based on your needs.

Itzik Ben-Gan : Special Islands

Itzik Ben-Gan : Special Islands

Itzik Ben-Gan explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.

T-SQL Tuesday #106 : INSTEAD OF triggers

T-SQL Tuesday #106 : INSTEAD OF triggers

For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.

Migrating from AnswerHub to WordPress : A Tale of 10 Technologies

Migrating from AnswerHub to WordPress : A Tale of 10 Technologies

Aaron Bertrand describes the process of migrating nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to its new read-only home on WordPress.

Speaking of SQL and Data Science in California from Sep 10 to Sep 20

Speaking of SQL and Data Science in California from Sep 10 to Sep 20

Join Kevin Kline, author of "SQL in a Nutshell", at one of seven PASS SQL Server user group meetings in California between the dates of Sept 10th to Sept 20th. See you there!

Announcing the New SentryOne Documentation!

Announcing the New SentryOne Documentation!

Melissa Connors walks through the new SentryOne documentation library, which replaces the older user guides with a modern web format and great new features, including video tutorials, annotated images, a glossary, and search functionality.

Glenn Berry : Perfect Storm for Upgrading to a Modern Version of SQL Server

Glenn Berry : Perfect Storm for Upgrading to a Modern Version of SQL Server

Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server — considering not only the platform improvements but also changes to Windows, storage, and hardware.

Fixes in SentryOne Plan Explorer 18.4.5

Fixes in SentryOne Plan Explorer 18.4.5

Product Manager Aaron Bertrand details the four fixes included in the latest release of SentryOne Plan Explorer (18.4.5).

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).

Helping Your Customers Build, Test, Document, and Monitor SQL Server Apps

Helping Your Customers Build, Test, Document, and Monitor SQL Server Apps

With the acquisition of Pragmatic Works Software in April, SentryOne now offers an end-to-end data performance management suite. See how the SentryOne products can benefit your company and customers in each phase of the data app lifecycle.

Erin Stellato : Mining Plans : Not just for the plan cache

Erin Stellato : Mining Plans : Not just for the plan cache

Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.

New Deadlock Visualizations in SQL Sentry and Plan Explorer

New Deadlock Visualizations in SQL Sentry and Plan Explorer

Product Manager Aaron Bertrand gives a brief walk-through of the new deadlock visualization options in Plan Explorer and SQL Sentry.

Delivering Managed Services: 4 Tips from an MSP Veteran

Delivering Managed Services: 4 Tips from an MSP Veteran

Considering transitioning your business from consulting to retainer-based managed services? These practical recommendations will help you get started.

Task Factory 2018.3 Delivers Support for Azure Data Factory and Cloud Data

Task Factory 2018.3 Delivers Support for Azure Data Factory and Cloud Data

Task Factory 2018.3 provides SSIS components that connect to Amazon S3, Microsoft Azure storage accounts, and Azure Data Factory (ADF). John Welch explains what Task Factory to Azure Data Factory means for running your SSIS packages in the cloud.