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

Announcing 2016 Service Pack 3 and 2017 CU26

1 year ago
Brent Ozar
SQL Server 2016, SQL Server 2017, Updates
6 Comments

First off, the less interesting one: SQL Server 2017 Cumulative Updates come out about every 60 days, so that one’s not a big deal. The new Cumulative Update 26 includes fixes for columnstore, affinity masking, and other stuff. Note that sp_pkeys was broken in CU25, and that one’s still not fixed in CU26.

Now for the more interesting one: SQL Server 2016 Service Pack 3.

2016 was the last version to have Service Packs. Starting with 2017, Microsoft only ships Cumulative Updates. In the past, Microsoft has used one last Service Pack to kinda seal the tomb, closing off support for a version. Long term support is only available for the last Service Pack for a product. As of today, 2016 SP2 only gets support until October 11, 2022, whereas SP3’s support goes all the way out through 2026.

I like this approach because it makes support simpler. Microsoft doesn’t have to deal with a wide variety of builds for these older versions (if you can call 2016 older) – we can just say, “If you want help, it’s gotta be build 13.0.6300.2.”

Sure, there are a list of fixes in the KB article, but for me, the bigger takeaway is that for long term support, you need to patch all your 2016 instances at some point in the near future. I know, it’s a little more work added to your plate – but ideally, this will be the last SQL Server patch you’ll ever have to apply on those boxes, barring a critical security surprise.

SQL Server 2016 isn’t dead yet, but…he did just have his retirement party and get a box with a nice gold watch for his services.

Brent Ozarhttp://sqlserverupdates.com
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.
Previous Post
Announcing SQL Server 2017 Cumulative Update 25: The Silver Anniversary
Next Post
Announcing SQL Server 2019 CU13 and SSMS 18.10: Replication Improvements

6 Comments. Leave new

  • Philip Barry
    September 18, 2021 11:33 pm

    I’m one of the Support Escalation Engineers for SQL Server that work at Microsoft. I have received a case for the sp_pkeys issue and have engaged the SQL Server Product Group about it.

    Reply
    • Brent Ozar
      September 18, 2021 11:34 pm

      Thanks, that’s great to hear!

      Reply
      • Philip Barry
        September 22, 2021 1:11 am

        I mentioned that I’d raised this with the SQL Server Product Group. They have confirmed that it is a bug and are targeting a fix in SQL Server 2017 CU27.

        Reply
        • Philip Barry
          October 28, 2021 1:22 am

          I’m pleased to say the fix has been released in SQL Server 2017 CU27 – https://support.microsoft.com/en-gb/topic/kb5006944-cumulative-update-27-for-sql-server-2017-79117c8f-9d54-42f8-9727-5870fe475187.

          Reply
  • Burhan Akgül
    September 23, 2021 3:58 am

    When I tried to update SQL Server 2016 SP3 for a customer it stopped at the instance selection window and did not go any further. There were 3 instances on the server. 1 Prod instance, 1 Test instance and 1 DEV instance. There was neither any instance marked nor could I select 1 instance to update. When I clicked further it gave an error that no instance is selected. The last state of the SQL Server was CU17.
    What did I do wrong. What is the error?

    Reply
    • Brent Ozar
      September 23, 2021 4:16 am

      I wish I could do free production support for your customers, but your best bet there would be to contact Microsoft.

      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

  • 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
  • Announcing SQL Server 2017 Cumulative Update 25: The Silver Anniversary July 12, 2021
  • Announcing SQL Server 2019 Cumulative Update 11: This One Goes to … June 11, 2021

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