Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-27
870 reads
Blog Posts
Annoyed with LinkedIn
Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday...
2009-10-26
599 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
784 reads
Book Review: Murach’s JavaScript and DOM Scripting by Ray Harris
In early September I received a complimentary copy of Murach’s JavaScript and DOM Scripting by Ray Harris (Amazon) to review. ...
2009-10-26
510 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 5
Here I go again, trying to finish up the translation. Thank you very much to local MVP Eric Moreau for his help fixing...
2009-10-26
855 reads
Expert SQL Server 2008 Encryption
Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out...
2009-10-26
1,055 reads
Notes on a Migration from Oracle to SQL Server
I have to admit, when asked to perform a migration from Oracle to SQL Server over the past couple of...
2009-10-26
586 reads
One Week until PASS 2009
It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle...
2009-10-26
677 reads
People I Can’t PASS on Meeting
One week from today I will be in Seattle for my first ever PASS Summit. One of the things I...
2009-10-26
600 reads
Special Events at PASS Summit
Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a...
2009-10-26
608 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