SQL Backup and Recovery
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very...
2012-11-01
564 reads
Blog Posts
SQLIO Analyzer now has test timestamps
Yesterday I finally got around to adding a much needed improvement to my SQLIO Analyzer tool. You now get a...
2012-11-01
1,499 reads
SSIS and Oracle All Your Non-options
Why do some things have to be so hard?
I have been asking myself that question for the better part of...
2012-11-01 (first published: 2012-10-30)
3,465 reads
Summit 2012
In case you have been living under a rock (I know it’s not under my rock), here is your notice that Summit 2012 is just a few days away...
2012-11-01
4 reads
Summit 2012
In case you have been living under a rock (I know it’s not under my rock), here is your notice...
2012-11-01
901 reads
Surface, Surface, Prepare to Surface
More stuff about the Surface.
Web browsing works extremely well so far. I enjoy how you can swipe to move back...
2012-11-01
804 reads
Countdown to PASS Summit 2012 – 6 to Go – Magenic Brings 9
Getting closer, 6 days to Summit 2012! Today, I just have to give kudos out to Magenic, my current employer....
2012-10-31
1,231 reads
Is PowerPivot the Next Access?
I’m impressed with the current generation of semantic modeling technology from Microsoft. I’ve had the opportunity to use both PowerPivot...
2012-10-31 (first published: 2012-10-28)
4,377 reads
Learn Good / Do Good
Obviously the title of this post is an exercise in bad grammar, but it’s a little catchy. Well, maybe not,...
2012-10-31
1,481 reads
Microsoft Surface
I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the...
2012-10-31 (first published: 2012-10-28)
3,271 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
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...
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