SQL Server Checkpoint Monitoring with Extended Events
See how you can use Extended Events to find your worst performing checkpoints.
Monthly Archive: February 2020
SQL Server 2019 Cumulative Update #2
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.
Patch Tuesday : Security Updates for SQL Server 2012, 2014, 2016
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.
T-SQL Tuesday #123 : Life hacks
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
SQL Server 2017 Cumulative Update #19 is available. The build # is 14.0.3281.6 and there are 38 fixes.
Use caution with sys.dm_db_database_page_allocations
In this tip, I talk about a concerning behavior in the dynamic management function, sys.dm_db_database_page_allocations.
Fun with (columnstore) compression on a very large table – part 3
I continue my series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.