Azure Cloud Chronicles with Microsoft MVPs YouTube Channel
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with Microsoft MVPs channel popped up and when I went to it, I noticed that the...
2025-07-08
24 reads
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with Microsoft MVPs channel popped up and when I went to it, I noticed that the...
2025-07-08
24 reads
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
105 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, John Sterrett
(blog) asks us:
What are you doing, or what can we do...
2025-07-08
18 reads
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-08
91 reads
Logging is a necessity in the database world, well, the entire tech world. You need to know what is happening in and around your databases. It’s easy to setup...
2025-07-07
242 reads
☁️ Cloud vs. On-Premises Database Security: A Strategic Transformation The approach to securing databases has evolved significantly with the rise of cloud computing. In a traditional on-premises setup, organizations...
2025-07-07
15 reads
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
1,044 reads
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media logs, website user interactions, and financial transactions. So, working with streaming datasets can place you...
2025-07-07
181 reads
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
361 reads
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
17 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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...
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