PASS Summit 2009 – Overall Event
I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some...
2009-11-10
699 reads
Blog Posts
SQL Connections
I’m flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I’m presenting...
2009-11-10
560 reads
SQL Server MVP Deep Dives Book Signing at PASS
The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the...
2009-11-10
387 reads
SQL Server Wish: Last Logon Information
The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up...
2009-11-10
8,739 reads
Time Management Quotes
A short post today, ran across http://www.lifeoptimizer.org/2007/03/08/66-best-quotes-on-time-management/ when I was looking for ideas for my Moo cards. Quotes are fun...
2009-11-10
489 reads
Closing Out PASS Summit 2009
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
623 reads
Looking Back - PASS Summit 2009 Day 1
I intended to blog daily while at the PASS Summit last week. At least that's what I told myself I...
2009-11-09
787 reads
More Thoughts on Stress
I’m trying to pay more attention to things that cause me stress and how I deal with the stress. It’s...
2009-11-09
929 reads
New Job with Pragmatic Works
Well if you attended PASS, you already know that I am changing jobs. I recently accepted a position with Pragmatic...
2009-11-09
666 reads
Notes from the PASS Summit 2009 Trip
A few random thoughts:
I think many people did ok at the airport connecting for ride share via Twitter. By next...
2009-11-09
369 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