This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing. This editorial was originally published on Jan 11, 2008. It is being re-run as Steve is traveling.
2012-12-07 (first published: 2008-01-11)
59 reads
I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to...
2012-12-07 (first published: 2012-11-29)
2,997 reads
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes. This editorial was originally published on Apr 3, 2008. It is being re-run as Steve is out of town.
2012-12-06 (first published: 2008-04-03)
492 reads
Do personality types matter and did you know there are more than just A or B types? This editorial was originally published on Feb 26, 2008. It is being re-run as Steve is traveling.
2012-12-05 (first published: 2008-02-26)
286 reads
Defaults are important since so many people just accept them. Steve Jones thinks that SQL Server needs to add more defaults to the setup program that might help DBAs better manage their systems.
2012-12-04
233 reads
Microsoft is asking for feedback, more and more from customers. Steve Jones sees that as a good thing.
2012-12-03
63 reads
The idea of moving to the cloud is scary, but it will happen for many of us. If not at this job, perhaps at the next. Learning more about the cloud is something Steve Jones thinks you should consider.
2012-12-03
438 reads
A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to...
2012-12-03
1,060 reads
Having management get too involved in technical details can cause problems. Steve Jones notes that technical people should minimize the details when communicating with management.
2012-11-29
283 reads
If you are bound by HIPAA regulations, you may have more auditing in your future. If you're not, perhaps you should still pay attention to the criteria being used for auditing.
2012-11-28
123 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