SSC Editorial – Limited Features or Limited Time
This editorial for the SSC newsletter ran last week and talks about the conundrum for software vendors – how do you...
2010-06-10
599 reads
Blog Posts
TechEd 2010 – Wednesday
My final day at TechEd. Packed up and checked my bag at the hotel, off to the bus. Noticed that...
2010-06-10
340 reads
TechEd Impressions: Day Three
Today I attended four regular sessions, plus a special lunch session for Microsoft MVPs. The sessions I attended varied a...
2010-06-10
651 reads
Upcoming SQL Lunch Events
We are scheduling more and more events daily on the SQL Lunch. Just as a reminder here are a few...
2010-06-10
520 reads
What a coincidence ....
Two of the biggest events in the Technology World will be held at the same date!
PASS SUMMIT 2010 (8-11, November...
2010-06-10
738 reads
Daily SQL Server 2008 New Feature – Day 19
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-09
432 reads
Filter Jobs using SQL Server Job Activity Monitor
Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things...
2010-06-09
1,696 reads
How To Eliminate Key Lookups in SQL Server 2008
The Key Lookup operator is a bookmark lookup on a table with a clustered index. Key Lookups can be quite...
2010-06-09
3,211 reads
MS TechUpdate Prishtina in Kosova (June 9, 2010)
On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this...
2010-06-09
1,845 reads
Option missing in NTILE function?
Just saw something interesting....we have a requirement to divide a result set into a certain number of groups that have...
2010-06-09
747 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