T-SQL Tuesday #122 – Imposter Syndrome
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
SQL Server 2019 Cumulative Update #1 is now available, with 83 fixes and improvements. Build # is 15.0.4003.23.
Fun with (columnstore) compression on a very large table – part 2
I continue my series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning.
A simple use case for columnstore indexes
In this tip, I show how and why a columnstore index can provide benefits to COUNT(*) queries.
2019 : Community Influencer of the Year
With another new year comes the recognition of a standout contributor to the SQL Server community. Read on to see 2019's honoree.
Fun with (columnstore) compression on a very large table – part 1
I start a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table.
Using metadata to troubleshoot metadata
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.
T-SQL Tuesday #121 : Gifts
For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.
Filtered Indexes and Forced Parameterization (redux)
Discover a simple way to keep your filtered indexes effective – even under forced parameterization.
Should we still chunk delete operations?
Conventional wisdom has suggested that deletes should be batched, but in some cases this can actually take a lot longer.
Introducing Big Data Clusters and SQL Server 2019
Let's talk a bit about the launch of SQL Server 2019 and the flagship, bet-the-farm feature: Big Data Clusters.
SQL Server 2019 Installation Enhancements
I talk a little bit about two big enhancements for SQL Server 2019: installation options for setting MAXDOP and Max Server Memory.
PASS Summit 2019 – WIT Luncheon
Notes and ramblings from the annual WIT Luncheon once again sponsored by SentryOne.
Memory-Optimized TempDB Metadata
Get a quick overview of a powerful new feature in SQL Server 2019 that will drastically improve certain tempdb-heavy workloads.
PASS Summit 2019 Keynote – Day 2
See the highlights from the second keynote at PASS Summit 2019 in Seattle.
PASS Summit 2019 Keynote – Day 1
See the highlights from the first-day keynote at PASS Summit 2019 in Seattle.
Thoughts on SQL Server 2019 Editions
I share some thoughts about the upcoming SQL Server 2019 release and edition-specific features.
Focus Groups at PASS Summit 2019
Register now for focus groups hosted by the product teams at PASS Summit next week!
Simulating ON DELETE CASCADE
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.
Impact of UTF-8 support in SQL Server 2019
I take a quick look at the performance and storage impact of the new UTF-8 collations in SQL Server 2019.
T-SQL Tuesday #119 : Changing My Mind
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.