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 kinds of people who read this blog? Let’s make a love connection. If your company is hiring, leave a comment. The rules: Your comment must include the job title, …
Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UD …
How to host an AI text embeddings model for SQL Server using Ollama
When we want to use AI-based comparisons of text, via vector search in SQL Server, we need to first generate embeddings for the text. An embedding is a numeric representation of meaning, usually represented by vectors. In this article, I’ll show you ho …
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more. There’s a part of the data science stack that rarely gets discussed. Not because it’s unimport …
[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 improve performance on an existing server. I’ll show you how to find your server’s top bottleneck, find the queries causing that bottleneck, and the …
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 necessarily AI in general. Part of the problem is something specific about SSMS Copilot and the way it prompts LLMs, and I wish I could tell you exactly what it …
Phare Data
Phare Data : La chaîne qui éclaire vos données Ici, on simplifie l’Analytics et l’IA pour transformer la complexité en choix clairs et actionnables. Plateformes data, patterns d’architecture (Lakehouse, Warehouse, Data Mesh, temps réel), gouvernance, …
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 sizes one day, and your eyes got big. The numbers got a little large while you weren’t looking. This is a great time to stop and think about a few …
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 thoughts on – the recent announcement that many role-based Microsoft certifications are being retired. Microsoft have announced that many role-bas …
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, requiring manual updates. The pgai Vectorizer automatically keeps PostgreSQL vector embeddings in sync by generating and updating …
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 AI, workflows become adaptive, data-driven, and capable of preventing failures – making them essential fo …
[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 performance on an existing database. I’ll show you how to figure out quickly if you’ve got too many indexes or not enough, and then demonstrate …
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 people smugly answer a question with “It depends!” Because most of the time, when they do it, they chuckle as if they know something, and as if what they just said illus …
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 UNPIVOT. Beyond documentation, transforming columns into rows (and vice-versa) can often be confusing and frustrating for those of us tasked with r …
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 easier to use. Now, it’s even easier to use. Download & install it, then run your query with SET STATISTICS IO, TIME ON, and after it fi …