SQL Server Autogrowth Settings Changes
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
3 reads
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
3 reads
This week I attended THAT Conference in Round Rock, just outside Austin, Texas. This was my second time attending the conference, which is a very unique. The conference runs...
2024-02-01
43 reads
A Primer on Attaching Databases with PowerShell Method AttachDatabase
Attaching a SQL Server database using PowerShell can be straightforward. Here's an effective and easy approach using the...
2024-01-31 (first published: 2024-01-16)
475 reads
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
63 reads
Introductory Ramble Spark Connect In July 2022, at the Data and AI summit, Apache Spark announced “Spark Connect,” which was a way of connecting to Apache Spark using the...
2024-01-31 (first published: 2024-01-17)
374 reads
The holidays have passed and it’s a new year. You probably have a gift card or two and haven’t decided how to use it yet. Allow me to help:
Buy...
2024-01-30
35 reads
Thanks to everyone that came to my talk at THAT Conference. The deck is here, if you want to download it and use it as a resource, or to...
2024-01-29
35 reads
A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...
2024-01-29 (first published: 2024-01-10)
290 reads
📰 News Fabric end-to-end use case: Data Engineering part 2 – Pipelines If you’re new in Microsoft Fabric – check this series and build it with Sam. Set up...
2024-01-29
25 reads
I’m in Round Rock, TX today at THAT Conference. I attended THAT Conference in Wisconsin Dells last summer, and it was fun. I took my wife, but I wish...
2024-01-29
19 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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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