Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...
2021-12-22 (first published: 2021-12-08)
476 reads
I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017...
2018-02-23
505 reads
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is...
2017-05-10
2,583 reads
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this...
2017-03-14
770 reads
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,246 reads
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...
2016-11-07
1,513 reads
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...
2016-07-08 (first published: 2016-06-30)
7,179 reads
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,063 reads
A strange error struck me last week, and this post is all about that.
What you normally expect when you run...
2016-03-15 (first published: 2016-03-07)
1,906 reads
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
1,942 reads
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
Comments posted to this topic are about the item STRING_AGG's behavior
Comments posted to this topic are about the item The Role of Databases in...
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOselect STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;