| Session Title | Abstract | Recording |
|---|---|---|
| Delete Vs Truncate - Myths & Misconceptions by Satya Ramesh | DELETE and TRUNCATE are two commands that helps in data deletion. Even though these commands are considered to be most basic ones, still there are lot of misconceptions around them, especially TRUNCATE. TRUNCATE cant be logged, TRUNCATE cant be rolled back etc. In this session, we will try to debunk all the myths and misconceptions. | Watch Now |
| Intelligent Query Processing in SQL Server 2019 by Joe Sack | 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. Well 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. | Watch Now |
| Gems To Help You Troubleshoot Query Performance by Pedro Lopes | 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. | Watch Now |
| Never Say Hacking SQL Server Again by André Melancia | Version 2 of Hacking SQL Server with new content, applicable to DBA and DEV | Watch Now |
| Deadlocking for Mere Mortals by Jonathan Kehayias | While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBAs in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events. | Watch Now |
| SQL Server 2017 Community Driven Enhancements by Javier Villegas | With SQL Server 2017, Microsoft incorporates new features proposed by the Data Platform community, we will talk about them as well as the outstanding enhancements of the current mayor version of SQL Server. We will see in action the new features Resumable Online index rebuild and Automatic Query Tuning. | Watch Now |
| SQLOpsStudio Vs SSMS There can be only one by Warwick Rudd | SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS? In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do. | Watch Now |
| Indexing in Azure Data Warehouse by Mukund Bhashkar | - | Watch Now |
| Data Virtualization in SQL Server 2019 Big Data Cluster by Niels Berglund | - | Watch Now |
| Graph Data Processing with SQL Server, the Relationship db by Shreya Verma | Graphs are ubiquitous. From social networks, transportation networks, fraud detection to making recommendations or predicting the likelihood to purchase. But, do you need an exclusive graph database to solve your graph problems? In this session we will look at how SQL Graph introduced with SQL Server 2017 and Azure SQL Database can help you generate insights from your highly connected data. | Watch Now |
| SQL Server 2016 Always On Availability Groups by Matt Gordon | Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. Well kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well. | Watch Now |
| From SQL to R Leverage Your T SQL Knowledge to Learn R by Markus Ehrenmueller | You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning & data visualization. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server. | Watch Now |
| Intro Into Index Analysis by Dmitri Korotkevitch | Indexing in SQL Server is both art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes. In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring. | Watch Now |
| Understanding Dynamic SQL - The Right Way by Satya Ramesh | In this session, you will be able to understand when and where to use Dynamic SQL and associated Pros and Cons. | Watch Now |
| SQL Server 2017 Adaptive Query Processing and Automatic Query Tuning by Javier Villegas | We will walk though features like Query Store, Automatic Query Tuning and Adaptive Query Processing. With all these features SQL Server will be able to get better execution plans resulting in better performance | Watch Now |
| Recompilations, Excessive CPU Load and Plan Caching by Dmitri Korotkevitch | SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems. In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries. | Watch Now |
| How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal | You always wanted to troubleshoot a slow running query. But you just dont know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session. | Watch Now |
| Migrate your SQL Server workload to Azure SQL DB by Parikshit Savjani | Azure SQL Database is a fully managed cloud database service with built-in intelligence, elastic scale, performance, reliability, and data protection that enables enterprises and ISVs to reduce their total cost of ownership and operational cost and overheads. In this session, I will share real-world experience of successfully migrated existing SaaS application and on-premises workload for some our tier 1 customers and ISV partners to Azure SQL Database service. The session walks through planning, assessment, migration tools and best practices from the proven experiences and practices of migrating real world applications to Azure SQL Database service. | Watch Now |
| Get Started with Azure Cosmos DB by Pankaj Khattar | - | Watch Now |
| PowerShell for the SQL DBA by Ben Miller | Do you manage more than one instance of SQL Server? More than one database? When clicking through any interface as a DBA it can get pretty time consuming and very frustrating. I am here to help you get started with PowerShell as a DBA so that you can get information quicker and more efficiently than clicking. I will show you some commands and best of all how to leverage commands that you do not have to write but still get the benefit of getting more done. Join me in the Quest to become a PowerShell DBA. | Watch Now |
| When Things go Wrong - Error Handling in SQL Server by Erland Sommarskog | Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straight¬forward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you dont. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling fancy, although it may seem to be a good idea in theory. The session also covers a few things to think of on client level. | Watch Now |
| Understanding SQL Server Indexes - The Right Way by Satya Ramesh | - | Watch Now |
| Plan Caching & Recompilation in SQL Server by Amit Bansal | - | Watch Now |
| Where Should My Data Live (and Why)? by Matt Gordon | Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is the cloud a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy. | Watch Now |
| Azure ARM & Azure PowerShell for SQL Server Automation by Avanish Panchal | Microsoft Azure cloud adoption is on accelerating fast. Azure Automation plays a key role in building a sustainable and repeatable framework for creating and managing SQL Server in Azure. Automation is very much in demand compared to monolithic deployment models to maximize the ROI (return on investment). Session is suitable for Cloud DBA, support engineers & IT Strategists. | Watch Now |
| Concurrency Problems in SQL Server by Satya Ramesh | In this session, we are going to discuss about various concurrency problems that are identified in SQL Server like, Dirty Reads, Non-Repeatable Reads, Phantom Reads etc., We will also discuss about Optimistic Concurrency & Pessimistic Concurrency models and how SQL Server uses locking behind the scenes to maintain data consistency. | Watch Now |
| Introduction to DBA Tools by Rob Sewell | Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools. Afraid of PowerShell? Worried its too complicated? Dont want to go through the learning curve? Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session | Watch Now |
| Machine Learning Services in SQL Server by Don Rohan Castelino | SQL Server 2016 introduced a new capability called SQL Server R Services. SQL Server 2017 expands this feature to include Python and what we now call SQL Server Machine Learning Services. We will explore and understand exactly how SQL Server Machine Learning Services works behind the scenes so you know how to install it, manage it, optimize it, and use this in real prediction analytic workloads. | Watch Now |
| SQL Server Indexes - Basics by Satya Ramesh | In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes. 1. How to create them and some best practices to follow. 2. What is a covering index and how is it useful. 3. What is fragmentation and how to defrag indexes 4. What is fill factor and how is is useful. This is going to be a level 100 session targeted towards Developers & DBAs beginning their careers with SQL Server. | Watch Now |
| Azure Data Studio and SQL Server 2019 Big Data Cluster by Niels Berglund | Azure Data Studio, (ADS), is a cross platform, (Windows, Mac, Linux), data tool for Microsofts on-prem and cloud data platforms. In this webinar we do a brief overview of ADS, followed by a deep-dive into how you can use ADS for deploying and and managing a SQL Server Big Data Cluster. | Watch Now |
| Understanding Views In SQL Server by Satya Ramesh | - | Watch Now |
| SQL Server Memory Part 1 by Amit Bansal | Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. Its dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured. | Watch Now |
| SQL Server Indexing Basics by Satya Ramesh | In this session, we are going to cover the basics of Clustered Indexes & Non-Clustered Indexes. 1. How to create them and some best practices to follow. 2. What is a covering index and how is it useful. 3. What is fragmentation and how to defrag indexes 4. What is fill factor and how is is useful. This is going to be a level 100 session targeted towards Developers & DBAs beginning their careers with SQL Server. | Watch Now |
| SQL Server is shaking hand with Linux by Avanish Panchal | Session talks about how SQL Server architecture chipped with Linux and how it looks in real to enterprise world.Demo of SQL Server placed with Linux | Watch Now |
| Azure SQL Managed Instance by Jody Roberts | In this session we will take a look at what all the fuss is about as well as Architecture of AMI(Azure managed Instance) Cost of AMI vs on-prem Different options to migrate to AMI Benefits of AMI Differences Between AMI and SQL Server on-prem. | Watch Now |
| SQL Server 2019 - The Unified Data Platform by Bob Ward | Come learn the new capabilities for SQL Server 2019 that have rocked the industry including Apache Spark and HDFS in the box, enhanced Polybase connectors to help avoid ETL, Intelligent Query Processing, Security with Enclaves, T-SQL with Java, and enhancements for SQL Server on Linux, Docker Containers, and Kubernetes. SQL Server is the new unified data platform allowing you to keep your data where it is located, build your own data lakes, and enable new container based solutions never before possible. | Watch Now |
| Adaptive Query Processing in SQL Server 2017 by Nagaraj Venkatesan | Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence query optimizers plan choices. The following session will provide an overview of the features and explain how it can help to address performance issues like parameter sniffing, plan regressions, lack of indexes or too many indexes without any manual intervention and change of code. | Watch Now |
| Azure SQL Database Unleashed Managed Instance, Hyperscale, and More Horsepower! by Matt Gordon | In the not too distant past Azure SQL Database was known to many as just cloud-based SQL Server without the full features needed to encourage a move to it from on-premises SQL Server. Times have changed! Azure SQL Database, with the addition of deployment models like Managed Instance and storage technologies like Hyperscale, has matured into a formidable competitor in the PaaS database space. Join me as I walk you through how these technologies work behind the scenes, what options that gives you as you and your company consider migration, and how the Azure SQL Database family has given companies a powerful platform to store and use their data without much of the management overhead and hassle. | Watch Now |
| Understanding SQL Server Joins The Right Way by Satya Ramesh | - | Watch Now |
| DevOps and the Data Professional by Hamish Watson | You may have heard the word DevOps and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps Continuous Integration & Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team. It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilize Continuous Delivery.Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline. | Watch Now |
| Tips and Tricks for Using SQL Server Management Studio Effectively by Dr. Greg Low | Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. Join Greg to see his favourite tips and tricks for working with SSMS. | Watch Now |
| SQL Server Statistics Things That You Didnt Know by Amit Bansal | Join Microsoft Certified Master & MVP, Amit Bansal, and learn about the internals of SQL Server Statistics, Histogram, Cardinality Estimation and more. | Watch Now |
| SQL Server Backup & Restore by Satya Ramesh | - | Watch Now |
| Understanding NULLs in SQL Server by Satya Ramesh | SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this 30 min session, we will try to go through different test cases to understand NULLs properly. | Watch Now |
| The Future of SQL as a Service Azure SQL DB Instance by Javier Villegas | We will look into the future of SQL Server as a Service Azure SQL Database Managed Instance is a new option for PaaS that will allow us to have near 100% compatibility with SQL Server on premise, allowing us to quickly migrate all our apps to the Microsoft cloud | Watch Now |
| Troubleshooting SQL Server IO Performance/Bottleneck by Amit Bansal | - | Watch Now |
| Data Science for DBA Get Started Now by Manohar Punna | If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will introduce you to the field of Data Science. You will start with R in SQL Server. Then you step into the world of R using R Studio and realize the power of Data Science using Azure Machine Learning. You will learn the basics of R programming language, Machine Learning, real-world analytics and visualizations that businesses need today. In this session, you will get a head start about each component and the possibilities that can be achieved with them. | Watch Now |
| SQL Server Data Partitioning by Vijay Reddy | You will learn about the SQL Server Data Partitioning | Watch Now |
| Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio by Matt Gordon | On-call DBAs have all had that phone call in the middle of the night: the database is down, fix it now! We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studios notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks. | Watch Now |
| Azure SQL DB Managed Instances by Tejas Shah | More and more customers who are looking to modernize their data centers have the need to lift and shift their fleet of databases to public cloud with the low effort and cost. Weve developed Azure SQL Database to be the ideal destination, with enterprise security, full application compatibility and unique intelligent PaaS capabilities that reduce overall TCO. In this session, through preview stories and demos learn what SQL Database Managed Instances are, and how you can use them to speed up and simplify your journey to cloud. | Watch Now |
| All About SQL Server 2017 Security by Avanish Panchal | Security is vital & highly complicated subject of todays world. Gartners report positions Microsoft SQL Server in Leader coordinate when it comes to security. A demo driven session talks all security features exist in SQL Server 2017. Must go session for Developers/DBAs/IT Managers & SQL Server Enthusiasts. | Watch Now |
| A Lap Around SQL Server 2019 Big Data Cluster by Niels Berglund | The new release of SQL Server; SQL Server 2019 includes Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage. This new architecture that combines together the SQL Server database engine, Spark, and HDFS into a unified data platform is called a big data cluster. This webinar gives you an overview of what a SQL Server Big Data Cluster is, and what you can do with it. We look at the various components, (Kubernetes, Spark, HDFS, PolyBase, etc.), and what you can do with them, and how to run the Big Data Cluster on Azure Kubernetes Service. | Watch Now |
| Introduction To R On SQL Server by Sandip Pani | - | Watch Now |
| Deep Dive Session On SQL Server Column Store Index by Vijay Reddy | - | Watch Now |
| Deep Dives Into The Storage And Data Pools In SQL by Niels Berglund | - | Watch Now |
| Recompilations, Excessive CPU Load and Plan Caching by Dmitri Korotkevitch | SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems. In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries. | Watch Now |
| Benchmarking & Testing In-Memory OLTP Performance by Amit Bansal | Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. Therefore, it is very critical that you benchmark & test in-memory performance for your SQL deployments before you decide to migrate disk-based tables to memory-optimized tables. In this video, you will learn: a. Baselining current performance b. How to identify the right candidates for In-Memory c. Generate sample production data d. Create simulated production workload e. Test & benchmark In-Memory performance with simulations f. Compare In-Memory performance with the baseline You will also learn about a verity of tools and techniques that can be used in your proof-of-concept. | Watch Now |
| Simplifying SQL Server Performance Tuning by Amit Bansal | SQL Server Performance Tuning is no rocket science! Its a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a troubleshooting methodology that can be put into production right-away!. | Watch Now |
SQL Server Education (by the geeks, for the geeks)