Presenting at Code Camp Orlando
I’ll be at Code Camp Orlando on March 22, 2014 doing a presentation on storing credit cards in SQL Server...
2014-02-05
630 reads
I’ll be at Code Camp Orlando on March 22, 2014 doing a presentation on storing credit cards in SQL Server...
2014-02-05
630 reads
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
501 reads
Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to...
2014-02-03
1,343 reads
Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations...
2014-01-31
1,229 reads
Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He...
2014-01-31
1,157 reads
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...
2014-01-30
1,100 reads
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,318 reads
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
549 reads
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
799 reads
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
979 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