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.
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.
Automated Machine Learning, "1 button data science", has been with us for a while. As always there's fans and detractors. We'll discuss when and why you'd use AutoML and when it's better to avoid it.
Join us for this session to learn about using serverless in SQL Database and save cost while achieving the desired performance.
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!
A client's case on how to build a robust metadata driven datahub by utilizing Databricks (Delta Lake) for data ingestion, validation, and loading
If you are planning to implement CCI in your production environment you need to be aware of certain aspects before you start. This session outlines key areas that you need to include in your planning beforehand.
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.
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
Look beyond the marketing to understand how, when and why you should consider Cosmos DB. Based on real world experience, we'll explain the complexities and gotchas in building realistic cost and performance models.
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.
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!
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.
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
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
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.
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.
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.
In this session we will look at the basics of the Power BI data model and why it is important to have a 'proper' model. We will then look at some real world modelling challenges and how to solve them.
A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports
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.
<<12>>