2023-08-16
434 reads
2023-08-16
434 reads
Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...
2023-08-16
33 reads
If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...
2023-08-15
7 reads
2023-08-14
409 reads
Communication can be challenging when we don't work closely with others. Steve draws a comparison with a popular children's show in the US.
2023-08-14
133 reads
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...
2023-08-14 (first published: 2023-07-26)
381 reads
aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...
2023-08-11
199 reads
A fun contest from Steve asks you to design a system that tracks travels for a fictitious business.
2023-08-11
1,712 reads
2023-08-11
433 reads
On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...
2023-08-11
17 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