Skip to content
Javi BuildsData • AI • Cloud Engineering
  • Home
  • Articles
  • Cheat Sheets
  • Runbooks
  • Labs
  • Projects
  • Speaking
  • Community
  • Resources
  • About
  • Contact
  • ENEnglish
  • FRFrançais
  • ESEspañol

Popular topics

No results found.

  • Browse all articles →
  • View the editorial roadmap →

↑↓ to navigate↵ to openEsc to close
  • ENEnglish
  • FRFrançais
  • ESEspañol

Articles

Practical write-ups on data engineering, the Microsoft Data Platform, AI and cloud architecture.

Explore the Modern Report Engine hub →

Browse by topic

  • Microsoft Fabric
  • SQL Server
  • Data Engineering
  • Python
  • Monitoring & Observability
  • Governance & Security
  • Testing & Quality
View all topics →

No articles match your search and filters.

  • Microsoft FabricIntermediate

    Microsoft Fabric Domains Explained: Architecture, Governance, and Workspace Assignment

    What Microsoft Fabric domains and subdomains are, how they relate to workspaces and capacities, who can create and assign them, and how to design a domain strategy that delegates governance without pretending to be security.

    Published Nov 17, 2026•16 min read

    Read article →
  • Microsoft FabricIntermediate

    Pandas vs Polars vs DuckDB vs PySpark in Microsoft Fabric: Speed, Memory and Scale

    Compare pandas, Polars, DuckDB, PySpark and Spark SQL in Microsoft Fabric by speed, memory use, data size, Delta support and scale, with measured results from a real Fabric benchmark and practical guidance for choosing the right engine.

    Published Nov 11, 2026•40 min read

    Read article →
  • DevOps & ObservabilityIntermediate

    Data Quality Checks for Data Pipelines: Rules, Severity, Quarantine and Evidence

    How to design data-quality checks that actually protect a pipeline: row-level and dataset-level rules, severity and actions, quarantine with reason codes, thresholds from baselines, recorded evidence, tests for the checks themselves, and Microsoft Fabric's built-in options.

    Published Nov 10, 2026•22 min read

    Read article →
  • DevOps & ObservabilityAdvanced

    Testing Incremental Loads and Idempotency: Reruns, Late Data, Replay and Recovery

    How to prove an incremental load produces the correct final state when it reruns, replays data, receives late or out-of-order records, or recovers from a partial failure: guarantees, a full-load oracle, watermark and MERGE tests, invariants, metamorphic tests and a tested PySpark suite.

    Published Nov 10, 2026•28 min read

    Read article →
  • DevOps & ObservabilityAdvanced

    Testing Microsoft Fabric Pipelines and Notebooks: A Practical Guide

    How to test Microsoft Fabric pipelines and notebooks before production: testable design, parameter and expression tests, controlled failures, retries, idempotent reruns, partial-failure recovery, exit-value contracts, data assertions, CI-triggered runs, environment rebinding and post-deployment smoke tests.

    Published Nov 10, 2026•30 min read

    Read article →
  • PythonIntermediate

    PySpark DataFrame Unit Testing with pytest: A Practical Guide

    Learn how to unit test PySpark DataFrame transformations with pytest using small deterministic datasets, schema assertions, fixtures, edge cases and reusable testing patterns, and where unit tests stop and integration tests begin.

    Published Nov 9, 2026•24 min read

    Read article →
  • DevOps & ObservabilityAdvanced

    Testing a Production Data Platform: Unit Tests, Data Quality and CI/CD Gates

    A practical architecture for testing production data platforms: unit and transformation tests, data-quality checks, SQL Server and PySpark testing, Microsoft Fabric pipelines and notebooks, integration tests, deployment validation and the CI/CD quality gates that decide whether a change reaches production.

    Published Nov 9, 2026•38 min read

    Read article →
  • DevOps & ObservabilityIntermediate

    Deploy a Fabric Solution with Git, Deployment Pipelines and Database Projects

    A hands-on Microsoft Fabric lifecycle lab: version a workspace with Git integration, promote it from Dev to Test with a deployment pipeline and deployment rules, change a Warehouse schema as a database project, cause two controlled deployment failures and plan rollback.

    Published Nov 9, 2026•21 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Real-Time Intelligence: Eventstream, Eventhouse and KQL Hands-On Guide

    A hands-on guide to Microsoft Fabric Real-Time Intelligence: send service telemetry through an eventstream into an Eventhouse, query and window it with KQL, compare Eventstream, KQL and Spark Structured Streaming, and break and fix the flow on purpose.

    Published Nov 9, 2026•24 min read

    Read article →
  • Microsoft FabricIntermediate

    Fabric Security Lab: Workspace Roles, Data Access, RLS and Masking

    A hands-on Microsoft Fabric security lab: test workspace roles with two identities, share items with exact permissions, implement row-, column- and object-level security in a Warehouse, restrict Lakehouse folders with OneLake security, mask a column, then break the model on purpose and diagnose it.

    Published Nov 9, 2026•22 min read

    Read article →
  • Microsoft FabricAdvanced

    Designing a Production Data Platform: From Requirements to Operations

    The decisions a data solution architect makes before building a production data platform: requirements and NFRs, source assessment, batch vs streaming, storage and serving, idempotency, security, observability, capacity, cost, RPO/RTO, governance and operational ownership, with a reusable review checklist.

    Published Nov 8, 2026•36 min read

    Read article →
  • Microsoft FabricAdvanced

    Recovery and Disaster Recovery Architecture for Microsoft Fabric: RPO, RTO, Replay and Rebuild

    An architect's guide to recovery for production Microsoft Fabric platforms: RPO and RTO that the design can actually meet, failure domains, what Microsoft recovers and what you rebuild, the capacity disaster recovery setting, item-by-item recovery, replay and idempotency, multi-tenant recovery, security revalidation, RTO decomposition and recovery testing.

    Published Nov 8, 2026•35 min read

    Read article →
  • Microsoft FabricAdvanced

    Microsoft Fabric Security Architecture for Production Data Platforms

    An architect's guide to securing production Microsoft Fabric platforms: threat model, identities, workspace boundaries, data-level controls and their bypass paths, multi-tenant isolation patterns, tenant context, secrets, networking, service identities, auditing and blast radius, with a reusable review checklist.

    Published Nov 8, 2026•29 min read

    Read article →
  • Microsoft FabricIntermediate

    SQL Server to Microsoft Fabric: What Maps to What?

    A mental model for SQL Server professionals and DBAs moving into Microsoft Fabric: the closest Fabric equivalent of an instance, database, table, SQL Agent, SSIS, Query Store, tempdb and backups, where each DBA task goes, and where the mapping breaks down.

    Updated Nov 8, 2026•23 min read

    Read article →
  • Microsoft FabricIntermediate

    How I Diagnosed a Microsoft Fabric Capacity Saturation Problem

    A sanitized production case study: a morning file-ingestion burst pushed a shared Fabric capacity well past 100%. How I separated capacity size from concurrency, per-file overhead and expensive workloads before deciding whether to scale.

    Published Nov 3, 2026•18 min read

    Read article →
  • Microsoft FabricIntermediate

    Migrate SSIS Packages to Microsoft Fabric: Retire, Rehost, Rebuild or Redesign

    A practical SSIS-to-Microsoft Fabric migration guide: what maps to Fabric Data Factory and what needs redesign, how to inventory and score packages, when to use Invoke SSIS Package (Preview), how to migrate in waves, and how to cut over without breaking production.

    Updated Nov 8, 2026•29 min read

    Read article →
  • Microsoft FabricBeginner

    Create Your First Fabric Warehouse with T-SQL

    A hands-on Microsoft Fabric Warehouse tutorial: create a Warehouse, build a schema and tables with T-SQL, insert, join, aggregate, update and delete rows, create a view, use transactions, query a Lakehouse and grant access.

    Updated Nov 2, 2026•18 min read

    Read article →
  • Microsoft Fabric Environment Spark properties showing spark.highConcurrency.max set to 50

    Microsoft FabricIntermediate

    Microsoft Fabric High Concurrency: How to Increase the Notebook Session Limit to 50

    A visual, step-by-step guide to setting spark.highConcurrency.max in a Microsoft Fabric Environment, enabling pipeline session sharing, and avoiding common setup mistakes.

    Published Oct 28, 2026•9 min read

    Read article →
  • Delta LakeBeginner

    Delta Tables in Microsoft Fabric for SQL Server Engineers

    What a Delta table really is, how it differs from a SQL Server table, and what to understand about writes, keys, time travel, maintenance and the SQL analytics endpoint before using Fabric Lakehouse tables in production.

    Published Oct 24, 2026•19 min read

    Read article →
  • Delta LakeIntermediate

    Delta Table Maintenance in Microsoft Fabric: OPTIMIZE, VACUUM, V-Order and Small Files

    Why Fabric Delta tables slow down over time and which maintenance actually helps: diagnosing small files, OPTIMIZE and auto compaction, VACUUM and retention, and when V-Order is worth it.

    Published Oct 24, 2026•18 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Capacity Explained: CUs, Smoothing, Throttling and Sizing

    Where Fabric capacity actually goes: what consumes Capacity Units, how smoothing and throttling work, how to investigate a spike in the Capacity Metrics app, and how to size without guessing.

    Published Oct 24, 2026•20 min read

    Read article →
  • Microsoft FabricIntermediate

    Pipelines vs Notebooks vs Dataflow Gen2 vs Copy Job in Microsoft Fabric

    A practical decision guide for Fabric data integration: when to use a pipeline, a notebook, Dataflow Gen2 or a Copy job, how they combine, and what each means for CI/CD, debugging and capacity.

    Published Oct 24, 2026•17 min read

    Read article →
  • Microsoft FabricBeginner

    Explore Data with PySpark in Microsoft Fabric

    Learn PySpark in Microsoft Fabric step by step by reading Lakehouse data, filtering rows, creating columns, aggregating, joining, using Spark SQL and writing a Delta result.

    Published Oct 24, 2026•14 min read

    Read article →
  • Microsoft FabricAdvanced

    Troubleshooting Microsoft Fabric Performance in Production

    A repeatable workflow for slow Fabric workloads: find where elapsed time goes, then decide whether the cause is capacity, startup, reads, shuffle and skew, Delta layout, MERGE, writes, SQL, concurrency or data growth.

    Published Oct 24, 2026•19 min read

    Read article →
  • DevOps & ObservabilityIntermediate

    Debugging Microsoft Fabric Pipelines and Notebooks in Production

    Debug Microsoft Fabric pipelines and notebooks systematically using run history, execution logs, correlation IDs, parameters, data validation, capacity metrics and safe rerun patterns.

    Published Oct 24, 2026•20 min read

    Read article →
  • Microsoft FabricIntermediate

    Incremental Loads in Microsoft Fabric: Watermarks, CDC and MERGE Without Reprocessing Everything

    Stop full reloads in Microsoft Fabric without losing correctness: bounded watermark windows, Change Tracking vs CDC, Delta MERGE, deletes, late data and safe reruns.

    Published Oct 24, 2026•21 min read

    Read article →
  • Cloud & AutomationIntermediate

    How to Secure SQL Endpoints in Azure: Application Gateway vs Private Link

    Choose private connectivity or an Application Gateway proxy for SQL Server, Azure SQL and Fabric endpoints, with accurate WAF, TDS and TLS boundaries.

    Published Oct 22, 2026•14 min read

    Read article →
  • SQL ServerIntermediate

    When a Datetime Index Helps in SQL Server - and When It Does Not

    Learn when datetime and datetime2 indexes help SQL Server, how selectivity and key order shape plans, and how to benchmark date-range queries safely.

    Published Oct 22, 2026•15 min read

    Read article →
  • SQL ServerBeginner

    Aggregate Functions in SQL Server: COUNT, SUM, AVG, MIN, and MAX

    Learn how SQL Server aggregate functions summarize customer and order rows with COUNT, SUM, AVG, MIN, and MAX.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Common SQL Beginner Mistakes and How to Avoid Them

    Recognize common SQL mistakes around filtering, NULL, joins, ordering, and data changes, then replace each with a safer habit.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    DELETE Basics in SQL Server

    Learn how to delete SQL Server rows carefully: preview them with SELECT, use WHERE, check @@ROWCOUNT, and verify removal.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Why SQL JOINs Create Duplicate Rows

    Learn why one-to-many SQL Server joins repeat customer values, how to check join keys, and when aggregation is the right result.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Filtering Data with WHERE in SQL Server

    Filter rows with the WHERE clause in SQL Server: comparison operators, AND and OR, IN, BETWEEN, LIKE, NOT, IS NULL, AND/OR precedence, and the data-type details that trip up beginners, with exercises.

    Published Oct 21, 2026•13 min read

    Read article →
  • SQL ServerBeginner

    From SQL Basics to SQL Server Performance Tuning

    Connect the SQL Server Foundations curriculum to production work with running queries, blocking, monitoring, Query Store, and performance tuning.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    GROUP BY Explained in SQL Server

    Learn how GROUP BY turns SQL Server rows into one summary row per status, customer, or combination of values.

    Published Oct 21, 2026•13 min read

    Read article →
  • SQL ServerBeginner

    Indexes in SQL Server: A Beginner Introduction

    Learn how SQL Server indexes help find rows, how clustered and nonclustered indexes differ, and why every index has a cost.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    INNER JOIN vs LEFT JOIN in SQL Server

    Compare INNER JOIN and LEFT JOIN in SQL Server and learn when to keep unmatched customers, filter orders, and find customers with no orders.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    INSERT Basics in SQL Server

    Learn how to insert one or several rows in SQL Server with explicit columns, clear values, and a SELECT check of the result.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    Understanding NULL in SQL Server

    Learn what NULL means in SQL Server, how IS NULL and IS NOT NULL work, why = NULL fails, and how COALESCE and COUNT handle missing data.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    Understanding the Parts of a SELECT Statement in SQL Server

    What each clause of a T-SQL SELECT statement does, which parts are required and which are optional, and how one complete query reads from SELECT to ORDER BY.

    Published Oct 21, 2026•9 min read

    Read article →
  • SQL ServerBeginner

    Primary Keys and Foreign Keys in SQL Server

    Understand how primary keys identify rows and foreign keys connect related tables while protecting relationships in SQL Server.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Safe UPDATE and DELETE Practices in SQL Server

    Use a repeatable SQL Server workflow to preview rows, count targets, make changes in a transaction, verify results, and choose COMMIT or ROLLBACK.

    Published Oct 21, 2026•15 min read

    Read article →
  • SQL ServerBeginner

    Sorting Data with ORDER BY in SQL Server

    Sort SQL Server query results with ORDER BY, ASC and DESC, multiple sort keys, aliases, expressions and TOP using dbo.Customers.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    SQL JOINs Explained in SQL Server

    Learn SQL Server INNER JOIN and LEFT JOIN with Customers and Orders. Understand keys, aliases, ON conditions and customers without orders.

    Published Oct 21, 2026•11 min read

    Read article →
  • SQL ServerBeginner

    SQL Query Order: Written Order vs Logical Processing Order

    You write SELECT first, but SQL Server logically starts with FROM. Learn the logical processing order of a SELECT statement and how it explains aliases, WHERE vs HAVING and GROUP BY errors.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    Stored Procedures in SQL Server: A Beginner Introduction

    Learn how to create, execute, parameterize, and alter a basic SQL Server stored procedure, and how it differs from a view.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Using Table and Column Aliases in SQL Server

    Learn how SQL Server table and column aliases make query results friendlier and JOINs easier to read without renaming database objects.

    Published Oct 21, 2026•10 min read

    Read article →
  • SQL ServerBeginner

    UPDATE Basics in SQL Server

    Learn to update SQL Server rows safely by previewing the target with SELECT, using a precise WHERE clause, and checking the result.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    Views in SQL Server: A Beginner Introduction

    Learn what a SQL Server view stores, how to create and query one, and when a reusable view helps keep beginner queries consistent.

    Published Oct 21, 2026•11 min read

    Read article →
  • SQL ServerBeginner

    WHERE vs HAVING in SQL Server

    Understand when to use WHERE and HAVING in SQL Server: filter individual rows first, or filter groups after aggregation.

    Published Oct 21, 2026•12 min read

    Read article →
  • SQL ServerBeginner

    How to Connect to SQL Server with SSMS

    A beginner's walkthrough of the SSMS Connect dialog: what to type as the server name, which authentication to pick, what the encryption options mean, and what to check when the connection fails.

    Published Oct 20, 2026•9 min read

    Read article →
  • SQL ServerBeginner

    How to Find and Navigate a Database in SQL Server Management Studio

    Learn how SQL Server organizes instances, databases, schemas and tables, how to find a table in Object Explorer, and how to open a query window in the right database.

    Published Oct 20, 2026•8 min read

    Read article →
  • SQL ServerBeginner

    Your First SELECT Query in SQL Server

    Write and run your first T-SQL queries in SSMS: SELECT and FROM, choosing columns, TOP, reading the results grid and Messages tab, a first look at WHERE and ORDER BY, and the errors every beginner hits.

    Published Oct 20, 2026•11 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Runtime 2.0 vs 1.3 vs 1.2: What Changed and Should You Upgrade?

    Compare Microsoft Fabric Runtime 2.0, 1.3, and 1.2 across Spark, Python, Java, Scala, Delta Lake, performance, lifecycle, compatibility, and migration risk.

    Published Oct 18, 2026•15 min read

    Read article →
  • SQL ServerIntermediate

    SQL Server 2025 vs 2022 vs 2019: What Changed and Should You Upgrade?

    Compare SQL Server 2025, 2022, and 2019 across performance, Query Store, intelligent query processing, locking, tempdb, security, availability, and support lifecycle.

    Published Oct 18, 2026•16 min read

    Read article →
  • SQL ServerIntermediate

    SSMS 22 vs 21 vs 20: What Changed and Why Upgrade?

    Compare SQL Server Management Studio 22, 21, and 20 across 64-bit architecture, Git, Copilot, Agent Mode, Database DevOps, security, Fabric integration, execution plans, and daily DBA productivity.

    Published Oct 18, 2026•13 min read

    Read article →
  • Microsoft FabricIntermediate

    Power BI Visualization in Microsoft Fabric: From Semantic Model to Effective Report

    How to turn a governed Fabric semantic model into a Power BI report people act on: page hierarchy, visual choice, KPIs, drillthrough, accessibility and performance.

    Published Oct 17, 2026•12 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Governance with Microsoft Purview: A Practical Architecture Guide

    How to govern a growing Microsoft Fabric platform: domains, workspaces, lineage, sensitivity labels, OneLake security, endorsement and where Microsoft Purview fits.

    Published Oct 16, 2026•13 min read

    Read article →
  • Microsoft FabricIntermediate

    Semantic Models in Microsoft Fabric: How Power BI Fits into a Modern Data Platform

    Where semantic models sit in a Fabric architecture: Gold tables vs business contracts, Lakehouse or Warehouse sources, Direct Lake, Import, DirectQuery, star schemas and security.

    Published Oct 16, 2026•12 min read

    Read article →
  • Cloud & AutomationAdvanced

    Building a Multi-Tenant Report Engine on Azure and Microsoft Fabric

    Design a multi-tenant report engine on Azure and Microsoft Fabric with metadata-driven reports, constrained custom queries, caching, pagination, asynchronous exports and capacity protection.

    Published Oct 15, 2026•14 min read

    Read article →
  • Microsoft FabricIntermediate

    Materialized Lake Views in Microsoft Fabric: A Practical Guide

    Learn how Materialized Lake Views work in Microsoft Fabric, including Delta persistence, dependency-aware refresh, medallion design and practical tradeoffs.

    Published Oct 15, 2026•5 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Invoke Pipeline Activity: Build Modular and Reusable Data Pipelines

    Use the Microsoft Fabric Invoke Pipeline activity to compose parameterized parent and child pipelines across workspaces, with secure connections and practical monitoring.

    Published Oct 15, 2026•10 min read

    Read article →
  • Microsoft FabricIntermediate

    Data Integration Patterns: A Practical Guide for Modern Data Platforms

    A practical guide to batch, ETL, ELT, CDC, streaming, replication, APIs, files, federation, zero-copy, reverse ETL, synchronization, and orchestration.

    Published Oct 13, 2026•8 min read

    Read article →
  • Microsoft FabricIntermediate

    ETL vs ELT vs CDC vs Streaming: Data Integration Patterns and How to Implement Them in Microsoft Fabric

    Compare ETL, ELT, ETLT, CDC, streaming, reverse ETL, mirroring, and shortcuts, with practical Microsoft Fabric implementations and technology choices.

    Published Oct 12, 2026•13 min read

    Read article →
  • PythonIntermediate

    Python 3.15 Performance: What Actually Got Faster?

    See what actually got faster in Python 3.15, including JIT improvements, startup behavior, standard-library optimizations, profiling, and how to benchmark your own code.

    Published Oct 12, 2026•13 min read

    Read article →
  • PythonIntermediate

    Python 3.15 vs 3.14: What Changed and Should You Upgrade?

    Compare Python 3.15 with 3.14: the practical language, runtime and profiling changes, compatibility risks, and a focused upgrade checklist.

    Published Oct 12, 2026•12 min read

    Read article →
  • Microsoft FabricIntermediate

    Bronze, Silver, Gold in Microsoft Fabric: A Practical Medallion Architecture Guide

    A practical guide to Bronze, Silver, and Gold layers in Microsoft Fabric, including what belongs in each layer, how data should move between them, Lakehouse and Warehouse choices, quality rules, and common implementation mistakes.

    Published Oct 9, 2026•17 min read

    Read article →
  • Cloud & AutomationIntermediate

    Design Patterns for Data Engineering: Practical Patterns for Reliable Data Platforms

    A practical guide to data engineering design patterns for ingestion, transformation, orchestration, storage, reliability, and serving.

    Published Oct 9, 2026•16 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Notebook Tutorial: From Your First Notebook to Production

    A practical Microsoft Fabric notebook tutorial covering Lakehouse attachment, PySpark and SQL, Delta tables, parameters, pipelines, Git, monitoring, performance, and production readiness.

    Published Oct 9, 2026•18 min read

    Read article →
  • SQL ServerIntermediate

    SQL Server JOINs in Practice: Multi-Table SELECT, UPDATE, DELETE, Indexing, and Performance

    A practical SQL Server guide to joining multiple tables, updating and deleting with JOINs, avoiding duplicate-row mistakes, choosing indexes for join columns, and understanding how JOIN design affects performance.

    Published Oct 9, 2026•20 min read

    Read article →
  • SQL ServerIntermediate

    SQL Server Performance Tuning Workflow: From Slow Query to Root Cause

    A practical SQL Server performance tuning workflow for moving from a vague slowdown to evidence, root cause, remediation, and validation using waits, Query Store, execution plans, blocking, I/O, CPU, memory, and workload context.

    Published Oct 9, 2026•18 min read

    Read article →
  • DevOps & ObservabilityBeginner

    Connect Microsoft Fabric to Git

    Connect a Microsoft Fabric workspace to a GitHub or Azure DevOps repository step by step, and understand branches, folders, commits, updates, conflicts and what belongs in source control.

    Published Oct 8, 2026•12 min read

    Read article →
  • Microsoft FabricBeginner

    Create Your First Microsoft Fabric Workspace

    Create a Microsoft Fabric development workspace step by step, with sensible decisions about capacity, workspace roles, naming, ownership and Git readiness from the start.

    Published Oct 8, 2026•9 min read

    Read article →
  • Microsoft Fabric architecture with OneLake connecting Lakehouse, Warehouse, Data Factory, notebooks, Eventhouse and semantic models.

    Microsoft FabricBeginner

    What Is Microsoft Fabric? A Practical Guide for Data Engineers

    How Microsoft Fabric works in practice: OneLake, Lakehouse, Warehouse, Data Factory, Eventhouse and Power BI, how they fit together, and when Fabric is the right platform.

    Updated Oct 24, 2026•18 min read

    Read article →
  • Microsoft FabricBeginner

    Create Your First Fabric Lakehouse

    Create a Microsoft Fabric Lakehouse step by step and understand Files vs Tables, Delta Lake, schemas, the SQL analytics endpoint and where your data actually lives in OneLake.

    Published Oct 8, 2026•10 min read

    Read article →
  • Microsoft FabricBeginner

    Create Your First Fabric Notebook

    Create a Microsoft Fabric notebook, attach it to a Lakehouse, build a small dataset with PySpark, write it as a Delta table and query it with Spark SQL, with every step explained.

    Published Oct 8, 2026•11 min read

    Read article →
  • PythonIntermediate

    Python 3.15 vs 3.11: What Changed and Should You Upgrade?

    See what changed from Python 3.11 through 3.15, which features arrived in each release, what may break, and how to plan an upgrade.

    Updated Oct 12, 2026•25 min read

    Read article →
  • Delta LakeAdvanced

    Delta Lake MERGE Performance Patterns for Large Tables

    Why Delta MERGE gets slow on large tables and the patterns that keep it fast: clean sources, pruning predicates, fewer touched files, sane file sizes, safe concurrency and knowing when not to MERGE.

    Published Oct 7, 2026•13 min read

    Read article →
  • DevOps & ObservabilityIntermediate

    Git Integration in Microsoft Fabric: A Practical Development Workflow

    How Fabric Git integration really works day to day: workspace and branch, commit and update, branching out, pull requests, conflicts, drift and permissions.

    Published Oct 7, 2026•11 min read

    Read article →
  • A Git repository flowing through a deployment pipeline into DEV, QA and PROD Fabric workspaces

    DevOps & ObservabilityIntermediate

    Microsoft Fabric CI/CD with fabric-cicd: From Git to DEV, QA and PROD

    A production guide to deploying Microsoft Fabric items from Git with Microsoft’s fabric-cicd library, covering repo layout, authentication, parameterization, CI and CD.

    Published Oct 7, 2026•15 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Notebook Parameters: Practical Patterns for Reusable Pipelines

    Make one Fabric notebook serve many runs: the parameters cell, pipeline base parameters, validation, date windows, environments, secrets, safe logging and testing.

    Published Oct 7, 2026•11 min read

    Read article →
  • Microsoft FabricIntermediate

    Microsoft Fabric Lakehouse vs Warehouse: Which One Should You Use?

    A practical decision guide for Fabric Lakehouse and Warehouse: write paths, Spark and T-SQL access, the SQL analytics endpoint, transactions, governance and when to combine both.

    Published Oct 7, 2026•12 min read

    Read article →
  • SQL ServerIntermediate

    How to Find SQL Server Performance Regressions with Query Store

    A practical Query Store workflow for SQL Server regressions: compare time windows, find queries that slowed down, inspect plan changes, force plans safely and undo them.

    Published Oct 7, 2026•13 min read

    Read article →
  • Microsoft FabricIntermediate

    Mirror Azure SQL Tables into Microsoft Fabric and Query Them from a Notebook

    Mirror an Azure SQL Database table into Microsoft Fabric OneLake without a copy pipeline, clear the network and identity prerequisites, and query it from a Fabric notebook with Spark SQL and PySpark.

    Published Oct 6, 2026•9 min read

    Read article →
  • SQL ServerIntermediate

    Azure SQL Table Types: Which One Should You Use?

    A practical guide to regular, memory-optimized, temporal, ledger, graph and external tables in Azure SQL, including when to use each one.

    Published Oct 6, 2026•9 min read

    Read article →
  • Web, mobile and external API clients sharing one report engine

    Cloud & AutomationIntermediate

    Designing a Report Engine for UI and API Consumers

    Design one governed report backend for interactive UI pages, external APIs, downloads and large asynchronous exports.

    Published Oct 3, 2026•9 min read

    Read article →
  • Report request following cache-hit or live-query paths

    Cloud & AutomationIntermediate

    Pre-Rendered Reports vs Live Queries

    Choose pre-rendered, live, or hybrid report execution using freshness, repetition, variability, cost and security constraints.

    Updated Nov 7, 2026•7 min read

    Read article →
  • Report request lifecycle from authentication through execution and monitoring

    Cloud & AutomationIntermediate

    Report Engine Architecture: Request to Result

    Trace a report request through gateway, security, validation, cache, Fabric query, result construction and monitoring.

    Updated Nov 7, 2026•7 min read

    Read article →
  • Clients reaching Fabric data through a gateway, report engine, cache and query layer

    Cloud & AutomationIntermediate

    What Is a Report Engine?

    Define the report engine as a secure service between UI or API consumers and analytical data.

    Updated Nov 7, 2026•7 min read

    Read article →
  • Notebook flowing through a reusable session and Spark processing into Delta output

    Microsoft FabricIntermediate

    How to Make Microsoft Fabric Notebooks Faster

    A practical workflow for reducing Fabric notebook startup, read, shuffle, transformation and Delta write time without guessing.

    Updated Nov 7, 2026•10 min read

    Read article →
  • Startup clock progressing into an active Spark session and running notebook

    Microsoft FabricIntermediate

    How to Reduce Fabric Notebook Startup Time

    Diagnose Microsoft Fabric Spark session acquisition and reduce avoidable notebook startup overhead through compatible pools, environments and reuse.

    Updated Nov 7, 2026•9 min read

    Read article →
  • Pipeline session tag routing compatible notebooks into a shared Spark session

    Microsoft FabricIntermediate

    Using Session Tags in Fabric Pipelines

    Use Microsoft Fabric pipeline session tags to group compatible notebook activities for Spark session reuse while preserving workload boundaries.

    Updated Nov 7, 2026•9 min read

    Read article →
  • Execution logging flow from trigger through child activity and operational log

    DevOps & ObservabilityIntermediate

    Designing an Execution Log for Microsoft Fabric Pipelines and Notebooks

    Design a production execution log for Microsoft Fabric pipelines and notebooks using run IDs, correlation IDs, status, row counts, watermarks, errors and rerun-safe patterns.

    Updated Oct 24, 2026•19 min read

    Read article →
  • Report request lifecycle from authentication through observed completion

    DevOps & ObservabilityIntermediate

    Measuring API and Report Request Volume

    Measure API and report demand by client, tenant, report type, latency, concurrency, payload and request cost.

    Published Oct 3, 2026•9 min read

    Read article →
  • Monitoring layers from client through compute and storage

    DevOps & ObservabilityIntermediate

    Monitoring a Data Platform: What Should You Actually Measure?

    A practical monitoring model connecting clients, applications, APIs, report engines, data platforms, compute and storage.

    Updated Nov 7, 2026•9 min read

    Read article →
  • Fabric pipeline and notebook execution flow into operational monitoring

    DevOps & ObservabilityIntermediate

    Monitoring Microsoft Fabric Pipelines and Notebooks in Production

    How to monitor Fabric pipelines and notebooks well enough to catch failures, slowdowns, retries, capacity pressure and bad data before users do, with run correlation, execution logs, baselines and alerts.

    Updated Oct 24, 2026•18 min read

    Read article →
  • SQL Server current-state monitoring connected to historical evidence

    DevOps & ObservabilityIntermediate

    Monitoring SQL Server Workloads in Real Time

    Inspect active SQL Server requests, sessions and connections, then connect current state to retained Query Store history.

    Updated Nov 7, 2026•13 min read

    Read article →
  • Highlighted DataFrame rows passing through a filter into a smaller table

    PythonBeginner

    Filtering Rows in pandas

    Build readable, null-safe pandas filters for realistic order questions and validate the result instead of relying on fragile expressions.

    Published Oct 3, 2026•11 min read

    Read article →
  • Data rows grouped into categories and summarized as aggregate bars

    PythonIntermediate

    GroupBy and Aggregations

    Build trustworthy pandas summaries by defining grain, revenue rules, null behavior and joins before grouping real order data.

    Published Oct 3, 2026•12 min read

    Read article →
  • A DataFrame grid with highlighted schema and profile indicators

    PythonBeginner

    Inspecting a DataFrame

    Profile a pandas DataFrame systematically with shape, schema, samples, null counts, uniqueness and distribution checks before transforming it.

    Published Oct 3, 2026•11 min read

    Read article →
  • Two DataFrame tables joining by a shared key into one result

    PythonIntermediate

    Joining and Merging DataFrames

    Join pandas DataFrames safely with explicit cardinality, unmatched-key checks, indicators and row-count reconciliation.

    Published Oct 3, 2026•12 min read

    Read article →
  • A CSV document flowing into a structured DataFrame grid

    PythonBeginner

    Reading CSV Files with pandas

    Load a real CSV into pandas deliberately, validate its shape and types, and avoid the ingestion assumptions that cause downstream data problems.

    Published Oct 3, 2026•11 min read

    Read article →
  • Three SQL Server sessions connected in a blocking chain, with lock indicators on waiting requests

    SQL ServerIntermediate

    How to Find Blocking in SQL Server

    Find blocked requests, trace blocking chains to the head blocker, and inspect the responsible session and transaction safely.

    Updated Nov 7, 2026•15 min read

    Read article →
  • Live SQL Server activity table comparing session, database, CPU, reads, and wait state

    SQL ServerIntermediate

    How to Find What Is Running in SQL Server Right Now

    A production-safe DMV query for active SQL Server requests, including statement text, identity, resource use, waits and blocking.

    Updated Nov 7, 2026•12 min read

    Read article →
  • SPID 123 linked to its session, current request, SQL text, login, host, wait, and blocker details

    SQL ServerBeginner

    How to Get a SQL Server Session ID and See What It Is Doing

    Find your SQL Server session ID, investigate another session, and inspect its request, SQL text, waits, blocking and open transaction state.

    Updated Nov 7, 2026•12 min read

    Read article →
  • SQL Server slowdown diagnostic flow from active requests and blocking through resource use, query plan, indexes, and statistics

    SQL ServerIntermediate

    SQL Server Is Slow: The First 15 Minutes of Incident Triage

    A production-first triage sequence for turning a vague SQL Server slowdown into evidence and a safe next diagnostic step in the first 10–15 minutes.

    Updated Nov 7, 2026•13 min read

    Read article →
  • SQL Server database icon beside relative storage bars for Orders, Events, and Customers tables

    SQL ServerIntermediate

    How to See SQL Server Table Sizes

    Measure SQL Server row counts, reserved space, data, indexes and unused allocation without double-counting partitions or allocation units.

    Published Oct 3, 2026•12 min read

    Read article →
  • Abstract illustration of a glowing blue brain labelled AI

    AI & Data

    Using LLMs with Your Data: Practical Patterns

    Engineering patterns for connecting LLM applications to enterprise data with controlled retrieval, tools and authorization.

    Published Oct 2, 2026•11 min read

    Read article →
  • Modern glass building with a flowing blue facade

    Microsoft Fabric

    Designing a Scalable Microsoft Fabric Architecture

    A practical guide to workload boundaries, storage, capacity, deployment and operations in Microsoft Fabric.

    Published Oct 2, 2026•13 min read

    Read article →
  • Microsoft FabricBeginner

    Medallion Architecture Explained: Bronze, Silver and Gold

    What the Bronze, Silver and Gold layers are for, how data quality and incremental processing work across them in Microsoft Fabric, and when fewer layers are the better design.

    Published Oct 2, 2026•11 min read

    Read article →
  • Close-up of a glowing server display reading SQL

    SQL Server

    SQL Server Performance Tuning: A Practical Checklist

    A production-oriented checklist for investigating SQL Server performance with evidence instead of guesses.

    Published Oct 2, 2026•12 min read

    Read article →

Follow the Microsoft Fabric learning path

See what is coming next: the editorial roadmap

Javi Builds

Data • AI • Cloud Engineering

  • Articles
  • Cheat Sheets
  • Runbooks
  • Labs
  • Projects
  • Speaking
  • Community
  • Resources
  • About
  • Certifications
  • Gear
  • Contact
  • GitHub — link coming soon

© 2026 Javi Builds. All rights reserved.

Share image photo: Peyto Lake in winter by Jakub Fryš, CC BY-SA 4.0 (adapted)

“Python” and the Python logos are trademarks or registered trademarks of the Python Software Foundation, used by Javi Builds with permission from the Foundation.