Jan 6 · 6 min read · Introduction: If you're involved in the Power Platform and frequently work with configuring Dataverse or Power Apps for Dynamics 365 sales, service, projects, etc., you might have come across a menu item labeled "Azure Synapse Link." This menu option...
Join discussion
May 25, 2025 · 18 min read · Everyone talks about normalization. But barely anyone talks about denormalization—let alone selective denormalization. Back in college, while studying DBMS concepts, professors would emphasize how important—crucial, even—normalization is. And to be h...
Join discussion
Mar 25, 2024 · 4 min read · En los anteriores artículos se describió como crear un Integration Runtime Self-Hosted de Azure Synapse y cómo copiar el contenido de un data lake a un lakehouse en Microsoft Fabric. Si combinamos esas dos soluciones, podríamos establecer un pipeline...
Join discussion
Jan 3, 2024 · 1 min read · Para poder conectar desde Synapse Analytics a un servidor On-Premise, se necesita un Integration Runtime Self-Hosted. En este artículo se explica como crear uno y poder conectar Synapse a un servidor de SQL Server on-premise. Creando Integration Runt...
Join discussion
Dec 28, 2023 · 3 min read · Interested to learn the difference between Azure Synapse Analytics and Databricks? then you are at the right place. In this Azure article, we will learn Azure Synapse Analytics vs Databricks. Azure Synapse vs Databricks Let’s point out some key diffe...
Join discussion
Apr 30, 2021 · 3 min read · Table constraints Dedicated SQL pool supports these table constraints: PRIMARY KEY is only supported when NONCLUSTERED and NOT ENFORCED are both used. UNIQUE constraint is only supported with NOT ENFORCED is used. For syntax, check ALTER TABLE an...
Join discussion
Mar 1, 2021 · 2 min read · Azure Synapse Analytics uses Azure Storage to store data. Because the data is stored and managed by Azure Storage, Azure Synapse Analytics charges separately for the storage consumption. The data itself is sharded into distributions to optimize the p...
Join discussion
Feb 24, 2021 · 2 min read · Synapse SQL architecture components Azure Synapse Analytics uses a node-based architecture. Applications connect and issue T-SQL commands to a Control node, which is the single point of entry for the data warehouse. The Control node runs the Massivel...
Join discussion
Dec 3, 2020 · 1 min read · With Satya Mandela’s announcement today, Azure Synapse Analytics is now Generally Available! Azure Purview Azure Purview is a unified data governance service that helps you manage and govern your on-premises, multicloud, and software-as-a-service ...
Join discussion
Aug 22, 2020 · 1 min read · azure synapse analytics architecture Azure Synapse is an analytics service that brings together enterprise data warehousing and Big Data analytics. Azure Synapse has four components: Synapse SQL: Complete T-SQL based analytics — Generally Available ...
Join discussion