Sessions & Content

Search
Content Type
Conference
Tags
10 reasons to look at using Azure Data Studio Robert French
Yet another new tool from Microsoft ! Why should you consider using it? Thats a good question. In this session we will explore at least 10 reasons to use the tool, and maybe a few more.
A Distributed Availability Groups Primer Allan Hirt
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
Advanced Plan Explorer Usage for Tuning Execution Plans Andy Yun
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.
Analyzing database with XE and Query Store data using R / Py Tomaž Kaštrun
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.
The video is not available to view online.
Azure SQL and SQL Server: Path to an Intelligent Database Pedro Lopes
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-Optimized SQL Engine for Edge/IoT Sourabh Agarwal
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
Baselining Performance with DEA Dustin Dorsey
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.
Building a Better Backup Strategy Paul Randal
Learn how backup and restore work and how to put together an effective backup strategy.
Can SQL Server 2019 auto-magically fix my bad T-SQL code? Andy Yun
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Deadlocks: Lets Do One, Understand It, and Fix It Brent Ozar
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.
De-risk Your Azure SQL Migration: 5 Critical Considerations Kevin Kline
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.
Designing Azure Data Disaster Recovery Strategies John Morehouse
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!
Digital Transformation from Edge to Cloud with Azure Data Rohan Kumar
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.
The video is not available to view online.
Docker Deep Dive Andrew Pruski
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.
Dynamic Data Masking in 20 Minutes David Postlethwaite
In this 20 minute session we will have an overview and demos of Dynamic Data Masking which allows us to obfuscate data in real time
Elementary! The Curious Case of Deceptive Query Optimizer Pinal Dave
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 ... where do I start? Hugo Kornelis
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!
Fast Focus: Scalar User-defined Functions in SQL Server 2019 Hugo Kornelis
SQL Server 2019 introduces FROID, a framework to inline user-defined functions, promising much better performance. What problem does it solve? And how does it work?
Financial Modelling with Power BI Bob Duffy
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
First Dates: AI & DBAs. Any Chance to be a perfect match? Sascha Lorenz
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Getting Started with Learning Azure Monica Rathbun
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.
Getting To Know SQL Server Encryption Capabilities Mladen Prajdic
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.
How To Start Collaborating With A GitHub Repository Rob Sewell
Wanted to join with open-source projects but don’t know how? This quick session will give you all that you need to start doing so.
How to Succeed on the 'Unhappy Path' in Database DevOps Kendra Little
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.
I'm a SQL DBA. What do I do with this Oracle database? David Postlethwaite
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.
Improving Availability in SQL Server and Azure SQL Database Kevin Farlee
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.
The video is not available to view online.
Inside SQL Server on Kubernetes Bob Ward
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.
Install & Configure SQL Server with PowerShell DSC Jess Pomfret
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
Introduction to Perf Troubleshooting Using Wait Statistics Paul Randal
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Microsoft certifications for the Data & AI professional Sandra Marin
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
Modern Database Design – Do’s and Don’ts Conor Cunningham
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.
Navigating the Bewildering Array of Data Services in Azure Ian Griffiths
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.
New SQL Server Features for Developers Hasan Savran
This session is for all developers who want to learn about the new Dev features and enhancements of SQL Server 2017 and 2019
Next Gen: Intelligent Infrastructure Shawn Meyers
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.
Performance Mythbusters Paul Randal
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Practical Azure SQL for the Modern Developer Davide Mauri
Come learn how to take advantage of everything Azure SQL can offer to a developer
Query plans: a map to query performance analysis Pedro Lopes
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.
Secure SQL Server Database Design: Tactics and Technology Dan Mallott
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.
Set Your SQL Server Data Free with the Use of Kafka Niels Berglund
In this talk we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.
SQL Notebooks in Azure Data Studio for the DBA Rob Sewell
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 on Linux-Whats new Tejas Shah
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: The Modern Data Platform Bob Ward
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.
SQL Server farm management vs single instance management Per Christopher Undheim
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.
SQL Server Secure Development Patterns Stuart Moore
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.
SQL Server Table partitioning – DOs and DON’Ts Margarita Naumova
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?
Stop Tuning Queries and Start Tuning Your Workload Erin Stellato
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.
Stop waiting to explore your data: use Azure Data Explorer! Jason Bonello
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!
Storing strings in SQL Server and Azure SQL DB Pedro Lopes
in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.
Test Driven Development in SQL Server, safer code deploys Hamish Watson
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
The art and skill of listening Robert French
We all want to be listened to. In our busy world sometimes we forget how to listen, often to other people. There are advantages to listening, and its a skill we can learn.
<<12>>