Twenty something years ago when I started my SQL Server career there was an amazing tool called Query Analyzer. Honestly I’d say if Microsoft did nothing more than bring...
2020-05-27 (first published: 2020-05-07)
899 reads
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Today, I will take you to step by step installation of...
2020-05-27
43 reads
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Today, I will take you to step by step...
2020-05-27
42 reads
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
21 reads
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
9 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing I needed to do lately was...
2020-05-27
27 reads
Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then...
2020-05-26
30 reads
I’ve 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...
2020-05-26
13 reads
I am thrilled to have recently recorded a podcast with our friends over at PacketPushers. The podcast, “How an IT Specialist Chooses Adjacent Competencies“, talks about how adjacencies in...
2020-05-26
11 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-05-26 (first published: 2020-05-11)
262 reads
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
I’m currently researching the best wireless credit card terminal for a growing business and...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
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