The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
505 reads
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
505 reads
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
537 reads
One of the many small things you don’t have to worry about any more when working with Azure SQL Database...
2016-01-18 (first published: 2016-01-11)
1,402 reads
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
586 reads
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
436 reads
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,747 reads
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
965 reads
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Never mind.*
Instead, it seems I’ll be...
2015-12-18 (first published: 2015-12-14)
1,256 reads
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
453 reads
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
489 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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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