2023-05-17 (first published: 2017-09-26)
271 reads
2023-05-17 (first published: 2017-09-26)
271 reads
I saw someone noting that AIs shouldn’t write obituaries. Since I maintain sqlmemorial.org, I wanted to see what would happen for me. This is part of a series of...
2023-05-16
27 reads
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
2023-05-15 (first published: 2019-12-11)
379 reads
I’m heading to Austin today for Redgate’s internal Level Up conference. This is designed to help employees improve their skills in some way. The original ones focused on technology...
2023-05-15
47 reads
2023-05-15
394 reads
vemoödalen – the fear that originality is no longer possible I used to worry about this, and often I thought that I’d run out of original things to do....
2023-05-12
101 reads
There has been a lot of attention given to ChatGPT and AI over the last month or two. I’ve tried a few things with the public interface at Open.ai....
2023-05-12 (first published: 2023-05-03)
621 reads
2023-05-12
511 reads
2023-05-10
183 reads
2023-05-10
344 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