Monitoring a growing database environment: insights for success

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.

Blogging for the Tech Professional

Blogging is a fantastic way to attract prospective employers that want to learn more about skills. This can raise your profile, help you guide the interview process, and even help you become an MVP.

Including Your Database in a DevOps CI/CD Process

Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.

Get Testing with tSQLt

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.

Branding Yourself for a Dream Job

Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.

Continuous Integration for Databases

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.

Searching Binary Data in SQL Server 2012

A look at binary data in SQL Server and full-text searching of the content of binary files.

Preparation for Disaster

Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepa

Security techniques for cross database access

Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.

Partitioning for Beginners

Introduction of areas for partitioning for Beginners

Why is SQL Server waiting for what?

You are wondering why SQL Server is waiting endless for a request and you don't know what is going on inside? A look behind the curtain with comon scenarios will help you to understand and solve long waits in SQL Server.

Inside statistics-a guessing game

A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics

Deep dive into the secrets of Temporal Tables

Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.

Daily problems with indexing and its-possible-solution

This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution

Safe Landings: Self-care In A High Intensity Technological World

The world feels like speeding along faster than the speed of sound. It feels like we all need our own air traffic controller to keep us focused on the right parts of our work, our learning, and our life. If your job role is deemed critical, the stress of all of this seems magnified. How do I know? I've been in those roles and I've led teams who filled those roles. I've been the pilot and I've been the air traffic controller trying to look out for my team and still bring that project in for a safe landing. I've seen what works - and I've seen what doesn't.

Ground to Cloud: Your Migration Success Checklist

Cloud migration projects are often massive projects with sprawling scopes. Don't you want some help sorting through this enormous pile of work? Join an experienced cloud migration consultant for a targeted walkthrough of their cloud migration success checklist so you can make sure your project gets off to a good start and reaches a successful completion.

The Cloud Never Goes Down, Right?

In this session, we'll set you on the right path towards high availability and disaster recovery for common data architectures in the cloud by the end of this session.

Troubleshoot and Triage Like a Pro

Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.

Make A Company Conversational using Azure Cognitive Services

How can data professionals help a company deliver more personal and prompt communication to customers that are demanding it? Learn how data knowledge and the power of Azure Cognitive Services APIs can make that happen!

Turn Runbooks into Notebooks: ADS for the On-Call DBA

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!

Top 5 Tips to Keep Always On AGs Humming and Users Happy

Have you wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy.