Kindle Update - Encouraging the Kids
I remember when each of my boys started to read a lot. There was a time when both of them...
2008-12-16
769 reads
Blog Posts
SQL Quiz Part 2 - Career Challenges
Another diabolical idea of Chris Shaw. I'm actually late to the game because I got tagged a week ago by...
2008-12-16
985 reads
A Good Use of Surface
I first saw a Surface Computer at the Sheraton in Seattle and thought it was pretty cool, but not necessarily...
2008-12-15
743 reads
A Week of Books - Part 1
I've been catching up on reading over the last month and I feel like taking a break from things technical/community/etc...
2008-12-15
658 reads
A Week of Books - Part 2
I'm just finishing up Boards At Work which talks about how a good board of directors can make a big...
2008-12-15
570 reads
PASS Presentation Evaluation Results
Just as I did last year I'm posting my evaluation scores for review. I co-presented with Steve Jones a session...
2008-12-15
805 reads
SQL Quiz Part 2
I was recently tagged by Tim Mitchell to give a response to Chris Shaw’s SQL Quiz Part 2 so here...
2008-12-15
817 reads
SQL Server 2005 SP3
… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.
2008-12-15
678 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2008-12-15
8,509 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
420 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers