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. She has more than 15 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. She is MVP for 10 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

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.
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?
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.
Margarita_Naumova.jpg