Varied and Interesting Links
Here are some things I’ve run across in the past few weeks you may find interesting:
FailCon. Billed as a one-day...
2012-05-14
577 reads
SQLAndy
SQLRally 2012-Closing Thoughts
It was interesting to watch an event that started 17 months ago with Dallas, Nashville, and Denver submitting applications to...
2012-05-12
1,160 reads
SQLRally 2012-Friday
Started the day early, heading to the Convention Center to be at Starbucks at 6:45 for the networking event I...
2012-05-12
956 reads
SQLRally 2012–Thursday
Arrived at the convention center about 7:30, managed to arrive at the right end of the convention center and walked...
2012-05-11
713 reads
Logical Fallacy Poster
Ran across this recently, YourLogicalFallacyIs.com is a site that lists all the ways you can apply logic badly, and they’ve...
2012-05-10
867 reads
SQLRally 2012–Wednesday
Had a nice lunch at On The Border at Orlando International before my flight, used that time to finish some...
2012-05-10
629 reads
My Garden Update
It’s been just over two months since I started my small home garden. The initial work to clear the area...
2012-05-08
659 reads
Moving from Droid X to Droid Razr Maxx
It’s been not quite two years since I moved from a Blackberry to a Droid X. The X turned out...
2012-05-07
537 reads
My Evolving Goals for Attending Conferences
The first conference I went to back in 1999 I attended every session, the bonus sessions, the breakfasts, everything. It...
2012-05-07
943 reads
Kindle Fire Parental Controls
I blogged a while back about not having the ability to easily disable purchasing on the Kindle. Until recently we...
2012-05-05
485 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...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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