Speaking at SQLSaturday #7 in Birmingham on May 30, 2009
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,350 reads
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,350 reads
Wes is a friend acquiring via networking and community involvement - another success story! He's based in Tampa and has been...
2009-05-25
562 reads
I've been using Snarfer for a while now, preferring an offline reader so that I use a few spare moments...
2009-05-25
739 reads
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and I think I'm gaining a little ground, but still finding that I have a lot to learn.
2009-05-25
813 reads
Today in the United States we celebrate Memorial Day, the day we remember American casualties of any military action. Though...
2009-05-24
563 reads
The Making of the Atomic Bomb by Richard Rhodes ($14 at Amazon) was a book I picked up for travel,...
2009-05-21
678 reads
I've been reading What Got You Here Won't Get You There by Marshall Goldsmith over the past couple months, and found it to be a useful book. My one sentence summary is that it teaches without the ability to be introspective and let go of your pride,...
2009-05-21
1,793 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-05-20
601 reads
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and...
2009-05-20
665 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-05-19
744 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