Blog Posts

Blog Post

IndiaAI Mission: Transforming India with AI Power!

IndiaAI Mission: Empowering India Through Artificial Intelligence🔹 Mission VisionThe IndiaAI initiative aims to harness the power of artificial intelligence to drive innovation, improve accessibility, and catalyze socio-economic development across...

2025-06-04

13 reads

Blog Post

IndiaAI मिशन: भारत को AI की ताकत से बदलने की तैयारी!

🔹 मिशन विज़नIndiaAI पहल का उद्देश्य आर्टिफिशियल इंटेलिजेंस की शक्ति का उपयोग करके नवाचार को बढ़ावा देना, पहुंच को बेहतर बनाना और देशभर में सामाजिक-आर्थिक विकास को गति देना है।...

2025-06-04

17 reads

Blog Post

Query multiple Azure SQL Databases

I was sick of changing context in Azure Data Studio while cleaning up things discovered in our vulnerability assessments. Changing things via PowerShell I wanted to be cautious with...

2025-06-04 (first published: )

429 reads

Blog Post

Stack Overflow & AI

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...

2025-06-04 (first published: )

418 reads

Blog Post

KDA: Echoes of Deception - Case 2

The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem

The police have asked for our assistance, and we’ve...

2025-06-02 (first published: )

206 reads

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

By

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

By

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

By

I’ve had a Dropbox account for years. Like a lot of people, I started...

Read the latest Blogs

Forums

Alamat kontak resmi BCA KCP Tebet Telp:0818751777

By Halo BCA

WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...

Stan Phone Number Australia +61-1800868603 Quick Help Guide

By richardrussel

When things go wrong - like trouble signing in, videos pausing, unclear charges, or...

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

By Layanan BCA 24 JAM

Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...

Visit the forum

Question of the Day

Detecting Characters

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 Taylor
How many rows are returned?

See possible answers