Comments on a Recent Visit to Boston
Slightly off topic today.
It's fair to say I'm not a great traveler. Waiting for planes, dealing with the hassles of...
2008-08-26
1,532 reads
Slightly off topic today.
It's fair to say I'm not a great traveler. Waiting for planes, dealing with the hassles of...
2008-08-26
1,532 reads
Just as I was debating whether to take advantage of Amazon's $100 savings offer on the Kindle (with a new...
2008-08-25
1,943 reads
I've used Quicken for a long time now and it's the center of how I manage finances at home. There...
2008-08-25
1,367 reads
One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central...
2008-08-24
1,443 reads
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,625 reads
In a week and a half, I start on the first of my four trips this year for work, and...
2008-08-21
1,459 reads
As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...
2008-08-21
1,401 reads
I got my first opportunity to visit New York City last week. I was actually sitting in on a training...
2008-08-20
1,553 reads
Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...
2008-08-20
1,460 reads
I was visiting with a client recently when they asked me to come take a look at an incident in...
2008-08-20
1,368 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