Review: Gamma Seal Lids
Last weekend I needed to go to Home Depot to get a five gallon bucket and a lid so we...
2011-11-22
709 reads
SQLAndy
Book Review: Highest Duty, My Search For What Really Matters
Highest Duty, My Search For What Really Matters by Chesley Sullenberger is the autobiography of the pilot who landed Flight...
2011-11-21
894 reads
Managing By Walking Around
For a long time a core piece of my ‘style’ has been to wander the halls a couple times a...
2011-11-18
608 reads
Culture Cubes
A while back I posted about Culture Posters, a technique for trying to build your culture by writing down the...
2011-11-17
817 reads
Distance Decreases Stress
When I’m managing I tend to absorb the stress that my teams feel. It’s my job to help them be...
2011-11-17
635 reads
Identify Risk Early
One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...
2011-11-16
482 reads
The Calendar Driven Organization
I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...
2011-11-15
741 reads
A Plug for IT Pro Camps
Here is something else that started in Florida (doesn’t everything?), a series of events along the lines of Code Camp...
2011-11-14
582 reads
Lists of Words You May Not Know
The Merriam-Webster site has an interesting list of Top 10 Lists, ranging from commonly confused words to things you didn’t...
2011-11-14
643 reads
Culture Shock
The work I’m doing right now has nothing to do with SQL Server, and while it deals with technology, it’s...
2011-11-14
693 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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