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.
In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs.
In this session, you'll learn about an end-to-end scenario that takes customers through the application migration process, and how that relates to the data migration.
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!
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.
Azure SQL Database Edge has taken the same SQL database engine you know and optimized it for the Edge. This session explores popular customer implementations, along with new product features for the Intelligent Edge
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.
This session will take you through the steps required to build an automated solution to create an Azure SQL Database with a Service Principal and create users and apply permissions
Learn to make better analytic solutions by following current thoughts on data modeling.
In this session you’ll learn the real-world ins and outs of how we successfully migrated customers to Azure data platform.
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.
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
In 2020, organizations have undergone digital transformation at breakneck speeds. In this keynote Rohan Kumar, Corporate Vice President of Azure Data, will discuss how you can be at the heart of change for your company.
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!
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.
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.
We often talk about DevOps when everything is going well, but what about when it isn't? We will walk through three real-world 'unhappy path' examples and how to overcome the challenges.
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.
Join John as he introduces Terraform as a cloud agnostic management interface for taking a code first approach to cloud infrastrucutre deployments.
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.
Azure's breadth of products can make technology selection a challenge. Learn how to make pragmatic and informed choices that meet your application's data transformation, processing and storage requirements.
Join us for a session that explains connectivity basics followed by how to eliminate all public access to SQL Database server and transition to private-only access using Azure Private Link.
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.
Come learn how to take advantage of everything Azure SQL can offer to a developer
Join this session to learn about new and upcoming SQL security features and how they are supported in hybrid environments.
Learn what SQL Injection is and all the mechanisms you should employ to help stop it.
Come and hear about the best practices of cloud migration, the latest enhancements of Azure SQL Database Managed Instance, and the future roadmap.
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
In this session, we will discuss new features recently announced for SQL Server on Azure Virtual Machines.
Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.
Learn how to analyze your data with pure T-SQL to get the performance you cannot reach with R, Python, or other tools. Learn the math behind as well.
This session will discuss how to look at your workload holistically using a variety of methods, so that you can target and address patterns in your code and query plans, rather than troubleshooting one query at a time.
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
Authentication and security in Azure use a different model. In this session you will learn how that works, and how to make it work for you applications.
SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.
If you have heard about Query Store but don't know what it can offer, or why you really need it, this session will answer those questions and demonstrate the value of this feature that continues to evolve.
Learn what is necessary to keep an eye on your Azure SQL Database in order to better tune it and reduce costs.
See how to analyze images in your Data Lake with Azure Data Lake Analytics, U-SQL and custom models
Managed Instances can make your cloud migrations simpler, but have their own nuances. Learn about what you need to know to manage this new platform.
This session presents how to migrate, replicate, and synchronize data between SQL Server, SQL VM, Azure SQL Database, and Azure SQL Database Managed Instance, across on-premises, Microsoft Azure, and other cloud platforms to build a real hybrid data platform. We introduce our current technology choices, deep dive in customer scenarios, and use cases, and share product roadmap.
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).
In this session, you will learn about the architectural details of Managed Instance, the available features, and the best ways to configure it and migrate your databases to Managed Instance.
<<12>>