Training Class Recordings Are Available (12 Classes. Pre-Cons & Post-Cons)
Subscribe NowAt DPS 2021, Pre-Cons & Post-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.
Training Class Finer Details (See below)
Getting The Best Out Of SQL Managed Instance In 2021 by Microsoft
Getting The Best Out Of SQL Managed Instance In 2021
Pre-Con Title | Getting The Best Out Of SQL Managed Instance In 2021 |
Track(s) | Data Administration |
Tags | #SQLServer #Azure #IaaS #Migration #BestPractices |
Level | Intermediate |
Trainer/Speaker | Niko Neugebauer, Vitor Tomaz, Vitor Pombeiro, Nevena Nikolic |
Abstract | Learn about how to become succesfull by understanding and making the best out of the Azure SQL Managed Instance, Microsofts PaaS offering that is most compatible with SQL Server running either on-premises or on IaaS. Get the knowledge of how to connect, configure, tune, monitor & troubleshoot your Instances to get the very best out of them. |
Modules/Topics | NA |
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 |
Data Engineering Best Practices Using Azure Data Factory by Microsoft
Data Engineering Best Practices Using Azure Data Factory
Pre-Con Title | Data Engineering Best Practices Using Azure Data Factory |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #ADF #Azure #IaaS #BestPractices |
Level | Intermediate |
Trainer/Speaker | |
Abstract | In this workshop, we will cover data engineering best practices while using Azure Data Factory - Performance, Secuirty and Scalability being the key focus areas. We will build ETL pipelines as part of the workshop for hands-on leanring. |
Modules/Topics | 1. Data pipeline overview
2. Data Integration: Connectivity and code-free transformation
3. Best practices for operationalizing data pipelines
|
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 |
It's Time To Learn DAX
It's Time To Learn DAX
Pre-Con Title | It's Time To Learn DAX |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #PowerBI #AnalysisServices #DAX #DataModel |
Level | Advanced |
Trainer/Speaker | |
Abstract | If you want to show more than simply the data provided by the data source and implement calculations in Power BI or Analysis Services Tabular you have to learn to write Data Analysis Expression (DAX). This workshop starts at entry level and jump-starts you into the world of even complex calculations within 8h. In the first module Markus will introduce the basic syntax, functions and concepts (which are best of bread, taken from Excel, SQL and MDX). Then you will learn that you can exchange complexity in the data model with complexity in DAX (and the other way around) in real world examples. Beginners usually struggle to fully understand the differences between calculated columns and measures. That’s why we will dedicate two modules on them. In the last module Markus will pick your brain with complex challenges and advanced techniques, which you can then take as template to apply on your own use cases. |
Modules/Topics | 1. Syntax and Basic Functions |
Attendee Pre-requisite (if any) | 1. Experience with either Power BI Desktop or Analysis Services |
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 |
The Future Of Deployment For Modern Data Platform Applications
The Future Of Deployment For Modern Data Platform Applications
Pre-Con Title | The Future Of Deployment For Modern Data Platform Applications |
Track(s) | Architecture |
Tags | #Arc #bdc #kubernetes #hybrid #dba |
Level | Intermediate |
Trainer/Speaker | |
Abstract | First, we will cover the basics of Kubernetes: What is it, who can use it, what can it be used for, why is this different or better than old school deployments through virtual machines. We will then build a Kubernetes cluster and learn how to deploy applications into this cluster. Building on those Kubernetes deployment fundamentals, we will then deploy a SQL Server Big Data Cluster to showcase how we can deploy a complex stateful application in Kubernetes. We will close the day by working our way through the next gamechanger for Deployments: Azure Arc Data Services, a solution that allows us to deploy managed Azure Data Service to any hardware running Kubernetes (including any cloud vendor) on-premises or in the cloud. You will leave with the knowledge, scripts, and tools to get started with Kubernetes and Kubernetes based applications today! |
Modules/Topics | 1. Kubernetes Fundamentals |
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 |
Execution Plans In Depth
Execution Plans In Depth
Pre-Con Title | Execution Plans In Depth |
Track(s) | Development |
Tags | #ExecutionPlans, #QueryTuning, #Performance |
Level | Advanced |
Trainer/Speaker | |
Abstract | For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper. In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For most of the operators you’ll find in execution plans, we will look at the inner workings, and at properties that affect their behavior. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan. Aside from explaining most operators, we will also look at how these operators interact, which will help you understand which areas in complex execution plans can cause performance issues. If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you! |
Modules/Topics | 1. Common mistakes 2. Reading data 3. Combining data 4. Performance enhancements 5. Manipulating data 6. Ordering and grouping data 7. Parallelism 8. Changing data 9. Batch mode |
Attendee Pre-requisite (if any) | Some prior experience in the area of performance tuning and execution plans is expected. This implies a fair understanding of T-SQL. |
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 |
Azure Synapse Analytics – From Data Ingestion To Visualization
Azure Synapse Analytics – From Data Ingestion To Visualization
Pre-Con Title | Azure Synapse Analytics – From Data Ingestion To Visualization |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #AzureSynapse #Azure #Analytics #DataLake #DataFactory #Spark #SQL #BigData |
Level | Intermediate |
Trainer/Speaker | |
Abstract | The world of data is getting more and more distributed. On-premises sources, cloud services and IoT data needs to be merged, integrated and brought under a single umbrella for a comprehensive analysis. With Azure Synapse Analytics, Microsoft adds a player into the cloud analytics field to address and deal with diverse sources, varying structures of data and diverging analytic needs. Join this workshop to learn why Azure Synapse Analytics is needed to address current analytic needs. Get to know the different technologies that sum up into Azure Synapse. Learn best practices what to consider to execute successful Synapse projects. Create your own Synapse environment. Solve big data data tasks as well as traditional data warehousing question, and at the end of day have a feeling how Azure Synapse can help you in your future data platform/analytics projects. |
Modules/Topics | 1. Why is a new analytics player needed? 2. Data driven projects – Big data versus Data Warehousing 3. What is Azure Synapse Analytics? 4. Data Ingestion 5. Big Data Analytics 6. Solving Data Warehousing tasks 7. Management / Monitoring 8. Visualization / Data Models |
Attendee Pre-requisite (if any) | Basic Azure knowledge is required. |
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 |
PowerShell For The DBA – Let's Do It!
PowerShell For The DBA – Let's Do It!
Pre-Con Title | PowerShell For The DBA – Let's Do It! |
Track(s) | Data Administration |
Tags | #PowerShell #SQLServer |
Level | Intermediate |
Trainer/Speaker | |
Abstract | There are so many servers and so little time today. PowerShell for a DBA is a must in my book to enable you to get more done in less time and with much less clicking. Setup, configuration and management are at the heart of a DBAs work. PowerShell knowledge and know how are more important than ever. This class will give you the tools to get more done as well as enable you to advance in your work with techniques and keep you moving forward past the seemingly hard things of every day DBA work. I will show you how to get your environment set up and take you through remoting, parallel execution of tasks and all about the PowerShell modules that are out there to make your life great. Join me in the quest to become a PowerShell DBA. |
Modules/Topics | 1. Environment setup 2. PowerShell Module eco-system 3. DbaTools module 4. SqlServer module/05-ImportExcel module 6. SMO Primer 7. DBA work with PowerShell 8. Next Steps to maximize efficiency |
Attendee Pre-requisite (if any) | Understanding of DBA work, easy huh? |
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 |
Big Data & Analytics With SQL Server 2019 Big Data Cluster
Big Data & Analytics With SQL Server 2019 Big Data Cluster
Pre-Con Title | Big Data & Analytics With SQL Server 2019 Big Data Cluster |
Track(s) | Data Science (AI/ML) |
Tags | #bigdatacluster #bigdata #sqlserver #hadoop #spark #azure #analytics |
Level | Advanced |
Trainer/Speaker | |
Abstract | This training session covers big data, data virtualization and analytics in SQL Server 2019 Big Data cluster. SQL Server 2019 Big Data Cluster, (BDC for short), is the evolution of SQL Server, and its goals are to be able to integrate, manage and analyze data in the peta byte range. The session starts with an overview of what the BDC is, to get everyone on the same page. After the overview, we look at data virtualization; how we can use the BDC as a data hub. We then drill down and look at how storage pools, and data pools works BDC . From there we look at how we can ingest data into the BDC, and how to analyze the data using the built-in Apache Spark engine. Part of this also looks at using Apache Kafka and Apache Spark together to ingest data into the BDC. We also see how we can "mount" external HDFS and Azure Data Lake sources in the Big Data Cluster. |
Modules/Topics | 1. Overview of SQL Server 2019 Big Data Cluster 2. Data Virtualization in the BDC 3. Storage Pools & Data Pools 4. Apache Spark 5. Data Ingestion into the BDC 6. Analytics with Apache Spark |
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 |
Demystifying Design Principles And Building Impactful Reports In Power BI
Demystifying Design Principles And Building Impactful Reports In Power BI
Pre-Con Title | Demystifying Design Principles And Building Impactful Reports In Power BI |
Track(s) | Business Intelligence & Advanced Analytics |
Tags | #powerbi #visualizations #design #reporting #dataviz #aesthetics |
Level | Intermediate |
Trainer/Speaker | |
Abstract | This training is developed and delivered by Microsoft MVP Reid Havens, and covers many essential design principles (and how to apply them) to build impactful reports in Power BI Desktop. Students will learn about how to enhance report design by adding elements such as: drillthrough, bookmarks, report page tooltips, conditional formatting, custom visuals, and more. There is coverage on best practices and recommendations that build upon the functions and features available in Power BI Desktop, providing you with a strong design foundation upon which you can create your reports. This course benefits both those new to Power BI and report design and those already familiar with Power BI. If you have a basic working knowledge of Power BI, this training will help fill in any gaps in your knowledge so you have a more complete set of skills. Regardless of your experience in building visually attractive reports, this course will show you what a stunning Power BI report looks like. Reid will share the many things he does to make his reports stand out from the crowd. When you apply what you learn to your own reports, you and your users are going to love the results. |
Modules/Topics | 1. Creating Reports
2. Designing Advanced Reports
3. Report Design Principles
|
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 |
An End To End Migration And Modernization Journey Of Your Applications And Workloads To Azure by Microsoft
An End To End Migration And Modernization Journey Of Your Applications And Workloads To Azure
Pre-Con Title | An End To End Migration And Modernization Journey Of Your Applications And Workloads To Azure |
Track(s) | Data Administration |
Tags | #SQLServer #Azure #IaaS #Migration #BestPractices |
Level | Intermediate |
Trainer/Speaker | Ajay Jagannathan, Raj Pochiraju, Rajesh Setlem, Alexandra Ciortea, Mohamed Kabiruddin |
Abstract | In this workshop you learn, “The migration driving factors, different migration strategies, phases in the migration journey, live demos of leveraging Microsoft migration tools, discover, assess, understand the Azure readiness, target deployment option and size recommendations, monthly estimates migrating your applications and SQL Server databases to Azure. |
Modules/Topics |
|
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 |
SQL Server Performance Tuning – Fast Track
SQL Server Performance Tuning – Fast Track

