🇧🇷 PT: Chegamos à reta final! Descubra como garantir um "Go-Live" sem estresse no Microsoft Fabric usando automação CI/CD, governança de dados e o checklist definitivo de prontidão para produção. Aprenda a usar a IA para revisar a segurança do seu projeto antes do lançamento.

🇺🇸 EN: We've reached the final stretch! Discover how to ensure a stress-free "Go-Live" in Microsoft Fabric using CI/CD automation, data governance, and the ultimate production readiness checklist. Learn how to use AI to review your project's security before launch.

🇪🇸 ES: ¡Llegamos a la recta final! Descubra cómo garantizar un "Go-Live" sin estrés en Microsoft Fabric utilizando automatización CI/CD, gobernanza de datos y el checklist definitivo de preparación para producción. Aprenda a usar la IA para revisar la seguridad de su proyecto antes del lanzamiento.

Tired of managing security three different ways for SQL, Spark, and Power BI? Microsoft Fabric's OneLake Security changes the game with a single unified layer that enforces table, row, column, and folder-level access control across every engine. Define your security policies once in the portal, and they're automatically enforced whether users query through notebooks, SQL endpoints, or DirectLake reports. This blog walks you through setting up real-world demos with sample data, creating granular roles via UI clicks, and validating enforcement across engines. Ready to simplify your data security? Let's build it step-by-step.

In this blog, I will walk you through how to configure OneLake security with fine‑grained Read, Read‑Write access and Row‑Level Security (RLS) in Microsoft Fabric. This step‑by‑step guide is based on a real‑world scenario and includes practical implementation details that you can easily replicate in your environment.

Compliance Without Complexity

As organizations move toward unified analytics platforms, Microsoft Fabric offers two powerful data storage models: Lakehouses and Data Warehouses. Each has unique advantages, and understanding when and how to use them is essential for effective data engineering and analytics.

This article explains the difference between Lakehouses and Warehouses in Fabric, shows how to create simple tables and load data, and includes links to practical exercises to get started.

Lakehouse vs. Data Warehouse in Microsoft Fabric
🔹 What Is a Lakehouse?
A Lakehouse combines the scalability of a data lake with the structure of a data warehouse. It stores structured, semi-structured, and unstructured data in open formats such as Parquet and Delta.

Key Features:

Supports files and tables in the same environment.
Ideal for big data analytics, data science, and machine learning.
Works seamlessly with Notebooks, Spark, and PySpark.

What Is a Data Warehouse?
A Data Warehouse in Fabric is optimized for structured data and BI reporting. It follows traditional SQL-based modeling and is best suited for OLAP workloads, business dashboards, and high-performance queries.

Creating Tables and Uploading Data
Let’s walk through how to create tables in both Lakehouses and Warehouses inside Microsoft Fabric.

🔹 In a Lakehouse:
Open your Lakehouse from the Fabric workspace.
Upload a CSV or Excel file.
Use the Data Engineering interface or a Notebook to create a Delta table

df = spark.read.csv("/Files/sales.csv", header=True, inferSchema=True)
df.write.format("delta").saveAsTable("SalesData")

In a Warehouse:
Go to your Warehouse in Fabric.
Use the SQL Editor to create a table:

CREATE TABLE Products (
ProductID INT PRIMARY KEY,
Name NVARCHAR(100),
Price DECIMAL(10,2)
);

3. Insert data manually or use the Load Data tool to import from OneLake, Excel, or an external source.

Practice Labs and Learning Resources
Here are some official and community resources where you can practice working with Lakehouses and Warehouses:

🔗Implement a Lakehouse with Microsoft Fabric - Training | Microsoft Learn
🔗Implement a data warehouse with Microsoft Fabric DP-602T00 - Training | Microsoft Learn
🔗 Sign in to your account

Choosing between a Lakehouse and a Warehouse depends on your workload. For data science and big data exploration, Lakehouse is ideal. For business intelligence and structured data analytics, the Data Warehouse provides better performance and SQL capabilities.

let’s connect on LinkedIn: https://www.linkedin.com/in/rufyda-abdelhadirahma/

Thinking of taking the DP-700 exam? Here’s how I passed it—and why it could change your career in data engineering with Microsoft Fabric.

In today's digital landscape, securing connections between services is more important than ever. This article will guide you through the process of connecting Microsoft Fabric to an Azure Database for PostgreSQL using Managed Private Endpoints (MPE). By following these steps, you can ensure that all outbound traffic remains on the private network, enhancing both security and performance. Whether you're an admin with Fabric workspace access or have sufficient rights in Azure, this comprehensive guide will provide you with the necessary prerequisites and step-by-step instructions to achieve a secure connection. Dive in to learn how to set up, approve, and validate your private endpoint, ensuring your Fabric environment can securely communicate with the Azure PostgreSQL database without exposing it to the public internet. 

Managing tenant settings in a Fabric environment can be a complex task, especially when it comes to tracking changes, updates, and new features that are sometimes enabled by defalut. To simplify this process, I’ve outlined two options to ensure you stay up to date on modified, new, and upcoming Fabric settings.