Introduction to SQL Server Essential Concepts on SQL Managed Instance

2022

TL; DR

When I first started learning about SQL Server, really deeply learning, there were a few “key” concepts that you hear repeated often by top speakers and SQL MVP’s. Internals, recovery models, and backups. They are interconnected. As the learning continued, it was self-evident how understanding basic data internals with pages, extents, and allocation bitmaps or database recovery models, the transaction log, and VLF’s. They affected not just SQL Server but the way you make decisions in order to determine how best to use SQL Server to support your business. This session enables you to have that core set of understanding required for advanced SQL learning. Feedback link: https://sqlb.it/?326128

Session Details

When I first started learning about SQL Server, really deeply learning, there were a few “key” concepts that you hear repeated often by top speakers and SQL MVP’s. Internals, recovery models, and backups. They are interconnected. As the learning continued, it was self-evident how understanding basic data internals with pages, extents, and allocation bitmaps or database recovery models, the transaction log, and VLF’s. They affected not just SQL Server but the way you make decisions in order to determine how best to use SQL Server to support your business. This session enables you to have that core set of understanding required for advanced SQL learning.

Feedback link: https://sqlb.it/?326128

3 things you'll get out of this session

Bradley Ball's previous sessions

From Beginner to Certified: A Fabric Analytics Engineer Workshop

In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.

Indexing Internals for Developers & DBAs

This is a dive into how indexes work within SQL Server. The goal of this session is for attendees to gain a greater understanding of how Indexes work and how to use them to gain performance.

What we’ve learned running a YouTube channel (so far)

This session is suitable for anyone who is interested in starting or growing their own YouTube channel, or who wants to learn more about the YouTube ecosystem.

Soft Skills eat Technical Skills for Breakfast

Over the years I’ve faced some very difficult situations. Talking down angry customers, de-escalating tense situations, and focusing on the right outcomes. There are a few key books that cover these concepts. In 20 minutes I will tell you what they are, why they are important, and how they saved me more than a few times.

The Most Powerful Azure Service You’ve Never Heard Of

Join Patrick Leblanc from the Power BI CAT team, Josh Luedeman, and Bradley Ball from the Azure FastTrack PG as we talk about the most powerful Azure Service you’ve never heard of. If only you knew the name of the service. Come to this session, and you’ll never forget it!

Migration to Azure Customer Experiences & Best Practices

How to create a roadmap to migrate to Azure, best practices, and using Azure Migrate to start, & customer stories

Inside the Query Optimizer

In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way

BI DBA Performance Tuning

Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well