Blogger Awards
A few days ago I wrote about an election that was taking place (ok so it was a week ago...
2010-11-10
569 reads
Jason Brimhall
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
3 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap...
2010-11-09
500 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th, the first Thursday of the month rather than the...
2010-11-04
5 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th,...
2010-11-04
513 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today we get to talk about chapter 7 in...
2010-11-03
9 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
741 reads
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
575 reads
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change...
2010-11-02
631 reads
Voting Day is Here
Tis the season for voting and SQLServerPedia has thrown out an election as well. The SQLServerPedia awards are under way...
2010-11-02
426 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