The Justification Database
Having a good process for managing security is important, but how many of us enforce that?
2023-10-25 (first published: 2019-01-18)
428 reads
Having a good process for managing security is important, but how many of us enforce that?
2023-10-25 (first published: 2019-01-18)
428 reads
I missed September since I was gone half the month in Europe and busy with a roadshow. And, I missed October, since I was busy this month and lost...
2023-10-25
46 reads
Another company has hard-coded credentials, which Steve feels are a sign of bad culture.
2023-10-23
150 reads
2023-10-23
427 reads
gobo – n. the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...
2023-10-20
30 reads
A busy year got a little too busy for Steve and he is taking steps to improve his work life balance.
2023-10-20
166 reads
We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post...
2023-10-20 (first published: 2023-10-02)
251 reads
Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...
2023-10-20
27 reads
2023-10-20
462 reads
Steve has had to change his security, which is good, but annoying.
2023-10-18
164 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