PreCon Sessions at the PASS Summit
My friend Andy Leonard posted yesterday about the process of getting selected for one of the coveted slots as a...
2010-06-01
388 reads
My friend Andy Leonard posted yesterday about the process of getting selected for one of the coveted slots as a...
2010-06-01
388 reads
The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it...
2010-05-28
1,407 reads
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
2010-05-28
167 reads
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
622 reads
Last week I wrote an editorial for SQLServerCentral titled Does The Job Matter To You?, asking how much the type...
2010-05-25
565 reads
I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor...
2010-05-24
493 reads
I ordered a copy of Currencies That Buy Credibility ($14 @ Amazon) after a comment from author Tom Wanek on Twitter...
2010-05-21
543 reads
If you download the May 2010 minutes of the Board meeting (login required) you’ll see that we devoted an entire...
2010-05-21
592 reads
How important is your job to you? Today's guest editorial from Andy Warren asks the question of the professionals out there, some of whom do great work, but don't care about their jobs.
2010-05-20
311 reads
We’re still in the early stages so the pace is comfortably slow. We’ve got about 30 sessions in already (plenty...
2010-05-20
518 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