Free

PSSUG: Adaptive Query Processing in SQL Server 2017

Event Information

Share this event

Date and Time

Location

Location

Microsoft

100 St Georges Terrace

Level 3

Perth, WA 6000

Australia

View Map

Friends Who Are Going
Event description

Description

About the session

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 the speaker

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.


About the Perth SQL Server User Group

We are a PASS Local Group run by Jenny Richardson and Cody Konior. We meet once a month to enjoy technical presentations about SQL Server over complimentary pizza and refreshments. Whether it's your first time attending, or you just haven't been in a while, come join us!

Share with friends

Date and Time

Location

Microsoft

100 St Georges Terrace

Level 3

Perth, WA 6000

Australia

View Map

Save This Event

Event Saved