1 min read
Copilot for SQL in Microsoft Fabric Data Warehouse
Copilot for SQL transforms natural language into T-SQL queries. Today I'm exploring how to leverage AI for data warehouse development in Fabric.
Data Warehouse
10 articles
1 min read
T-SQL in Fabric: Patterns and Best Practices
If you're coming to Fabric Warehouse from a SQL Server or Azure SQL Database background, the T-SQL compatibility is reassuring — CTEs, window functions…
1 min read
Fabric Warehouse: Cloud-Native SQL Analytics
The Fabric Warehouse is the part of Microsoft Fabric that surprised me most in hands-on testing. I expected it to be the Lakehouse's SQL analytics endpoint…
1 min read
Synapse Data Warehouse in Microsoft Fabric: Cloud-Native SQL Analytics
The Fabric Data Warehouse provides enterprise SQL analytics without infrastructure management. Tomorrow, I will cover Synapse Real-Time Analytics for…
1 min read
Synapse Pathway: Accelerating Data Warehouse Migration
Synapse Pathway translates SQL code from various sources to Azure Synapse Analytics SQL syntax: Teradata to Synapse Netezza to Synapse Snowflake to Synapse…
1 min read
Azure Synapse Analytics Updates: Ignite 2022 Highlights
Azure Synapse Analytics continues to mature as a comprehensive analytics platform. The improvements in serverless SQL, Spark integration, and data lake…
2 min read
Databricks SQL: Analytics Warehousing on the Lakehouse
Databricks SQL offers: SQL Endpoints : Serverless compute for SQL queries Query Editor : Web based SQL IDE Dashboards : Built in visualization and reporting…
2 min read
Azure Synapse Dedicated SQL Pool Best Practices
Synapse Dedicated SQL Pool (formerly Azure SQL Data Warehouse) is the massively parallel processing (MPP) engine for structured, petabyte-scale analytical…
1 min read
Azure Synapse Dedicated SQL Pools for Enterprise Data Warehousing
Dedicated SQL pools distribute data across 60 distributions for parallel processing: Control node : Orchestrates queries and manages metadata Compute nodes…
1 min read
Azure Synapse Dedicated SQL Pools (Preview): Enterprise Data Warehousing
Note: While dedicated SQL pools are mature (evolved from Azure SQL DW), the Synapse unified experience is still in preview.