PASS: Quantum Computing Slides
If you're an attendee at the PASS Data Community Summit this year, there are mechanisms to get slides from every speaker who uploaded them. This slide deck is the...
2025-11-21
46 reads
Blog Posts
SQL Server Database Migration Pitfalls
SQL Server Database Migration Pitfalls (and How to Fix Them)
Database migrations are where great product ideas go to die—unless you plan for SQL Server’s quirks and the realities of...
2025-11-21 (first published: 2025-11-05)
517 reads
The fundamental requirements of a reporting system
There are some fundamental boxes that your reporting system must tick. ✅ The figures must be accurate A good reporting solution can be trusted. A bad one causes confusion...
2025-11-21 (first published: 2025-11-02)
452 reads
Power BI PBIR Format Admin Setting
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...
2025-11-20 (first published: 2025-11-18)
155 reads
Finding the Last Last Name in SQL: #SQLNewBlogger
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting...
2025-11-19
164 reads
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There is a lot of buzz in the air regarding this because it opens new scenarios...
2025-11-19 (first published: 2025-11-04)
561 reads
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost. Sometimes, that “ghost” is really just a guy in a mask trying to scare everyone...
2025-11-19 (first published: 2025-11-04)
517 reads
SQL Server Reliability: Clearing the Fuzzy Thinking
The terminology around reliability is a mess If you’ve ever said, “We’re covered, it’s replicated,” you’re in good company. SQL Server is a massive, 35+ year-old product that...
2025-11-19
46 reads
FabCon Vienna 2025 Recap
Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...
2025-11-18
23 reads
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install...
2025-11-18
88 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers