Close, but no MCM Cigar
I failed.
There’s no other way to say it, but I’m not really disappointed or discouraged. I’m actually fairly upbeat about...
2011-04-12
1,200 reads
I failed.
There’s no other way to say it, but I’m not really disappointed or discouraged. I’m actually fairly upbeat about...
2011-04-12
1,200 reads
Quite a few utility companies and energy producers have ha data breeches in the last year, yet most of them don't have good tools to detect the intrusions or the support of executive management. Steve Jones talks about this being a problem in many companies.
2011-04-11
99 reads
Steve Jones talks about the possibility of SQL Injection, or other security issues from malformed input, affecting our lives in new and annoying ways.
2011-04-11
594 reads
Matt Velic is hosting T-SQL Tuesday this month. You have a week to get a post ready on the apply...
2011-04-11
1,410 reads
2011-04-11
2,366 reads
This Friday Steve Jones asks what you would like to see in Standard Edition. Is there one feature that would make a big difference to you?
2011-04-08
129 reads
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-08
2,355 reads
If the future of out IT works involves more ad hoc, swarming project teams, are you prepared? Steve Jones talks about social networking being something you might consider as a way to build some skills to work with others in a less formal way.
2011-04-07
110 reads
I have been trying to get to Dallas for a SQL Saturday for nearly a year, when the first event...
2011-04-06
873 reads
I have been trying to get to Dallas for a SQL Saturday for nearly a year, when the first event...
2011-04-06
1,396 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