In this tip, I show how soft deletes and a filtered index can help minimize the cost of ghost records in an Availability Group.

I add some details about phase 2 of my home office changes.

I detail my home office setup, much of the gear in it, and show the progress of a minor renovation – a new standing desk and improved backlighting.

For this month's T-SQL Tuesday, I talk a little bit about how I make my imposter syndrome feel less like imposter syndrome.

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.