If you work with SQL Server databases, you work with filegroups. Learn what filegroups are, cover best practices for using them, and see them in action! Bring your hard hat – we’re diving into the database structure!
Did you enjoy this session? There’s more where that came from! I’ll be presenting “The What, Why, and How of Filegroups” at PASS Summit on Wednesday, November 7. This session is 75% demos – come see filegroups in action!
Every DBA needs to know how to create and maintain filegroups because they are part of every SQL Server database. Filegroups affect the performance, maintenance, and security of your data. What are filegroups, and how do you use them?
In this session, we’ll see how to create filegroups, create objects in them, move objects between them, and perform maintenance on them. We’ll also walk through piecemeal restores. The information in this session will help you create databases that perform better and are easier to maintain.