Bloggers-Don’t Blog About Spam!
Earlier this week I posted Bloggers, Quit Worrying About Spam, discussing what I felt was an over-focus on preventing spam...
2010-10-27
683 reads
Earlier this week I posted Bloggers, Quit Worrying About Spam, discussing what I felt was an over-focus on preventing spam...
2010-10-27
683 reads
Imagine you’re talking with a recruiter about a position that seems like a good fit and during that conversation they...
2010-10-27
596 reads
With SQLSaturday #49 we tried something I call micro-sponsors, charging $5 for a blogger to sponsor the event. It’s a...
2010-10-26
993 reads
I don’t comment as often as I should on blog posts. I say should because as a blogger I know...
2010-10-25
610 reads
Bill Graziano posted our 2011 budget today. This runs from Jul 1, 2010, through Jun 30, 2011. I hope you’ll...
2010-10-22
675 reads
One more from the ‘new book’ shelf at the library, All Things at Once is an auto biography of Mika...
2010-10-22
707 reads
So far SQLSaturday Tampa will be the first SQLSaturday of 2011, and the first one I’ll be attending in 2011...
2010-10-22
581 reads
Today we have a guest editorial from Andy Warren that talks about ways to enjoy life without spending a lot of money. Some of these might even be great team building ideas.
2010-10-21
189 reads
I was just writing a thank you message to our speakers for SQLSaturday #49 and wanted to write down a...
2010-10-21
588 reads
I wrote Cheap Fun after buying a really cheap – $1 – wood airplane kit at the store for the kids. Amazing...
2010-10-21
739 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