Intelligent Query Processing in SQL Server 2019 by Joe Sack

Learn about the largest online learning event on Azure Data, Analytics & AI covering 30+ technologies including SQL Server, Power BI, MS AI stack, Azure Data stack & Advanced Analytics stack: https://www.DataPlatformVirtualSummit.com

Follow us on Twitter
https://www.twitter.com/TheDataGeeks
https://www.twitter.com/SQLServerGeeks
https://www.twitter.com/DataAISummit
https://www.twitter.com/SQLMaestros
https://www.twitter.com/A_Bansal
.
.
(Get new content delivered in your inbox: http://bit.ly/SSGRSS)

Please note that this a recorded webinar. It was recorded during live presentation.

Microsoft is introducing the next wave of intelligent query processing improvements that will enhance the performance of workloads that have historically been difficult to tune through classic methodologies. In this session we will cover five new improvements, including row mode memory grant feedback, table variable deferred compilation, batch mode on rowstore, scalar UDF inlining, and approximate query processing. We’ll cover how you can determine if your workloads will benefit from these improvements and discuss how these features fit into your existing Azure SQL Database and SQL Server performance tuning and troubleshooting strategy.

Webinar resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources)

As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources.
Suggest us topics that you wish to learn through our webinars: http://www.dataplatformgeeks.com/dpg-suggest-topics/
Connect with DataPlatformGeeks: http://www.dataplatformgeeks.com/
http://www.twitter.com/SQLServerGeeks
https://www.facebook.com/SQLServerGeeks
Email us: [email protected]

Have technical questions? Join the largest SQL/Data group on FaceBook – https://www.facebook.com/groups/thesqlgeeks/
LinkedIn Group: https://www.linkedin.com/groups/6753546

DataPlatformGeeks (DPG) Community
Join the fastest growing community of data & analytics professionals

Why Join DPG? http://www.dataplatformgeeks.com/

-Attend all events hosted by DPG, including SQLMaestros Special Events
-Get access to free videos, labs, magazines and host of learning resources
-Download all events & conference material
-Learn new skills. Sharpen existing skills
-Be part of Asia’s Largest Data/Analytics Community
-Opportunity to be a regional mentor & speaker at our events
-Immense technical & professional development
-http://www.dataplatformgeeks.com/

Data Platform Summit 2019 Pre-Registration is now Open
DPS 2019 will be officially launched in January 2019. However, you can pre-register yourself right now. This will indicate that you are interested in DPS 2019 and it will entitle you to the pre-launch discount code which will give you the lowest pricing for DPS 2019. The pre-launch code will only be shared with pre-registered individuals. Pre-registration does not cost you anything. Click Here to learn more. https://www.dataplatformgeeks.com/dps2019
Check out Data Platform Summit 2018 success https://www.dataplatformgeeks.com/dps2018/

A word from our sponsors

SQLMaestros Master Classes
Wish to Attend Full-Day, Deep-Dive Training? SQLMaestros Master Classes are announced. Classes on SQL Server, SSRS, Power BI, SSIS, DevOps, Machine Learning, R, Python & Artificial Intelligence. http://www.sqlmaestros.com/

SQLMaestros Video Courses
Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/

SQLMaestros Hands-On-Labs
Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere.
http://hols.SQLMaestros.com
Email [email protected]

SQLMaestros Learning Kits
The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/

SQL Server Health Check
If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/

Connect with the founder of DataPlatformGeeks/SQLServerGeeks
Follow on Twitter: https://twitter.com/A_Bansal
Follow on FaceBook at http://www.facebook.com/amit.r.bansal
Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010
Facebook Page: https://www.facebook.com/AmitRSBansal