SQLServerUpdates.com
  • Home – Most Recent Updates
    • SQL Server 2019 Updates
    • SQL Server 2017 Updates
    • SQL Server 2016 Updates
    • SQL Server 2014 Updates
    • SQL Server 2012 Updates
    • SQL Server 2008 R2 Updates
    • SQL Server 2008 Updates
  • Download SQL Server
  • Subscribe to Updates
  • Contact Us
    • Frequently Asked Questions

SQL Server 2016 SP2 Cumulative Update 8

4 years ago
Brent Ozar
SQL Server 2016, Updates
4 Comments

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.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing a Tall Refreshing SQL Server 2014 Cumulative Update
Next Post
SQL Server 2016 SP2 CU9

4 Comments. Leave new

  • BeckyH
    August 1, 2019 10:22 am

    I’m a winner! Brent said so 🙂

    Reply
  • Jeff Moden
    November 19, 2019 10:43 am

    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.

    Reply
    • Brent Ozar
      November 19, 2019 10:44 am

      Hahaha, thanks sir!

      Reply
  • Jeff Moden
    November 19, 2019 10:45 am

    Heh.. and the bong water made me misspell “cite”. 😀

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Subscribe

Want to get an email when Microsoft publishes a new SP or CU for SQL Server? Subscribe here.

Recent Updates

  • SQL Server 2022 Gets Its 2nd Update in 2 Days February 16, 2023
  • SQL Server 2022 Gets Its First Update! Plus 2019, 2017, 2016, 2014 Updates February 14, 2023
  • Announcing SQL Server 2019 CU15 January 27, 2022
  • Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements October 5, 2021
  • Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021

© 2021 Brent Ozar Unlimited®. All Rights Reserved. Privacy Policy