Congratulations to MVP Grant Fritchey
Announced today on his blog at http://scarydba.wordpress.com/2009/04/01/mvp/. Well earned in my opinion between his participation with PASS, SSC, and his...
2009-04-01
417 reads
Blog Posts
LinkedIn - Part 2
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
513 reads
Moving to MySQL
It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software....
2009-04-01
491 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
539 reads
Buying A Plane
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes...
2009-03-31
1,469 reads
Keeping Relevant in the Face of Changing Technologies
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,886 reads
Lunch in Town
One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed....
2009-03-31
1,814 reads
Microsoft Project Migration Template for the move to SQL 2008
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,822 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,436 reads
SQLSaturday #15 in Jacksonville
The call for speakers is still open and will close April 6th, there's still from for a few more sessions....
2009-03-31
1,338 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