2020-01-02
330 reads
Career Growth
The Best DBA Gifts
Today Steve asks if there is anything you'd want as a gift that would make your job better.
2019-12-27
295 reads
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
170 reads
The Evolving DBA
Steve thinks the DBA job is evolving and we will always need people to manage data.
2024-05-17 (first published: 2019-12-16)
527 reads
Finding Your Own Career
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
2023-05-15 (first published: 2019-12-11)
379 reads
What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
2019-12-06
263 reads
It's More Than What You Know
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,957 reads
HSA for Training
Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.
2019-12-03
182 reads
2019-11-23
1,882 reads
The Conference Springboard
The period after a conference is a good time to start driving yourself forward.
2019-11-20
131 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