Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

This repository demonstrates SQL performance optimization techniques using a sample database. It showcases best practices for indexing, query optimization, and schema design. The project is ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

Mirroring in Fabric is an enterprise, cloud-based, zero-ETL, SaaS technology. In this section, you learn how to create a mirrored SQL Server database, which creates a read-only, continuously ...

Millions of users work with SQL to keep the gears of their business turning. In an era marked by relentless digital transformation, the proliferation of AI workloads, and tightening regulatory demands ...