TechEd 2010 – Tuesday Morning
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
477 reads
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
477 reads
One of the nice unplanned parts of the trip was walking out the front door of the hotel to realize...
2010-06-07
547 reads
Flew out of Orlando Sunday morning via Southwest. It was my first time flying SW, I usually go with whoever...
2010-06-07
523 reads
Checkin at TechEd was fast, people were moving through very quickly. Photo ID required, get your badge, and then down...
2010-06-07
315 reads
As you may recall we relaunched this late last year, trying to fill a gap in both content on sqlpass.org...
2010-06-04
275 reads
A guest editorial today from Andy Warren. When someone is looking to introduce a free version of a product, what's the best way to tackle it?
2010-06-04
157 reads
I’m flying out early Sunday morning, looking forward to four days at TechEd. It will be a break from the...
2010-06-04
279 reads
Note: This isn’t a recommendation or endorsement, just notes from some research I’ve done. Please contact your vendor before making...
2010-06-03
553 reads
Another recent editorial I wrote for SQLServerCentral talks about whether you would be happy doing your hobby for living. For...
2010-06-02
697 reads
For years, ever since I was first required to be on call, I’ve made it a habit to check my...
2010-06-01
627 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