[read this post on Mr. Fox SQL blog] I had a recent requirement to capture and stream real-time data changes on several SQL database tables from an on-prem SQL Server to Azure for...
2017-07-11
91 reads
Wow, hard for me to believe it has been a little bit since the last T-SQL Tuesday block party. This...
2017-07-11
486 reads
This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about:
For this month, I want you...
2017-07-11
7 reads
A quick post, written last week as I’m relaxing in the mountains.
This month the topic is lessons learned the hard...
2017-07-11
494 reads
TweetG’day,
Well, it’s T-SQL Tuesday time again -the blog party started by Adam Machanic (blog | twitter) and this month hosted by...
2017-07-11
626 reads
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
462 reads
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
280 reads
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
121 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
5,166 reads
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.
Because of this...
2017-07-10
724 reads
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...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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