A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware. This editorial was originally published on Mar 3, 2008. It is being re-run as Steve is traveling.
2012-12-24 (first published: 2008-03-03)
335 reads
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week...
2012-12-21
917 reads
This Friday Steve Jones asks what the load on your systems are. Do you know what it is and how it compares to other systems?
2012-12-21
92 reads
One of the tenets of good security is that no person or process is granted more rights than it needs...
2012-12-21 (first published: 2012-12-17)
3,394 reads
Automobiles are becoming more complex, with more computerized systems every year. Steve Jones talks about some advances and how we must be sure that security is a part of future design considerations.
2012-12-20
98 reads
Does certification help your career? Is it the choice for those that can't actually accomplish something in the real world? Steve Jones says that it can go either way, but it's up to the individual.
2012-12-19
248 reads
I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...
2012-12-18 (first published: 2012-12-12)
2,735 reads
Like most of us, I get a lot of email. I get subscribed to various services from different ads, events,...
2012-12-17
960 reads
Why is SQL Server licensing so complex? Today Steve Jones asks the question and wonders if Microsoft would make some changes to make it easier to understand.
2012-12-17
196 reads
2012-12-17
71 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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