Extended Events: Avoid the XML
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
372 reads
Blog Posts
VMware Improves In-Guest Time Synchronization with 7.0 U1
I just found out that VMware has updated their in-guest time synchronization with the 7.0 Update 1 release. Previously, we had to manually disable some of the advanced time...
2021-04-08 (first published: 2021-04-01)
251 reads
Daily Coping 7 Apr 2021
I 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...
2021-04-07
11 reads
Moving Into Consulting 101 - Part 5 - The Tensions of a Consultancy
This is part five in a five part series this week, Moving into Consulting 101.
In the business consulting system, the clients are served by two separate yet equally important groups....
2021-04-07 (first published: 2021-03-26)
237 reads
Upcoming speaking engagements
The last time I presented a session was at the final PASS Summit in November 2020, so it is time to get back on the virtual conference trail again....
2021-04-07
12 reads
What is Transparent Data Encryption?
In this post we look at Transparent Data Encryption (TDE) in SQL Server. What it is - and how it works.
2021-04-07 (first published: 2021-03-29)
418 reads
A Year of “Good Morning!”
Just a little over a year ago, I started posting a “Good Morning!” tweet on Twitter every work day. I’ve kept it up for over a year and I’d...
2021-04-06
113 reads
Bullet Journal Workshop for April/May!
Edit: The April 26 workshop will be at 10:30am Central Time, because right after that I get my second Covid […]
The post Bullet Journal Workshop for April/May! appeared first...
2021-04-06
5 reads
Bullet Journal Workshop for April/May!
I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
7 reads
Bullet Journal Workshop for April/May!
I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
9 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
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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