In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
363 reads
Today’s coping tip is to do something outdoors today. Enjoy nature. I’m writing this a few days ahead, so I’m using an activity I did over the weekend. The...
2023-01-06
10 reads
This is the goal setting post for 2023. The previous ones were: 2022 2021 2020 2019 2018 As with previous years, I’ll break these into three categories: career, personal,...
2023-01-06
20 reads
Last year I set a bunch of goals, and I thought I did pretty good working on them. Not amazing, but pretty good. This year, I want to attack...
2023-01-06
17 reads
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In the previous posts we looked at what TDE is and how it...
2023-01-06
83 reads
We got a solar system in 2022 to try and fix some of our power costs and hedge against the future. We were fairly confident it would work well,...
2023-01-06 (first published: 2022-12-28)
254 reads
Super excited that I was selected to speak at SQLBits 2023. The conference is taking place 14-18 March 2023 in Wales. I have never been to Wales and am...
2023-01-06 (first published: 2022-12-23)
240 reads
Today’s coping tip is to set aside a regular time for the next month for an activity you love . This is a big month for me, with coaching...
2023-01-05
19 reads
Today’s coping tip is to share something helpful with a friend that you learned recently. I share a lot with my wife and kids. They are a big part...
2023-01-04
8 reads
This post introduces you to the Pure Storage FlashArray OpenMetrics Exporter. It shows you how to get started quickly using Docker Compose so you can monitor your Pure Storage...
2023-01-04 (first published: 2022-12-20)
330 reads
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
i have huge table with lot of data and is also wide. i took...
Comments posted to this topic are about the item Creating a JSON Document II
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers