Multiplatform Reality Checks: pg_stat_wal vs. Oracle Redo Metrics
For anyone who has spent years tuning Oracle redo, the first time you look at PostgreSQL’s pg_stat_wal view may feel
Read More
Making Technology Bulletproof
Author: Kellyn
Gearing Up for PASS Summit: Keynotes, Redgate Fun, and the Magic AI-Ball
It’s that time of year again when data professionals from every corner of the world are gathering for PASS Data
Read MoreMcDonald’s Drive-Thrus and OOM Kills
We organizers just wrapped up the Data Platform DEI Neurodiversity Day, which I helped host while battling a pretty major
Read MoreWe Can do Better: Why Representation and Respect Still Matter for Women in Tech
I have the greatest respect for those that organize and create user group tech events. It’s an incredible challenge, especially
Read MoreThe Power of Self-Care: My European Adventures Between Tech Events
Recharging, Exploring, and Sharing Knowledge So My Kevlar Stays Intact The world is always moving fast for me, so it’s
Read MoreThat Code Review with OLlama and Qwen 2.5
I just posted on how to use a PowerShell script in a flexible manner to perform different tasks with generative
Read MoreEmbedding Local AI into DataOps with Powershell
When working with database migrations, automation is the key to speed and safety. Redgate Flyway already helps us structure and
Read MoreCareer Lessons from Mentoring
Why I Move On, and Why You Might Need To I mentor between three and five individuals at any given
Read MorePostgreSQL for the Oracle DBA, Part 6: Tuples, MVCC, and Two Views
After our first two weeks of ensuring Grant and I didn’t burn down SQLServerCentral figuring out how Steve Jones has
Read MorePostgreSQL for the Oracle DBA, Part 5: Understanding Wait Analysis
Oracle: Wait Classes & Events As discussed in an earlier blog post, Oracle groups wait events into wait classes like
Read MorePostgreSQL for the Oracle DBA, Part 4: Query Tuning and the PostgreSQL Planner
As an Oracle DBA venturing into the world of PostgreSQL, one of the most important areas to get comfortable with
Read MorePostgreSQL for the Oracle DBA, Part 3: Transaction Control, Locking, and Performance Insight
Now that we finished Part 2 on physical data structures, storage and processes, it’s time to work our way into
Read MorePostgreSQL for the Oracle DBA, Part 2: Physical Data Structures, Storage, and Processes
In the previous post, I covered some high-level areas around installation and architecture, but for this post, we’re going to
Read MoreOracle DBA to PostgreSQL, Part 1: Install and Architecture
As an Oracle DBA stepping into the PostgreSQL world, one of the first surprises you’ll encounter is during installation. If
Read MoreAn Oracle DBA’s Introduction to PostgreSQL – The New Reality
Back in 2004, I had my first run-in with PostgreSQL’s predecessor: Ingres. It was just another database platform for me
Read MoreKeynotes and Data Protection in the Age of AI
Over the last year, I’ve had the privilege of presenting keynotes and technical sessions to both the Oracle and SQL
Read MoreOracle Multitenant- Navigating CDB and PDBs Seamlessly
With Oracle Database 12c, Oracle introduced Multitenant Architecture, a major shift in how databases are structured and managed. This architecture
Read MoreOracle Data Guard: Disaster Recovery AND High Availability
In its traditional, (and free) configuration, Oracle Data Guard operates in an active/passive architecture. This incredibly well-designed and valuable solution
Read More