Thoughts from Never Eat Alone
Watching a Chefograpy on Giada De Laurentiis, I learned that she was considered very much an introvert and had a...
2007-04-10
1,447 reads
Blog Posts
Help Johnny, Help Kids
I had heard of Johnny Long before I attended his briefing at Black Hat 2004. Well known for his research...
2007-04-09
1,512 reads
Microsoft CRM Security Internals
On the Microsoft Dynamics CRM Team Blog, Jay Grewal has posted information about the CRM Security Model Internals.
CRM is...
2007-04-09
1,639 reads
More information about SQL Server 2005 and SP2
SQL Server MVP Aaron Bertrand has posted an update (April 6, 2007) on the version numbers of post SP2 hotfixes....
2007-04-09
1,374 reads
How to pick a combination lock in 30 seconds
This is just frightening. A piece of a beer can, a pair of pliers, and the combo lock pops open.
...
2007-04-07
1,501 reads
QA/QC
I wrote a small commentary on quality control today and I'm surprised it didn't get more reaction.
I'm not a great...
2007-04-06
1,467 reads
SQL Server Samples on CodePlex
Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that...
2007-04-06
1,417 reads
The Data Warehouse Lifecycle Toolkit
On a recommendation, I picked up this book by Ralph Kimball. I remember it coming out years ago and I...
2007-04-06
1,418 reads
Thoughts from The Cuckoo's Egg
The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how...
2007-04-06
1,655 reads
Hot Fixes
I wrote about Hot Fixes being inclusive of previous hot fixes. Someone questioned this and so I went back to...
2007-04-03
1,416 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