Margarita Naumova

Magi Naumova is an SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master, MVP, MCT, Founder of SQL Master Academy, and founder and CEO Of Inspirit Data Platform Consulting Company in Bulgaria and Norway, founder, and the leader of Bulgarian SQL & BI User group and Azure Analytics User Group BG. She has more than 25 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team. Currently she speaks, writes, trains and consults people on SQL Server and MS Fabric Data Platform. She is MVP for 15 years in a row. Her unique SQL Master Academy training program has helped hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.

Sessions for 2026

Large Tables, Big Problems: Indexing, Partitioning, and Archiving at Scale

Managing massive tables isn't just about storage, it's about keeping performance sharp and maintenance practical. In this session, you'll learn proven strategies for optimizing queries, indexing, and partitioning on large tables, along with scalable data archival approaches to reduce bloat, control cost, and stay compliant. Ideal for DBAs and data engineers working at scale

A Deep Dive into Table Partitioning – Part 1: Mechanics and Performance

A practical, demo-driven deep dive into SQL Server table partitioning. Learn how partitioning works under the hood, why partition elimination succeeds or fails, and how design and maintenance choices impact performance and reliability in real systems. Learn how table partitioning works internally in SQL Server. This Part 1 session covers partition functions and schemes, physical row placement, partition switching, splitting and merging, and the mechanics behind partition elimination—supported by practical demos and execution plan analysis.

A Deep Dive into Table Partitioning – Part 2: Design, Maintenance, and Troubleshooting

A practical, demo-driven deep dive into SQL Server table partitioning. Learn how partitioning works under the hood, why partition elimination succeeds or fails, and how design and maintenance choices impact performance and reliability in real systems. Learn how table partitioning works internally in SQL Server. Build on the partitioning mechanics from Part 1 and focus on real-world usage. This session explores partition key selection, aligned and non-aligned indexes, maintenance strategies, and how to diagnose and fix common performance problems in partitioned tables.

From Load to Logic: Designing for Performance in Microsoft Fabric Warehouses

This training day provides an end-to-end approach to designing high-performing Microsoft Fabric Warehouses. It covers loading strategies, schema and query design, performance features, Workload Management, and deployment practices, with a strong focus on performance and cost efficiency. Real project examples and feedback from data engineering teams illustrate how design decisions behave in practice. Attendees leave with a clear mental model that enables informed, scalable, and predictable warehouse design.

SQL Server 2025 and Microsoft Fabric: Integration Patterns and Trade-offs

This session explores the main ways to integrate SQL Server 2025 with Microsoft Fabric and the trade-offs each approach introduces. We compare classic ETL (including pipeline-based ingestion) with newer near-real-time options such as Mirroring and Change Event Streams (CES). Using practical scenarios, the session focuses on how these patterns differ in latency, operational complexity, schema evolution, and cost. Attendees leave with a clear framework for choosing the right integration approach for their workloads.

SQL Server 2025 Optimized Locking and ADR: Practical Internals for Real Systems

SQL Server 2025 introduces Optimized Locking and deepens its reliance on Accelerated Database Recovery. This session explains how these features work together, what changes in locking and recovery behavior, and what that means in real production systems. Attendees gain a practical understanding of the benefits, trade-offs, and operational considerations of using Optimized Locking with ADR.

Warehouse loading – tips and tricks for better performance

We will talk about how to combine the toolset we have for building elegant data loading solutions in the warehouse for the best performance. Tips and tricks on the way will help you learn, design and be prepared to start a process of loading data in your Fabric warehouse environment.

Previous Sessions

Keeping historical data in tables forever – mission (im)possible!

Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.

Modern database design (anti)patterns

We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.

SQL Server Table partitioning – DOs and DON’Ts

When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?

Identify opportunities for In-Memory OLTP

The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.