After a series of blockbuster webinars in November with Bob Ward , Jonathan Kehayias and Matt Gordon, here are more webinars for December and January. This time with Pedro Lopes (Senior Program Manager, Microsoft) who has over 16 years of Industry experience in SQL Server, Sandy Winarko (Principal Program Manager, Microsoft, China) with more than 20 years of experience in Azure, SQL Server and AI and Joe Sack (Principal Program Manager, Microsoft, USA) with more than 20 years of experience in SQL Server. This will be another great series. More details are given below. It’s all free, go ahead and register. Everyone is invited!
Gems To Help You Troubleshoot Query Performance by Pedro Lopes
Date: 12th December (Wednesday) Time: 9 PM – 10: 30 PM IST (10:30 AM – 12:00 PM EST)
In this demo driven session, come learn about enhancements the engineering team has added to SQL Server, that can help you troubleshoot query performance: from show plan improvements to improved DMVs, learn how these can help you streamline the process of troubleshooting query performance, while looking at common scenarios that apply across SQL Server versions and different types of query performance regressions, such as Cardinality Estimation gotchas.
Date: 18th December (Tuesday) Time: 3 PM – 04: 30 PM IST (4:30 AM – 6:00 AM EST)
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting & shifting SSIS packages – and extend it with custom/3rd party components. Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice data transformations in your ETL/ELT workflows, automatically provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.
Intelligent Query Processing in SQL Server 2019 by Joe Sacks
Date: 10th January (Thursday) Time: 9 PM – 10: 30 PM IST (10:30 AM – 12:00 PM EST)
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.
All webinars are absolutely free for you to attend. Registration is mandatory.