Studying and Learning Business Intelligence
I have been doing interviews for Pragmatic works for the past few years and I have come across quite a...
2012-10-02
2,771 reads
Blog Posts
When I get stumped I ….
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+...
2012-10-02
1,203 reads
Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...
2012-10-01
1,093 reads
Database Maintenance Essentials – Resources
I told people in New York at SQL in the City that I’d post some resources on the blog from...
2012-10-01
1,285 reads
DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events
SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical...
2012-10-01
1,338 reads
Free Training Before the PASS Summit
How many of you out there get approval to go to the PASS Summit (YES!) but then get denied the...
2012-10-01
633 reads
New York New York
Come and join me live in New York this coming December where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-01
839 reads
October 2012 – Monthly SQL Server Checklist
October already. The PASS Summit is coming soon and we’re entering the time of the year that many of us...
2012-10-01
607 reads
Speaking at SQL Server #165 Lincoln this Saturday
The Omaha SSUG’s sister group, the Lincoln SSUG, is hosting a SQL Saturday this coming Saturday, October 6th, at Avery...
2012-10-01
696 reads
SQL in the City
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US...
2012-10-01
1,197 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