Merry Christmas
Today is Christmas and while I do not expect anybody to actual be reading today, here it is nonetheless. I wish you and your family as many blessing as...
2025-12-25
16 reads
Blog Posts
T-SQL Tuesday #193 – Notes to my past self and from my future self
It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...
2025-12-24 (first published: 2025-12-09)
241 reads
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike Walsh. Mike’s call for us is to end the year on a poignant note –...
2025-12-24 (first published: 2025-12-09)
152 reads
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened and pilots stalled, organizations across industries faced the same challenge: turning AI expectations into sustainable...
2025-12-22
30 reads
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on GitHub. The vast majority of the commits, merges, and squashes I run on a daily...
2025-12-22 (first published: 2025-12-09)
471 reads
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
Recently, the world was reminded of just how fragile the internet can be. Two well established cloud services, Cloudflare and Azure Front Door, both had simultaneous outages that caused...
2025-12-22 (first published: 2025-12-08)
410 reads
A New Word: Etherness
etherness – n. the wistful feeling of looking around a gathering of loved ones, all too aware that even though the room is filled with warmth and laughter now,...
2025-12-19
140 reads
Prepping for Certification, Part 4 of 4
In Parts 1-3, I covered how I prepare for a certification exam. In this last part, I'll talk about how I go about taking the exam.
2025-12-19 (first published: 2025-12-08)
440 reads
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When your SQL Server goes down, alarms are blaring, and managers are hovering, that sentence might...
2025-12-19 (first published: 2025-12-03)
653 reads
4 CPE Opportunity (Virtual) for Charity
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands ISACA Chapter partner together to put on a "CPE catchup" opportunity in December to provide...
2025-12-17
19 reads
Blogs
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...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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