Testing AI with an Office Hours Question
When the new MiniMax H3 image-to-video model dropped this month, I was really impressed with how quickly and […]
Archives de l’année : 2026
How to use the Power BI Desktop Bridge to automate ...
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently […]
When CTEs Don’t Work, Try Temp Tables – #TSQL2sday
Common Table Expressions are awesome because they let SQL Server reorder processing in whatever way it deems to […]
The full story of PASS Data Community Summit: 25 years ...
PASS Data Community Summit is celebrating a milestone most communities never reach: 25+ years of data professionals […]
MSDB attack paths: how to secure SQL Server Agent, triggers, ...
SQL Server DBAs routinely rely on automation: SQL Server Agent jobs, maintenance plans, refresh processes, restore scripts, replication cleanup, […]
[Video] Office Hours: Car in the House Edition
Today I’m hanging out in the dining room, or what would normally be a dining room, but we […]
How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, ...
PostgreSQL replication is one of the most powerful tools available for keeping your database resilient, redundant, and […]
Who’s Hiring Database People? August 2026 Edition
Is your company hiring for a database position as of August 2026? Do you wanna work with the […]
MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls ...
MySQL and PostgreSQL both store spatial and geometric data, but they take fundamentally different approaches. While MySQL […]
Free Webcast: 3 Numbers Every Tuner Should Know.
Every SQL Server performance tuner eventually faces the same question: is this normal, or is something wrong? The […]
How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL ...
Moving from Oracle to PostgreSQL means losing one of Oracle’s most-loved diagnostic tools: the Automatic Workload Repository […]
[Video] Office Hours: Desert Database Q&A
I’m in the Lake Mead National Recreation Area today, hanging out in the triple-digit heat, to answer your […]
How a SQL Server backup can execute attacker code during ...
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with […]
Miscellaneous Thoughts About Building Stuff with AI in July 2026
Over the past couple of years, I’ve been using the bejeezus out of AI. I don’t really feel […]
Need a Reference Check on Richie Rump? Here You Go.
So your company read my post about 5 reasons you should hire Richie Rump, and you checked out […]
What does a modern DBA actually do? 6 key points ...
The DBA role has always been misunderstood. But ask a senior database professional what their week looks […]
Think You Know A Lot About SQL Server? Well, Actually…
Got a few minutes? Close that dating app and pay attention. Check out this little SQL swipe quiz: […]
SQL Server index tuning: common mistakes and how to fix ...
Indexes are supposed to make SQL Server faster – so why do so many databases end up […]
How to get clean, usable data out of SQL Server ...
In the modern data landscape, most of the effort doesn’t go into building models or dashboards. It […]
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 […]
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 […]
Presenting a workshop at PASS Summit West in Seattle!
I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite […]
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 […]