Networking – A Year Later
I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...
2010-06-15
663 reads
Blog Posts
oPASS Meeting Tonight June 15, 2010 – Featuring Kendal Van Dyke
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
312 reads
Report Render Duration
Every once in a while I come across a scenario where I really want to know how long it took...
2010-06-15
557 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
711 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
494 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
630 reads
The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
661 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
864 reads
Daily SQL Server 2008 New Feature – Day 22
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-14
399 reads
Jacksonville Code Camp Call for Speakers
Bayer White has announced the call for speakers for the 2010 Jacksonville Code Camp to be held August 28, 2010...
2010-06-14
311 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