SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting. As I posted here, we will be learning...
2011-07-13
8 reads
Jason Brimhall
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group...
2011-07-13
604 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more...
2011-07-11
4 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that...
2011-07-11
1,060 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in...
2011-07-11
4 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement....
2011-07-11
492 reads
July 2011 S3OLV Meeting
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a meeting was scheduled but did not happen. The cause...
2011-07-06
5 reads
July 2011 S3OLV Meeting
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a...
2011-07-06
485 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would share some experiences. None of these experiences were job...
2011-07-06
8 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would...
2011-07-06
726 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