After Seven Years, Time for Something New
Earlier this month, I passed the seven year mark at Digineer. It was a weird feeling, since the last time...
2012-09-14
709 reads
StrateSQL
Sometimes Failure Is An Option
Wouldn’t it be nice if failure was an option? You could go along in life, screw it all up and...
2012-09-12
772 reads
Going to San Diego (#SQLSat157)
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
694 reads
Lost in Translation – Deprecated System Tables – sysdevices
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-09-07
1,173 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
895 reads
Minnesota SQL Saturday (#SQLSat149)
It’s close to that time of year again. It’s time for a SQL Saturday in Minnesota and this… it isn’t...
2012-08-28
942 reads
Lost in Translation – Deprecated System Tables – sysdepends
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-08-22
1,232 reads
Got A Pal in Kalamazoo (#SQLSat160)
It’s been a year already and it’s time to head back to Kalamazoo for their SQL Saturday. We’re heading back...
2012-08-21
919 reads
August #Meme15 Round-Up
The August round of #meme15 finished up last week with a good number of people participating. The aim of the...
2012-08-21
741 reads
Why I Like My Job – #Meme15
A while back, Kevin Conan (Blog | @ConanTheCDN) emailed me about this months #meme15 topic. He thought it would be good...
2012-08-20
1,029 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
Forums
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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