Meet the Azure Data Community Advisory Board

How to Conduct a Transact-SQL Code Review

Learn a collection of important best practice for Transact-SQL code and how to integrate them into your code acceptance testing for better performance and efficiency.

Shift-Left: A DevOps and Database Story

Database code often works well in a test environment, but end up causing significant performance issues when rolled out to production. In turn, these performance issues lead to lost productivity, excess resource consumption, and lost time spent troubleshooting the issue. But what if we could catch those issues during development? Join Kevin Kline to learn how SolarWind's SQL Sentry can shift performance tuning left to the dev cycle so those issues never occur on production systems in the first place.

SQL Horror Stories

Join Kevin Kline as he takes you on a guided tour of some of the worst and most horrible SQL coding experiences. Some were intention and some were accidental. But all of them will make you wince and laugh! Learn new SQL coding tips and tricks from these cautionary tales.

De-risk Your Azure SQL Migration: 5 Critical Considerations

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.

Pitch Perfect-Presenting Ideas That Win Executive Support

You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?

Optimizer Secrets: Debugging using 860x Trace Flags

Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.

Ten 10 Query Tuning Techniques Every SQL Programmer Should K

Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.

Top 10 Mistakes of New IT Leaders

New IT leaders are rarely trained in the soft skills needed to be successful when put in charge. This one-hour session will explore the ten most frequent and challenging mistakes that new IT leaders make, as well as discuss methods for combating thos

An End-to-End Troubleshooting Checklist for SQL Server

Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

Top Ten Crucial Dev Skills to Make Your DBA Happy

Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration

Top 10 Administrator Mistakes on Microsoft SQL Server

Microsoft SQL Server is one of the easiest database to setup and administrate. But that doesn't mean it's problem free. Find out the most common DBA mistakes on SQL Server so that you can make sure not to make them!

Understanding and Preventing SQL Injection Attacks

SQL Injection attacks are one of the most common hacker tricks used on the web. Learn all about SQL Injection attacks in this perennially favorite session.

Understanding and Preventing SQL Injection Attacks

SQL injection can happen to you! But SQL injection is also very easy to prevent. Learn the ins and outs of SQL injection so that you don't become a victim.

Mastering SQL Server Performance & Optimization Strategies

Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.

Mastering TempDB

Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.

Your Performance Tuning Check List

Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements. You will learn about best practice configuration, SQL Server surface area, memory optimizations, isolation levels, Tempdb and transaction log configuration.

Performance Tuning Azure SQL Database

Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.

Tales from the Field - How to Avoid Burnout

In the fast paced "always plugged in world" we all live in today, getting burned out is something that you will most likely experience. That feeling of emotional and physical exhaustion that leaves you overwhelmed, trapped, defeated and stagnant can be unbearable. Taking the time to learn how to avoid burnout can be game-changer for your mental health, motivation, and productivity. In this 20 minute session, we will discuss ways to help prevent that burn out.

Your Performance Tuning Check List

Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements.

Erin & Monica’s Favorite SQL Stuff

Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.

Always Encrypted for Beginners

Let's learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt.

Getting Started with Learning Azure

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.

More than 'just' a Data Catalogue - Boarding the Tour through the Microsoft Purview Universe

What is Microsoft Purview? With the name changes, many tools under one umbrella, many users are confused what Microsoft Purview really includes. Board this session to learn what's included in the product suite and how these pieces work together.

The Top 5 Must-Cares for On-Boarding New Team Members

Technical on-boarding of new team members is one thing, integrating the person and its personality in the team is much more important! Join this session if you want to hear about our team on-boarding process, the prearrangements before the new colleague arrives, the welcome experience (we have cake for everyone) and how we try to make the start into our team a very good experience for everyone.

Data Governance with Azure Purview - Ask the Experts

Join us for an hour to examine data governance for business and how it can benefit you.

Data Governance with Azure Purview - Theory, Customer Insights and Demos

This data governance session guides you through the organization processes, policies and roles that are required for a successful data governance adoption. In addition to demos showing the possibilities of Azure Purview (the MS data governance service), we will share about experiences from our data governance workshops and adoption projects with our customers.

Why you should care about Data Community and how the community cares about you

Join me in this session to talk about WHY you should care about the Data Community and HOW every side of the relationship (the community and you) gets the best out of it.

The Microsoft Power Platform-What is it?

Building solutions based on powerful platforms is a key requirement for success. Join this session to see the PowerPlatform and its members (PowerApps, Power BI and Microsoft Flow) in action and how they can improve your daily work.

Microsoft Defender for SQL: Advanced Threat Protection

Microsoft Defender for SQL is part of the Azure Defender family and it protects SQL Server in two main ways. We'll cover the first way, Advanced Threat Protection. This is a feature with advanced security capabilities that detect anomalous activities that might access or exploit sql server, like SQL Injection.

Understanding Maintenance in Azure SQL

You know Microsoft handles patches and updates for your OS and SQL but what does that really mean? When does that maintenance occur, what might happen and do I have any control? Let's answer these questions and more in 20 minutes.

Women In Tech: Lifting as We Climb

In this session, you'll learn a few actionable steps that anyone can take to support women in tech where you work, every day. From meetings to project assignments, from hiring to sponsorship - women need allies and a support system to offset biases and patterns of behavior that work against their success. We'll start with a short presentation and then pivot to questions and discussions. Feel free to share your day-to-day experiences, and we'll help find actionable steps you can take to improve things.

Microsoft's Hybrid Data Strategy

Learn how to build the best hybrid data strategy with Azure Stack and Azure Arc.