Using Customer Docker Compose File Names
As I use containers more and more to run various things, I decided I not only wanted to set up docker compose files, I wanted to name them something...
2025-09-26 (first published: 2025-09-03)
355 reads
Blog Posts
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I have learned that data quality management really comes down to building the right foundation from...
2025-09-25 (first published: 2025-09-23)
30 reads
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found on Github.
The post Cloud Data Driven User Group 2025 – Slides & Scripts first...
2025-09-25
12 reads
Connect with your SQL Community on Slack
Slack is a popular tool for team interaction. To describe it quickly, it's a feature-rich persistent chat room, with threads,...
2025-09-25 (first published: 2017-05-04)
607 reads
Leading Through Change: Guiding Teams in Times of Uncertainty
Change is not a disruption in technology; it is the rhythm. New frameworks appear, markets shift, customer expectations evolve, and entire strategies can be rewritten in a single quarter....
2025-09-25
14 reads
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably embracing the habit of lifelong learning. For the long-winded answer, read on. Have you ever...
2025-09-24 (first published: 2025-09-04)
440 reads
How to Install SQL Server 2025 RC0 on an Azure VM
I wanted to try out the new JSON index which is for the moment only available in the SQL Server 2025 preview version. I know, it’s not even available...
2025-09-24 (first published: 2025-09-05)
396 reads
SQL Server Is Slow – Part 2 of 4(?)
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk lights up: “The SQL Server is down. Nothing works.” By 9:07, everyone is staring at...
2025-09-24
26 reads
Local LLM Models at SQL Saturday Boston 2025
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...
2025-09-23
25 reads
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise applications. They power everything from e-commerce platforms to financial systems, and their reliability is non-negotiable....
2025-09-22
73 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers