8 Weeks In
I’m about eight weeks into my current project and while I’m certain I don’t know it all, I’m finally at...
2011-09-13
537 reads
SQLAndy
Checkers, Chess, and Politics
There are few games that don’t have some kind of strategy, from tic-tac-toe on up. Sometimes we take the time...
2011-09-12
1,155 reads
My Sessions & Schedule at the 2011 PASS Summit–Early View
I was just checking the event calendar and saw that my Building a Professional Development Plan presentation is on Wednesday...
2011-09-12
766 reads
PASS Update #64 (Officer Elections)
Recently former PASS President Kevin Kline posted his thoughts on the current slate of officers. I encourage you to read...
2011-09-07
1,020 reads
SQLSaturday #85 Is Just Around the Corner
Coming up on September 24th we’ll be doing our fifthannualSQLSaturday here in Orlando. We’re still at Seminole State College but...
2011-09-06
673 reads
Testing Decisions
One of the things I like to do is take some time on decisions that matter to me. That’s a...
2011-09-02
1,037 reads
Parking Places & Editorials
Parking places, that’s the topic of my recent editorial on SSC. A simple topic, but one that most of us...
2011-09-02
851 reads
Strong Manager or Weak Manager?
Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...
2011-08-30
1,722 reads
Notes From The 2011 Jacksonville Code Camp
In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a...
2011-08-29
831 reads
PASS Update #63 (How Do We Rate)
A short update today, following up on an email to the Board from incoming VP of Finance Douglas McDowell who...
2011-08-25
793 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