Session Title | Abstract | Recording |
---|---|---|
The Computed Column Magic Trick by Guy Glantser | Query tuning is like magic. You take a slowly-running query, you do some magic, and boom – it runs amazingly fast. There are many magic tricks that you can use to boost query performance. I will demonstrate a lot of them in my Performance Tuning Magic Show. In this webinar, I would like to focus on one of them – the Computed Column Magic Trick. We will examine together several slow queries, and I will show you how to do magic using computed columns that will make these queries fly. | Watch Now |
Short Guide on Performance Tuning and Troubleshooting by Denis Reznik | To be short, this session will contain some SQL Server internals, troubleshooting, and query optimization. It will not cover everything but will give a good idea of where to start and how deep you can go. You will learn how to collect basic and specific data for troubleshooting with extended events; some simple and complex query optimization approaches; some indexes and physical joins internals. This webinar will not be a short version of my PreCon on Performance Tuning and Troubleshooting, but rather an optional complementary part of it. | Watch Now |
Model Your Data Like A Star In Power BI by Markus Ehrenmüeller-Jensen | Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modeling the tables and how they are related to each other. In this talk we spend quality time on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why is redundancy (not) a bad thing? After this session you will understand how to model data like a star. | Watch Now |
RIP Profiler: Why XEvents is Better! by Jason Brimhall | Extended Events (XEvents) was introduced in SQL Server 2008. Since that initial release, XEvents has seen a significant upgrade with every new release of SQL Server. Join me for a little adventure into the realm of XEvents as we compare and contrast this feature to Profiler (the predecessor to XEvents). As we compare and contrast the two features, we will discuss how to use XEvents to aid in performance tuning as well as in day to day administration. This session will also explore some background and the architecture of Xevents (in contrast to Profiler). This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XEvents sessions that can help troubleshoot different issues and to help (the Data Professional) become more intimately aware of their data/environment. | Watch Now |
Spark For Engineers With Databricks by Tomaž Kaštrun | Apache Spark has become one of the standard engine for large scale data analytics. With capabilities for multi-language support on all data engineering tasks, as well as machine learning tasks. In this webinar, we will explore the Spark engine and make a gentle introduction to Scala and PySpark, and cover most important engineer tasks, and make comparison between both languages with benchmark. For the simplicity of this webinar, we will use Azure Databricks. | Watch Now |
Why Query Store? by Milos Radivojevic | Query Store is a great troubleshooting tool, but it is still not embraced by customers as it deserves. In this session, you will learn about Query Store purpose, you’ll see what can be achieved with Query Store and how it can help you not only to identify performance issues more efficiently but also to fix some of them. You will also see many reasons why you should invest in learning Query Store and, in this regard, why it is a very good idea to attend the Query Store Deep Dive workshop at the DPS 2022 conference. | Watch Now |
Analytics At Scale With Power BI and Azure Synapse Analytics by Dave Ruijter | Designing the perfect solution that spans both Power BI and Azure Synapse Analytics can be quite difficult. Both of those services are very rich platforms that offer many advanced capabilities, but they also have some challenges, especially in the part where you chain them together. In this webinar we will discover the options for a performant and scalable solution, because the advanced capabilities of both worlds can really complement each other! | Watch Now |
Building Data Pipelines With Azure Data Factory by Dennes Torres | In this session you will discover the power of Azure Data Factory and how to build data pipelines in the cloud using ETL/ELT processes to load a data warehouse. | Watch Now |
Power BI Performance – 5 Things To Consider! by Nikola Ilic | Great job! You’ve built a nice-looking Power BI report and your charts look fancy. But, your data refresh process takes forever…Or, your report is unacceptably 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! In this webinar, I’ll share with you 5 things to consider when you troubleshoot the performance of your Power BI solution: starting with understanding the best practices for data model size optimization, 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. | Watch Now |
Predictive Analytics With T-SQL by Dejan Sarka | Predictive analytics is definitely a popular contemporary topic. There are many languages, tools and services you can use for predictive analytics, including R, Python and Azure ML. However, could you imagine you can do some predictive analytics also with T-SQL? I will show you how to implement two predictive algorithms in T-SQL. I will also explain why and when would you use T-SQL for such an untypical task. I will introduce the look-alike model, which is a mixture of k-nearest neighbor and decision trees algorithms, and the Bayesian inference model, both implemented with T-SQL. | Watch Now |
Developing an Azure Analysis Services Database by Peter Myers | Learn how companies are using Microsoft Azure services including Azure SQL Database, Azure SQL Data Warehouse, Azure Analysis Services and Microsoft Power BI to gain insights from their data. In this presentation, you will see how to develop and deploy a semantic model by using the online web designer, and then publish a Power BI report to deliver a highly interactive and rich analytical experience sourced from the model. If youre new to Analysis Services, this will make a great introduction. If youre experienced with SQL Server Analysis Services, the development of an Azure Analysis Services database by using the online web designer may be of interest to you. | Watch Now |
Azure Analysis Service & Automation by Khushboo Gupta & Kane Conway | Introduction to Azure Analysis Service, Deployment of Models to Azure AS and Processing Automation using Azure services | Watch Now |
Azure Databricks by Viresh Kumar | - | Watch Now |
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 |
Introduction to Azure Security by Adin Ermie | Azure is a powerful platform with many amazing services, but it can also be hard to know which ones you need to know about when youre first getting started. Also, ensuring the connected services are properly secured is a responsibility that we all share. In this presentation, we will cover common scenarios where security is a must. | 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 |
Using the SSIS Catalog by Andy Leonard | The SSIS Catalog is a data integration execution framework that manages SSIS package execution, configuration, and logging. Join SSIS author, blogger, and podcaster Andy Leonard as he discusses and demonstrates using the SSIS Catalog to manage SSIS in the enterprise. | Watch Now |
Power BI Tips & Tricks to make stuff work by Manohar Punna | Building Power BI Report from the scratch in an environment without proper BI tools is always a challenge. You pick it up from pulling in the datasets, transforming your data and building the model within Power BI to build the end user reports. I have been on this path and have learned few techniques the hard way. In this session I will go through a few tips that will help another Data Professional to get through the journey of building beautiful reports in Power BI. This will be a complete demo driven session covering 1. Tips to manipulate and duplicate your datasets. 2. Tips around Date table to make your life easier. 3. Tips on understanding and using DAX the simpler way. 3. Tips on some new and old features that are awesome. | Watch Now |
Bridging The Gap Between SSRS and Power BI by Manohar Punna | - | 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 |
The Gremlins are attacking the Azure Cosmos DB by Cédric Charlier | Have you got some data structures not playing well with the relational concepts? Data, as it appears in the real world, is naturally connected. Traditional data modeling focuses on entities and is not perfectly rendering this highly connected world. For many applications, theres a need to model both entities and relationships naturally. Azure Cosmos DB, with its Gremlin Graph API, supports this property graph model. During this session, youll learn the best use-cases and the great benefits of graph models but also how Azure Cosmos DB is supporting this. Youll receive a good explanation of whats TinkerPop and why its so important in the world of graph databases. The Gremlin language will be explained from the basics to some more advanced concerns in the form of recipes for common use-cases of graph databases! | Watch Now |
Power BI Writeback with Power Apps by Gilbert Quevauvilliers | - | 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 |
A Gentle Introduction to Text Analytics by Mark Wilcock | The analysis of text documents is rapidly growing in importance and not just of social media (tweets, reviews) but also for legal, academic and financial documents. Well look at the basics of text mining; frequency analysis, finding words and phrases specific to one or a few documents in a collection, and topic modelling. Well analyze a few documents, then visualize the results. Well use a variety of tools; R, text analytics web services and Power BI. | Watch Now |
Budgeting with Power BI by Alberto Ferrari | Budgeting is one of the most challenging scenarios in the Power BI arena. For example, you might need to summarize sales in previous years and to allocate the budget forecasts. You have to work with data at different granularities and to find a way to author DAX code to compute the forecasts at the desired granularity. When it comes to budgeting, each company is a unique scenario. In this session, you will see some common techniques to use when building a budget model with Power BI, including previous year allocation, multiple-step budgeting with calculated, handling of budget on items that do not yet exist. | Watch Now |
Endless Possibilities of Machine Leaning Using R inside Power BI by Leila Etaati | AI is one of the topic that these days many company use it to produce more smart reports and applications. Power BI tools a powerful application for the visualization and data cleaning. There are some possibilities to do machine learning in Power BI: Using predefined custom visual created by Microsoft team from Office Store, Writing R codes inside Power Query, create a machine learning modules using M language inside Power BI. In this one hour session, I am going to show you how to use the Power BI custom visual for the aim of Machine learning, How to write R code in Power Query using Run R script Editor. Finally, I will show how to use M language inside Power Query for the aim of parametrizing and create some predefined machine learning modules, so end user able provide data, prediction columns and method and then get the result of prediction as separate query.Endless Possibilities of Machine Leaning Using R inside Power BI | Watch Now |
Introduction to Cosmos DB by Deepthi Anantharam | Azure Cosmos DB is a multi-model database thats globally distributed, and scales remarkably well. In addition to boasting 99.99 % availability within a region, Cosmos DB offers several well-defined consistency models strong, bounded-staleness, session, eventual, and consistent prefix. Let us look at querying and indexing Cosmos DB and the graphs that you can build on them. | 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 |
R For Developers by Steph Locke | Whether youre interested in picking up another language, or you need to understand what those new data scientists have written and how you go about implementing their crazy new algorithms in your front-end, this session will take you through the R fundamentals, drawing comparisons against other languages, and give you a load of tips to make getting started easier. | Watch Now |
Practical DAX for SQL Server Professionals by Philip Seamark | Are you a whizz at SQL and curious about learning more about DAX? This session will be aimed to share some helpful tips and tricks for creating beautiful DAX when building Power BI reports or Tabular Cubes. Most people who learn DAX come from an Excel background, but this session will be tailored to those used to set based approaches such as SQL. We will create data from thin air and show how you can shape your data model using DAX | 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 |
Launching a Data Science Project: Cleaning is Half the Battle by Kevin Feasel | Theres an old adage in software development: Garbage In, Garbage Out. This adage certainly applies to data science projects: if you simply throw raw data at models, you will end up with garbage results. In this session, we will build an understanding of just what it takes to implement a data science project whose results are not garbage. We will the Microsoft Team Data Science Process as our model for project implementation, learning what each step of the process entails. To motivate this walkthrough, we will see what we can learn from a survey of data professionals salaries. | 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 |
A Dialogue with your Data - Interactive AI with Azure Cognitive Services By Matt Gordon | Customers and users increasingly demand more personal and prompt communication from companies and brands with which they interact. How can data professionals help fill that need? The incredible power and instant accessibility of the Azure Cognitive Services Language and Speech APIs, combined with other Azure services, put the power in our hands. From translating between languages to make communication more efficient to analyzing support communications to ensure customers are happy, Azure Cognitive Services allows data professionals to enhance a brands interaction with and impression in the customer community. This demo-heavy sessions walks through practical applications of these APIs that you can apply at home or at work immediately after the session. | 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 |
Basic Introduction to Machine Learning by Sakshi Chourasia | - | Watch Now |
Get Started with Azure Cosmos DB by Pankaj Khattar | - | Watch Now |
I want my model to be deployed! Why is it so difficult by Paul PETON | Putting machine learning into production remains a challenge even though the algorithms have been around for a very long time. Here are some blocks: the choice of programming language the difficulty of scaling fear of black boxes on the part of users Azure Machine Learning is a new service that allows to control the deployment steps on the appropriate resources (Web App, ACI, AKS) and especially to automate the whole process thanks to the Python SDK. This session offers an end-to-end demonstration. | 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 |
Machine Learning Basics using R & Python by Deepak Pradeep Kumar | Machine learning is essentially a form of applied statistics with lot of emphasis on the use of computers to statistically estimate complicated functions and find patterns on sample set / new set of data. A machine learning algorithms are set of algorithms that are able to learn from data about the experiences, trends, tasks, performance measures and improves the experience with new set of data. Some of the common machine learning tasks include Regression, Classification, Synthesis and Sampling, Imputation of missing values. We can look into few machine learning algorithms to train the machines and apply them to real world examples. We shall continue to have the series of Machine learning algorithms and go through Deep learning techniques to ensure you are industry level ramped up for implementing Deep learning techniques. | Watch Now |
Azure Machine Learning Studio vs Power BI by Yana Berkovich | There are so many tools for data analysis and prediction. Lets explore the Azure ML lab vs PowerBI, how can each of them be used? What are their differences? In this session, you will learn the differences between loading data in the Azure ML Lab vs into PowerBI. We will discuss the cleansing of data in both tools, as well as analyzing existing data (the OOTB for each tool). We will then build a simple prediction model and summarize and compare the results. | Watch Now |
Introduction to Feature Engineering - ML by Sandip Pani | You will learn about Feature Engineering in Machine Learning | Watch Now |
From Technician to CEO A Roadmap for Advancing Your Career by Edwin Sarmiento | Whether you are just starting out as a technician, a help desk associate, or a junior database administrator (DBA), everyone wants to grow and advance their careers. In this session, learn how to intentionally advance your career one day at a time. You will learn how to continuously develop your technical expertise while improving your soft skills, creating a personal growth plan, and consistently work towards achieving our maximum potential. We also look at the role of mentors in achieving success. | 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 |
Azure Machine Learning SDK by Parashar Shah | During this session Parashar will explain how to use Azure Machine Learning SDK for data prep, automated ml/training and deployment. He will showcase how to use Azure ML SDK for e2e Machine Learning [Classical Machine Learning and Deep Learning] using Azure Databricks and Azure Notebooks (Jupyter). | 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 |
Implementing AI solutions using Azure Machine Learning Services by Vitor Fava | Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology. As well as the arrival of the personal computer, the cloud computing, and smartphones, the AI is the artificial technology that takes you to where youre going so much faster, intuitive and smart. In this session, we will discuss the basics of IA and how we can apply it in our business using the Azure Machine Learning Services. | 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 |
Query Diagnostics in Power BI by Colin Popell & Jorge Gomez Basanta | Learn how to use Query Diagnostics in Power BI. See how to record traces, diagnose steps, and get performance information, as well as how to look for what folded and visualize performance. | Watch Now |
Building Custom Vision Applications by Chris Testa-O Neill | This demo packed talk will focus on the development of a classification solutions that makes use of the Cognitive Services Custom Vision Service. It will teach the student how to build and classify images, and then train them so they can be utilized in the prediction endpoint that is embedded within an application. | 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 |
Build Predictive Model using Azure Machine Learning Studio by Sandip Pani | If you are new to Machine learning, dont know where to start, what is the difference between ML and AI, and you want to learn how to start, Then this session is for you. In this session I will explain what is machine learning, What is AI? Life cycle of a machine learning project. How to train a predictive model using Azure Machine learning studio. If you think you need deep understanding of statistics to start your Machine learning project then dont worry I will cover minimum important and fundamental key component of Statistics which is sufficient to build your first predictive model. | Watch Now |
OData and .NET Core State of the Union by Rainer Stropek | OData is a well-established standard that has been used in many software systems for years. Azure makes heavy use of OData and the protocol is supported in client apps like Power BI, too. In this session, MVP and Regional Director Rainer Stropek speaks about the current state of OData. He starts with a quick introduction for those viewers who are not familiar with OData. Next, he shows how ODatas integration with .NETs LINQ, ASP.NET Core and Entity Framework makes it pretty simple to get you own OData services up and running. Rainer will also critically evaluate OData by talking about areas where Microsofts implementation has to improve as well as pros and cons compared to classical REST APIs, gRPC, GraphQL, and JSON:API. If you build data-driven APIs for the web and the cloud, this session is for you. Rainer will use only a few slides. He will focus on code walkthrough and live coding. | 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 |
Cloud based Integrations using Azure Data Factory by Anupama Natarajan | SQL Server Integration Services (SSIS) has been a known ETL tool for enterprises to transfer data from one data source to another. Azure Data Factory (ADF) is a managed service on the cloud providing the ability to transfer data from one data source to another irrespective of whether the data source is on-premises or on the cloud. ADF v1 release provided the ability to build datasets, activities and pipelines for data movement. With ADF v2 (preview) release, now we can lift and shift on-premise SSIS packages to run on Azure. In this session you will learn about: a) Introduction to Azure Data Factory b) Components of Azure Data Factory c) ADF v1 vs. ADF v2 (preview) Features d) Lift and Shift on-premises SSIS package to Azure | Watch Now |
Create an Advanced QnA Bot using Azure Bot Service by Anupama Natarajan | QnA Maker enables you to power a question and answer service from your semi-structured content like FAQ (Frequently Asked Questions) documents or URLs and product manuals. You can build a model of questions and answers that is flexible to user queries, providing responses that youll train a bot to use in a natural, conversational way. In this session you will get to learn about how to develop a Web bot using Azure Bot Service and integrate it with QnA Maker and LUIS. We will create multiple QnA Knowledge Bases and using LUIS we can redirect requests to the appropriate knowledge bases to retrieve the response. | 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 |
Getting Started with Machine Learning .Net by Bruno Capuano | If you are a developer and you started to feel outside of the Machine Learning world, this session is for you. In this session, we will review the basics of machine learning, how to use existing models and services in standard developer apps, and how to get started with creating your own simple models. Important: we dont need any specific math or data skills to create ML models. We will cover the basis of Machine Learning.Net, a complete ML framework to work with C#, F# or any other .Net Core language. And Im a developer first, so do not expect much slides. Instead, we will code a fully functional app from scratch. | Watch Now |
Data Visualization in Power BI Tips and Tricks by Reza Rad | Visualization is the front end of every BI system, and getting it right will affect tremendously on the data analysis solution. In this session you will learn tips and tricks of data visualization with Power BI, examples of effective visualizations, and you will learn when is best to use which type of chart. You will learn about best way of visualizing elements through built-in visualizations or custom visuals. | 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 |
Dataflows in Power BI by Bent Nissen Pedersen | Get and overview of Dataflows and how it integrates data lake and ETL technology directly into Power BI to enable anyone with Power Query skills. Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI. We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation. This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data. | Watch Now |
Azure Machine Learning for MLOps by Mercy Ranjit | MLOps will enable you to build Continuous Integration and Continuous Delivery pipeline for a ML/AI project. We will be seeing how to use the Azure DevOps Project for build and release/deployment pipelines along with Azure ML services for model retraining, model management and operationalization. | 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 |
Deep Dive into SSIS in ADF by Sandy Winarko | This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR dedicated ADF servers for lifting & shifting SSIS packages and extend it with custom/3rd party components. Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. Next, we will guide you to trigger/schedule SSIS package executions as first-class activities in ADF pipelines and combine/chain them with other activities, allowing you to inject/splice data transformations in your ETL/ELT workflows, automatically provision Azure-SSIS IR on demand/just in time, etc. And finally, you will learn about the licensing model for ISVs to develop paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF. | 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 |
Machine Learning Using Python & R (Part 2) by Deepak Pradeep Kumar | - | Watch Now |
Introduction to the Microsoft AI and Data Science Platform by Chris Testa-O Neill | This session will provide you with an overview and examples of the Microsoft AI and Data Science Platform with an introduction to technologies in Cognitive Services, Bot Framework and Machine Learning. It will also outline how development in this area can be managed though the Team Data Science Process, and we will explore that professional roles that can ensure the delivery of these types of solutions today whether you are a developer, or a data scientist. | 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 |
Top 13 Best Security Practices for Azure by Radu Vunvulea | Security nowadays is just a buzzword. Even so, by joining this session, we discover together what are the most important security best practices that you need to have in mind when you work inside the cloud inside Microsoft Azure. | 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 |
Digging data from hard-to-reach websites with Power BI by Tim Heng | Tools such as Power Query and Power BI generally require websites to provide information in a defined Table format, which relies on website developers to a) take the time to present their data in that format, and b) be willing to provide their data in a way that is easy to scrape. As tools have become better at automatically collecting data, many websites have started restructuring in order to limit a users ability to download information. We will apply some of the newer tools within Power BI to analyse non-tabular datasets, showing you how easy it is to apply cutting-edge analytical tools to difficult websites. | 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 |
Applying Forensic Accounting Techniques Using SQL & R by Kevin Feasel | Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benfords Law, outlier analysis, time series analysis, and cohort analysis. | Watch Now |
Developer Tools for Microsoft Azure by Radu Vunvulea | During this session, well take a look at the proactivity tools that can be used to improve our development experience on Azure. Well talk about tools from multiple areas like storage, computation, automation, cleaning and many more. All of them are free to use, build by the Azure community or Microsoft to improve the cloud experience. | 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 |
Art Of Feature Engineering For Machine Learning by Sandip Pani | Building ML model is easy if you know your data well. According to a survey in Forbes, data scientists spend 80% of their time on data preparation. The features in your data are important to the predictive models you use and will influence the results you are going to achieve. Though Deep learning takes care of feature engineering process by itself, but many ML model still require to go through this Feature Engineering phase. In this session I will be presenting on various feature engineering techniques such as Imputation, Handling Outliers, Binning, Log Transform, One-Hot Encoding, Grouping Operations, Feature Split, Scaling, Handling Date. It will be a demo heavy session where we will explore different techniques of Feature engineering. Building ML model is easy if you know your data well. According to a survey in Forbes, data scientists spend 80% of their time on data preparation. The features in your data are important to the predictive models you use and will influence the results you are going to achieve. Though Deep learning takes care of feature engineering process by itself, but many ML model still require to go through this Feature Engineering phase. In this session I will be presenting on various feature engineering techniques such as Imputation, Handling Outliers, Binning, Log Transform, One-Hot Encoding, Grouping Operations, Feature Split, Scaling, Handling Date. It will be a demo heavy session where we will explore different techniques of Feature engineering. | 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 |
ADF, Mapping Data Flow by Sudhir Rawat | In todays world, big data processing is a critical task for every organization. Organization spent good amount of time and resources to build data transformation pipeline. Recently Microsoft launched ADF Mapping Data Flow. Mapping Data Flows allow users to quickly transform data at scale. Build resilient data pipelines in an accessible visual environment with our browser-based designer and let ADF handle the complexities of Spark execution. | Watch Now |
Introduction To Apache Kafka Architecture by Suvarna Raju Madhey | - | Watch Now |
Real-Time Analytics With Power BI by Manohar Punna | - | Watch Now |
Introduction To R On SQL Server by Sandip Pani | - | Watch Now |
PowerApps And Flow Best Practices - Working With SQL by Manohar Punna | Microsoft PowerApps and Flow have seen tremendous adoption in recent years. With an ever-growing need for rapid and agile solution development, these two products have the potential to solve business problems with very minimal development efforts. However, as with any product, with great simplification comes greater problems. As a data professional, it is our responsibility to make sure the data layer is accessed with proper security and efficiency. In this session, I will explore different methods to connect to the data from PowerApps and Flow. In this demo filled session, I will cover different scenarios for sending and receiving data in PowerApps using Flows. | Watch Now |
Develop zero Code ML Models Using MS Technologies by Anupama Natarajan | Artificial Intelligence is undoubtedly booming in the business and every organisation wants to use AI to transform their business. Machine Learning, a category within AI has become far more effective and widely available enabling organisations to build systems that can learn how to perform tasks on their own. Whether you are a Developer or Data Scientist and new to Machine Learning, Microsoft provides tools to develop models without writing single line of code to accelerate your AI journey in your organisation. In this webinar you will get to learn about the Microsoft Technologies that will allow you to create models without any coding required. | 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 |
Computer Vision API In Cognitive Services by Anupama Natarajan | Computer Vision API is part of Cognitive Services that provides developers with access to advanced algorithms for processing images and returning information. It works well with image formats like JPEG & PNG and can extract text, visual information, celebrities and landmarks etc. In this session you will get to learn about how to detect and extract text from images (OCR) and analyse images and return visual information found in the image. You will also get to learn about some business scenarios where Computer Vision API can be valuable. Demos in this session will make use of C#, Computer Vision API, Computer Vision SDK and Visual Studio 2017. | 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 |