Hyper-V Guests
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
2010-12-16
79 reads
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
2010-12-16
79 reads
Despite my joking with Aaron Bertrand on Twitter that his suggestion on Connect got voted down because he’s Canadian, I...
2010-12-16
1,040 reads
I'm slow to get this out, but I finally rendered the raw bloopers from November. Enjoy.
Part 1
Part 2
Part 3
2010-12-15
1,104 reads
Today Steve Jones reminds us that talent and technical skills are not necessarily enough to advance your career and that you ought to remember to work on other types of skills that you may want to improve.
2010-12-15
218 reads
It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...
2010-12-14
704 reads
Today Steve Jones talks about those products we consider "low-end." Products like Access or VB. Are they a problem for us?
2010-12-14
179 reads
I’m hosting this month’s T-SQL Tuesday blog party, but that doesn’t mean I can’t participate. I posted the invitation last...
2010-12-14
1,173 reads
There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer...
2010-12-13
808 reads
A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.
2010-12-13
1,775 reads
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 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