A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
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.
DBA and Data scientists should work together! Analyzing data gathered with XE and Query Store data using R or Python for better database insight and discovering hidden patterns.
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
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.
Learn how backup and restore work and how to put together an effective backup strategy.
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.
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!
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.
Played around with SQL Server in containers and want to delve further into the platform? This session is for you! In this session we'll dive straight into the Docker platform and investigate its internals.
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!
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
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.
How to increase security by using symmetric and asymmetric server encryption, client side Always Encrypted, secure SSL/TLS channels and Transparent Data Encryption for data at rest.
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.
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.
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.
In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. This session assumes a fundamental knowledge of both SQL Server and containers.
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
Learn what wait statistics are and how to use them to identify performance bottlenecks.
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.
This session is for all developers who want to learn about the new Dev features and enhancements of SQL Server 2017 and 2019
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.
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Come learn how to take advantage of everything Azure SQL can offer to a developer
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.
When you design and build an application, do you think about security first or is it an afterthought? In this talk, you will learn strategies for designing and securing your data layer.
In this talk we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.
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.
SQL Server 2019 introduces set of new features and improvements to bring close to parity with SQL Server on Windows. Also SQL Server improvements on Linux in Azure ecosystem enables new scenarios for HA/DR.
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.
Most DBA’s are cowboys, but there is much to learn from the world of cow herding and dairy farms that can make us manage SQL Server instances in a better way. Come and learn how SQL Server farms are the future.
The database is at the heart of your organisation's applications. If you can embed secure practices here, then it will flow througthe rest of your application stack.
When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
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.
See how we can address the problem of real-time analysis, on data in its raw form, without going through the whole ETL/ELT process, using Azure Data Explorer. We will also explore this solution in a demo!
Testing data in SQL Server is hard, but it is easier than having to restore your database. This session will show how easy it is to test database code using industry frameworks, tools and processes
So your company has no budget for fancy 3rd party tools. Don’t worry, the SQL community has got your back. Come and hear about the many free tools available to data professionals that will help you in your daily life.
One of the most common “false positives” that people see when troubleshooting query plans is that updating statistics “fixes” a problem. In this first session, we'll decipher the ACTUAL problem - caching or statistics?
In this second session, we'll talk about problems that are NOT caching related but in fact, actually statistics problems? More importantly, I'll give you ways to help solve them!
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.
Come learn how to scale your database applications to new heights with SQL Server In-Memory Database.
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" Learn how Azure Data Studio notebooks can make our responses faster and more organized so we can get more sleep!
Get introduced to SQL Server on containers and what you need to know as a DBA to start deploying and managing them in both development and production environments
<<12>>