Visitor Parking
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
178 reads
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
178 reads
The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress...
2013-11-26
494 reads
Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...
2013-11-26
482 reads
Back in September I wrote the first version of Skills I Used Last Week, so I thought I’d loop back...
2013-11-25
721 reads
I’ll be presenting PCI for the SQL DBA today at 1 pm EST for the PASS Security Virtual Chapter. Depending...
2013-11-21
626 reads
Today we have a guest editorial from Andy Warren. Andy asks today if you've thought about a dream job, and if so, what would it be?
2013-11-15
178 reads
For once the drive from Orlando to Tampa went smoothly, no delays due to accidents or construction or UFO’s, a...
2013-11-11
607 reads
Tonight I’ll be talking again with my children about Veteran’s Day, what it means to me, and what I hope...
2013-11-11
498 reads
I’ll be heading back to Tampa on November 9, 2013 for the BI Edition of SQLSaturday. I’ll be presenting PCI...
2013-10-30
1,199 reads
Rick Bolesta and Neil Buchwalter of CA technologies are leaving the Board at the end of 2013. CA and Microsoft...
2013-10-30
1,422 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