Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve had to relearn this trick multiple times,...
2020-05-22 (first published: 2020-05-04)
363 reads
Today Steve notes that having a list of things to do before you die can be a driving force for you.
2020-05-22
103 reads
When the global pandemic shut down much of the world, we started the Community Circle at Redgate, with the idea that we would try and help others cope with...
2020-05-21
19 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-21
6 reads
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
2020-05-21
100 reads
2020-05-21
447 reads
Learn how to build a SQL Server Configuration file from the Installation Center and then use this configuration file for subsequent installations.
2020-05-21
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post, I installed SSAS on...
2020-05-20
32 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-20
11 reads
2020-05-20
471 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
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...
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
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