SQLCAT at PASS Summit 2018

This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years before, the SQLCAT (a.k.a. DataCAT) team will be at the conference. This year, we will present three sessions:

On Thursday Nov 8 at 4:45 PM in room 6B, Alexei Khalyako, John Hoang, and Mike Weiner will talk about Learnings and Best Practices in Building an Enterprise Data Warehouse Using Azure SQL DW. Our team has had the opportunity to work with a number of customers moving their data warehouse workloads to Azure SQL DW. In this session we’ll share learnings around the most common design patterns with Azure SQL DW and go deeper on data loading and performance tuning and optimization considerations with Azure SQL DW (Gen2). Come to this session to learn from our real-world experiences in working with customers on adopting Azure SQL DW.

On Friday Nov 9 at 8:00 AM in room 615, Arvind Shyamsundar will show how to tackle Advanced SQL Server Troubleshooting with SQLCallStackResolver. This Level 400 session is a product of many real-world customer engagements that our team has worked on. Arvind will show you some tools and techniques to tackle the hardest-to-investigate performance issues in SQL Server and he will demo one such scenario involving spinlock contention on high-end servers. Most importantly, the information in the session is very practical and directly usable. Guaranteed to help you be much more efficient and precise when troubleshooting SQL Server performance!

On Friday Nov 9 at 9:30 AM in the TCC room Tahoma 5, Kun Cheng, Dimitri Furman, and Mike Weiner will talk about SQL DB Managed Instance - Best Practices and Lessons Learned. For well over a year, since the early private preview in summer of 2017 and through General Availability in fall of 2018, we have been collaborating with Microsoft customers who are the early adopters of Managed Instance, and with the Managed Instance engineering team, to ensure successful implementations and to improve the offering. If you want to learn how Managed Instance works and how to use it optimally, from performance tips to migration best practices, this session is for you.

In addition to presenting, we will also be at the Data Clinic, where together with our colleagues from the SQL Server engineering team, the Tiger team, the CSS team, and many others we will help you solve real life problems and answer hard (or easy 😊) questions about SQL Server and other data technologies we work with.

See you at the Summit!