2019-11-18
229 reads
Career Growth
Agile Job Descriptions
Steve ends his week of career thoughts with a look at the job descriptions that we often use to decide if we want to apply for a job.
2019-11-15
280 reads
Micro Credentials
Today Steve talks about a new way of achieving some certification and education from Microsoft.
2019-11-13
267 reads
2024-05-15 (first published: 2019-11-12)
386 reads
Falling Behind and Digital Bankruptcy
The challenges of information overload can weigh on technology workers.
2019-10-30
201 reads
Contracting for Work
The decision to work for yourself instead of full time for an organization can be a hard one.
2019-10-28
365 reads
Experiment First
One skill that's useful to develop is the ability to learn things on your own. Often with a little help, but not too much.
2019-10-16
228 reads
Aging in Technology
As we grow and evolve in our careers, we face new challenges all the time. Steve highlights on of those that some tech workers worry about today.
2019-10-14
291 reads
Priorities and Productivity
Managing a complex workload is a skill many of us need to acquire and maintain. Today Steve has a few ideas on how to do that.
2019-10-09
211 reads
2019-10-03
235 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