Date(s) - 20/01/2018
9:30 am - 1:30 pm
Data Platform Day
|Event Type||Free In-Person Event (Half Day)|
|Session 1||Scale Out for SSIS|
Speaker: Muthukumaran Arumugam (Microsoft)
Abstract: SSIS Scale Out providers high performance execution of SSIS packages by distributing package executions across multiple computers. In this session, you will come to know the architecture of how this works and what you should know to make it work. Also, you will take home the knowledge from a practical demo.
|Community Break||Data Platform Summit 2018 Community Launch||Tea/Coffee Break||10 Minutes|
|Session 2||What’s New for Database Developers in SQL Server 2017|
Speaker: Sandip Pani (DataPlatformGeeks)
Abstract: SQL Server 2017 is already released and many new features added to database engine. In this session I will talk about features added for database developer. I will be talking about my top most 2 favorite features of SQL Server 2017. I will demonstrate how Resumable online index rebuild and Adaptive Query Processing works in SQL Server 2017.
|Session 3||Azure Analysis Services|
Speaker: Rahulinder Singh & Mohammed Malik (Microsoft)
Abstract: The following topics will be covered:
1. Overview of AAS.
2. Connectivity to sources and consumers.
3. Security in AAS with AAD.
4. Migrating existing on premise Analysis services models to AAS.
5. Right sizing AAS infrastructure based on telemetry.
6. Cost optimization strategies using Pause/resume and scaleup/scaledown.
7. Disaster recovery using backup/restore.
8. Automation of processing and synchronization using AMO for coexistence with exiting on premise infrastructure.
|Session 4||Real-World Query Tuning Examples (Video recorded session)|
Speaker: Amit R S Bansal (MCM, MVP)
Abstract: Join Microsoft Certified Master of SQL Server, Amit Bansal, and learn some real-world query tuning examples. In this deep-dive session you will learn how you can re-write T-SQL queries using new constructs to improve performance. You will learn how you can tune indexes & deal with statistics to improve query performance. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured.
|Date & Time||Saturday 20th January 2018 ( 9:30 AM – 1:00 PM IST)|
Note: Come by 9:00 AM for registration and security formalities. Please be seated by 9:30 AM.
|Venue||Survey No 210, Microsoft Campus,|
Hyderabad, Telangana – 500032
Bookings are closed for this event.