SQL Saturday Baton Rouge 2014
Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since...
2014-07-10
711 reads
Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since...
2014-07-10
711 reads
Last night was a big success for the first annual Baton Rouge User Groups Networking Night, an all-user-groups invited event...
2014-07-10
620 reads
Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!
Here is my presentation for the 1:15 presentation in...
2014-06-21
642 reads
I'm thrilled to be joining many of my colleagues at Baton Rouge SharePoint Saturday this weekend at the Louisiana Technology...
2014-06-16
548 reads
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,166 reads
This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I...
2014-05-01 (first published: 2014-04-23)
2,962 reads
I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...
2014-03-29
1,195 reads
About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long...
2014-03-27
745 reads
Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the...
2014-02-27
1,303 reads
Great crowd last night and a great job by organizers Glenda Gable and Jill Joubert for the very first meeting...
2014-02-26
1,007 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