It’s Been 10 Years. Has Microsoft Built What You Voted ...
Ten years ago, I published a blog post with the top 10 most highly upvoted requests for Microsoft […]
Archives du mois : août 2026
9 things I wish SQL Server had (and why they’d ...
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do […]
How Azure Arc allows a DB admin to become SQL ...
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure […]
sp_TexasHoldEm: Multi-Player Poker in T-SQL
Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other […]
Database Animations: The Difference Between Row Compression and Page Compression
What’s the difference between SQL Server’s row compression and page compression, and when does each one make sense? […]
JSON indexing in SQL Server 2025: how it works and ...
SQL Server 2025 finally gives developers a native JSON data type and, with it, a purpose-built way […]
How to implement Deep Data Security (DeepSec) in Oracle 26ai: ...
So you’ve been tasked with deploying a Generative AI, RAG (retrieval-augmented generation), or Agentic AI application. Have […]
How to avoid nested REPLACE functions with TRANSLATE in SQL ...
If your T-SQL is buried under layers of nested REPLACE() calls just to swap out a few […]
Testing AI with an Office Hours Question
When the new MiniMax H3 image-to-video model dropped this month, I was really impressed with how quickly and […]
How to use the Power BI Desktop Bridge to automate ...
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently […]
When CTEs Don’t Work, Try Temp Tables – #TSQL2sday
Common Table Expressions are awesome because they let SQL Server reorder processing in whatever way it deems to […]
The full story of PASS Data Community Summit: 25 years ...
PASS Data Community Summit is celebrating a milestone most communities never reach: 25+ years of data professionals […]
MSDB attack paths: how to secure SQL Server Agent, triggers, ...
SQL Server DBAs routinely rely on automation: SQL Server Agent jobs, maintenance plans, refresh processes, restore scripts, replication cleanup, […]
[Video] Office Hours: Car in the House Edition
Today I’m hanging out in the dining room, or what would normally be a dining room, but we […]
How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, ...
PostgreSQL replication is one of the most powerful tools available for keeping your database resilient, redundant, and […]
Who’s Hiring Database People? August 2026 Edition
Is your company hiring for a database position as of August 2026? Do you wanna work with the […]
MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls ...
MySQL and PostgreSQL both store spatial and geometric data, but they take fundamentally different approaches. While MySQL […]
Free Webcast: 3 Numbers Every Tuner Should Know.
Every SQL Server performance tuner eventually faces the same question: is this normal, or is something wrong? The […]
How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL ...
Moving from Oracle to PostgreSQL means losing one of Oracle’s most-loved diagnostic tools: the Automatic Workload Repository […]