Giving Back to Speakers
It might be hard to think back to 2007, but at that time, there were only a few SQL Server events taking place in the world. SQL Bits held...
2020-07-24
51 reads
The Voice of the DBA
Daily Coping 23 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-23
6 reads
Tonight is the PASS Marathon on SQL Server Performance
The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...
2020-07-23
21 reads
Color Coding a Database on All Servers with SQL Prompt
SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...
2020-08-04 (first published: 2020-07-22)
363 reads
Daily Coping 22 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-22
16 reads
Daily Coping 21 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-21
14 reads
Azure DevOps Changing Build Notifications
I don’t do a lot of team builds in Azure DevOps, but I constantly use it for demos. However, I’m often experimenting with things and I break builds regularly....
2020-07-30 (first published: 2020-07-20)
317 reads
Daily Coping 20 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-20
12 reads
A Travel Milestone: Two Keystones
I used to travel a lot. Last year I flew over 140,000 miles in the air, drive another 1000 or so on vacation, and visited numerous countries. It’s hectic...
2020-07-17
28 reads
Daily Coping 17 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-17
6 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers