How to Tell if the IO Subsystem Reads Are Struggling
December, 5 2022
How many times have you heard or felt, "It's an IO problem!" How can you tell? What does this even mean? Who's fault is it? It is a broad and...
Read More
World Cup Predictor App
December, 2 2022
As the FIFA World Cup Soccer tournament was approaching, we decided to create an app to have some fun throughout the tournament. The rules were...
Read More
Oracle RAC + ASM + NFS Home Lab
November, 25 2022
Many people look for ways to emulate enterprise hardware in their home labs in order to get good hands-on experience with Oracle products. One of the...
Read More
Understanding How an Intense & Diverse SQL Workload Causes Parsing Problems
November, 4 2022
This post is about how an intense and diverse SQL statement workload can cause Oracle parsing problems. Big problems.
Read More
Loading Large CSV Files Using Oracle External Tables
October, 31 2022
After millions of rows, thousands of files, and hundreds of hours, we've learned a thing or two about working with big data sources, especially files...
Read More
SQL Server 2022 Backup & Restore to AWS S3-compatible Object Storage
October, 24 2022
SQL Server 2022 (16.x) is now in preview, and it introduces a bunch of new features. One of the coolest features I found is the backup and restore to...
Read More
Find the Gap
October, 14 2022
A client’s Data Guard environment fell out of sync when archive logs went missing from the standby. A number of factors played a part:
Read More
Saving an Interactive Grid Cell on Change
October, 14 2022
Have you ever been caught off guard by a co-worker that comes to talk to you about that show that everyone was watching this week and totally forgot...
Read More