Hello there! Another week, another roundup of Internet interesting stuff. Press Microsoft Business Applications Summit The event is happening now in the Georgia World Congress Center in Atlanta, GA....
2019-06-10
19 reads
It was tremendously extensive week for me (a week ago) when I spent time between two conferences: SQLDay (Wroclaw, Poland) and SQL Saturday #857 (Kiev, Ukraine). I’ve been helping...
2019-05-26
12 reads
Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...
2019-05-13
18 reads
Since now, we will not keep our guests in secret. We want you to be prepared and wait if you’re interested in. First time 2 vs 2 in #AskSQLFamily...
2019-05-01 (first published: 2019-04-19)
200 reads
Introduction Guy in a Cube is all about helping you master business analytics on the Microsoft Business analytics stack to allow you to drive business growth. They are just...
2019-04-26
52 reads
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
5 reads
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....
2019-03-23
390 reads
Hi there! I’m in Bellevue, WA today when finishing this post. My first MVP Summit and the second trip to...
2019-03-17
368 reads
Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...
2019-03-11
301 reads
SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens,...
2019-03-06
391 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
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