2011 PASS Board Election Results
Results of the 2011 PASS Board of Directors election were officially announced this morning. I want to congratulate my friends...
2011-12-28
780 reads
Kendal Van Dyke
2011 PASS Board Elections Notes
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
938 reads
PASS Summit 2011 Session Evaluations
Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...
2011-12-15
1,074 reads
A PASS Board Of Directors Endorsement
One of the requirements for the PASS Board of Directors application was a collection of recommendations - 3 from volunteers, 3...
2011-12-09
891 reads
PASS Board Of Directors Voting Open Through Dec. 20
Voting for the 2011 PASS Board of Directors elections started earlier this week and if you were a PASS member...
2011-12-09
678 reads
Database Mirroring In A Windows Workgroup
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,706 reads
PASS Board Of Directors Interview
I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...
2011-11-08
632 reads
Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
820 reads
My PASS Summit 2011 Experience
The 2011 PASS Summit is in the rear view mirror (has it really been almost three weeks now?)...and as always...
2011-11-02
931 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
841 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