2010-07-30
2,771 reads
2010-07-30
2,771 reads
Steve Jones thinks we should be building feedback loops into all our systems. Not just for customer service, but also for bugs.
2010-07-29
126 reads
Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty...
2010-07-29
1,913 reads
It seems that Thursdays are becoming SQL Saturday day here at my blog. I wrote a few posts about SQL...
2010-07-29
1,111 reads
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
800 reads
Outsourcing is a fact of life, but with the economic issues worldwide, it has also slowed. That will change eventually and Steve Jones has some thoughts about what you can do to prevent it for your job.
2010-07-28
291 reads
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,041 reads
Do I follow my own advice?
I’ve been asked that at a few of my Modern Resume presentations if I do...
2010-07-27
1,486 reads
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
2010-07-27
168 reads
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge....
2010-07-27
678 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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