Looking Back
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
731 reads
SQLAndy
Review of The Way
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
675 reads
SQLSaturday Philadelphia, Cocoa Beach, Orlando, and Charleston
I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday...
2013-04-22
650 reads
Assorted Links for April 13, 2013
Consider adding Troy Hunt to your feed listGreat post about the role of staffing firms in your job search and...
2013-04-13
627 reads
How Much Power Does Your PC Use?
I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...
2013-04-08
767 reads
Failing to Overreach
I’m not sure what put this phrase in my head, though I think in part it came from various posts...
2013-04-03
716 reads
Mo-SQL On A Stick
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed...
2013-04-01
1,022 reads
Office Space–Not The Movie
I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or...
2013-03-26
987 reads
We Need a Place for SQLFamily News
I’m writing this because I was thinking about a member of the local PASS chapter on the way home last...
2013-03-29 (first published: 2013-03-22)
1,201 reads
Speaking Tomorrow Night at MagicPASS
I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics...
2013-03-19
652 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