One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...
2026-03-20 (first published: 2026-03-11)
326 reads
The T-SQL Tuesday topic this month comes James Serra. What career risks have you taken? I started my career as a preacher and ended it as a director in...
2026-03-20 (first published: 2026-03-10)
391 reads
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today on Day 4 I would like to write about the Transformer architecture — the foundation...
2026-03-18 (first published: 2026-03-04)
184 reads
In my experience, FinOps success has never been just about tools or dashboards. It comes down to people. The right structure, the right ownership, and clear accountability make all...
2026-03-18 (first published: 2026-03-17)
33 reads
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility into cloud costs. In the cloud, resources can be spun up in seconds and scaled...
2026-03-18 (first published: 2026-03-17)
41 reads
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class on April 13-16, 2026, in Columbia, SC.
2026-03-18
24 reads
Over time, I’ve realised that one of the hardest parts of cloud management isn’t deploying infrastructure — it’s balancing performance with cost. The cloud gives us incredible flexibility, but...
2026-03-18
24 reads
Working in DevOps long enough teaches you two universal truths: That’s exactly why I lean heavily on FinOps. For me, it’s not just a framework — it’s the reality...
2026-03-18
17 reads
I’m starting a webinar series about SQL Server indexing with the fine folks of MSSQLTips.com. Each “episode” will be about 30 minutes long and will feature a certain topic...
2026-03-18 (first published: 2026-03-17)
17 reads
I come to Heathrow often. Today is likely somewhere close to 60 trips to this airport in my lifetime. After over 19 years of working with Redgate (plus a...
2026-03-18 (first published: 2026-03-17)
18 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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