MSSQLTIGER at SQL Saturday Redmond

imagePASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. We are excited that the event this Saturday (April 2nd, 2016) is happening in our backyard! We are happy to have the opportunity to meet the SQL Family and learn how SQL Server is behaving in your environment. And if you had any feedback about how SQL Server should have behaved in certain scenarios in your environment, we are all ears!

The day is packed with great sessions delivered by SQL stalwarts with decades of SQL Server experience. We also have a number of our colleagues from the Microsoft Data Group and SQL Server CAT team who will be presenting sessions related to interesting topics for Data related technologies. The full schedule of the event is available here.

We will also be delivering a few sessions during the day. Below is a list of the sessions that the members of the Tiger team will be delivering. We are looking forward to the weekend and hope to see you at Microsoft Building 33, 16070 NE 36th Way , Redmond, Washington, 98052, United States!


Session: In-Memory Analytics using Columnstore Index in SQL Server 2016
Session Time: 8:45AM – 9:45AM PST
Level: Beginner
Room: Rainier
Speaker: Sunil Agarwal

What you can expect: The updateable clustered columnstore in SQL Server 2014 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional btree-based schemas. This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016.

Session: Real Time Operational Analtyics in SQL Server 2016
Session Time: 10:00AM – 11:00AM PST
Level: Intermediate
Room: Rainier
Speaker: Sunil Agarwal

What you can expect: SQL Server 16 enables customers can run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics.

Session: Troubleshooting made easier using Extended events
Session Time: 2:15PM – 3:15PM PST
Level: Intermediate
Room: Rainier
Speaker: Amit Banerjee

What you can expect: Extended Events in SQL Server provides a huge opportunity to debug and analyze complex problems with ease. Join me to understand the diagnostics enhancements available in SQL Server database engine in SQL Server 2012 Service Pack 3 and above. After this session, you will be able to leverage the diagnostics to troubleshoot and mitigate issues quickly in mission-critical environments and simplify troubleshooting experience for common SQL Server scenarios.

P.S. Generally we are good tigers and don’t growl or bite! Don’t be afraid to come talk to us! :)


Amit Banerjee (@banerjeeamit)
Senior Program Manager
Microsoft Data Group