(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists were asked to explain certain anomalies that were projected on a computer screen. One of...
2021-10-01 (first published: 2021-09-21)
447 reads
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema is better than a database model communicated by a multitude of data scripting text objects.
Someone...
2021-08-16 (first published: 2021-07-31)
967 reads
(2021-Jun-30) One of my university professors liked to tell us a quote, “The Sleep of Reason Produces Monsters”, in a way to help us, his students, to stay active in...
2021-07-14 (first published: 2021-06-30)
3,597 reads
(2021-July-07) Back in the late 90s when I was a college student intern at a local power supply company, I was invited to a social event of our IT department....
2021-07-07
98 reads
(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some ‘Server (5xx)’ errors. Nothing has been changed on my side, and I’m not sure how...
2021-06-23 (first published: 2021-06-16)
757 reads
(2021-May-31) Recently, I created a prototype solution for one of the projects, that would copy data files from Azure to SharePoint location. The task is trivial, doesn't require a lot...
2021-06-14 (first published: 2021-05-31)
199 reads
(2021-May-17) It took some time to come up with a final title for this blog post in my attempt to encapsulate its several major ideas: Azure Data Factory (ADF) pipeline,...
2021-05-26 (first published: 2021-05-17)
555 reads
(2021-Apr-23) Memory is an interesting thing, you may not remember all events from your past, but some sparking moments keep extending their bright beams of light. With the growing time...
2021-05-05 (first published: 2021-04-23)
377 reads
(2021-May-01) My first time working with a Data Vault modeling was in 2018, where I started and continued my journey to explore this approach or creating a scalable mechanism to...
2021-05-01
519 reads
(2021-Mar-22) I had an interesting Azure Data Factory (ADF) case last week while pulling a list of files from an Azure Storage account with the help of [Get Metadata] activity....
2021-03-31 (first published: 2021-03-23)
1,460 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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...
Comments posted to this topic are about the item Detecting Characters
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