Training Class Recordings (Pre-Cons)

Training Class Recordings Are Available (12 Classes. Pre-Cons)

At DPS 2022, Pre-Cons were delivered (collectively called Training Classes). These were 8 hours, focused, deep-dive, demo-based virtual classroom training. Each Training Class was designed to offer intermediate & advanced-level training on a specific topic/subject. These classes offered more knowledge, skills and expertise beyond the summit content.

Recordings are now available. If you missed registering for the LIVE class, no worries, Subscribe Now to the recordings & get 12 Months On-Demand access.

ETL/ELT In The Cloud Using Data Factory

Pre-Con Title	ETL/ELT In The Cloud Using Data Factory
Track(s)	Data Administration
Tags	#DataFactory #Azure #Cloud #ETL #DataWarehouse
Level	Intermediate
Trainer/Speaker	Dennes Torres
Abstract	Data Factory is a powerful member of the Azure data platform. We can build powerful ETL solutions with no code and migrate existing on-premise SSIS solutions to the cloud. Come to this full-day session to discover how it works and what you can build. This demo-packed preconference will show many different examples and scenarios illustrating common ETL/ELT challenges in an enterprise data platform.
Modules/Topics	1. Data Factory - Basic Concepts Pipelines Tasks used during pipelines 2.The Flexibility of the Copy Data Activity 3. Download from the web using the Web Activity Parameterization Using KeyVault for authentication Using Managed Identity to access KeyVault (and other services) 4. Datasets 5. Managing Source and Destination Datasets 6. Azure SQL Datasets 7. Azure Storage Datasets 8. Using Schema Drift 9. Creating the destination Schema 10. Dataflows Transformations in the dataflow Using Data Sources and Destinations in the dataflow Using dataflows in pipelines 11. PowerQuery Transforming Data with Power Query Using PowerQuery in the pipeline 12. Data Factory Examples ETL to a Data Warehouse 13. Incremental Loading Data 14. Loading data into Slowly Changing Dimensions Ingesting to a Data Lake Integrating with Cognitive Services 15. Managing the Development Using Git integration Managing Branches 16. Managing Execution Managing pipelines execution Monitoring pipelines execution Using Integration runtimes 17. SSIS Migrating SSIS Packages to the cloud Using SSIS Integration Runtime
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	No special instructions/comments from the Speaker
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
BooK Now	Book Now

Analytics At Scale With Power BI And Azure Synapse Analytics

Analytics at scale with Power BI and Azure Synapse Analytics

Pre-Con Title	Analytics At Scale With Power BI And Azure Synapse Analytics
Track(s)	Business Intelligence & Advanced Analytics
Tags	#PowerBI #AzureSynapseAnalytics
Level	Advanced
Trainer/Speaker	Dave Ruijter
Abstract	This training day we will learn how Power BI and Azure Synapse Analytics can form a solid marriage, and provide a truly scalable analytical platform. Together we will explore the tricky parts of an enterprise-grade Power BI solution, and how advanced modelling capabilities of Power BI with a solid data lakehouse / warehouse in Azure Synapse Analytics can save the day! For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabilities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons. The advanced capabilities of both worlds can really complement each other. We will train you how to design and build a solution, share our learnings and best-practices along the way in a demo-rich day. After the training you will be able to: Better design and implement complex data models, including hybrid tables, aggregations, and combined storage modes (import, DirectQuery, dual). Orchestrate the end-to-end data processing, with a pipeline chain from data ingest in the data lakehouse to the incremental Power BI dataset refresh. Use different techniques to identify performance bottlenecks in your solutions and how to solve those ("does it fold"?). Implement a cost-efficient solution, that still meets the scalability demands. You will be guided by Dave Ruijter, bringing a wealth of practical experience to the table across the entire stack of Power BI and Azure Synapse Analytics.
Modules/Topics	Common challenges in Power BI solutions Common challenges in Azure Synapse Analytics solutions Azure Synapse Analytics Lakehouse architecture Azure Synapse Analytics loading and storage patterns Power BI Premium Power BI aggregations Power BI DirectQuery and query folding Power BI Hybrid Tables Power BI Incremental Refresh Policies End-to-end solution architecture End-to-end solution orchestration options Azure Synapse Analytics monitoring and scaling Power BI monitoring and scaling
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	NA
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

The Performance Tuning Magic Show

