Back from the MVP Summit
Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...
2011-03-04
441 reads
Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...
2011-03-04
441 reads
The second part of Steve Jones' series on coding standards within SQL Server.
2011-03-04 (first published: 2002-07-01)
31,220 reads
This Friday Steve Jones talks about the commitments and contracts that you may have with your customers. Do you know what they are? Is the contract explicitly spelled out? Take this Friday's poll and share your answer with everyone else.
2011-03-04
585 reads
2011-03-04
2,641 reads
Today we have an editorial reprinted from Jan 15, 2006 as Steve is on vacation. This one talks about the patching process at Microsoft, and why it sometimes is slower than we might like.
2011-03-03
378 reads
What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.
2011-03-02
2,144 reads
2011-03-02
2,287 reads
I’m glad I went running this morning. It’s been a long day, in and out of sessions and meetings all...
2011-03-01
397 reads
Steve Jones talks a little about the 2011 MVP Summit and what the annual event means to the average DBA.
2011-03-01
177 reads
2011-03-01
2,818 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