SQL Server MVP Daily Paper
A while back, I started a twitterlist of SQL Server MVPs. I wasn’t really sure why, but I just thought...
2011-02-10
544 reads
Blog Posts
SQL University: SQL Server Security Architecture - Home-grown, No Options!?!
Thanks for hanging in there for Day 4 of Security Week here at SQL University. Today we're going to look at the...
2011-02-10
2,165 reads
Why You Should Attend SQL Saturday #70 - Columbia, SC
Free training. Excellent speakers. Outstanding location. Great networking opportunities. Experienced and efficient event staff. These are the primary things you...
2011-02-10
2,148 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-09
783 reads
Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley feeling ill, we will be doing the S3OLV UG...
2011-02-09
3 reads
Feb 2011 S3OLV Meeting
I am getting this out extremely late. I seriously have good excuses for that. Due to my location and Charley...
2011-02-09
343 reads
I make myself smile
Sometimes, usually when I’m editing video, I see myself do something silly. Today was one of those times, and these...
2011-02-09
706 reads
My devLINK Abstracts
For the past few years, I’ve spoken at a great event in Nashville called devLINK. I’ve really enjoyed speaking there.
Although...
2011-02-09
897 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have chosen for this month is Automation! It can...
2011-02-09
5 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have...
2011-02-09
833 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Detecting Characters
Comments posted to this topic are about the item Detecting Characters
Question of the Day
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