Visiting Atlantis
This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at...
2013-06-26
1,351 reads
SQLAndy
PASS Nominating Committee for 2013 Elections Announced
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,245 reads
Kindle vs Library
Since I bought a Nexus 7 (two of them, I broke the first one) I’ve been interested to see if...
2013-06-17
621 reads
Is $160 Per Day a Lot?
Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...
2013-06-17
753 reads
Interesting Approach-One Time Tools
Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...
2013-06-17
872 reads
Vacation Notes
First stop was Philadelphia, mostly because we scheduled our vacation to coincide with SQLSaturday #200, but also because we had...
2013-06-11
922 reads
Presenting at SQLSaturday #231 in Cocoa Beach
I’ll be attending the very first SQLSaturday held in Cocoa Beach on July 27, 2013, and doing a brand new...
2013-06-07
623 reads
Train Rides and A Silly Train Story
This past week I took my kids on a train ride from Philadelphia to Washington DC. It was their first...
2013-06-07
614 reads
Notes from SQLSaturday #200
My first time in Philadelphia (and in Malvern, the actual event location). I drove up Friday night for the speaker...
2013-06-07
775 reads
Back to Plan A
At the end of April I posted a bit on my change in plans and what I thought I’d be...
2013-05-28
792 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