The Done Stamp
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
590 reads
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
590 reads
This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...
2012-05-25
621 reads
There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...
2012-05-24
766 reads
I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...
2012-05-23
842 reads
I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...
2012-05-23
727 reads
I received an email from LinkedIn suggesting that I might find these groups useful:
I’m sure those map back to someone...
2012-05-22
728 reads
I was chatting with a friend recently and he said he could never blog the way I do. Which way...
2012-05-18
587 reads
One of the things I’ve learned from running events is to set expectations. If you’re going to provide coffee don’t...
2012-05-18
580 reads
I saw this on the Boing Boing feed yesterday, Little Free Library is a project to try to build 2500...
2012-05-18
843 reads
NELL (Never Ending Language Learning) is a computer system that is trying to learn to read the web. Couple things...
2012-05-17
714 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