Pre-Con Title	The Performance Tuning Magic Show
Track(s)	Development
Tags	#SQLServer #AzureSQL #Performance #Tuning
Level	Intermediate
Trainer/Speaker	Guy Glantser
Abstract	Welcome to the great Performance Tuning Magic Show! Come to the show and watch real magic in action. We will analyze common use cases of poorly performing queries and apply magic tricks to make them run really fast. But unlike traditional magic shows, we will learn how these magic tricks actually work. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. Some examples of magic tricks we will cover: proper handling of parameter sniffing, scalar UDF inlining and T-SQL tricks. By the end of the show, you will walk away with a list of actionable performance tuning techniques, including how to identify candidate queries for each magic trick. Enjoy an interactive and entertaining magic show (and yes, I will pull a rabbit out of my hat).
Modules/Topics	Analyzing Execution Plans Search Arguments Data Type Issues Indexes Best Practices Temporary Tables vs. Table Variables (Not) Using Cursors Scalar Functions and Inlining Working with Parameters and Variables Skewed Data Distribution Window Functions LOB Data Row Identifiers Manipulating Statistics Query Hints and Plan Guides Intelligent Query Processing And More, As Time Permits…
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	No special instructions/comments from the Speaker
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
BooK Now	Book Now

Data Modelling In Power BI – From Zero To Hero

Data Modelling in Power BI – From Zero to Hero

Pre-Con Title	Data Modelling In Power BI – From Zero To Hero
Track(s)	Business Intelligence & Advanced Analytics
Tags	#DataModelling, #DimensionalModelling #DAX #PowerQuery #RealWorldExamples
Level	Advanced
Trainer/Speaker	Markus Ehrenmüeller-Jensen
Abstract	You have collected your first experiences with Power BI and wondering why the performance of your reports is slow (even when working with a relatively small amount of source rows)? Maybe you are suffering from complicated DAX formulas (which can have their cause in non-optimal modelling)? Or you are just curious about what’s the secret behind the model view? In any case, this full-day workshop got you covered! We will start with the very basic foundation and we will work step-by-step from concepts and practical examples to real world problems and how to solve them.
Modules/Topics	“Modelling 101”: Tables, Primary Keys, Foreign Keys, Normal forms, Dimensional modelling, Kimball, Inmon, Data Vault “Modelling Options in Power BI”: Relationships, Cardinality, Cross-filter direction, Data Preparation with DAX , Data Preparation with Power Query “Special Dimensions”: Time & Date, Role-playing dimensions, Hierarchies “Real world examples “: Budgeting, Localized data models, Composite models
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	Keep up the good community work you are doing with your events!
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

Advanced Analytics With Transact-SQL

Advanced Analytics with Transact-SQL

Pre-Con Title	Advanced Analytics With Transact-SQL
Track(s)	Business Intelligence & Advanced Analytics
Tags	#TSQL #datascience #advancedanalytics #dataoverview #datapreparation
Level	Expert
Trainer/Speaker	Dejan Sarka
Abstract	If you want to learn how to get information from your data with Transact-SQL, or shortly T-SQL language, then this course is the course for you. It will teach you how to calculate statistical measures from descriptive statistics including centers, spreads, skewness and kurtosis of a distribution, find the associations between pairs of variables, including calculating the linear regression formula, calculate the confidence level with definite integration, find the amount of information in your variables, and do also some machine learning or data science analysis, including predictive modeling and text mining. T-SQL language in latest editions of SQL Server, Azure SQL Database, and Azure Synapse Analytics, has so many business intelligence (BI) improvements that it might become your primary analytic database system. Many database developers and administrators are already proficient with T-SQL. Occasionally they need to analyze the data with statistical or data science methods, but they do not want to or have time to learn a completely new language for these tasks. In addition, they need to analyze huge amounts of data, where specialized languages like R and Python might not be fast enough. SQL Server has been optimized for work with big datasets for decades. In order to get the maximum out of these language constructs, you need to learn how to properly use them. This in-depth course shows extremely efficient statistical queries that use the window functions and are optimized through algorithms that use mathematical knowledge and creativity. The formulas and usage of those statistical procedures are explained as well. Any serious analysis starts with data preparation. The course introduces some common data preparation tasks and shows how to implement them in T-SQL. No analysis is good without good data quality. The course introduces data quality issues, and shows how you can check for completeness and accuracy with T-SQL, and how to measure improvements of data quality over time. And since the talk is already about the time, the course shows how you can optimize queries with temporal data, for example when you search for overlapping intervals. More advanced time-oriented information includes hazard and survival analysis. Then the course switches to the currently most fashionable topic, the data science. Some of quite advanced algorithms can also be implemented in T-SQL. The reader learns about the market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the course shows how to develop predictive models with a mixture of k-nearest neighbor and decision trees algorithms and with Bayesian inference analysis. Analyzing text, or text mining, is another modern topic. However, many people do not realize that you can do really a lot of text mining also in pure T-SQL. SQL Server can also become a text mining engine. The course shows how to analyze text in multiple natural languages with pure T-SQL, using also features from the full-text search (FTS).
Modules/Topics	Descriptive Statistics Associations between Pairs of Variables Data Preparation Data Quality Time-Oriented Data Time-Oriented Analyses Data Mining Text Mining
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	NA
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

