Networking Dinner at the 2013 PASS Summit–Tonight!
Tonight for the fourth year Steve Jones and I are hosting an informal networking dinner. We’ll be at Buffalo Wild...
2013-10-14
379 reads
SQLAndy
Notes from SQLSaturday #227 in Charleston
My first time in Charleston! Quick notes:
Made the drive with the family in 7 hours, not bad, and easily the...
2013-10-13
558 reads
Renewed As MVP for 2013
Last Tuesday I received the email confirming that I will be an MVP for another year. Nice news to get....
2013-10-07
351 reads
Wrapping Up The 2013 PASS Election-Part 3
Today I’ll continue with my notes and thoughts on the 2013 election process and a good place to start is...
2013-10-06
718 reads
Wrapping Up The PASS 2013 Election–Part 2
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
680 reads
Farewell Tom Clancy
Tom Clancy died yesterday. I’ve been reading his books for a long time and I think I’ve read them all...
2013-10-03
483 reads
Wrapping Up the 2013 PASS Election–Part 1
Yesterday the results were announced, with Jen Stirrup, Tim Ford, and Amy Lewis winning seats for the two year term...
2013-10-03
392 reads
I Just Voted in the PASS 2013 Election
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
576 reads
Monday Night Networking at the 2013 PASS Summit
For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS...
2013-09-27 (first published: 2013-09-25)
1,035 reads
I’m Voting for Allen Kinsel
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
761 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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