The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one ... Continue reading
2020-04-13 (first published: 2020-04-06)
1,378 reads
2020-04-13
9 reads
A friend tagged me in a Facebook post about a surgical mask strap that had been remixed by a Boy Scout for faster printing and less filament usage. My...
2020-04-13
7 reads
A friend tagged me in a Facebook post about a surgical mask strap that had been remixed by a Boy Scout for faster printing and less filament usage. My...
2020-04-13
4 reads
A friend tagged me in a Facebook post about a surgical mask strap that had been remixed by a Boy Scout for faster printing and less filament usage. My...
2020-04-13
7 reads
A friend tagged me in a Facebook post about a surgical mask strap that had been remixed by a Boy Scout for faster printing and less filament usage. My...
2020-04-13
7 reads
I see a lot of confusion among many people on what features are available today in Azure Synapse Analytics (formally called Azure SQL Data Warehouse) and what features are...
2020-04-13
454 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was working with Get-DbaRegServer from dbatools and...
2020-04-13
453 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-13
28 reads
SQL DBA Peter Shore (t) and I had a great time recording this. Quotables: “Vehemently OK”, “Intentional Accidental DBA”, “Professional Nerd”, “Senior DBA as defined by AARP” I cut...
2020-04-13
26 reads
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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