SQL Server Administration and Maintenance

SQH08 SQL Server 2016 Database Administration for the Non-DBA


1:00pm - 2:15pm

Level: Introductory

Denny Cherry

Principal Consultant

Denny Cherry & Associates Consulting

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it? I've got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

During this session Microsoft MVP and Certified Master Denny Cherry will give you the basic information that is needed to get that new SQL Server that you've just been told that you need to manage running and safe. After this session you will be armed with the basic information needed to know how to properly backup the database so that you can recover it after a failure. You will learn how to properly maintain the database so that it runs at peek performance, while using the least possible space. You will also learn how to look for, and correct database corruption problems.