An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
15 reads
Blog Posts
An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open,...
2017-12-07
464 reads
An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
10 reads
Closing all of the connections to a database
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
6,367 reads
Kalen Delaney’s Weekly Webinars
Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...
2017-12-07
340 reads
Watch Out for Automap in SQL Compare
I wrote a piece on SQL Compare and customizing the Automap feature. This was handy for me in a small...
2017-12-07 (first published: 2017-11-27)
1,234 reads
All Mac users should do this immediately
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released...
2017-12-06
544 reads
ARMED - Azure ARM VS Code extension
I have been working with ARM templates for a little while and have found it really annoying to test functions inside the templates, you see if you have an...
2017-12-06
5 reads
ARMED - Azure ARM VS Code extension
I have been working with ARM templates for a little while and have found it really annoying to test functions...
2017-12-06
51 reads
ARMED - Azure ARM VS Code extension
I have been working with ARM templates for a little while and have found it really annoying to test functions...
2017-12-06
35 reads
Blogs
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...
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...
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