Review of Change to PASS Bylaws
As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly...
2013-12-26
529 reads
As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly...
2013-12-26
529 reads
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
698 reads
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
2013-12-23
158 reads
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
918 reads
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
904 reads
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
831 reads
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
629 reads
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
690 reads
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
217 reads
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,331 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