Opening Doors – Part 1
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
As a speaker, blogger, even a DBA at work it’s hard to know when you’re having a positive impact on...
2009-11-23
722 reads
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
535 reads
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
499 reads
I’ve had this on my list of things to talk about someday, a recent post on almost the same subject...
2009-11-18
606 reads
In a recent blog post Brent Ozar questioned why PASS decided to relaunch the SQL Server Standard given the failure...
2009-11-17
747 reads
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
498 reads
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
529 reads
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
541 reads
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
584 reads
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
488 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