In this session you'll learn some of the key data privacy problems facing database developers and DBAs and 10 steps to help your database team build a "defensible position" through development.
We're fortunate in seeing tons of customers migrate to the cloud - this session covers major
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Learn the tools and techniques you can use to create governance and insights around your Azure spend
In this session you’ll learn more about Azure data services on Azure Arc
In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Learn what the Database Experimentation Advisor is and how you can start using it to baseline performance from a target and source server when new changes are introduced.
Come learn how to use .NET and Spark together in Azure Synapse and elsewhere to cook and analyze your data!
We will see how to construct a cloud-first architecture based on serverless data analytics. We will look at specific challenges and cost saving strategies, to produce a reliable, scalable and cost effective solution!
Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach
This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement.
Learn to make better analytic solutions by following current thoughts on data modeling.
Databricks, Lakes & Parquet are a match made in heaven, but explode with extra power when using Delta Lake. This session will dive into the details of how Databricks Delta works and how to make the most of it.
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
Are you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? Then this is the session for you.
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
Come learn how to design your enterprise-scale data lake on Azure using Azure Data Lake Storage
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
Learn tips and tricks to make SSIS perform better.
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
Automate optimising your hybrid production databases by recording workloads and replaying them either on-prem or onto Azure instances whilst identifying bottlenecks and exploring SQL tuning techniques.
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
Learn about two innovations in – Accelerated Database Recovery and Resumable Operations – that will help you meet even the strictest SLAs by reducing startup and maintenance time and increasing up-time.
BI professionals continuously improve datasets, reports and dashboards to provide their users with the best analytics experience, but managing all those content updates can be a challenge.
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we wil
Are you looking to take your career to the next step? Microsoft Certifications help validate knowledge and ability required to perform current and future industry job-roles in a modern digital business. Our certification
The goal of the talk will be to show you how to choose among the various storage technologies that exist when building your next application.
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
Every day our organizations expect us to do more with less. Writing scripts to automate some tasks will only get you so far. It is time for the DBA to leverage Intelligent Infrastructure to remove routine tasks.
In this session, learn from the tools team about what a notebook is and how to use SQL, Python, and Powershell notebooks for deployment, automation, troubleshooting and analytics.
Learn about using serverless in SQL Database to optimize price-performance and simplify performance management
In this session we will demonstrate a few workload patterns on Azure SQL Database and discuss how to identify and remove bottlenecks in order to scale those applications.
This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows.
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Azure Databricks has become one of the staples of big data processing. See how to make the most of it by understanding how Spark works under the covers.
A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports
This session provides an end-to-end walk through of how to use Azure Synapse for cloud-hosted advanced analytics, based around a real-world predictive maintenance use case.
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Walk through partitioning strategies and look into partitioned views to consolidate distributed data. Enterprise features makes this easy, however hacks will be demo'd to make this work in Standard edition.
Databricks Delta Lake brings new levels of reliability and transformation abilities to big data solutions. Come and learn how you can simplify your ETL and maximise data consistency and resilience, no matter the size
Come and hear about the best practices of cloud migration, the latest enhancements of Azure SQL Database Managed Instance, and the future roadmap.
SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.
<<12>>