PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2017-04-07
944 reads
StrateSQL
PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community to find some presenters interested in...
2017-04-07
13 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
978 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
20 reads
Monday Morning SQL Break – January 16, 2017
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since...
2017-01-16
763 reads
Monday Morning SQL Break – January 16, 2017
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since I’ve published this summary post, but hey that’s what life...
2017-01-16
8 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-11-07
794 reads
Monday Morning SQL Break – November 7, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-11-07
15 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
888 reads
Yup, @StrateSQL’s Running for the PASS Board of Directors
Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....
2016-10-05
14 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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?
Removing TDE
Comments posted to this topic are about the item Removing TDE
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