The Way0utwest Joker #SeattleSummitMoments
I work for Redgate, who has been a great sponsor of the Summit in the past and now is charged with stewarding the event into the future. This post...
2022-11-04
22 reads
Blog Posts
Validating Backups: PGSQL Phriday #002
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
15 reads
Daily Coping 3 Nov 2022
Today’s coping tip is to ask yourself, will this matter a year from now? It’s easy to get caught up in short term things. I’m behind on a few...
2022-11-03
17 reads
The PASS Data Community Summit
I’m looking forward to attending the PASS Data Community Summit this year in Seattle, Washington. I’m also glad to have the opportunity to speak with fellow Microsoft MVPs Josh...
2022-11-03
17 reads
The PASS Summit 2022 DevOps Devour Hour from Redgate
At the Data Community Summit this year, Redgate is hosting a couple of lunchtime sessions, the Summit 2022 DevOps Devour Hour. A creative name, for sure. These are Thursday...
2022-11-03
24 reads
Create a Community Event at the Summit
There are a few community events at the Summit this year, but fewer than in the past. I know we’re all rebooting our conference experiences, and that can make...
2022-11-02
16 reads
Daily Coping 2 Nov 2022
Today’s coping tip is to be kind to yourself today. Remember, progress takes time. I am usually good at this. I work on many things that take time, so...
2022-11-02
16 reads
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
150 reads
Organize Your Tabs in SQL Server Management Studio
I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...
2022-11-02
146 reads
Tales From The Field Weekly Wrap Up for the Week of 10-17-2022
Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
123 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Question of the Day
Detecting Characters
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