Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
2010-07-26
113 reads
This week Steve Jones finds some issues with the security of third party vendor software.
2010-07-26
113 reads
I am honored to be a guest lecturer this week for SQL University. There have been some amazing professors helping...
2010-07-26
8,163 reads
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
2010-07-26
353 reads
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
2010-07-23
180 reads
One of the new products that Red Gate Software has released recently is SQL Source Control. I saw a demo...
2010-07-23
1,481 reads
I have a few people ask about this recently, so I thought I’d blog about it, and maybe get an...
2010-07-23
1,000 reads
2010-07-23
2,620 reads
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
2010-07-22
380 reads
The hardest thing, I think, for most new organizers of a SQL Saturday is the fundraising. A few years ago...
2010-07-22
1,098 reads
I keep seeing lots of debate about Android v the iPhone 4. I have friends talking about how cool Windows...
2010-07-21
1,172 reads
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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