How to Write a cross-database query in Microsoft Fabric
Using three-part naming to reference the databases/tables, you can join multiple databases. Using three-part naming to reference the database and tables, you can insert data from one…
How to Ingest data into your Warehouse using data pipelines
Create a data pipeline How to Ingest data into your Warehouse using the COPY statement Create a table Ingest Parquet data using the COPY statement Ingest CSV…
What is data warehousing in Microsoft Fabric?
Virtual warehouses with cross database querying Data Warehousing experiences in Microsoft Fabric It has two distinct data warehousing experiences in Microsoft Fabric: the SQL analytics endpoint of…
Different ways to load data into Microsoft Fabric Lakehouse
There are several ways to load data into your Lakehouse from the explorer page: How to Use a notebook to load data into your Lakehouse? Load data…
How to Explore the data in your lakehouse with a notebook
Open or create a notebook from a lakehouse Open a lakehouse from an existing or new notebook Switch lakehouses and set a default You can add multiple…
What is OneLake shortcuts in Microsoft Fabric?
What are Shortcuts? Where all we can create shortcuts? Creation of Shortcuts in a Lakehouse Creation of Shortcuts in a KQL database From Where can I access…
What is lakehouse in Microsoft Fabric?
What is Lakehouse? Note : The Lakehouse creates a serving layer by automatically generating a SQL analytics endpoint and a default semantic model during creation. How to…
What is OneLake in Microsoft Fabric
OneLake is a single, unified, logical data lake for your whole organization. Like OneDrive, OneLake comes automatically with every Microsoft Fabric tenant and is designed to be…
What is Workspace identity in Microsoft Fabric?
In simple terms, a Fabric workspace identity is like a special account that is automatically created and managed by Fabric. This account is linked to a Fabric…
What is Workspace in Microsoft Fabric?
What is Workspace? Workspaces are places to collaborate with colleagues to create collections of items such as lakehouses, warehouses, and reports. How to Work with workspaces Some useful…
Some Microsoft Fabric terminology
Definitions of terms used in Microsoft Fabric, including terms specific to Synapse Data Warehouse, Synapse Data Engineering, Synapse Data Science, Synapse Real-Time Analytics, Data Factory, and Power…
How Microsoft Fabric Works?
Microsoft Fabric has SaaS foundation This integration provides the following advantages: Components of Microsoft Fabric Fabric includes industry-leading experiences in the following categories for an end-to-end analytical…
Introduction to Microsoft Fabric
What is Microsoft Fabric? Microsoft Fabric isn’t a single service but rather a unified platform within Azure Data Services. It essentially brings together various data tools and…
Best Practice of Stored procedures using Synapse SQL in Azure Synapse Analytics?
Here are best practices for using stored procedures with Synapse SQL in Azure Synapse Analytics, explained with examples: 1. Encapsulation and Reusability: 2. Parameterization: 3. Error Handling:…
External tables supported in Azure Synapse Analytics
An overview of the external table types supported in Azure Synapse Analytics Hadoop-Based External Tables: Native External Tables (Preview): Key Differences: Choosing the Right Type: Additional Considerations:…
External tables using SQL pools in Azure Synapse Analytics
Here’s a guide on using external tables with SQL pools in Azure Synapse Analytics 1. Create an External Data Source: 2. Create an External File Format: 3….
Different ways to limit access for the users on different schemas in Azure synapse Analytics
1. User-Defined Schemas: 2. Row-Level Security (RLS): 3. Server-Level Roles: 4. Credentials and External Users: 5. Dynamic Data Masking (DDM): Additional Considerations: Mohammad Gufran Jahangir
How to Create or edit a log alert rule from Azure Monitor
Accessing the alert rule wizard in the Azure portal There are several ways that you can create a new alert rule. Create or edit an alert rule…
What is Kusto Query Language (KQL) and How to Use KQL to Query Audit Log
Kusto Query Language (KQL) is used to write queries in Azure Data Explorer, Azure Monitor Log Analytics, Azure Sentinel, and more. Here’s a comprehensive guide on using…
Azure SQL Database audit log format
Azure SQL Database auditing tracks database events and writes them to an audit log in your Azure storage account, or sends them to Event Hub or Log…