Referral Contest for PASS Summit
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,371 reads
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,371 reads
We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...
2009-09-30
1,406 reads
I’m late announcing this here, but I’m pleased to announce my friend Jack Corbett is joining me in leading oPASS...
2009-09-29
1,613 reads
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....
2009-09-28
952 reads
I saw this post by Neil Davidson about sales people being different that discusses how sales people are compensated and...
2009-09-27
2,498 reads
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-25
2,229 reads
My friend Smitha sent me this link about fishbowl conversations as something that might make sense to add to the...
2009-09-24
866 reads
Ran across The Inner Game of Stress: Outsmart Life's Challenges and Fulfill Your Potential ($16 @ Amazon) at the the library,...
2009-09-24
688 reads
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-24
1,829 reads
Back in July we had Chad Miller visit oPASS to do a presentation on Powershell. It was well received and...
2009-09-23
858 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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