I like this
Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein
from 37 signals blog.
2009-09-11
937 reads
Blog Posts
LaRock on Monitoring
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
654 reads
Memories Of PanzerBlitz
Back when I was a small tyke, I vividly remember playing an Avalon Hill board game called PanzerBlitz, which was...
2009-09-11
1,082 reads
Running a Server Side Trace
This is part two of three part series on creating, running, and scheduling Server Side Traces in SQL Server. Part...
2009-09-11
2,801 reads
Thanks Space Coast SQL User Group
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
366 reads
What I’ve Read and Recommend to Others – Joe Celko Edition
I’ve known Joe for a number of years and have a lot of respect for his experience and knowledge around...
2009-09-11
857 reads
Building a Chair – Part 1
I glance at Make (magazine and web site) from time to time, and recently have been recording and watching their...
2009-09-10
808 reads
Columbus User Group webcast on SQL Server locking
Later this afternoon, I’m presenting at the Columbus, Ohio, SQL Server User Group meeting. The topic: SQL Server Locking and...
2009-09-10
356 reads
Denver SQL Server User Group Board Meeting Notes from 20090901
To address a few questions on what does the board actually do and to bring more visibility to all of...
2009-09-10
698 reads
Don't Make Me Work, VIA Rail
I got an email the other day from Canada's VIA Rail, advertising "Discover Canada by Train" and the chance to...
2009-09-10
884 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