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 …
4 CVEs are affecting Valkey databases. Here’s everything you need to know (and what you should do, right now, to protect yours)
There’s now another reason an immediate patch is needed for organizations running Valkey clusters, according to Percona (and other database experts.) In this article, I’ll detail four CVEs affecting your Valkey database. I’ll tell you what they are, wh …
How tampered indexed-view metadata can break cross-database isolation in SQL Server
Indexed view tampering in SQL Server backups can expose cross-database data after restore. In this article, you’ll learn how restore-boundary attacks work – and how to defend against them. In my previous article, I showed how SQL Server’s own internal …
In 2026, engineering teams are quietly accepting more risk. Here’s why
Redgate’s 2026 State of the Database Landscape report reveals that people are increasingly willing to accept more risk to be more productive and take full advantage of AI’s capabilities. But, why is this happening – and are they even aware? That’s the …
PostgreSQL is removing MD5 authentication for passwords. Here’s what it means for your databases
Upcoming versions of PostgreSQL will be phasing out the MD5 hashing method within the authentication infrastructure of the database, as first suggested by Nathan Bossart in 2024. In doing so, PostgreSQL will become a safer and more secure database for …
[Video] Office Hours in Port
Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, let’s go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:17 Janis: Hey Brent, Deleted mil …