Azure Synapse Analytics
Serverless SQL Pools offers a straight-forward method of querying data including CSV, JSON, and Parquet format stored in Azure Storage.…
In part one we looked at a process in which a pre-aggregated dataset can be created by Azure Synapse Analytics…
Dedicated SQL Pools have a feature called Materialized Views which can generate a pre-calculated/processed dataset ready for consumption and is…
In this video we’re talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh,…
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along…
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the…
Temporary (temp) tables have been a feature of Microsoft SQL Server (and other database systems) for many years. Temp tables…
Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data…
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and…
When using Serverless SQL Pools to write data to Azure Storage/Data Lake Gen2 using the CREATE EXTERNAL TABLE AS SELECT…