In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]
Learn how to remove TDE from a database and return it to a normal state.
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
Learn how you can configure a Snowflake account in your cloud database and load data.
This article shows you how to create an Analysis Services Tabular Model project, import data from World Wide Importers database, create a measure and analyze in Excel.
In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.
In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
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;