É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 […]
Archives de l’année : 2026
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 […]
[Video] Office Hours: Ask Me Anything At Home
I’m back in the home office to take another round of the top-voted questions from https://pollgab.com/room/brento. Here’s what […]
Looking Back On My 2018 Predictions
For T-SQL Tuesday #100, Adam Machanic’s challenge for SQL bloggers was to predict what databases would be like […]
Why migrating from Oracle is harder than anyone admits – ...
Oracle-to-Postgres migration seems simple at first, but everything changes when you hit the DBMS_* packages. The 200,000 […]
Who’s Hiring Database People? June 2026 Edition
Is your company hiring for a database position as of June 2026? Do you wanna work with the […]
Never ship a broken semantic model again: how to build ...
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — […]
How to host an AI text embeddings model for SQL ...
When we want to use AI-based comparisons of text, via vector search in SQL Server, we need […]
How data scientists work with PostgreSQL from Python (and how ...
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data […]
[Video] How to Tune Queries Fast
In this live stream recording, I’ll show you how to use the latest features of sp_BlitzCache to rapidly […]
SSMS Copilot is Messing With Your AI Prompts.
You might notice that the advice you get from Copilot in SSMS isn’t very good, but it isn’t […]
Phare Data
Phare Data : La chaîne qui éclaire vos données Ici, on simplifie l’Analytics et l’IA pour […]
Your Database Just Hit One Terabyte: Now What?
Congratulations. You were minding your own business, and all of a sudden it happened. You glanced at file […]
Microsoft are retiring role-based certifications. Here’s why they shouldn’t
In this Simple Talk opinion piece, Microsoft certification veteran Dr Greg Low considers – and shares his […]
How to automate vector embeddings with pgai Vectorizer in PostgreSQL
While pgvector enables powerful semantic search, it doesn’t automatically keep embeddings in sync when your data changes, […]
Why AI-driven workflows are important (and how to implement them)
AI-driven workflow automation and orchestration enable faster decisions, greater efficiency, and scalable operations. By combining automation with […]
[Video] How to Tune Indexes Fast
In this 76-minute session, I’ll show you how to use the latest features of sp_BlitzIndex to rapidly improve […]
I Hate The Way You’re Using “It Depends.”
Can I be honest with you for a second? It makes my skin crawl when I hear database […]
Demystifying PIVOT and UNPIVOT in T-SQL
There are few operators in T-SQL that cause developers to scramble for documentation more than PIVOT and […]