(Art van Scheppingen) SELECT … FOR UPDATE has a (not so) surprising side effect on non-existent rows: it could cause a (serious) performance penalty and even prevent you from inserting new rows at all.
Author: SSWUG Research
OCI: Enabling X11 Forwarding on an Oracle Linux instance
(Trent) I was connecting to one of my works servers the other day hoping to copy the contents of a file into my clipboard, which would require the use of an X11 forwarded session, but as I connected to the server with X11 forwarding enabled, I was sad to see the following message:
Asynchronous Function Calls through API Gateway on Oracle Cloud Infrastructure
(Lucas Jellema) In a recent article, I described how serverless Functions on Oracle Cloud Infrastructure can invoke each other: synchronously and asynchronously.
Monitor your lockdown profiles
(Connor McDonald) Most administrators are now aware of the lockdown profile facility in the Oracle database (available since 12c). They allow a more granular level of privilege control of components and functionality within the database.
SQL SERVER – Patch Failure – Disk Full: There is Not Enough Disk Space On the Volume
(Pinal Dave) Few of my clients are still running older versions of SQL Server and they have their own reasons to not to move to the new SQL version. In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enough disk space on the volume.”
Lose Your Business App? VS Code to the Rescue!
(David Ramel) I found a new use for Visual Studio Code, the little code editor that could: substituting for a vital work app when your PC dies and a replacement won’t be shipped to your remote office for weeks.
Working with the SerialPort Component in .NET
(Hannes DuPreez) Hello and welcome to my article. Today, I’d like to show you how to perform basic serial port communication. It is quite easy, so let’s get started.
Getting the Most Out of Application Insights for .NET (Core) Apps
(Dave Paquette) Application Insights is a powerful and surprisingly flexible application performance monitoring (APM) service hosted in Azure.
DB2 for z/OS Locking for Application Developers Part 2
(Gareth Copplestone-Jones) As we saw in the previous article, (DB2 for z/OS Locking for Application Developers Part 1) the ACID properties of database transactions (atomicity, consistency, isolation and durability) are intended to guarantee data integrity.
Manage multiple Java SDKs with SDKMAN! with ease
(Rafal Borowiec) SDKMAN! is a convenient tool for managing parallel versions of multiple Software Development Kits. The tool is especially useful for Java developers as it supports SDKs for the JVM such as Java, Groovy, Scala, Kotlin and Ceylon.