PASS Summit 2012-Wednesday Keynote Part 2
Ted Kummert speaking.
Talking about SQLFamily and the way this event feels like a family reunion (it does)Showing a picture of...
2012-11-07
826 reads
SQLAndy
PASS Summit 2012-Wednesday Keynote Part 1
It’s 8:15 on Wednesday and I’m at the blogger table, hoping for a good to great keynote.
First up is Bill...
2012-11-07
781 reads
Reminder & Invitation–Networking Dinner Tonight
If you’re in Seattle for the PASS Summit and would like a chance to meet some new people in a...
2012-11-05
831 reads
PASS Summit 2012-Part 1
I started this trip with a 4:30 am wake up on Sunday to be at the airport for the direct...
2012-11-05
834 reads
Marking Up Books
I like reading and while I read more on an e-reader than I used to, I still prefer the printed...
2012-11-05
839 reads
Debugging Isn’t an Obvious or Easy Skill
I tend to take it for granted and I imagine most of you do as well, but not everyone is...
2012-11-01
813 reads
More Thoughts on the Mac Air
I’ve been living with my Mac Air for a few weeks now, thought I’d share some quick thoughts:
I miss the...
2012-10-24
812 reads
PASS Election Results Posted
Congratulations to Wendy Pastrick, James Rowland-Jones, and Sri Sridharan on winning a two year term on the PASS Board of...
2012-10-17
805 reads
Reminder to Register for the Monday Night Networking Party
We just crossed the 100 mark for registrants for our Monday Night Networking Party and still room for more. If...
2012-10-12 (first published: 2012-10-09)
1,816 reads
MVP Status: Renewed
I was just answering an email and realized I’m behind on posting on a few topics, one of them the...
2012-10-08
929 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