For this month's T-SQL Tuesday, I talk a little bit about how I make my imposter syndrome feel less like imposter syndrome.
SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
I continue my series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
With another new year comes the recognition of a standout contributor to the SQL Server community. Read on to see 2019's honoree.
I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
I show how I tried to chase down a very unexpected issue with SQL Server metadata. Spoiler: it didn't end the way I thought it would.
For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.
Discover a simple way to keep your filtered indexes effective – even under forced parameterization.
Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
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.