A subtle redirection
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
Notes and ramblings from the annual WIT Luncheon once again sponsored by SentryOne.
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.
See the highlights from the second keynote at PASS Summit 2019 in Seattle.
See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.
Register now for focus groups hosted by the product teams at PASS Summit next week!
See how to generate a set of scripts that will delete rows from dependent tables and show you how many rows will be deleted from each.
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
For this month's T-SQL Tuesday, I talk about an incident where I've changed my mind about something I was previously pretty stubborn about.
Find out how to use dynamic SQL to quickly generate metadata queries to pull attributes for all columns across a database or even a set of databases.
Forced Parameterization can be a useful setting to tune workloads, but this can work against you if you're also using filtered indexes.