Another Lunch Story
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
583 reads
SQLAndy
Unusual BBQ
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
596 reads
The Bar Where Everyone Queries Your Name?
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
584 reads
Notes from the December 2010 OPASS Meeting
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
592 reads
Email Pruning
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
873 reads
Soft Skills Matter More Than You Think
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
612 reads
More Networking Thoughts
I’ve happened to have a few networking events happen recently that I thought I’d share, all part of trying to...
2010-12-13
648 reads
IT Education Part 2
For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...
2010-12-10
699 reads
Book Review: The Way We Work Isn’t Working
The Way We Work Isn’t Working by Tony Schwartz ($19 @ Amazon) is a holistic approach to work and a work...
2010-12-09
601 reads
SQLSaturday #62–Too Many Speakers
I received the email this week that I won’t be getting a place on the schedule, nor will the other...
2010-12-08
787 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