SQL Server Administration & Maintenance

SQT09 Introduction to SQL Server Essential Concepts

12/04/2018

2:45pm - 4:00pm

Level: Introductory to Intermediate

Bradley Ball

Premier Sr. Consultant, Premier Support for Developers

Microsoft

When I first started learning about SQL Server, really deeply learning, there were a few "key" concepts that I would hear repeated often by top speakers and SQL MVPs: internals, recovery models and backups. They're 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 virtual log files (VLFs), or advanced backup options like stripping and piecemeal restores affected the use of SQL Server. 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.

You will learn:

  • How data is structured and stored in SQL Server
  • How recovery models, VLFs and backups impact your SQL Server decision making
  • High-level concepts to assist with future SQL Server learning