Tag Archives: patching

No More Service Packs

The new servicing model for SQL Server is out, with a great explanation from Glenn Berry (there’s also a webcast). The summary is that going forward with SQL Server 2017, we won’t get Service Packs anymore. I’m somewhat sad, as I was always looking … Continue reading

Posted in Editorial | Tagged , | 1 Comment

The New CU Schedule

Is my math right? The new CU servicing schedule for SQL Server 2017 is: 1 CU per month for the first year 1 CU per quarter through mainstream support (5 years) That means by my count, we get this: WITH … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Security and Patching Struggles

A couple weeks ago we had a huge security issue with the WannaCry ransomware racing across the world. I was out of the office, and mostly offline, so I was a bit out of touch. However, many organizations were affected, … Continue reading

Posted in Editorial | Tagged , ,

Another Re-Release

If you haven’t noticed, SQL Server Release Services dropped an updated CU6 for SQL Server 2014 SP1 this week. This replaces a previous CU6 that had a NOLOCK bug in it, and the old KB article (and patch) have been … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Install Cumulative Updates

For years I haven’t recommended installing Cumulative Updates (CU) as they are released. The main reason is that Microsoft has had language associated with their CUs that say customers should not install a particular CU unless they are experiencing the … Continue reading

Posted in Editorial | Tagged ,

Reasonable Timeframes

Many of us hear about problems with various systems on a regular basis. We report them in Database Weekly far too often, and I’m sure a few of you have been informed (or found) bugs, nagging issues, even vulnerabilities in … Continue reading

Posted in Editorial | Tagged ,

The Service Pack Fiasco

I remember getting a Service Pack years ago that caused a blue screen of death on Windows 2000 servers when it was installed. In fact, a quick search shows that quite a few operating systems (and SQL Server 2005) have had issues … Continue reading

Posted in Editorial | Tagged ,

The Final Service Packs

There was an announcement recently that Service Pack 3 for SQL Server 2008 R2 was released. This is the final SP for that version and is mostly a rollup of all the previous cumulative updates (CU), though there are a couple additional … Continue reading

Posted in Editorial | Tagged , | 2 Comments

MS14-044–Security Alert for SQL Server

I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL Server. Here’s the bulletin: MS14-044 There are QFE and GDR patches for versions since 2008, but you need to read … Continue reading

Posted in Blog | Tagged , , ,

Patching Problems

I applied the Windows 8.1 update a few weeks ago and had some issues with my machine. Windows was fine, but I lost my SQL Server service. A few other users, including some of the SQLServerCentral community also had issues and sent me … Continue reading

Posted in Editorial | Tagged , , , | 1 Comment