Adventures in SQL Server 2019: Microsoft updates the update that broke the update

I don't know why she swallowed the fly...


There was good news for administrators of Microsoft's SQL Server 2019 last night as Cumulative Update 8 emerged, fixing the borkage of its predecessor.

Things haven't been going well for the SQL Server 2019 servicing model: Cumulative Update 2 left the SQL Agent a bit unhappy (resulting in the company advising users to skip the patch if they were using the afflicted component). And most recently Cumulative Update 7 suffered from a "known issue" with database snapshots, which also affected that little-used command DBCC CHECKDB.

Cumulative Update 8 arrived with little fanfare and, like its predecessor, applies to both the Linux and Windows incarnations of Microsoft's database engine. Those who applied the previous borked update and have hit the server with the CREATE DATABASE ... AS SNAPSHOT OF syntax will need to recreate that snapshot before applying number 8.

Microsoft is naturally keen that administrators slap on its sticking plasters as soon possible, declaring that each contains all the fixes (but hopefully not the cock-ups) of those that have gone before and all "are certified to the same levels as Service Packs, and should be installed at the same level of confidence".

In the case of SQL Server 2019's Cumulative Updates, confidence levels may not be particularly high at this stage since two of the eight were subsequently subject to hurried "for the love of God, don't install this one!" warnings from the Windows giant.

This is a shame because the updates are generally packed full of handy fixes. A notable one in CU8 deals with a severe spinlock contention issue afflicting those running on high-end hardware with a high number of concurrent users.

However, despite Microsoft's insistence that customers should opt for "ongoing, proactive installation of CUs as they become available", anyone pondering the update of production systems would do well to consider the company's final bit of advice: "We recommend that you test SQL Server CUs before deploying to production environments."

This is in addition to hitting F5 a few times on the CU knowledgebase page just in case, you know, a big yellow box showing the equivalent of "Argh! It burns! It burns" turns up. ®


Other stories you might like

  • Stolen university credentials up for sale by Russian crooks, FBI warns
    Forget dark-web souks, thousands of these are already being traded on public bazaars

    Russian crooks are selling network credentials and virtual private network access for a "multitude" of US universities and colleges on criminal marketplaces, according to the FBI.

    According to a warning issued on Thursday, these stolen credentials sell for thousands of dollars on both dark web and public internet forums, and could lead to subsequent cyberattacks against individual employees or the schools themselves.

    "The exposure of usernames and passwords can lead to brute force credential stuffing computer network attacks, whereby attackers attempt logins across various internet sites or exploit them for subsequent cyber attacks as criminal actors take advantage of users recycling the same credentials across multiple accounts, internet sites, and services," the Feds' alert [PDF] said.

    Continue reading
  • Big Tech loves talking up privacy – while trying to kill privacy legislation
    Study claims Amazon, Apple, Google, Meta, Microsoft work to derail data rules

    Amazon, Apple, Google, Meta, and Microsoft often support privacy in public statements, but behind the scenes they've been working through some common organizations to weaken or kill privacy legislation in US states.

    That's according to a report this week from news non-profit The Markup, which said the corporations hire lobbyists from the same few groups and law firms to defang or drown state privacy bills.

    The report examined 31 states when state legislatures were considering privacy legislation and identified 445 lobbyists and lobbying firms working on behalf of Amazon, Apple, Google, Meta, and Microsoft, along with industry groups like TechNet and the State Privacy and Security Coalition.

    Continue reading
  • SEC probes Musk for not properly disclosing Twitter stake
    Meanwhile, social network's board rejects resignation of one its directors

    America's financial watchdog is investigating whether Elon Musk adequately disclosed his purchase of Twitter shares last month, just as his bid to take over the social media company hangs in the balance. 

    A letter [PDF] from the SEC addressed to the tech billionaire said he "[did] not appear" to have filed the proper form detailing his 9.2 percent stake in Twitter "required 10 days from the date of acquisition," and asked him to provide more information. Musk's shares made him one of Twitter's largest shareholders. The letter is dated April 4, and was shared this week by the regulator.

    Musk quickly moved to try and buy the whole company outright in a deal initially worth over $44 billion. Musk sold a chunk of his shares in Tesla worth $8.4 billion and bagged another $7.14 billion from investors to help finance the $21 billion he promised to put forward for the deal. The remaining $25.5 billion bill was secured via debt financing by Morgan Stanley, Bank of America, Barclays, and others. But the takeover is not going smoothly.

    Continue reading

Biting the hand that feeds IT © 1998–2022