Pre-Con Title | SQL Server Performance Tuning – Fast Track |
Track(s) | Data Administration |
Tags | #Performance #SQLServer #Tuning #Troubleshooting #Query Tuning |
Level | Intermediate |
Trainer/Speaker | |
Abstract | One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issue that is plaguing your SQL Server environment. Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have to fire-fight less during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases. Join this demo-filled, full-day class, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:
|
Modules/Topics | Module 1: SQL Server Wait Types & Statistics
Module 2: The Holy Trinity – CPU, Memory, IO
Module 3: Query Execution & Query Plan Analysis
Module 4: Query Tuning
Module 5: Index Tuning
Module 6: Dealing with Deadlocks
|
Attendee Pre-requisite (if any) | Pre-requisite: You need to have at least two years of genuine SQL Server experience to gain maximum from this pre-con. |
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 |
10 Rules A Database Developer Must Know
10 Rules A Database Developer Must Know
Pre-Con Title | 10 Rules A Database Developer Must Know |
Track(s) | Development |
Tags | #SQLServer #Development #Rules #Performance |
Level | Advanced |
Trainer/Speaker | |
Abstract | Are you already an experienced programmer and know your way around the Microsoft SQL Server development language? Still, there are always problems with query runtimes that you cannot explain to yourself. Data is not written to database tables fast enough and you are looking for ways to optimize ETL processes? These are all things that pose new challenges for a database developer daily. This workshop for database developers closes many of these gaps and uses practical examples to explain, analyze and solve the problems.
This workshop is suitable for database developers who are already beyond the basics and want to sharpen the nuances. Ideally, you already have experience with execution plans and are very familiar with the SQL Server Management Studio. This workshop is most hands on with prepared labs for the participants. All demos and hands on will be handled wit a BIG database (17 GB) and not with only a few records. |
Modules/Topics |
|
Attendee Pre-requisite (if any) | The Instructor/Trainer has not specified any pre-requisites. |
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 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 pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience. |
More Questions? | Visit FAQ page. |
BooK Now |