Explore Javi Builds by Topic
Browse practical guides, learning paths, labs and resources by technology and problem area.
Microsoft Fabric
Learning paths, Lakehouse, Delta, pipelines, performance and production.
54 guidesOpen the Microsoft Fabric hub →
Start Here →
The 12-step path from an empty workspace to a production-ready platform.
Lakehouse & OneLake →
Create Lakehouses and notebooks, and see how files and tables live in OneLake.
- Start hereCreate Your First Fabric Lakehouse
- Cheat sheetLakehouse vs Warehouse
Delta Lake →
Transactions, MERGE, maintenance and reliable Delta tables in Fabric.
PySpark & Notebooks →
Explore and transform data with PySpark, and keep notebooks fast.
Pipelines & Data Factory →
Orchestrate ingestion, pass parameters and choose the right tool for each step.
- Start herePipelines vs Notebooks vs Dataflow Gen2 vs Copy Job in Microsoft Fabric
- Deep diveMicrosoft Fabric Notebook Parameters: Practical Patterns for Reusable Pipelines
- Deep diveMigrate SSIS Packages to Microsoft Fabric: Retire, Rehost, Rebuild or Redesign
- Hands-onEnd-to-End Sales Analytics in Microsoft Fabric
- Cheat sheetDebug Fabric Pipelines
Warehouse & SQL →
T-SQL in Fabric and when a Warehouse beats a Lakehouse.
Architecture & Medallion →
Bronze, Silver and Gold, and platform designs that scale.
Performance & Capacity →
Diagnose slow workloads, capacity pressure and tune production systems.
Monitoring & Debugging →
Execution logs, monitoring and a repeatable debugging workflow.
Git & CI/CD →
Version Fabric items and promote changes from DEV to PROD.
Governance & Security →
Purview, ownership, access and trust across Fabric.
Interview Preparation →
Practical Fabric interview questions, from fundamentals to senior scenarios.
SQL Server
Performance tuning, indexing, Query Store and troubleshooting.
44 guidesOpen the SQL Server hub →
Start Here →
A step-by-step workflow for tuning a slow SQL Server.
Query Performance →
Running queries, Query Store, plans and workload diagnostics.
Query Tuning →
Faster joins and safe UPDATE and DELETE on large tables.
Indexing & Storage →
Index design, table sizes and storage choices.
Troubleshooting →
Incident triage, blocking and the first 15 minutes of a slowdown.
- Start hereSQL Server Is Slow: The First 15 Minutes of Incident Triage
- Deep diveHow to Find Blocking in SQL Server
- RunbookSQL Server Blocking Runbook
- Cheat sheetFind Blocking in SQL Server
Monitoring →
Watch live workloads, waits and sessions without guessing.
- Start hereMonitoring SQL Server Workloads in Real Time
- Cheat sheetSQL Server Wait Types
T-SQL Foundations →
Learn SQL from your first SELECT to joins, views and procedures.
- Start hereYour First SELECT Query in SQL Server
Versions & Tools →
SQL Server and SSMS versions compared, when to upgrade, and how SQL Server maps to Fabric.
Interview Preparation →
Practical SQL Server interview questions, from indexing to production troubleshooting.
Data Engineering
Architecture, Delta and Parquet, Python, observability and production patterns.
46 guidesOpen the Data Engineering hub →
Architecture & Patterns →
Integration patterns, ETL vs ELT, CDC and design trade-offs.
- Start hereDesign Patterns for Data Engineering: Practical Patterns for Reliable Data Platforms
- Deep diveDesigning a Production Data Platform: From Requirements to Operations
- Deep diveETL vs ELT vs CDC vs Streaming: Data Integration Patterns and How to Implement Them in Microsoft Fabric
- Cheat sheetBatch vs Streaming
Delta Lake & Parquet →
Columnar files, Delta tables and how to keep them healthy.
Python & PySpark →
pandas, DataFrames and PySpark for practical data work.
Observability →
What to measure, execution logs and monitoring data platforms.
Testing & Data Quality →
Unit and transformation tests, data-quality checks and CI/CD quality gates.
Production Engineering →
Incremental loads, debugging and running pipelines in production.
Interview Preparation →
Practical data engineering interview questions, from ETL and CDC to reliability and system design.
PySpark Interview Preparation →
Practical PySpark interview questions, from DataFrames to joins, shuffles, skew and production performance.
Python Interview Preparation →
Practical Python interview questions for data engineers, from generators and pandas to memory and reliable ingestion.