Why Isolation Levels Matter More Than Most Developers Think (SQL Server, Oracle, PostgreSQL and MySQL)
One of the Most Misunderstood Topics in Databases After more than 25 years working with…
Devs
SQL Server
SQL Server
Why Every Serious DBA Must Understand Wait Statistics in SQL Server (Lessons I Learned the Hard Way)
The Moment Every DBA Eventually Faces After 25 years working with databases — SQL Server,…
SQL Server
The Hard Lessons I Learned About SQL Server File Configuration After 25 Years Running Databases
Why Disk Layout Still Matters More Than People Think After 25 years working with databases…
Devs
MySQL
Oracle
Postgres
SQL Server
30 SQL Mistakes I Still See Developers Make (And the Production Nightmares They Caused Me) — After 25 Years Across SQL Server, Oracle, PostgreSQL, and MySQL
I’ve spent 25 years living inside databases. Not just reading docs — I mean: being…
SQL Server
The SQL Server Log Most DBAs Ignore… Until It’s Too Late
Why Every Serious DBA Must Master SQL Server Error Logs One of the Most Important…
SQL Server
The Hidden SQL Server Command That Lets You Simulate Hardware: Mastering DBCC OPTIMIZER_WHATIF
Introduction One of the most fascinating — and often overlooked — capabilities inside SQL Server…
MySQL
Oracle
Postgres
SQL Server
Microservices and Their Real Impact on Databases: Architecture, Trade-Offs, and the DBA’s New Reality
Over the past decade, microservices have gone from trend to mainstream architecture. Every company wants…
BI Analyst
Data Analyst
Devs
MySQL
Oracle
Postgres
SQL Server
Data Modeling Is Not Optional: Why a Strong Data Model Defines the Success — or Failure — of Any System
If there’s one mistake I’ve seen repeatedly in my career, it’s this: Teams rushing to…
SQL Server
What Is a Deadlock in SQL Server (And in Any Serious Relational Database)?
If you’ve worked long enough with relational databases in real production environments, you’ve encountered it.…
SQL Server
Cumulative Updates (CUs) in SQL Server: Why Serious DBAs Never Ignore Them
Let me be very clear about something: Ignoring Cumulative Updates in SQL Server is not…