Creating a SERVER ROLE created a LOGIN as well.
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
342 reads
Blog Posts
Daily Coping 21 Sep 2022
Today’s coping tip is to leave positive messages for yourself to see regularly. I could use post-its, or something else, but something that has worked well for me with...
2022-09-21
11 reads
Distributed Replay: The Little Engine That Almost Could
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive I’m an idiot. As we needed proof. To be a little fair to me, I...
2022-09-21 (first published: 2022-08-15)
190 reads
“Done in 7 minutes” -SQL Server 2019 Install
This blog comes to you from the home office after three days of caring for my sick six-year-old son. Yay for stomach bugs… Have you ever needed to install...
2022-09-20
37 reads
Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
20 reads
Daily Coping 20 Sep 2022
Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...
2022-09-20
10 reads
Meetings Are Work Too
So Many Meetings I’ve said it. We’ve all said it.
I can’t get any work done today, I’ve got so many meetings.
I need to be reminded on occasion that for...
2022-09-20
120 reads
Daily Coping 19 Sep 2022
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
13 reads
Extended Events for Anything but Query Tuning: bulk_insert_usage
Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...
2022-09-19
37 reads
Mental Health Bullet Journal – Collect Data to Help Your Mental Health
Purpose This blog and bullet journal was specially created to help me with my tendency to have suicidal ideation, depressive, and manic episodes related to
The post Mental Health Bullet...
2022-09-19 (first published: 2022-09-06)
272 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Pademangan TLP/Wa 08216977749
Gg. 21 dan 22 No.1, Pademangan Tim., Kec. Pademangan, Jkt Utara, Daerah Khusus Ibukota...
BCA KCP Jembatan Dua TLP/WA 08216977749
Jl. Jemb. Dua Raya No.82 BB-BC, Pejagalan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota...
BCA KCU PASAR BARU TLP/HUB 08216977701
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers