Training Class Recordings (Pre-Cons)

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

Subscribe Now

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/Topics1. 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

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

  1. Common challenges in Power BI solutions
  2. Common challenges in Azure Synapse Analytics solutions
  3. Azure Synapse Analytics Lakehouse architecture
  4. Azure Synapse Analytics loading and storage patterns
  5. Power BI Premium
  6. Power BI aggregations
  7. Power BI DirectQuery and query folding
  8. Power BI Hybrid Tables
  9. Power BI Incremental Refresh Policies
  10. End-to-end solution architecture
  11. End-to-end solution orchestration options
  12. Azure Synapse Analytics monitoring and scaling
  13. 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

1. Analyzing Execution Plans
2. Search Arguments
3. Data Type Issues
4. Indexes Best Practices
5. Temporary Tables vs. Table Variables
6. (Not) Using Cursors
7. Scalar Functions and Inlining
8. Working with Parameters and Variables
9. Skewed Data Distribution
10. Window Functions
11. LOB Data
12. Row Identifiers
13. Manipulating Statistics
14. Query Hints and Plan Guides
15. Intelligent Query Processing
16. 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

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


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

  1. “Modelling 101”: Tables, Primary Keys, Foreign Keys, Normal forms, Dimensional modelling, Kimball, Inmon, Data Vault
  2. “Modelling Options in Power BI”: Relationships, Cardinality, Cross-filter direction, Data Preparation with DAX , Data Preparation with Power Query
  3. “Special Dimensions”: Time & Date, Role-playing dimensions, Hierarchies
  4. “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

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

  1. Descriptive Statistics
  2. Associations between Pairs of Variables
  3. Data Preparation
  4. Data Quality
  5. Time-Oriented Data
  6. Time-Oriented Analyses
  7. Data Mining
  8. 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

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

  1. Getting to know Apache Spark, Installation and setting up the environment
  2. Creating Datasets, organising raw data and working with structured APIs
  3. Designing and building pipelines, moving data and building data models with Spark
  4. Data and process orchestration, deployment and Spark Applications
  5. Data Streaming with
  6. 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

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!

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

  1. Introduction
  2. Data Modeling best practices
  3. Data Model Size
  4. Data Refresh Process
  5. Aggregations
  6. DAX Calculations
  7. Visualization rendering time
  8. Storage Mode choice
  9. 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/Topics1. 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
  1. ADF/ Synapse Pipelines Overview
  2. 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)
  3. Copy: High-perf data integration (Extract-load)
  4. Data flows: Code-free transformation (Extract-transform-load)
    • Data quality, data masking, SCD type2
    • Data mapper and lake databases
  5. Change Data Capture-based incremental extractions from various sources
  6. Scripts, Spark notebook, and Stored Procedure: Code-based transformation (Transform)
  7. Continuous Integration and delivery
  8. Real-world case studies
  9. 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
  1. Introduction to Query Store
  2. Configuring Query Store
  3. Query Store in Action
  4. Forcing Plans
  5. Automatic Tuning
  6. 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