Looking for Free Educational Events to Attend?
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
625 reads
Blog Posts
Financial Trust
I’m sure that the people at Mint and Thrive have people’s best interests at heart. They built services designed to...
2008-10-14
951 reads
Flyclear Revisited
Back in May I wrote about signing up for FlyClear as a way to save time travelling and in doing so,...
2008-10-14
520 reads
Too Good at Data Analysis - Why Did I Write This?
The past few weeks have been a rough one all around the globe as economies aren't doing well. I studied...
2008-10-14
604 reads
Back to 400
I had to research a bit, write some code, and look up things to answer questions this morning. I must...
2008-10-13
700 reads
Data Farming - Why Did I Write This?
I grew up in the Cold War, with real concern that the Russians would attack us someday. I wanted to...
2008-10-13
814 reads
Double Posting
I think that it’s a great idea to keep a few blogs going, and separate out your thoughts in different...
2008-10-13
634 reads
LiveWriter
I’ve been experimenting a bit in the blogging world, setting up a few blog accounts and trying different services. I...
2008-10-13
634 reads
Post Event Notes on SQLSaturday #5 & SQLSaturday #9, and Future Plans
Thought I'd post these notes based on feedback from the event organizers, wasn't able to attend myself due to scheduling...
2008-10-13
539 reads
Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
521 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