Tiger Team (@mssqltiger) represented by (Sudhakar Sannakkayala, Bob Ward, Sunil Agarwal and Ajay Jagannathan) will be in full force by speaking at 14 sessions at the SQL Server Geeks Annual Summit (#SSGAS2016), Asia’s Premier Data & Analytics Conference taking place on 11-13 August in Bangalore, India. SQLServerGeeks Annual Summit 2016 is a full 3-day conference with more than 100 breakout sessions and deep dive pre-con sessions on SQL Server, BI & Analytics, Cloud, Big Data, and related technologies.
|This is a truly unique conference (see this video), comprised with multiple tracks on Database Management, Database Development, Business Intelligence, Advanced Analytics, Cloud, and Big Data. The summit attracts SQL experts from around the globe. SSGAS 2016 is the only Data/Analytics event in Asia where product teams from Microsoft’s Data Group fly down from Redmond to deliver advanced sessions on the latest technologies.|
Here is a list of breakout sessions, chalk talks and open talks where you can get to meet and interact with the team.
|Aug 11 2016||10:45 – 12:00||Breakout||Friction-Free Upgrade and Migration to SQL Server using DMA, SSMA and WAR||Ajay Jagannathan / Sudhakar Sannakkayala||Intermediate||DBA||Are you excited about new capabilities in SQL Server 2016 and SQL Azure DB to unlock your business insights? Are you looking for a friction-free upgrade and migration experience? Do you want to understand the application compatibility and performance impact the upgrade/migration will have? Do you want low cost and high confidence from these complex activities? If you answered yes to any of these questions, then this demo-filled session is a must attend. We will showcase several new tools such as Data Migration Assistant, SQL Server Migration Assistant and Workload Analysis Reports that will help you plan, assess, execute and compare results of your upgrade or migration projects.|
|Aug 11 2016||13:45 – 15:00||Breakout||Understanding SQL R Services: What Every SQL Professional Should Know||Bob Ward||Intermediate/Advanced||DBA/DEV||SQL Server 2016 introduces a new platform for building intelligent, advanced analytic applications called SQL Server R Services. This session is for the SQL Server Database professional to learn more about this technology and its impact on managing a SQL Server environment. We will cover the basics of this technology but also look at how it works, troubleshooting topics, and even usage case scenarios. You don’t have to be a data scientist to understand SQL Server R Services but you need to know how this works so come upgrade you career by learning more about SQL Server and advanced analytics|
|Aug 11 2016||14:30 – 15:00||Chalk-Talk||Transaction Isolation Levels Including RCSI and Snapshot Isolation||Sunil Agarwal||Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!|
|Aug 11 2016||17:15 – 17:45||Chalk-Talk||Background Threads – Silent Heroes of SQL Server Engine||Ajay Jagannathan||Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!|
|Aug 11 2016||17:15 – 18:30||Breakout||Operational Analytics in SQL Server 2016 and Azure SQL Database||Sunil Agarwal||Intermediate||DEV/DBA||SQL Server 2016 enables customers to 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 Real-Time Operational Analytics.|
|Aug 11 2016||18:00 – 18:30||Open-Talk||Troubleshooting the Top 5 Issues Seen by Customers of SQL Server||Bob Ward||Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A|
|Aug 12 2016||11:45 – 13:00||Breakout||SQL Server 2016: Customer Success Stories with Columnstore Index||Sunil Agarwal||Intermediate/Advanced||DBA/DEV||In-memory Analytics using columnstore index provides industry leading performance for analytics workload. This session will cover some key customer workloads that have been successfully deployed in production both for in-memory analytics and real-time operational analytics with SQL Server 2016. For each workload, we will describe the scenario, learnings and the performance achieved
As a result of attending this session I am better able to…
o Understand the scenarios where columnstore can deliver superior performance for the workload
o Learn how to choose between clustered columnstore index and nonclustered columnstore index
o Apply the best practices in using columnstore index to deliver superior performance
|Aug 12 2016||13:15 – 14:30||Breakout||Inside the SQL Server Query Store||Bob Ward||Advanced||DBA/DEV||In this session you will understand how the SQL Server Query Store can be used to take you to the next level for query performance monitoring, tuning, and troubleshooting. You will see how the Query Store works, what its capabilities are, and even how to troubleshoot when problems occur with its execution. There will be plenty of demos in this session covering both SQL Server 2016 and Azure SQL Database scenarios.|
|Aug 12 2016||14:45 – 16:00||Breakout||Enhancements That Will Make Your SQL Engine Roar||Ajay Jagannathan||Advanced||DBA||Are you interested in knowing about some cool improvements in SQL Server to turbo charge its performance? If yes, then this session is for you!
This session will showcase several improvements in the Database Engine for SQL Server 2012 through 2016, that address some of the most common customer pain points involving tempdb, new CE, memory management, partitioning, alter column as well as diagnostics for troubleshooting query plans, memory grants, and backup/restore.
Come see this demo filled session to understand these changes in performance and scale of the database engine, new and improved diagnostics for faster troubleshooting and mitigation.
Learn how you can use these features to entice your customers to upgrade and run SQL Server workloads with screaming performance.
1. Learn about performance, scale and diagnostics enhancements in SQL Server database engine.
2. Evangelize these enhancements to get an out-of-box performance.
3. With this, understand how your experience with SQL Server will improve, and why you should install the latest and greatest Service Packs
|Aug 12 2016||16:30 – 17:00||Open-Talk||TempDB Configuration and Common Issues||Ajay Jagannathan / Sunil Agarwal||Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A|
|Aug 12 2016||17:15 – 17:45||Chalk-Talk||Understanding SQLOS Scheduling||Bob Ward||Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing!|
|Aug 13 2016||08:45 – 10:00||Breakout||Become A Troubleshooting Ninja Using SQL Server Extended Events||Ajay Jagannathan||Advanced||DBA||New to Extended Events? Want to become a ninja in troubleshooting common SQL issues using extended events? This is a demo filled session that will show you how to troubleshoot several common issues in SQL server database engine and identify hotspots as well failures using only extended events. We will showcase how extended events make scenario based troubleshooting easier without having to collect disparate sets of diagnostic data, gather memory dumps and comprise on performance. There have been a plethora of Extended Events which have been added to SQL Server recently based on customer feedback which deprecates the need to run profiler in many commonly encountered situations in production environments. This session covers the new enhancements and capabilities available for Extended Events.|
|Aug 13 2016||10:30 – 11:45||Breakout||SQL Server 2016: It Just Runs Faster||Bob Ward||Intermediate/Advanced||DBA/DEV||Join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won’t want to miss this session.|
|Aug 13 2016||13:30 – 14:45||Breakout||In-Memory OLTP: Concepts and Improvements in SQL Server 2016||Sunil Agarwal||Advanced||DBA/DEV||SQL Server 2014 introduced in-memory technology for optimizing OLTP workloads. This talk provides an overview of the in-memory technology using common use cases. We will examine how in-memory tables and indexes are managed. You will also learn how to provision and control memory usage, how durability and high availability is achieved and how these constructs and operations are integrated together with disk-based tables to provide you a seamless experience|
Ajay Jagannathan (@ajaymsft)
Principal Program Manager