Prepping for Certification, Part 2 of ?
The advantage of understanding the make-up of the exam: I can tailor my efforts for best results.
2025-11-24
17 reads
Blog Posts
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage FlashArrays, achieving truly consistent backups becomes a critical and interesting technical challenge. In this post,...
2025-11-23
16 reads
2025-11-23
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
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
7 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)
422 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers