5 T-SQL features that should already exist (2026 SQL Server wish list)
SQL Server is one of the most mature database platforms in the world, but that doesn’t mean it’s finished. With T-SQL now spanning Fabric, Azure SQL Database, Synapse, and SQL Managed Instance, the gap between what the language can do and what develope …
[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, to Dettifoss in Prometheus, and more. However, probably the most-photographed one is Seljalandsfoss, partially because of its easy …
Analytics in esProc SPL: a complete guide
Understand analytics in esProc SPL with this comprehensive guide covering time series analysis, text processing, statistical methods, custom functions, machine learning integration, and interactive dashboards. Part of the “Moving from Python to esProc …
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 Richie Rump, my developer that’s worked with me for the last decade. Richie Rump, aka Jorriss Calling him “my developer” doesn’t do justice to …
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, indexing strategies, standards support, and the practical challenges developers may encounter when working with XML-heavy …
Get Your Blog Posts Ready for T-SQL Tuesday #200. Here’s the Topic.
Way back in December of 2009, Adam Machanic published a blog post (archive) in which he invited database bloggers to participate in a new monthly event he called T-SQL Tuesday. Each month, he (or a blogger he picked) proposed a topic, and on that date, …
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 a good time at conferences lately, and I feel like it’s time to bring the live stuff back. Plus I don’t know about you, but I have a heck of a hard time paying attent …
How I built an app just by talking to an AI LLM – the good, the bad, and what I’d do differently next time (part one)
Like most of you, I’ve been using AI large language models (LLMs) at work and at hobby level for a couple of years now. Snippets of code, the odd data conversion, a small database for a presentation. What I hadn’t done — and what kept nagging at me — w …
Exposing a SQL injection vulnerability you’ve never heard of (what it is, how it works, and key takeaways)
SQL injection is one of the oldest and most well-understood vulnerability classes in software security. Most developers know the rules: use parameterized queries, avoid string concatenation, sanitize your inputs. And yet, SQL injection vulnerabilities …
[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 can’t buy them in the US) in some of the freshest real estate in the world and took your top-voted questions from https://pollgab.com/room/brento. This is …
Why you should still become SQL-certified in 2026 (and how to achieve it)
It may seem that in today’s rapidly evolving landscape of AI and digital threats, becoming certified is a thing of the past. A throwback, perhaps, to forums circa 2015, where seeing ‘SQL-certified’ community members was the norm. However, many people a …
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 I’ll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow. …
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 VECTOR_SEARCH functions. You’ll learn how vector indexes work, when to use them, and what the key trade-offs are — including the current read-only …
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: one that gathered data just once per day, and gave you a short email with a specific list of actionable tasks to make a difference in health and performance …
How to anonymize PII in LLM pipelines (5 key techniques explained)
Large language models (LLMs) and the agents built on top of them ingest everything they are given, including personally-identifiable information (PII). In workflows where PII is inevitable, proper measures should exist for data sanitization. Data can l …