Amit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit (India), MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on www.youtube.com/SQLMaestros. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal/
Amit Bansal has submitted 3 sessions for SQLBits 2019, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. You will also see a few practical examples of memory troubleshooting.
Enough of bookish examples. Learn how you can re-write T-SQL queries using new constructs, tune indexes & deal with statistics to improve query performance.
You always wanted to troubleshoot a slow running query. But you just don’t know where to begin.

Sessions

Previous Sessions

Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.