SQL Internals, Recovery Models, and Backups - On Demand

Price: $199.00

Presented by Bradley Ball

Total Running Time: 183 minutes

When learning about SQL Server, there were a few key concepts that you often hear top speakers and SQL Server MVP’s repeat often: data and index internals, recovery models, and backups. SQL Server internals, recovery models, and backups are important and interconnected.

As you dive deeper into SQL Server, it becomes self-evident how understanding basic data internals with pages, extents, and allocation bitmaps – or database recovery models, the transaction log, and VLF's, or advanced backup options backups like stripping and piecemeal restores – impact the uses of SQL Server.

You also start to realize how essential index internals are to having your query choose the right index. This online training course will enable you to gain the core set of concepts required for advanced SQL learning.

By the end of this course students will learn:

  • ACID, concurrency within SQL Server, and an overview of lock, blocking, and latches
  • transaction log internals, how they affect your business, and how they work with relation to database backups
  • how business needs drive recovery time objective and recovery point objective. Experience a demo of a piecemeal restore

Session 1: SQL Recovery Models and Backups

The more you know about SQL Server, the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view, we know what databases, tables, and columns are. But what are full, simple, and bulk-logged recovery? What are the differences between full, transaction log, differential, or filegroup backups? What is a piecemeal restore? What is a stripped backup and how does it speed things up? What is a VLF and how does VLF fragmentation affect my SQL Server? How do VLF’s affect AlwaysOn, mirroring, change data capture, or use transactional replication? This session will cover these topics and more.

Session 2: Data Internals Deep Dive

As a DBA, you often learn backward. Most of the time, you get a DBA job and you have databases that have tables, and in those tables you have data. Nobody tells you that you have records, stored on pages, grouped in extents, assigned by allocation bitmaps, with IAM pages and allocation units that span partitions and filegroups.

During this session, we'll start at the bottom and build our way up. We'll cover byte swapping, bitmaps, and dive a little into decoding Hex and binary – working to give you a full understanding of database internals and how you use them every day!

Session 3: Indexing Internals

What are the secrets to making your queries run faster? Why does SQL Server use an index for some queries and not for others? What makes a good index? How many indexes should I have? Have you ever asked these questions?

When you want to understand an application, you look at its core architecture. Underneath the covers SQL Server is just a C++ application. Together, we will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.

About our instructor:

Bradley Ball is a Microsoft SQL Server MVP with more than a decade of experience. He spent 8 years working as a defense contractor for clients such as the US Army, The Executive Office of the President of the United States, and Publix Supermarkets. Currently, Bradley is the Data Platform Management Lead for Pragmatic Works and Microsoft VTSP. He has presented at many SQL Saturdays, PASS SSUG's, SQL Rally, IT/Dev Connections, SQL Live 360, and the PASS Summit 2011-2014. Bradley can be found blogging on sqlballs.com about SQL Server or anything else that interests him.


Customer Service

Need to be invoiced or interested in registering 2 or more people? Please contact our customer service team at service@sqlmag.com or by phone at 800-262-1954 or 913-967-1719. Invoicing options and group discounts are available.


Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×