So Spaced Out
I had some fun last week presenting to the Space Coast User Group in Melbourne as well. They were so...
2010-11-08
328 reads
Blog Posts
Successful Teams: Knowing When to Step Out of Your Role
I've talked about the fact that everyone needs to contribute for the success of the team and that everyone should...
2010-11-08
1,454 reads
The Future Of PASS Elections
Am I stirring up a hornets nest or beating a dead horse bringing up a the PASS elections the day...
2010-11-08
474 reads
Pass Summit Sunday Morning
I’m sitting in Top Pot Donut. I’m having a fantastic apple fritter. I’m also trying out the capabilities of the...
2010-11-07
562 reads
Quick Elevators
I’m at the Renaissance in Seattle for a couple days, stuck on the 14th floor. That’s higher than I normally...
2010-11-07
457 reads
2010 DBA of the Year Will be Awarded at SQLServerCentral.com PASS Opening Night Party
Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com PASS...
2010-11-06
874 reads
6 Networking Tips for the PASS Summit & A Sunday Invitation
There’s no doubt that the PASS Summit is about learning. In just a few days you’ll max out your learning...
2010-11-06
706 reads
SQLBIGeek’s Function Friday – Return First Date of Month
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-11-06
539 reads
SQLPSX 2.3 Release
Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a...
2010-11-06
2,161 reads
SQLServerCentral.com Track at SQL Server Has Record Attendance
This past week, November 3-4, the SQLServerCentral.com track at SQL Server Connections has a record 431 attendees. Below are some...
2010-11-06
663 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers