Catching Up On SQLOrlando
Somehow two years have elapsed since my last update; hopefully it won’t be that long before the next one. My last post was about SQLSaturday Orlando 2023. Since then,...
2026-01-16 (first published: 2026-01-03)
182 reads
Somehow two years have elapsed since my last update; hopefully it won’t be that long before the next one. My last post was about SQLSaturday Orlando 2023. Since then,...
2026-01-16 (first published: 2026-01-03)
182 reads
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
2025-10-08 (first published: 2014-03-04)
304 reads
Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
2024-01-29
117 reads
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
2024-01-19
116 reads
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
5,943 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
9,811 reads
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy looks at the ways we can cope when we have been working too much.
2023-09-13 (first published: 2012-02-16)
381 reads
Most of us want more autonomy at work, but it isn't given out without effort. Today Andy Warren has a few thoughts on how to get more freedom from your boss.
2023-07-24
138 reads
Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.
2023-07-21 (first published: 2023-07-06)
164 reads
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
43 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