Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.
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 explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.
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.
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.
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!
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 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.
Product Manager Aaron Bertrand details the four fixes included in the latest release of SentryOne Plan Explorer (18.4.5).
Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).
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 shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.
Product Manager Aaron Bertrand gives a brief walk-through of the new deadlock visualization options in Plan Explorer and SQL Sentry.
Considering transitioning your business from consulting to retainer-based managed services? These practical recommendations will help you get started.
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.