Friday 1:50 PM - 3:00 PM · Room 347

Introduction to SQL Server Essential Concepts

Bradley Ball

Microsoft - Sr. Cloud Solution Architect

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 or advanced backup options backups like stripping and piecemeal restores affected the uses 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.