T-8d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelveeight days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-17
587 reads
Blog Posts
Thank you all for going Zero to Cube with me!
Hey there folks. I am so excited about the tremendous turnout at the 24 hours of PASS. There were so many...
2010-09-17
357 reads
The best laid plans....
I had big plans for this blog, a place to rant, a place to put cool things I discovered, a...
2010-09-17
1,777 reads
Denver SQL Server UG September meeting
For the past 1 1/2 years now we’ve been hosting two presentations each meeting. The first presentation is typically a...
2010-09-16
778 reads
Do You Have Influence? Part 1
Most people blog because it’s fun, rewarding, good way to improve writing skills, be cool, and it looks good on...
2010-09-16
1,009 reads
Going to SQL Saturday #46 in Raleigh, NC
So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting...
2010-09-16
742 reads
Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot...
2010-09-16
818 reads
Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,101 reads
Let PASS help you get a job!
With so many folks out there struggling and loking for new opportunities you may want to take some time away...
2010-09-16
332 reads
Notes from the Sep 13, 2010 oPASS Meeting
Jack led the meeting tonight, spending a good amount of time on SQLSaturday, and Kendal Van Dyke did his marketing...
2010-09-16
590 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