Webinar: Using SQL Storage Compress by Steve Jones and Brad McGehee
Steve Jones and Brad McGehee lead you through real-world examples of working with SQL Storage Compress
2013-05-15
314 reads
Steve Jones and Brad McGehee lead you through real-world examples of working with SQL Storage Compress
2013-05-15
314 reads
Steve Jones sees a problem with the Azure platform. It's one that he thinks is limiting adoption, and may become a big problem for Microsoft at some point.
2013-05-14
216 reads
It’s T-SQL Tuesday time, this month hosted by Wendy Pastrick who asks you to talk about the Long and Winding...
2013-05-14
895 reads
2013-05-13
2,226 reads
I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back,...
2013-05-10
1,020 reads
A picture can express a thousand words. That's a phrase that many of us understand well, and one we embrace when we try to present large amounts of data in reports and dashboards. This week Steve Jones asks you what visualizations you use.
2013-05-10
167 reads
After a recent trip, Steve Jones noted a problem somewhere with the way airlines are handling passenger data.
2013-05-09
162 reads
A future world where the machines rule, as shown in films like Terminator and the Matrix, isn't what most people want. However the fears of machines taking over much of our world are very real. Steve Jones thinks it's not as bad as you might believe.
2013-05-08
124 reads
One of the tools that Red Gate Software makes is SQL Source Control. It’s a plug in to SSMS that...
2013-05-08
8,471 reads
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
2013-05-07
183 reads
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...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
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