Expose Multiple Docker Ports
I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication....
2019-08-21 (first published: 2019-08-07)
395 reads
I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication....
2019-08-21 (first published: 2019-08-07)
395 reads
2019-08-21
462 reads
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was scrambling a bit, but since I’ve worked with a few customers in the last year...
2019-08-20
24 reads
2019-08-20
432 reads
2019-08-20
684 reads
2019-08-19
208 reads
2019-08-19
1,128 reads
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
2019-08-17
247 reads
tl;dr For Windows when you need a different account. I had to work with a new GitHub account recently and needed to add a separate account. I worked through...
2019-08-16
7,434 reads
One of the things that’s handy when working with containers is being able to move files in and out of the container. Certainly you can do this from a...
2019-08-16 (first published: 2019-07-31)
408 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...
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...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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