Perth SQL Server User Group

Event

Next Meeting: Thu, Aug 24 2017

Adaptive Query Processing in SQL Server 2017

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-adaptive-query-processing-in-sql-server-2017-tickets-36826773872

A sneak preview of new query optimisation capabilities in SQL Server 2017. Query optimizer with Adaptive Query Processing can change the query plan if it identifies that the actual row counts are very different from the estimates or update memory grants based on changed requirements. In this session, we will understand these new capabilities and run through some examples. Note that product is in RC stage and behaviour in release may vary.

When

iCal
UTC : Thu, Aug 24 2017 09:00 - 10:00
Event Time : Thu, Aug 24 2017 17:00 - 18:00 (UTC+08:00) Perth
Your Local Time: Thu, Aug 24 2017 09:00 - 10:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

Adaptive Query Processing in SQL Server 2017

Speaker: Prabhu Mohapatra, Data Platform Consultant WARDY IT Solutions

Summary: A sneak preview of new query optimisation capabilities in SQL Server 2017. Query optimizer with Adaptive Query Processing can change the query plan if it identifies that the actual row counts are very different from the estimates or update memory grants based on changed requirements. In this session, we will understand these new capabilities and run through some examples. Note that product is in RC stage and behaviour in release may vary.

About Prabhu: Based in Brisbane, Prabhu Mohapatra is a Microsoft Certified Professional and Data Platform consultant at WARDY IT Solutions. Prabhu has been immersed in the SQL Server industry for the past 13 years, working for a number of notable organisations including Microsoft and JPMorgan Chase. As a Data Platform consultant, Prabhu has significant experience working with companies of all sizes across Australia to help them design, build and improve their Microsoft SQL Server environments. He’s passionate about data management systems, HADR, Azure SQL Database and Data Warehouse, SQL Server Always On and SQL Server performance optimisation. As a self-confessed SQL enthusiast, he’s excited for the SQL Server 2017 release.

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids