Hello there! Another week, another roundup of Internet interesting stuff. Press Microsoft Business Applications Summit The event is happening now in the Georgia World Congress Center in Atlanta, GA....
2019-06-10
20 reads
It was tremendously extensive week for me (a week ago) when I spent time between two conferences: SQLDay (Wroclaw, Poland) and SQL Saturday #857 (Kiev, Ukraine). I’ve been helping...
2019-05-26
12 reads
Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...
2019-05-13
19 reads
Since now, we will not keep our guests in secret. We want you to be prepared and wait if you’re interested in. First time 2 vs 2 in #AskSQLFamily...
2019-05-01 (first published: 2019-04-19)
201 reads
Introduction Guy in a Cube is all about helping you master business analytics on the Microsoft Business analytics stack to allow you to drive business growth. They are just...
2019-04-26
52 reads
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
5 reads
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....
2019-03-23
391 reads
Hi there! I’m in Bellevue, WA today when finishing this post. My first MVP Summit and the second trip to...
2019-03-17
368 reads
Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...
2019-03-11
302 reads
SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens,...
2019-03-06
392 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...
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