How do you test your data projects? Do you even test? Let's face the truth that data processing solutions are very rarely tested ... So let's start with fundamentals of (not only data warehouse) testing.
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
This demo-heavy session will show you advanced methods Paul's used extensively over the years to salvage data for real-life clients after catastrophic corruption.
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.
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.
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 and optimized it for the Edge.This session explores customer implementations with Azure SQL Database Edge, along with new product features.
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.
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.
Learn the four core practices which enable high performance for database development and delivery.
SQL Server 2019 comes with Python as an installation option. Let’s use this to gather data from various sources to create your test and development data.
Learn common patterns for testing data, and the anti-patterns that trip developers up.
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.
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!
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.
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!
<<123>>