A collection of videos for the DBA.

+5 Wisdom - Learn to Ask Better Questions to Solve the Right Problems

By asking the right questions we can solve the actual problem - not only the problem we think we are facing. Take a step back, look further, and ask better questions. We'll show you how.

Break five common myths about SQL Server backup

In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.

Built-in Intelligence with Azure SQL and SQL Server 2022

"Learn about the Intelligent query processing feature family such as improvements to memory grant feedback, degree of parallelism (DOP) feedback, parameter sensitive plan optimization, and more - that help business-critical workloads run at scale, without changing your application code. We will cover the intelligent database feature family, the database compatibility levels, and troubleshooting with query store hints."

Don’t Let Your Permissions Be Hijacked!

Learn how malicious users can lure a power user such as sysadmin to run code that performs action to the benefit of the evil user by something I call permission hijacking and what means you can take to prevent this from happening.

Data Modernization in a Hybrid World

Join Dell for an overview of the data journey, moving from consolidation on modern architectures, to Linux, to containers, to true native hybrid cloud for all your data “things”. We’ll touch on the realities that we see with all customers and Dell partners to further your journey with a holistic model approach.

SQL Server 2022 hidden gems

SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.

Hear me out - Don't go offline because of your index deployment strategy

Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.

Unlocking the Power of WhoIsActive

Discover better ways to monitor SQL Server activity with WhoIsActive

How To Get the Auditors Off Your Butt with dbachecks

Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.

Dell and Azure Arc-enabled data services - SQL MI Business Critical

Are you developing or expanding your data services estate and need insights on how to plan, deploy and service hybrid data solutions? Come hear from technical experts from Dell Technologies on how to meet the most demanding mission critical requirements for your business with fully-automated and consistent data solutions built around Azure Arc–enabled data services. Attendees will hear real world approaches to ensuring that solutions are successfully deployed, perf and business continuity exceed business expectations, optimize IT resources, and simplify Dev/Ops with predictability.

SQL Migrations to Azure Made Easy

In this session we will demonstrate how you can leverage the innovations of Microsoft’s Migration Tools to evaluate the impact of your SQL migration to the business and accelerate migrations with optimized speed. Have the opportunity to see how new migration extensions available in Azure Data Studio can support routine, mid-scale migrations" to boost your team productivity.

The SQL Leadership Panel

Bring all your questions about the strategy and future of Microsoft SQL to the leadership team of Microsoft in a panel hosted by Bob Ward, Principal Architect at Microsoft

From Your Couch to the Cloud: When and Why to Choose the Azure Portal

In this session you'll learn how to get the most out of the Azure Portal and how to maximize its unique capabilities for Azure SQL administration.

Azure SQL Managed Instance Roadmap

Learn more about the next wave of innovation coming to Azure SQL Managed Instance at this session hosted by the engineers from the product group.

SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy

Join Dell for an overview of new capabilities with SQL 2022 and storage backup and recovery. At Dell Technologies we have known the power of storage snapshots for over a decade. Storage snapshots are a fundamental feature in Dell PowerStore and the rest of the Dell storage portfolio. They are a powerful feature that allows point-in-time volume copies to be created and recovered in seconds or less, regardless of size. For SQL 2022, one of the most exciting is the Transact-SQL snapshot backup feature. This is a gem that can transform your backup and recovery strategy and turbocharge your database recoveries!

Next Level Availability on SQL Server 2022

Learn all about the availability improvements for the most cloud-enabled SQL Server 2022 release covering improvements that are available by default and new capabilities database administrators can enable giving way to a highly available and performant platform.

SQL Server 2022 migrations with dbatools

Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.

What the heck is a checkpoint, and why should I care?

This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.

Azure Data Studio and the Surprises Inside

If you're not sure whether you're leverating Azure Data Studio to it's full capability, then attend to this session to discover the bits you might be missing.

SQL Server 2022 and the Wheel of Power

Come learn about the latest major release of SQL Server and the "wheel of power" with capabilities across hybrid, built-in query intelligence, core database engine, data virtualization, and T-SQL. This is one of the most power-packed set of new capabilities in a SQL Server major version ever and this session is the one you will want to attend to learn about all of them.

