Not Useless Features
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
2023-11-01 (first published: 2017-12-01)
326 reads
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
2023-11-01 (first published: 2017-12-01)
326 reads
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
2023-11-01
659 reads
Training more people on the job, while still allowing them to continue their education is something Steve thinks would help more people get started in technology.
2023-10-30
118 reads
2023-10-30
497 reads
funkenzwangsborstellung – n. the primal trance of watching a campfire in the dark. I am not a big camper, but 3-4 times a year we usually go out with...
2023-10-27
29 reads
2023-10-27
439 reads
One piece of advice for engineers is to be valuable, but not critical. It's a mistake Steve made early in his career, but he hopes you can do better.
2023-10-27
975 reads
A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post. This...
2023-10-27 (first published: 2023-10-16)
224 reads
I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...
2023-10-27
28 reads
2023-10-25
551 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...
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...
Tlp/Wa_Cs:0817-866-887. Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, RT.2/RW.2, Karet...
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