I KNOW, you thought the urgent security update earlier this month was the only patch you’d have to do for SQL Server 2016 in July, but buckle up, pardner: Microsoft is back with another one hot off the presses. SP2 CU8 includes these gems:
- Restores of compressed encrypted backups fail
- Data masking doesn’t
- DAX query needs memory 200x larger than the database size
- Peer-to-peer replication fails if your host name isn’t uppercase
- Query Store cleanup can fill the transaction log and cause an outage
- Distributed Availability Groups cause memory dumps when automatic seeding
- AG replication stops working due to internal thread deadlocks
- The deadlock monitor can cause an access violation
- Query a view with a union on a linked server, boom
- Concurrent inserts into a clustered columnstore index can deadlock
- Infinite loop when FileTable is used for a long time without a restart
- SSAS 2016 randomly crashes (I’m gonna guess it wasn’t completely random if they fixed it)
- Transparent Data Encryption doesn’t encrypt if it’s restarted mid-encryption
And much more. Go get ’em. There will also likely be a new SP1 CU published here shortly, but I won’t write a separate post for that. Only losers would still be on SP1. You’re a winner, right? Of course you are.
I’m a winner! Brent said so 🙂
Wow! It’s funny about the stuff someone can miss. Today is the first day that I was made aware of SQLServerUpdates.com. I was checking things (and totally impressed that someone would list the latest version of SSMS that had the debugger in it). I was also impressed with the fonts used and the general readability. I thought, “Wow… there aren’t many people that get this kind of stuff right and this all somehow seems familiar”. Then I started reading the descriptions and thought about Brent’s humor…
I’m sometimes a little slow on the uptake (it’s the bong water that Brent dished up for me several years ago) but I have to say, once I realized that this was another fine “Brent’s Brains” cite, I was pretty happy with my guess. The man does make quality and the humor of the art apparent.
Thanks for what you’ve done and what you do, Brent.
Hahaha, thanks sir!
Heh.. and the bong water made me misspell “cite”. 😀