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 100 months from then. Me in 2018 at the Porsche museum in Germany Well, guess what: that’s coming up this July! I wonder how many of the orig …
Why migrating from Oracle is harder than anyone admits – and what you should do instead
Oracle-to-Postgres migration seems simple at first, but everything changes when you hit the DBMS_* packages. The 200,000 lines of procedural logic your application has built on Oracle’s built-in package ecosystem — job scheduling, optimizer statistics, …
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 …