Insufficient Space to Create Databases For SCOM 2012 R2
Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...
2014-10-16
708 reads
Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...
2014-10-16
708 reads
Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go...
2014-10-16
764 reads
The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the...
2014-10-15
911 reads
Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader,...
2014-10-14
869 reads
Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have...
2014-10-13
918 reads
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...
2014-10-13
851 reads
For the fifth year Steve Jones and I are organizing the Monday Night Networking Dinner at the PASS Summit. It...
2014-10-10 (first published: 2014-10-02)
6,065 reads
Introduction
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog...
2014-10-10
767 reads
Quick note in case I need again some day. The team recently moved all the user databases for a monitoring...
2014-10-09 (first published: 2014-10-02)
6,020 reads
One of my current projects is PASSWatch. Right now it’s mostly aggregation which I think has value, but I hope...
2014-10-08
878 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