SQL Server: Database Creation, Configuration, and Alteration

Learn how to create and configure databases, files, and filegroups correctly, for developers and DBAs from SQL Server 2005 onward
Course info
Level
Intermediate
Updated
Dec 17, 2013
Duration
1h 27m
Table of contents
Course Introduction
Creating a Database
Modifying Files and Filegroups
Changing Database Configurations
Description
Course info
Level
Intermediate
Updated
Dec 17, 2013
Duration
1h 27m
Description

SQL Server databases have a wide variety of configuration options and this demo-centric course shows the options available when creating a database, and how to modify a databases's configuration after it has been created, including adding and removing files and filegroups. This course is perfect for developers, DBAs, and anyone responsible for creating and configuring SQL Server databases, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.

About the author
About the author

Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.

More from the author
More courses by Joe Sack