SQL Saturday #149 Minneapolis 2012
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 reads
Blog Posts
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby...
2012-10-03
4 reads
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their...
2012-10-03
1,075 reads
Why do you attend sessions? – Survey Results
Several weeks ago I posted a quick survey on my blog that asked how you choose a session to attend...
2012-10-03
964 reads
Honored with MVP award!
I’m so honored to be recognized as an MVP for SQL Server by Microsoft!
Thank you Microsoft and the SQL Server Community.
My...
2012-10-02
1,333 reads
Master Data Services: Copy Versions
In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of...
2012-10-02
1,141 reads
One Great Day And Mixed Feelings
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,013 reads
PASS 2012 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2012-10-02
719 reads
SQL Server : Setting up Server Side Trace
For a DBA, SQL profiler is a great tool to trouble shoot performance issues. It is a pain to configure...
2012-10-02
1,282 reads
SQL Server Virtualisation and Consolidation
SQL Server Virtualisation and Consolidation: Hands-On
Come and join me in London this December for a three day course covering the...
2012-10-02
626 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
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
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
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