Having your databases grow by 1MB or percentage based increments can result in issues with many virtual log files (which can lead to long DB recovery times), or waits associated with SQL extending the data file before you’re able to write into it. Configuring appropriately size DB growth increments can help to address both these…Read More
At the end of last year, Microsoft made the decision to delay the release of patches due to the pandemic and the holidays. This decision has left some users with incorrect query results from the CONCAT function and incorrect results from in-memory optimized tables with clustered columnstore indexes.
Fortunately, Microsoft has recently released SQL Server 2019 CU9 and 2016 SP2 CU 16, which should help to resolve these issues. The new updates are available on SQLServerUpdates.com, where users can find the latest news and updates for SQL Server.
The new updates are a welcome relief for users who have been dealing with incorrect query results and other issues. With the release of SQL Server 2019 CU9 and 2016 SP2 CU 16, users can now rest assured that their queries will be running correctly.
For more information on the new updates, visit SQLServerUpdates.com. The website provides the latest news and updates for SQL Server, so users can stay up to date with the latest developments.Read More
In today’s KB 4583468 and CVE 2021 1636, Microsoft is fixing vulnerabilities in Extended Events that “may cause code to run against the SQL Server process if a certain extended event is enabled.” I, for one, throw 100% of the blame on Team Profiler, who surely hacked SQL Server in an effort to discredit Team XE….
The post Extended Events Security Issue in SQL Server 2019, 2017, 2016, 2014 appeared first on SQLServerUpdates.com.Read More
SQL Server 2019 CU7 didn’t go so well, and Microsoft pulled it. Old news. That’s so 30 days ago. Microsoft pulled CU7 due to a bug involving snapshots, and they’ve fixed it in today’s Cumulative Update 8. Or at least…I think maybe they have. Because CU8’s release notes don’t actually mention anything about snapshots (other than…
The post Remember SQL Server 2019 CU7? Forget it. Here’s CU8. appeared first on SQLServerUpdates.com.Read More
If we were playing blackjack, the dealer would have just gone bust, and you’d have collected your winnings. Scattered amongst the pile of cash, Cumulative Update 22 includes: Unfortunately, we no longer get full KB articles for each fix, and that’s a shame because CU 22 includes some really odd fixes like this one: This…Read More
Yesterday, Microsoft dropped Cumulative Update 7 for SQL Server 2019. Among the fixes, Microsoft slipped in a new message in sys.messages. Message 47149 says: Cannot start the job “%s” because this is secondary replica of contained availability group. Start the job in the primary replica of this contained availability group. So, what are “Contained Availability…
The post Announcing SQL Server 2019 CU7, and Work Continues on Contained Availability Groups appeared first on SQLServerUpdates.com.Read More
The 6th Cumulative Update for SQL Server 2019 is out, and she’s a big one. In keeping with the questionable design decision from CU5, Microsoft has given up on documenting a lot of this stuff, and they’re giving you “bug reference numbers” that correspond to some internal documentation somewhere that you’re not allowed to see….
The post SQL Server 2019 Cumulative Update 6: The CU6th Sense appeared first on SQLServerUpdates.com.Read More
It’s here, and there seems to be a new style for posting the KB articles. A lot of the bug fixes don’t have detailed KB articles, so they’re kinda like a box of chocolates. Quick rundown of some of the issues: “Fix:” Scalar UDF inlining issues – this KB article keeps getting expanded with each…
The post SQL Server 2019 Cumulative Update 5: A Box of Chocolates appeared first on SQLServerUpdates.com.Read More
As any polite gift-giver can tell you, for a 20th anniversary gift, the traditional option is fine china. As a result, the download for the new Cumulative Update 20 ships in porcelain. (Disclaimer: Express Edition users only get Rachael Ray china, not the good stuff.) Be careful when extracting it, and you’ll be rewarded with…
The post Unveiling SQL Server 2017 Cumulative Update 20: China appeared first on SQLServerUpdates.com.Read More
Thanks to the quarantine, Microsoft developers are spending dramatically less time at the water cooler, and they’ve passed the savings on to you. Now, they’re locked up at home, forced to do nothing but fix bugs all day. I’m not sure whether to laugh or cry. As a result, just nineteen days after the last update,…
The post Announcing SQL Server 2019 Cumulative Update 4: Another One appeared first on SQLServerUpdates.com.Read More