SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,915 reads
Blog Posts
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,199 reads
CakeWrecks
Recently I had a student point me to CakeWrecks, a blog about good cakes gone bad.The post from today has...
2010-09-17
552 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,358 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
571 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,471 reads
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
491 reads
SQL Saturday #52 in Denver
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held...
2010-09-17
637 reads
SQLSaturday #52 – Colorado Here I Come!
Well, I’ve been waiting to book hotel and rental car for SQLSaturday #52 – Colorado because I wasn’t sure if my...
2010-09-17
355 reads
StreamInsight sample from my 24HOP session
As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...
2010-09-17
536 reads
Blogs
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...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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?
Removing TDE
Comments posted to this topic are about the item Removing TDE
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