Running a Service
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
2023-09-27
117 reads
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
2023-09-27
117 reads
Many people are worried for their future career prospects with the growth of Artificial Intelligence (AI) in many situations. Steve doesn't think that AI is going to take over the world, but it might affect your future opportunities.
2023-09-25
159 reads
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has a great schedule (scroll...
2023-09-25
16 reads
A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...
2023-09-25
85 reads
One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...
2023-09-25 (first published: 2023-08-28)
388 reads
My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...
2023-09-25
21 reads
2023-09-25
473 reads
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...
2023-09-22
14 reads
2023-09-22
314 reads
It’s a small thing, but copying the migration number can be a pain. However, we’ve made this easier in Flyway 6.5.4. I’ve been working with Flyway Desktop for work...
2023-09-22 (first published: 2023-08-18)
114 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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