Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
892 reads
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
892 reads
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,153 reads
By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain...
2011-03-01
936 reads
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,480 reads
Today we have a guest editorial from Andy Warren. There are changes in the Microsoft Certified Master of SQL Server program and many people are considering trying to earn this certification. Today Andy Warren asks if you want to go down that path.
2011-02-28
346 reads
This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...
2011-02-25
1,568 reads
Wirefly is a website devoted to purchasing cell phones and plans. I found it when I was researching my Droid...
2011-02-22
854 reads
I attended the second meeting of MagicPASS (no web site yet) on Feb 16 at Stetson University in Celebration, FL....
2011-02-18
555 reads
PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...
2011-02-18
556 reads
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
2011-02-18
1,369 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