Buenos Aires Code Camp
No, I didn’t attend this one!
My friend Jonas Stawski is the organizer and we’ve been pleased to be a...
2009-10-06
375 reads
No, I didn’t attend this one!
My friend Jonas Stawski is the organizer and we’ve been pleased to be a...
2009-10-06
375 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-06
339 reads
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
821 reads
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
357 reads
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 reads
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
395 reads
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
191 reads
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
392 reads
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
273 reads
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,389 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