1.SQL Server Vulnerability: Audit Failure for SERVER_PERMISSION_CHANGE_GROUP in SQL Server 2022
This blog begins by saying, “Important Disclaimer: This vulnerability was reported to Microsoft. After assessment from Microsoft side they concluded that this is a low impact vulnerability and will fix it in a future “cumulative update” patch.”
It concludes with “security auditing is a very crucial security feature , and any bug or deficiency will lead to a security whole in your system, because security audit logs are shipped for real time security monitoring through SIEM solutions. Be aware of this vulnerability when you upgrade from previous versions of SQL Server to 2022 release.”
2. Vectors in Oracle Database 23ai FREE
This blog from Connor McDonald begins with, “This is a long overdue post which arose initially from a discussion with Philipp Hartenfeller way back in August 2024. I made a note to blog about it, headed off to CloudWorld and of course promptly forgot about it 😃
When you are tinkering with the cool new vector features in 23ai FREE, you might hit some problems when you try to create a vector index.”
3. Preview the Redesigned Oracle Cloud Console
This blog links to a 3 part blog series
4. Infinity – Old Oracle Numbers
Neil Chandler starts this blog with:
“A long time ago, Oracle had a couple of special numbers that you were allowed to store in a NUMBER datatype. They were Infinity and Negative Infinity!
If you selected these numbers (using SQL*Plus) , they showed up as “~” and “-~“, although it is worth noting that if you’re using the funky modern sqlcl you get the words “Infinity” and “-Infinity”.
Davis Kurtz asks, “What happens if I have two consumer groups with different CPU time limits, but the same long-running SQLs can be run in either group?
Pete Finnigan asks, “Can we use AI in Oracle security?”
7. Handling OGG-01154: No Data Found Exception in Oracle GoldenGate
Nassyam Basha says, “Oracle GoldenGate is a powerful replication solution, but certain scenarios can trigger exceptions that require investigation. This test case examines how GoldenGate handles a no data found error when a record is deleted at the target but subsequently updated at the source.”
This blog shares:
Brief: The parameter “max_datapump_jobs_per_pdb” is controls the maximum number of concurrent session in Data Pump jobs for each pluggable database.
Impact on this parameter: If you set this parameter to high value it may leads the datapump jobs consume more resources and also low value my restrict the users to executing jobs.
Usage of resources: The major resource of datapump utilize in SGA of the DB., we should maintain an balance b/w resource usage and job execution.
9. Mailinator, but self hosted in your OCI tenancy with Inbucket
Christopher Johnson begins with: “Mailinator is a service that provides “disposable” email addresses – it accepts mail for any addressee and provides a web interface and APIs to read them. Most people I know use it for things like “sign up for our email list to get a discount” but the creators market it as being intended for testing. And it’s good for that. But you probably don’t want to expose even a preproduction site and its “welcome to” or password reset emails to everyone on the big bad internet. So let me show you how to deploy your own workalike called Inbucket on OCI instead!
First things first let’s draw a quick diagram to show what we will be building.”
10. Financial Reporting – Another Nail in the Coffin
Erik Erikson writes, “Oracle announced in the release notes that support for Financial Reporting in EPM is ending in June 2025 and this message is a confirmation. As noted above, this transition has been planned for some time now.
Fortunately, it’s not a hard process to convert existing Financial Reporting reports to Reporting. But before trying to migrate reports, check first that they run and have no errors (if a report doesn’t work now, it’s not going to work later). Also check with the users about which reports need migrating.”