Updated SQLSaturday Advisory Council
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
699 reads
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
699 reads
Our last day went well, even extremely well. By day 2 (or day 3 if you attended a seminar) everyone...
2011-05-16
686 reads
Everything went well on Thursday. No major delays at check-in was a good start, and everything going according to plan....
2011-05-13
578 reads
Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...
2011-05-12
692 reads
Here’s your chance to give the program committee your thoughts on which sessions should be selected for the big show....
2011-05-11
553 reads
This year I received an invitation to compete for one of the spotlight sessions and I wanted the presentation with...
2011-05-10
634 reads
It actually starts tomorrow for me (and many of you), I’ll be at the Marriott World Center around 1 pm...
2011-05-09
827 reads
My editorial about Running as Sysadmin ran in the SQLServerCentral newsletter yesterday and generated some good (and passionate!) responses. It’s...
2011-05-09
837 reads
Today we have a guest editorial from Andy Warren that talks about what DBAs might need to know in the future.
2011-04-14
694 reads
Today we have a guest editorial from Andy Warren that talks about the problems we sometimes run into when we must work with other people and make decisions. Sometimes getting the information from people, or giving it to them, is not as simple as we would like.
2011-03-29
150 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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