Spark For Data Engineers

Spark for Data engineers

Pre-Con Title	Spark For Data Engineers
Track(s)	Business Intelligence & Advanced Analytics
Tags	#spark #data #engineering #azure
Level	Intermediate
Trainer/Speaker	Tomaž Kaštrun
Abstract	Data Analysts, data Scientist, Business Intelligence analysts and many other roles require data on demand. Fighting with data silos, many scatter databases, Excel files, CSV files, JSON files, APIs and potentially different flavours of cloud storage may be tedious, nerve-wracking and time-consuming. Automated process that would follow set of steps, procedures and processes take subsets of data, columns from database, binary files and merged them together to serve business needs and potentials is and still will be a favorite job for many organizations and teams. Apache Spark™ is designed to to build faster and more reliable data pipelines, cover low level and structured API and brings tools and packages for Streaming data, Machine Learning, data engineering and building pipelines and extending the Spark ecosystem. Spark is an absolute winner for this tasks and a great choice for adoption. Data Engineering should have the extent and capability to do: - System architecture - Programming - Database design and configuration - Interface and sensor configuration And in addition to that, it is as important as familiarity with the technical tools is, the concepts of data architecture and pipeline design are even more important. The tools are worthless without a solid conceptual understanding of: - Data models - Relational and non-relational database design - Information flow - Query execution and optimisation - Comparative analysis of data stores - Logical operations Apache Spark have all the technology built-in to cover these topics and has the capacity for achieving a concrete goal for assembling together functional systems to do the goal.
Modules/Topics	Getting to know Apache Spark, Installation and setting up the environment Creating Datasets, organising raw data and working with structured APIs Designing and building pipelines, moving data and building data models with Spark Data and process orchestration, deployment and Spark Applications Data Streaming with Ecosystem, tooling and community
Attendee Pre-requisite (if any)	Data engineering tasks: analyzing and organizing raw data (with T-SQL or Python or R or Scala) buidling data transformations and pipelines (with T-SQL or Python or R or Scala) Technical prerequisite: working laptop with ability to install Apache Spark and other tools Access to internet Credentials and credit (free credit) for accessing Azure portal
Target Audience	Data engineer, BI Engineer, Cloud data engineer
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	NA
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

SQL Server Performance Tuning And Troubleshooting

SQL Server Performance Tuning and Troubleshooting

Pre-Con Title	SQL Server Performance Tuning And Troubleshooting
Track(s)	Data Administration
Tags	#SQLServer #PerformanceTuning #Internals #QueryProcessor #StorageEngine #SQLOS #PerfromanceCounters #ExtendedEvents #DMVs #QueryStore #QueryPlan #QueryTuning
Level	Advanced
Trainer/Speaker	Denis Reznik
Abstract	Nothing is perfect, which means that your database maybe not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning. In this workshop, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. In this way, we will learn performance tuning practical techniques and solve a bunch of issues in real time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.
Modules/Topics	1. SQL Server Internals SQL Server Architecture SQL Server Network Interface Query Processing Query plan and query plan cache Query Optimizer Indexes and Statistics Physical Joins Parallel Query Plan Storage Engine Transaction Log and Database Recovery Model Locks Transaction isolation levels Deadlocks SQLOS System resources SQLOS and system resources usage Query execution and resources consumption Typical wait types 2. Searching for Performance Issue Root Cause Finding Global Performance Issues with Performance Monitor Finding Queries that cause performance Issues with Common Tools Extended Events Dynamic Management Views Query Store 3. Optimizing Query Query Execution Time Optimization Algorithm First-Level Root Cause(s) Second-Level Root Cause(s) Query Optimization and Query Plan Analysis
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	NA
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

Cracking Power BI Performance Tuning In A Day!

Cracking Power BI Performance Tuning in a day!

Pre-Con Title	Cracking Power BI Performance Tuning In A Day!
Track(s)	Business Intelligence & Advanced Analytics
Tags	#PowerBI #DAX #Performance #PowerQuery #Aggregations
Level	Advanced
Trainer/Speaker	Nikola Ilic
Abstract	Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more... And, if you feel lost, I don't blame you - I've also been there! That's why this workshop is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.
Modules/Topics	Introduction Data Modeling best practices Data Model Size Data Refresh Process Aggregations DAX Calculations Visualization rendering time Storage Mode choice Summary
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	NA
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now

