Did you ever want to rename an existing connection in Azure Data Studio? Unfortunately as of today (April 2020), there is no way to modify an existing connection group or...
2020-04-28 (first published: 2020-04-16)
711 reads
I’m very happy to share that I will be speaking at the next PASS Marathon event. Here are the details of the session I will be presenting on April...
2020-03-31
5 reads
As I announced before, I had the honor to be selected as speaker for PASS Summit this year. This is a huge deal for me as data professional and...
2019-11-05
8 reads
I’m very happy to announce that this will be my second time participating as speaker at the SQL Saturday# 908 in Denver! Here are the details of the session...
2019-10-09
11 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 912 in New York City! This event will be...
2019-10-02
13 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
12 reads
SQL Server 2008 end of support for SQL Server 2008 is fast approaching, so it’s time to take flight and build your migration plan. As announced during the...
2019-06-24
22 reads
Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
746 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 830 in Colorado Springs Here are the details of...
2019-04-05
45 reads
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,217 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...
Comments posted to this topic are about the item Enhancing SQL Server Searches with...
I've got a small SQL Server 2022 Developer Edition database on my laptop. It...
I'm backing up a SQL 2016 db and copying it to SQL Server 2022. ...
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;