The age of the Service Pack is over. The time of the Modern Servicing Model has come

It's CUs and GDRs here on out for Microsoft's SQL Server


It's the end of an era. Microsoft has finally released its very last SQL Server service pack.

Microsoft first warned the end was nigh some years ago, but the reality is here: SP3 for SQL Server 2016 is to be the last, the service pack beloved by administrators around the world killed off in favour of a "Modern Servicing Model."

The successors to SQL Server 2016 have already moved on from service packs, according to Microsoft, with only Cumulative Updates (CU) and General Distribution Releases (GDR) filling the void.

Indeed, many a company would hold off from installation until at least SP1 had been reached yet those days are gone from much of Microsoft's product line-up nowadays.

But what of quality? "Will the testing and resulting quality levels of CUs be the same as SPs?" asked an FAQ in Microsoft's earlier posting on the topic.

"Yes," was the unsurprising and cheery response, "CUs for all versions of SQL Server are tested to the same levels of Service Packs," and "you should plan to install a CU with the same level of confidence you plan to install SPs as they are released."

Best not mention CU2 for SQL Server 2019 then, which broke that little-used component: SQL Server Agent.

Service Pack 3, which contains CU1 through 17, also comes hot on the heels of the end of mainstream support for the product in July. Extended support (which requires an install of SP3) goes to July 2026. Users running SP2 have just over a year of support remaining until a move to SP3 is required.

Still, the final Service Pack for SQL Server 2016 does very much represent the demise of the on-premises darling. Yes. It is time to move on. ®


Other stories you might like

  • DuckDuckGo tries to explain why its browsers won't block some Microsoft web trackers
    Meanwhile, Tails 5.0 users told to stop what they're doing over Firefox flaw

    DuckDuckGo promises privacy to users of its Android, iOS browsers, and macOS browsers – yet it allows certain data to flow from third-party websites to Microsoft-owned services.

    Security researcher Zach Edwards recently conducted an audit of DuckDuckGo's mobile browsers and found that, contrary to expectations, they do not block Meta's Workplace domain, for example, from sending information to Microsoft's Bing and LinkedIn domains.

    Specifically, DuckDuckGo's software didn't stop Microsoft's trackers on the Workplace page from blabbing information about the user to Bing and LinkedIn for tailored advertising purposes. Other trackers, such as Google's, are blocked.

    Continue reading
  • Despite 'key' partnership with AWS, Meta taps up Microsoft Azure for AI work
    Someone got Zuck'd

    Meta’s AI business unit set up shop in Microsoft Azure this week and announced a strategic partnership it says will advance PyTorch development on the public cloud.

    The deal [PDF] will see Mark Zuckerberg’s umbrella company deploy machine-learning workloads on thousands of Nvidia GPUs running in Azure. While a win for Microsoft, the partnership calls in to question just how strong Meta’s commitment to Amazon Web Services (AWS) really is.

    Back in those long-gone days of December, Meta named AWS as its “key long-term strategic cloud provider." As part of that, Meta promised that if it bought any companies that used AWS, it would continue to support their use of Amazon's cloud, rather than force them off into its own private datacenters. The pact also included a vow to expand Meta’s consumption of Amazon’s cloud-based compute, storage, database, and security services.

    Continue reading
  • Atos pushes out HPC cloud services based on Nimbix tech
    Moore's Law got you down? Throw everything at the problem! Quantum, AI, cloud...

    IT services biz Atos has introduced a suite of cloud-based high-performance computing (HPC) services, based around technology gained from its purchase of cloud provider Nimbix last year.

    The Nimbix Supercomputing Suite is described by Atos as a set of flexible and secure HPC solutions available as a service. It includes access to HPC, AI, and quantum computing resources, according to the services company.

    In addition to the existing Nimbix HPC products, the updated portfolio includes a new federated supercomputing-as-a-service platform and a dedicated bare-metal service based on Atos BullSequana supercomputer hardware.

    Continue reading

Biting the hand that feeds IT © 1998–2022