PowerShell DBA Dream DBATools Workshop

Pre-Con Title	PowerShell DBA Dream DBATools Workshop
Track(s)	Data Administration
Tags	#PowerShell #DBA
Level	Basic
Trainer/Speaker	Ben Miller
Abstract	This full day class will take you through the most essential DBATOOLS module commands and teach you all you need to know to hit the ground running. We will go over the dbatools ecosystem and the common concepts that will help you get the most out of this module. There are over 650 commands, so we won't be going over all of them, but I will take you through the mainstream, daily use commands in the Get, Set, Test, Backup, Restore and others in the verbs in this module. Not only that but we will cover how to prepare your profile and environment to have ready variables that will assist you in quick commandline operation as well as automated running of commands. Join me in the quest for becoming a PowerShell DBA.
Modules/Topics	1. DBATools Ecosystem 2. Anatomy of a command in DBATools 3. Seeing DBATools in Action
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	No special instructions/comments from the Speaker
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
BooK Now	Book Now

Data Integration Best Practices In Azure Synapse Analytics

Pre-Con Title	Data Integration Best Practices In Azure Synapse Analytics
Track(s)	NA
Tags	#Synapse
Level	Basic
Trainer/Speaker	Abhishek Narain
Abstract	Azure Synapse contains the same Data Integration engine and experiences as Azure Data Factory, allowing you to create rich at-scale ETL pipelines without leaving Azure Synapse Analytics. Ingest data from 100+ data sources Code-Free ETL with Data flow activities Orchestrate notebooks, Spark jobs, stored procedures, SQL scripts, and more (ELT) This training will cover the best practices when using Synapse pipelines and is targeted at a data engineer who is new to Azure/ Azure Synapse Analytics.
Modules/Topics	ADF/ Synapse Pipelines Overview Best practices Metadata encryption (Microsoft, Customer-Managed Keys) Source Control Secure Authentication – Managed identity (MSI) and AKV integration Access control/ RBAC in Synapse Managed Virtual Network-enabled workspace Monitoring and alerting (Observability) Copy: High-perf data integration (Extract-load) Data flows: Code-free transformation (Extract-transform-load) Data quality, data masking, SCD type2 Data mapper and lake databases Change Data Capture-based incremental extractions from various sources Scripts, Spark notebook, and Stored Procedure: Code-based transformation (Transform) Continuous Integration and delivery Real-world case studies Challenge, Q&A
Attendee Pre-requisite (if any)	Basic data engineering skills required (ETL, ELT, Data extraction techniques) You would require an Azure subscription for the workshop or set up a free Azure trial before the workshop (link - https://azure.microsoft.com/en-us/free/)
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	No special instructions/comments from the Speaker
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
BooK Now	Book Now

Query Store Deep Dive

Pre-Con Title	Query Store Deep Dive
Track(s)	Data Administration
Tags	#QueryStore
Level	Intermediate
Trainer/Speaker	Milos Radivojevic
Abstract	In this full-day workshop, you will learn to leverage Query Store to quickly identify and solve query performance issues. You’ll see and learn from many real-world examples, the author experienced in the last three years in the complex SQL Server production environment with heavy workloads. You’ll get tips for proper Query Store configuration and recommendations to reduce its impact on the production system. Plan forcing is a very powerful feature, but a bit controversial. This workshop will demystify it; you’ll see what Query Store exactly does when an execution plan is forced when it is respected, when and why isn’t, and the most important – when you have to force a plan in the production system, and when force can bring additional troubles. The next topic that will be covered in detail is automatic tuning. You will understand the benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk. Finally, you’ll learn how to mitigate Query Store limitations and common issues. This workshop is a great opportunity to learn about Query Store or expand your knowledge and implement it successfully in your production system.
Modules/Topics	Introduction to Query Store Configuring Query Store Query Store in Action Forcing Plans Automatic Tuning Issues and Limitations
Attendee Pre-requisite (if any)	NA
Is this class being recorded?	Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.
Additional Comments from Instructor/Speaker	No special instructions/comments from the Speaker
Additional Comments from the Organizers	The current pricing is always the lowest. If you like the content, Book Now and save. Training Classes are instructor-led, demo-based, 8 hours (4 hrs each day). Due to virtual mode delivery, training classes are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the training class material (PDFs, demos, scripts, etc, as shared by the instructor) to practice at their convenience.
More Questions?	Visit FAQ page.
Book Now	Book Now