A New Word: Dead Reckoning
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would have expected, even if they were only an abstract presence in your life, like a...
2025-11-21
13 reads
Blog Posts
A Practical Guide to Kubernetes Stateful Backup and Recovery
Explore methods, tools and best practices for protecting data in databases, memory caches, storage systems and other stateful applications.Featured image by bangoland on Shutterstock.Kubernetes is a very powerful and...
2025-11-21
8 reads
Managing subscribers, creating newsletters
When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous...
2025-11-21 (first published: 2025-11-20)
19 reads
PASS Data Community Summit 2025 Slides and Code
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with Automation! I will have a more comprehensive post in the coming days. Slides and demo...
2025-11-21
24 reads
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
12 reads
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)
396 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)
424 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)
133 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
143 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)
537 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers