My 2013 PASS Suggestion Tsunami List
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
797 reads
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
797 reads
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,429 reads
My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch...
2013-09-06 (first published: 2013-08-08)
1,025 reads
Last week I was checking on some stuff and noticed that a couple databases were in simple mode – unusual, but...
2013-09-05
701 reads
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,438 reads
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
616 reads
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,445 reads
This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...
2013-08-19
688 reads
Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...
2013-08-14
844 reads
Luis Figueroa will be presenting Getting started with Master Data Services 2012 and then Jen Underwood will be presenting Practical...
2013-08-13
646 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