Book Review: Chasing Daylight
I read Chasing Daylight by Eugene O’Kelly after a reference to it in an audio book. It’s the story of...
2010-11-30
1,508 reads
I read Chasing Daylight by Eugene O’Kelly after a reference to it in an audio book. It’s the story of...
2010-11-30
1,508 reads
I’ve been living with my Droid X phone for a couple weeks now. It’s definitely a big change from my...
2010-11-29
1,484 reads
It’s the end of November and this will probably be my last update on PASS for the year as things...
2010-11-29
1,564 reads
Today we have a guest editorial from Andy Warren. Are you ready for an inspection at work? Are you really running your environment in a way that would make you proud? Andy has some thoughts about sticking to your policies and procedures.
2010-11-29
107 reads
TechEd will be in Atlanta next year, May 16-19, 2011 at the Georgia World Conference Center. I went this year...
2010-11-29
1,535 reads
Today we have a guest editorial from Andy Warren. Andy discusses the need to consider personnel when you are planning for things to go wrong.
2010-11-23
161 reads
I ran across this article in Visual Studio Magazine that tracks the source of a missing object to an embedded...
2010-11-19
559 reads
Somewhat of a strange title, but it’s been an interesting journey to understand that I do take risks and to...
2010-11-18
564 reads
My friend Mala is heading up the 2nd annual SQLSaturday in Louisville, KY, being held next year on January 22,...
2010-11-17
482 reads
One of the ideas I mentioned in my presentation on Comprehensive Professional Development was to set up some type of...
2010-11-17
1,808 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...
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,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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