It's all about Customer Service
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
87 reads
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
87 reads
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
410 reads
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
633 reads
I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number...
2017-04-03
426 reads
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
645 reads
I made a mistake the other day. For some reason I got it into my head that I was flying...
2017-03-28
448 reads
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
3,032 reads
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I...
2017-03-20 (first published: 2017-03-07)
1,839 reads
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,755 reads
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the...
2017-03-09 (first published: 2017-02-28)
1,960 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...
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