HDInsight: First Pass
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
893 reads
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
893 reads
There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...
2012-11-26
1,107 reads
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,112 reads
No major updates at the moment. I still haven’t played with remoting through PowerShell. I’m just living with it.
Had an...
2012-11-19
993 reads
I sat the through the big announcements at the 2011 PASS Summit about the partnership between Microsoft and Hadoop. I...
2012-11-16
1,211 reads
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,368 reads
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2012-11-12
17,087 reads
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
997 reads
I’m a little over two weeks with the Surface at this point. I’ve been travelling all of that time, so...
2012-11-11
1,469 reads
Two quick points, I’m putting this blog together using the Surface.. ooh… and this isn’t a keynote, but a spotlight...
2012-11-09
1,447 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