In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...
2019-06-10 (first published: 2019-05-22)
769 reads
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
Use Case
Leveraging aws system manager sessions can help with aws development, by eliminating the need to RDP for work that can be done via a PowerShell session. In addition,...
2019-06-10
19 reads
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
22 reads
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
92 reads
To my Data Family, Redgate Family, #SQLFamily, and Family Family:Thank you!I love you!Keep going!
The post My #SQLFamily appeared first on Grant Fritchey.
2019-06-10
20 reads
Today I am going to share most of the links about CosmosDB. I was asked if I like this solution or not. Well, I have the luck that I...
2019-06-10
17 reads
Database deployments are scary, you have all this data and if you drop the wrong table, run the wrong delete statement or have an error in a stored procedure...
2019-06-10
4 reads
Database deployments are scary, you have all this data and if you drop the wrong table, run the wrong delete statement or have an error in a stored procedure...
2019-06-10
105 reads
I was interviewed yesterday by Stephen Wynkoop (twitter) for the upcoming SSWUG Virtual Conference on May 23rd. One of the questions was about how to keep management engaged on...
2019-06-07 (first published: 2019-05-21)
482 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