Remote Desktop: Force the resolution to match the screen size.
One of the things I hate most about using remote desktop is when the resolution for the remote server is ... Continue reading
2021-09-09
51 reads
Blog Posts
Timeseries Analytics Capabilities, and Azure Data Explorer (ADX)
I've had a few recent conversations where customers/partners were encountering scale concerns in existing timeseries database applications hosted outside of Azure, and wished to explore the native services in...
2021-09-09 (first published: 2021-08-24)
229 reads
CDOT Bar Chart Makeover
As I was browsing Twitter today, I noticed a tweet from the Colorado Department of Transportation about their anti-DUI campaign. Shown below, it contains a bar chart that appears...
2021-09-08 (first published: 2021-08-19)
267 reads
Daily Coping 8 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-08
20 reads
Why you need a Dead Man’s Switch
Right off the top here, I must note that the term “dead man’s switch” is archaic, so for the rest of this post I’ll refer to it as “operator...
2021-09-08
43 reads
Auditing with “C2 Auditing” and “Common Criteria Compliance”
I’m going to be fairly high level on these because to be honest, if you are going to use them ... Continue reading
2021-09-07
73 reads
Daily Coping 7 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-07
20 reads
Azure Purview Best Practice: Naming your scans
If you’ve ever been a DBA and seen the mess that you get with SQL Agent Jobs without a clean naming standard for your job schedules and job names...
2021-09-06 (first published: 2021-08-13)
325 reads
Daily Coping 6 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-06
16 reads
Heraflux turns 8 – and gift for you
My company, Heraflux Technologies, just celebrated eight years in business! First, here’s a huge thank you to Molly and Jon at Heraflux. We couldn’t have done this without both...
2021-09-06
45 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