Deciding to Submit to Conferences–#NewStarNovember
I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in...
2022-11-08
36 reads
Blog Posts
T-SQL Tuesday #156–Ready for Production
It’s a busy time for me, but it’s also T-SQL Tuesday blog party day. I’m rushing a bit as I forgot about this (thanks for the reminder, Deb) and...
2022-11-08
25 reads
Daily Coping 7 Nov 2022
Today’s coping tip is to identify three things that give you hope for the future. The creativity and passion of youth The drive from many people who build software...
2022-11-07
12 reads
The SQL Server Central Casino Party #SeattleSummitMoments
Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of...
2022-11-07 (first published: 2022-10-25)
903 reads
What can you do with a SELECT statement without a FROM clause?
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
671 reads
Daily Coping 4 Nov 2022
Today’s coping tip is to plan a fun or exciting activity to look forward to. I almost shouldn’t do this much, since I’ve had a great year with plenty...
2022-11-04
16 reads
From Manual to DevOps at the Data Community Summit
This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
119 reads
Goal Progress for Oct 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Another month of busy stuff. Prepping for the Data Community...
2022-11-04
18 reads
Notes on SQLSaturday Orlando 2022
First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...
2022-11-04 (first published: 2022-10-19)
110 reads
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
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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