Upcoming Free Webinars on Database Development and Operations
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
1 reads
2019-11-16
3 reads
2019-11-16
7 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
15 reads
2019-11-06
1 reads
2019-11-06
4 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
3 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
11 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
3 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
1 reads
Blogs
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Forums
Enhancing SQL Server Searches with Elasticsearch and Python
Comments posted to this topic are about the item Enhancing SQL Server Searches with...
What is a Tail-Log Backup failure?
I've got a small SQL Server 2022 Developer Edition database on my laptop. It...
restore a cdc db from 2016
I'm backing up a SQL 2016 db and copying it to SQL Server 2022. ...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
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;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;