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.
Join this session to learn about new and upcoming SQL security features and how they are supported in hybrid environments.
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.
Application and Database migrations can be a cause for concern. How many times have you heard, "If it isn't broke don't fix it". Come see how you can give confidence to key stake holders on testing the process.
Join us for this session to learn about using serverless in SQL Database and save cost while achieving the desired performance.
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 and optimized it for the Edge.This session explores customer implementations with Azure SQL Database Edge, along with new product features.
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.
Together Power BI and Azure Synapse Analytics can handle huge datasets. This session details how the composite model and aggregation capabilities of Power BI can be used to fully exploit the scale provided by Synapse.
A client's case on how to build a robust metadata driven datahub by utilizing Databricks (Delta Lake) for data ingestion, validation, and loading
Columnstore Indexes were launched in SQL Server 2012 and greatly enhanced in 2014 & 2016 - but if you thought that Microsoft was done with them - you are missing a lot of important improvements that were added.
Learn the four core practices which enable high performance for database development and delivery.
Learn common patterns for testing data, and the anti-patterns that trip developers up.
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.
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.
Join us to get the scoop on the newest certification in Microsoft's certification portfolio. If you implement or manage cloud-based or hybrid data platform solutions, this certification could be the one for you!
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.
In this session we will discuss the concept of benchmarking database performance & how to use benchmarking to accurately compare different DBaaS & IaaS offerings across cloud providers, using your own production workload
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.
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 demo filled session on how to systematically reduce public access to SQL Database server and transition to private endpoint access using networking features.
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.
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
Azure Data Share enables organizations to simply and safely share data with their customers and partners. Watch a live demo, hear how customers are using the service and how we're thinking about governed data sharing.
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.
Go from beginner to expert with learning new Azure skills and the best material out there
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.
Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Don't worry! I have made plenty of presentation mistakes over the years so you won't have to :)
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.
<<12>>