Don’t Understand? You’re About to Learn Something
Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.
2015-03-09
262 reads
Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.
2015-03-09
262 reads
Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.
2015-03-06
137 reads
Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.
2015-02-05
202 reads
I’ve been running WordPress for years now and find it to be a solid solution for what I want to...
2014-12-24 (first published: 2014-12-16)
6,385 reads
Today Andy Warren talks about an employee work item that many of you might not be tasked with.
2014-12-22
143 reads
I recently read Onward: How Starbucks Fought for Its Life without Losing Its Soul by Howard Schultz. Not bad reading...
2014-12-08
849 reads
I’m spending some time this week and the next few weeks thinking about what I want to talk about next...
2014-12-04
651 reads
It’s been just over two months since I wrote the first post for PASSWatch. I’m trying hard to keep PASSWatch...
2014-12-02
550 reads
I finished reading Ghost of My Father by Scott Berkun over the holiday weekend. It’s an intense read about the...
2014-12-02
548 reads
Back in March 2013 I wrote We Need A Place For SQLFamily News after the death of the spouse of...
2014-12-01
517 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...
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