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)
437 reads
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)
429 reads
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)
139 reads
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
152 reads
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)
542 reads
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)
492 reads
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
20 reads
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
15 reads
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
59 reads
If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...
2025-11-18
50 reads
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers