Comparing MySQL Enterprise Monitor with Oracle Enterprise Manager for MySQL ...
MySQL Enterprise Monitor was a tool many database administrators turned to in times of need – that […]
Archives de l’année : 2026
T-SQL Tuesday Roundup: You Know A Query’s Gonna Be Bad ...
For this month’s T-SQL Tuesday, I invited y’all to tell me how you know a query’s gonna be […]
AI built my WordPress plugin. Here’s what worked – and ...
Building a WordPress plugin was never part of Grant Fritchey’s comfort zone — but that’s the whole […]
[Video] What AI is Good For Right Now
This isn’t specifically database-related, but it’s the kind of thing I’m really into, so maybe you’re into it […]
How SQL Server maintenance becomes an attack path – and what ...
This article takes one practical thread from Fabiano Amorim’s broader SQL Server security research: how apparently normal […]
[Video] Office Hours Overlooking Rome
I was in Rome to attend a teaching conference, and my AirBnB had the most beautiful view overlooking […]
The best AI developer tools in 2026: from coding agents ...
AI developer tools have matured fast. In 2026, most engineering workflows touch at least one AI coding […]
Updated First Responder Kit and Consultant Toolkit for July 2026
From now on, I’m going to be releasing annual versions of the First Responder Kit, starting with this […]
Big data: what it is, why projects fail, and how ...
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to […]
I let AI build my API. Here’s what happened (building ...
Building an API with AI is fast, but it’s not hands-off. In this article, Grant Fritchey uses […]
How to automate Fabric data agent testing with promptfoo and ...
This guide walks through setting up promptfoo, an open-source LLM testing framework, to run automated test suites […]
Tomorrow’s the Last Day to Sign Up!
Tomorrow’s your last day to join about a dozen of your closest friends – well, you’re gonna be […]
[Video] Office Hours at the Black Pebble Beach
After the PASS Data Community Summit in Frankfurt, Germany, I headed back to Iceland and spent a few […]
What’s missing in T-SQL? My wish list of features that ...
Edward Pollack recently wrote an excellent wish list for T-SQL features he’d like to see in an […]
I Know a Query’s Gonna Be Bad When… #TSQL2sday
I open it up and the first thing I see is a comment with a changelog showing a […]
Confession Time: I Never Taught You About B-Trees.
I work with databases for a living. I teach people, and I help them via consulting. And as […]
AI can build the pipeline, but don’t trust it for ...
Building a database deployment pipeline with AI assistance sounds straightforward…until the AI starts treating temporary security shortcuts […]
Économie d’énergie Windows vs. Optimisation SQL Server
En cette période de fortes chaleurs, je pense utile de rappeler le point suivant. Activer la fonctionnalité d’économie […]
How I built a startup with no web development background: ...
Building a startup as an international student, while job hunting on OPT and coding past midnight, isn’t […]
[Video] Office Hours from Iceland’s Glacier Lagoon
Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple […]
How to match names in C# without exact string comparisons
Duplicate records are a costly problem in any system that stores people’s names. “Jon Smith” vs. “John […]
Who’s Hiring Database People? July 2026 Edition
Is your company hiring for a database position as of July 2026? Do you wanna work with the […]
DMS migration failing? How to debug Oracle to Cloud SQL ...
For database engineers stepping into cloud migrations for the first time, networking is the silent troublemaker. Most […]
How to Format Your Queries in SSMS
Microsoft SQL Server Management Studio 22.7 added the ability to format your T-SQL queries by right-clicking and clicking […]
Live Class Enrollment Closes July 12. Here’s Why.
Years ago, when I used to sell a Live Class Season Pass, I sold it year long. All […]
I let Copilot build my database. Here’s what I learned ...
I handed Microsoft Copilot the keys to design a PostgreSQL schema for Azure Database for PostgreSQL Flexible […]
5 T-SQL features that should already exist (2026 SQL Server ...
SQL Server is one of the most mature database platforms in the world, but that doesn’t mean […]
[Video] Office Hours at Iceland’s Most Famous Waterfall
Iceland has some pretty famous waterfalls, from Þórufoss and Skógafoss in Game of Thrones, to Háifoss in Stranger Things, […]
Analytics in esProc SPL: a complete guide
Understand analytics in esProc SPL with this comprehensive guide covering time series analysis, text processing, statistical methods, […]
5 Reasons You Should Hire Richie Rump Today.
We’re discontinuing our apps (not the First Responder Kit scripts, just the apps), which means I’m laying off […]
The complete guide to XML support in MySQL and PostgreSQL
This article explores how MySQL and PostgreSQL handle XML data differently, including storage behavior, validation, XML querying, […]
Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s ...
Way back in December of 2009, Adam Machanic published a blog post (archive) in which he invited database […]
Announcing New Live Online Classes! Save 50% to Celebrate.
I used to run live online classes all year round, and I really miss it. I’ve had such […]
How I built an app just by talking to an ...
Like most of you, I’ve been using AI large language models (LLMs) at work and at hobby […]
Exposing a SQL injection vulnerability you’ve never heard of (what ...
SQL injection is one of the oldest and most well-understood vulnerability classes in software security. Most developers […]
[Video] Office Hours in a Lava Field
On a 12-hour layover in Keflavik, I pulled over my Suzuki Jimny (love these little things, and we […]
Why you should still become SQL-certified in 2026 (and how ...
It may seem that in today’s rapidly evolving landscape of AI and digital threats, becoming certified is […]
I’m Coming to the #PassDataSummit in Seattle!
The lineup for the PASS Data Community Summit Seattle event was just released,and I’m proud to share that […]
Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs
In this article, I’ll explain how to implement vector search in SQL Server using the VECTOR_DISTANCE and […]
We’re Discontinuing SQL ConstantCare and the Consultant Toolkit. Here’s Why.
About ten years ago, I sketched out an idea for a different kind of SQL Server monitoring tool: […]
How to anonymize PII in LLM pipelines (5 key techniques ...
Large language models (LLMs) and the agents built on top of them ingest everything they are given, […]
From anthropology to analytics: how to build a data career ...
Kristyna Ferris didn’t come from a traditional tech background. She studied anthropology, stumbled into data through an […]
[Video] Office Hours: Off St. Thomas
I’m at sea again, this time cruising aboard the Disney Treasure off of St. Thomas. Let’s go through […]
It’s 2026. Why are databases still failing GDPR compliance audits?
Seven years after GDPR came into force, European regulators have issued over 2,245 fines totalling nearly 5.65 […]
And Then There Was The Time RCSI Actually Made Query ...
Normally when I tell people about SQL Server’s optimistic concurrency isolation levels, Read Committed Snapshot Isolation (RCSI) and […]
Why even the best teams struggle with cloud migrations
According to Redgate’s 2026 State of the Database Landscape report, 91% of teams – no matter how […]
If You Had to Go Back On-Prem… #tsql2sday
For T-SQL Tuesday #199, Koen Verbeeck posed an excellent question: if your company moved up to the cloud, […]
Today Is the Last Day of Our Anniversary Sale!
Way back in May 2002, I posted my first blog post here. I didn’t know what it would […]
How to call an Ollama-based AI text embeddings model from ...
In the first article of this series, I explained how to install and configure Ollama to host […]
How to stop AI hallucinations in enterprise RAG systems (a ...
Retrieval-Augmented Generation (RAG) does not solve AI hallucinations. Instead, it just moves the failure point from the […]