A develop should be a glass-half-full kind of guy, at least according to Steve Jones. This editorial was originally published on April 15, 2008. It is being re-run as Steve is on holiday.
2013-01-21 (first published: 2008-04-15)
259 reads
This week Steve Jones asks you to predict the future of hardware. When will we have laptops that rival the specs of today's large SQL Server servers.
2013-01-18
116 reads
Do you know the basics of how to create a database? Hopefully you do and can do so without the...
2013-01-17
2,800 reads
The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.
2013-01-17
135 reads
Steve Jones talks about Service Broker and messaging and how these techniques can help you build a more robust application.
2013-01-16
273 reads
Today Steve Jones talks about the questions people ask on the Internet about interviews. Are they ok? Should you cram for an interview this way?
2013-01-15
344 reads
Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it...
2013-01-15
1,513 reads
The second article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.
2013-01-15
5,606 reads
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,508 reads
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
2013-01-14
80 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...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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
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