Banishing Slow Queries with Intelligent Query Processing

An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,

SQL Server 2022 - the most Azure-enabled SQL Server yet

Learn how SQL Server 2022 allows you to achieve business continuity, real-time analytics over operational data, manage, secure and govern data centrally by integrating with Azure services such as Managed Instance, Microsoft Purview, Microsoft Defender and Azure Synapse.

The Most Important Performance Factor in SQL Server and Azure SQL

If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.

A to Z Azure SQL Security Concepts

Planning to move your databases to the cloud but seriously doubt if your data is 100% secure? No matter if you are on-prem or in the cloud, making sure your data is protected in every angle possible is the most crucial and important step in building a secure data tier of an application. Let's dedicate this session to knowing the different multi-layer defense-in-depth security techniques and strategies available to armor your Azure SQL database. let's dive deep into each of these layers starting with the network security, Azure role-based access control (RBAC), data security at the row level, auditing, advanced threat protection, different layers of encryption, monitoring, and more. By the end of this session, you will have the knowledge to make the right security decisions for your environments and implement these techniques in securing your data.

Understanding Alert Fatigue

This session will explore the causes of alert fatigue and its impact on individuals and organizations.

Crossing The Streams: Adding PostgreSQL to Your SQL Server Skillset

It used to be easy to ignore, but times have changed. More and more we are required to manage multiple data platforms. As this information became more apparent, Redgate started down the journey to add additional RDBMS platform support to its amazing toolset. Join Grant Fritchey as he relates both Redgate's and his own personal journey of discovery on how to use the PostgreSQL system. Learn why it's important that you develop knowledge and skills. Discover some of the mechanisms that made this journey easier. Finally, find some ways to overcome the challenges you're likely to meet. It's a multi-platform world out there, this session will help you cope with it.

Analytics in SQL Server and Azure SQL Database

Join us to learn about the SQL Server and Azure SQL Database features that support analytical and HTAP/Translytical workloads.

Tidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers

The metaphorical tidy space not only leads to better performance, but it also creates budgetary space for new initiatives. This talk will discuss managing SQL Server and Azure SQL estates spread across multiple cloud services including Azure, AWS, and GCP.

Efficiency up, failed releases down; compliant production data for your test and dev environments

In this session, we’ll tackle the challenges that come with getting yours hands on quality data for test, QA, and CI practices.

Should We Defragment Indexes?

You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.

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.

Choosing the Right Data Store--An Overview of Azure Data Platform Choices

There are a lot of options in Azure for your data. In this session you will learn about the various options for how to store data fro your app, and a decision tree for how to make the best choices for your application.

Lift and Shift with dbatools - Azure SQL Managed Instance edition

Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.

The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance

In this session we’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides the ultimate freedom of movement between the two. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance. You don’t even need to migrate to the cloud to use it – remain running on your existing SQL Server and use the modern Azure services by offloading R/O workloads and analytics to the cloud. When ready to migrate, use it as the best possible minimum downtime migration option in Azure. Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.

A Capgemini Solutions Architect discusses common customer challenges, program trends & initiatives.

Industries ranging from government, healthcare, education, travel and finance. Capgemini’s Prashant Bhargava, shares his experience on typical customer challenges, pain points, trends and patterns. A minimum; you’ll see you’re not alone. At best; you might learn strategies for addressing common obstacles in these programs and initiatives. Join us for a thought-provoking discussion.

Get PaaS like benefits outside of Azure with Azure Arc enabled SQL Managed Instance

In this session, learn how you can modernize those SQL servers to a Kubernetes based Azure Arc enabled SQL managed instance and how you can get a PaaS like experience for your SQL Servers, in your own infrastructure. We will explore various areas such as: Architecture of Arc enabled data services Built-in automatic backups Built-in High availability Built-in Disaster Recovery Built-in Monitoring easy provisioning/deprovisioning etc. Plenty of demos included throughout.