See a quick example where plan shape can cause errors that really shouldn't happen.
In this tip, see ways you can change how a function is called without having to modify all calling code at the same time.
Need to get data, log, or bak files into your container's file system? See how, with
SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.
With the increasing number of office closures, I share some tips about working from home.
In this tip, I show how to measure the positive effects of delayed durability, in cases where a small amount of data loss is acceptable.
I start a series explaining how I evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.
See how you can use Extended Events to find your worst performing checkpoints.
It's a few days later than many of us were expecting, but Cumulative Update #2 for SQL Server 2019 (15.0.4013.40) is overflowing with 134 fixes and enhancements.
Security updates were released today to patch a remote code execution vulnerability in Reporting Services, but I would install the patch even if you're not running SSRS.
This month, Jess Pomfret hosts T-SQL Tuesday, and asks us to talk about our own personal life hacks that make our day easier.
SQL Server 2017 Cumulative Update #19 is available. The build # is 14.0.3281.6 and there are 38 fixes.
In this tip, I talk about a concerning behavior in the dynamic management function, sys.dm_db_database_page_allocations.
I continue my series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.
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.
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.