In this blogpost we will see the step by step installation and few details about SQL Server 2019. For SQL Server 2019 Installation, We have following System Requirements SQL...
2022-04-20 (first published: 2022-04-06)
4,490 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-19
19 reads
My learnings on Redis thus far which you may find useful: Location of Redis should be close to your app. Data structures within Redis, larger key value sizes lead...
2022-04-19
17 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-18
21 reads
TLDR: There ain’t one. I was privileged last week to be able to present a couple of sessions at the SQL Server and Azure SQL Conference (great event, I...
2022-04-18 (first published: 2022-04-11)
605 reads
I had started a Stairway series on containers (which I need to get back to), and I got a question. How do we set the name of a container?...
2022-04-18 (first published: 2022-04-11)
164 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-15
28 reads
Azure Data Explorer is a PaaS offering from Azure providing an end-to-end solution for data exploration. https://azure.microsoft.com/en-us/blog/individually-great-collectively-unmatched-announcing-updates-to-3-great-azure-data-services/ Here is a quick introduction of the features: https://azure.microsoft.com/en-us/services/data-explorer/#features This service from...
2022-04-15 (first published: 2022-03-31)
427 reads
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
342 reads
Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do,...
2022-04-14
136 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...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
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