I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other...
2018-10-03
22 reads
Every now and again, someone asks if I write romance novels. Why? Well, let’s ask Bing who Kendra Little is…. To clarify, I am not married, I have dogs...
2018-10-01
5 reads
I’ve submitted a session proposal to the free, online GroupBy conference. Voting will open for sessions soon, but before then, you can help me out by reading my abstract....
2018-09-27
5 reads
I’ve got FOUR sessions coming up in October. These sessions will each be 30 minutes. Redgate Sessions Wed, Oct 3, 9AM PT / 12PM ET: How to Lead DBAs...
2018-09-26
12 reads
It’s TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great...
2018-09-11
15 reads
Do you know where your career is going? Do you know what skills you need to be successful in the current climate? In this 25 minute keynote, I discuss the...
2018-09-07
12 reads
SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired. Join us...
2018-09-03
8 reads
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
16 reads
Sometimes it’s useful to know how to cause a problem. Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and...
2018-08-22
17 reads
SQL in the City is coming up, and it's a huge opportunity to learn. Register now to attend the free online streamed event, and join the Redgate team in...
2018-08-22
9 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
hi a peer of mine who ive never known to be wrong says a...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
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