I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...
2021-09-13 (first published: 2021-08-28)
516 reads
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
4 reads
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
35 reads
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three...
2021-09-13 (first published: 2021-08-26)
346 reads
As part of its ‘All Cloud’ push that began to take shape in 2019, Connect for Health Colorado (C4) selected Matillion ETL to be its cloud ETL/ELT tool. At...
2021-09-12
6 reads
In this blog post, we will walk through a few examples of how to configure SQL Server in Docker Containers. First, we will configure a container at runtime by...
2021-09-12
159 reads
In this blog post, we will walk through a few examples of configuring SQL Server in Kubernetes. First, we will create a Deployment for SQL Server, override the container’s...
2021-09-12
15 reads
The split-brain scenario in a database environment is a situation whereby the communication link between two different sites is broken, as a result of this situation the production database...
2021-09-11
29 reads
Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...
2021-09-10 (first published: 2021-08-25)
159 reads
I 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...
2021-09-10
17 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers