Matan Yungman is a Technical Evangelist for Madeira SQL Server Services. He has over 10 years of experience working with SQL Server, focusing mainly on performance tuning, high availability, database development and database design. Matan also co-hosts the SQL Server Radio podcast on SQLServerRadio.com. He is passionate about SQL Server, technology and the SQL Server community.
Matan Yungman has submitted 2 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions
Microsoft has a famous whitepaper called "The Data Loading Performance Guide".
On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.
As DBAs, we all know about the big new features, like AlwaysOn Availability Groups, Columnstore Indexes and In-Memory OLTP ("Hekaton"). But there are other "small" hidden features you may have not heard about that can make your lives a lot easier.
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?