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 […]
Archives de l’année : 2026
[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 […]
Announcing the SSMS StatisticsParser Extension
If you do a lot of query tuning, you’ve probably come across Richie Rump’s StatisticsParser.com. Now, it’s even […]
4 CVEs are affecting Valkey databases. Here’s everything you need ...
There’s now another reason an immediate patch is needed for organizations running Valkey clusters, according to Percona […]
How tampered indexed-view metadata can break cross-database isolation in SQL ...
Indexed view tampering in SQL Server backups can expose cross-database data after restore. In this article, you’ll […]
In 2026, engineering teams are quietly accepting more risk. Here’s ...
Redgate’s 2026 State of the Database Landscape report reveals that people are increasingly willing to accept more […]
PostgreSQL is removing MD5 authentication for passwords. Here’s what it ...
Upcoming versions of PostgreSQL will be phasing out the MD5 hashing method within the authentication infrastructure of […]
[Video] Office Hours in Port
Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, […]
Turns Out DBAs Use the Consultant Toolkit, Too
When I first hired Richie over a decade ago, the very first task I assigned him was to […]
How to build a privacy-aware analytics layer with SQL (4 ...
Privacy-aware analytics is the practice of generating insights without exposing PII, helping you stay compliant with laws […]
New Official Documentation on Forced Parameterization
I love me some documentation. For years, I’ve pointed folks to the SQL Server 2008 documentation on Forced […]
Why database ownership is so fragmented in 2026 – and ...
In today’s cloud-driven, multi-platform environments, answering the simple question – who owns that database? – is no […]
It’s Our Anniversary! Let’s Have a Sale!
Way back in May 2002, I posted my first blog post here. I didn’t know what it would […]
How DataOps principles help to reduce GenAI risk and improve ...
John Kerski explains how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. […]
“We want to archive, but we still want to query ...
At least once a month, I get this question from a client: We have big data, and we […]
Why COALESCE might be the most useful SQL function you’re ...
In SQL, handling missing or NULL values is essential for reliable data analysis and application logic. The […]
Free SQL Server Spring Training on Performance Tuning
Times and tech are changing quickly. Let’s get you up to speed on the latest developments to do […]
Who’s Hiring Database People? May 2026 Edition
Is your company hiring for a database position as of May 2026? Do you wanna work with the […]
What are managed identities in SQL Server 2025? A complete ...
Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft […]
Alias DNS vs fichier host vs Alias Client
Quand se pose la question de la migration d’un serveur SQL, se pose inévitablement la question des chaines […]
Free Webcast: Fixing Parameter Sniffing with Index Tuning
When a query is sometimes fast and sometimes slow, there are a lot of ways you can reduce […]
What is chunking, and how does it apply to vectors ...
In this article, Greg Low explains what chunking is, why it matters for embeddings, and how SQL […]
So You Wanna Build an App
I get a lot of emails like this: Hi! I built an app. Can you take a look […]
How to get 80% of GPT-4’s value for 20% of ...
AI model costs can explode fast – and overpaying is common. The reality is, you don’t need […]
You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually […]
What is fillfactor in PostgreSQL – and when should you ...
fillfactor in PostgreSQL controls how full table or index pages are. The lower the fillfactor, the better […]