Podcast: Myths of Modern Data Management
As part of the Secrets of Data Analytics Leaders by the Eckerson Group, I did a 30-minute podcast with Wayne Eckerson where I...
2018-04-02
171 reads
Blog Posts
Podcast: Myths of Modern Data Management
As part of the Secrets of Data Analytics Leaders by the Eckerson Group, I did a 30-minute podcast with Wayne Eckerson where I...
2018-04-02
489 reads
Power BI Data Security – Sharing in Email
Microsoft has expanded sharing by allowing users to share Power BI content via email. In a previous post, I discussed...
2018-04-02 (first published: 2018-03-22)
2,128 reads
Primary Replica Jobs
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
974 reads
SQL Homework – April 2018 – Indexes
This month we are going to look at a topic near and dear to both database developers and database administrators...
2018-04-02
315 reads
Database Superhero Adventures, April 2018 Edition
Chicago O’Hare AirportI had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold....
2018-04-01
269 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...
2018-04-01
406 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...
2018-04-01
12 reads
Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.
This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...
2018-03-31
702 reads
Azure SQL Database Manage Instance
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...
2018-03-31
738 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
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...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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