Thinking on Execution
I read a lot, one the most recent books is The 4 Disciplines of Execution which is, of course, about...
2012-08-31
1,546 reads
SQLAndy
Three Not SQL Blogs To Read
Here are three blogs I’ve been reading recently that are interesting. None about SQL, but you might find some value...
2012-08-31
1,941 reads
Building My Event Bag-Part 4
Back to the list, what should go in this minimalist creation? Here’s what I have so far:
laptop (yes)
charger (yes – buy...
2012-08-31
1,517 reads
Invited to the PASS Summit Blogger Table
Earlier this week I RSVP’d to an invitation to sit again at the bloggers table at the Summit. It was...
2012-08-30
1,537 reads
Misc Links for Aug 29,2012
Sword fighting. A friend sent me this, debunks the movie view we have of sword fighting. I can’t say I...
2012-08-29
1,628 reads
Say Seminar, Not Pre-Con for SQLSaturday
I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by...
2012-08-28
1,031 reads
Re-Using Phone Numbers at the Office
I’ve been with my current client for just over a year and I still get calls for the previous occupant...
2012-08-27
700 reads
Five Applicants for the PASS Board
If you haven’t reviewed the list, head to the PASS Election Page. One incumbent, two appointees, one previous candidate, and...
2012-08-27
568 reads
We Need Our Community Leaders to Share Their Views
My friend Jack Corbett returned to blogging recently and one of his comments was not wanting to be the guy...
2012-08-25
1,145 reads
Auto Tweets from SQLSaturday
I was chatting with PASS community pollinator Karla Landrum recently and she asked me my thoughts on the auto tweets...
2012-08-25
706 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