Wrapping Up The PASS 2013 Election–Part 2
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
680 reads
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
680 reads
Tom Clancy died yesterday. I’ve been reading his books for a long time and I think I’ve read them all...
2013-10-03
483 reads
Yesterday the results were announced, with Jen Stirrup, Tim Ford, and Amy Lewis winning seats for the two year term...
2013-10-03
392 reads
Looking for a new job? Want to pick the best one? Your employer probably feels the same way. Andy Warren talks about how your interview is more like dating than you think.
2013-09-27
375 reads
For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS...
2013-09-27 (first published: 2013-09-25)
1,036 reads
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
576 reads
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
761 reads
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
845 reads
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
962 reads
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
664 reads
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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