Need a Blogging Nudge? Try Plinky
If you want to blog you need ideas, something to write about, and sometimes that leads to the blank stare...
2012-04-09
720 reads
SQLAndy
Steady State vs Tempo
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
999 reads
Stress Thoughts-Part 7
I’m going to finish up my thoughts on stress by talking about the philosophy I’ve evolved, some of the tricks...
2012-04-04
826 reads
Stress Thoughts-Part 5
Stress affects everyone, but it’s easy to forget that. Once you get sensitized to it, it’s amazing to pick up...
2012-04-02
731 reads
Announcing SQLSaturday #175–In Flight Edition
One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...
2012-04-01
691 reads
Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,524 reads
Stress Thoughts-Part 4
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,618 reads
Stress Thoughts-Part 3
It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...
2012-03-28
688 reads
Stress Thoughts–Part 2
One thing I’ve learned is that even losing one hour of sleep or just not sleeping well degrades my ability...
2012-03-27
718 reads
Stress Thoughts–Part 1
If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...
2012-03-26
719 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