Data is Not Always Enough
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
2014-08-11
110 reads
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
2014-08-11
110 reads
Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...
2014-08-11
565 reads
2014-08-08
1,860 reads
SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.
2014-08-05
8,910 reads
If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.
2014-08-04
8,341 reads
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
2014-08-01
340 reads
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-30 (first published: 2014-07-24)
8,041 reads
2014-07-29
181 reads
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
2014-07-28
303 reads
It can be very easy for technology experts to get frustrated when they see bad design and practices, but you must be careful with how you go about trying to influence change.
2014-07-28
24 reads
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...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
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