SQL Server Administration & Maintenance

SQW02 SQL Server Database Administration for the Non-DBA


8:00am - 9:15am

Level: Introductory

Denny Cherry

Owner and Principal Consultant

Denny Cherry & Associates Consulting

Are you a developer or a sysadmin and you've just been handed a SQL Server database and you've got no idea what to do with it? This session will provide you with some of the answers you need. We'll 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.

You will learn:

  • About backing up databases
  • How to handle corruption
  • About compatibility levels