I’m a native English writer/speaker. Some might debate how well I really know the language, but I am a native. I wasn’t a good student of languages. I struggled...
2021-05-10 (first published: 2021-04-26)
166 reads
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
5 reads
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
157 reads
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
8 reads
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
14 reads
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
122 reads
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
17 reads
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
21 reads
I have to thank Kathi and Mala for putting on the WIT Mental Health and Wellness today today. I was honored to present, but I was more glad that...
2021-05-08
21 reads
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data stored in the table at any point in time by storing an effective dated version...
2021-05-07 (first published: 2021-04-22)
211 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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