Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote that instantly stood out as my favorite of the day “Is it possible? …..Why not!...
2025-12-17 (first published: 2025-12-03)
126 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
66 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running. Here’s what happened when I...
2025-12-15 (first published: 2025-11-26)
1,012 reads
Each year around this time, companies enter the familiar ritual of budgeting. For many, it feels like a long and exhausting negotiation between ambition and constraint. Everyone knows, it...
2025-12-15 (first published: 2025-12-02)
709 reads
Superheroes and saints never make art. Only imperfect beings can make art because art begins in what is broken – from Excellent Advice for Living Interesting advice for living...
2025-12-12
15 reads
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day to connect with new faces, explore the bustling expo hall, engage with customers and service...
2025-12-12 (first published: 2025-12-02)
288 reads
Following on from my last post about Getting Started With KubeVirt & SQL Server, in this post I want to see if I can improve the performance from the...
2025-12-11
97 reads
Dry-run xp_delete_file Before Actually Deleting Files?
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...
2025-12-10 (first published: 2025-11-27)
498 reads
Announced at Microsoft Ignite two weeks ago were many new product features related to the data platform. Check out the Major announcements and Book of News. I went through the many announcements and picked...
2025-12-10 (first published: 2025-12-02)
390 reads
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t do that.Dave: What’s the problem?HAL: I think you know what the problem is just as...
2025-12-08 (first published: 2025-11-24)
148 reads
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Comments posted to this topic are about the item What Happens When You Ask...
Comments posted to this topic are about the item Detecting Characters
hi a peer of mine who ive never known to be wrong says a...
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