SQL Server: Database Creation, Configuration, and Alteration

By Joe Sack
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
Course Introduction 1m A Myriad of Arguments 1m Why Not Use the GUI? 2m Course Structure 1m
Creating a Database
Module Introduction 1m Demo: CREATE DATABASE Simple Version 5m Demo: Defining Files with Your Database Creation 3m Demo: Creating a Database with Multiple Data Files 2m Demo: Creating a Database with a User-Defined Filegroup 2m Demo: Defining Collation 2m Demo: Recovery Models 2m Demo: Database Ownership 2m Demo: DB_CHAINING and TRUSTWORTHY 2m Demo: Creating a Database by Attaching a File 3m Demo: Creating Database Snapshots 3m Demo: Accommodating FILESTREAM Data 3m Demo: Containment Settings 3m Module Summary 0m
Modifying Files and Filegroups
Module Introduction 1m Demo: Adding and Removing Files 2m Demo: Adding and Removing Filegroups 3m Demo: Changing Growth Options 2m Demo: Relocating User Database Files 3m Demo: Changing a Logical File Name 1m Demo: Making a Filegroup Read-Only 2m Module Summary 0m
Changing Database Configurations
Module Introduction 1m Demo: Changing Compatibility Level 2m Demo: Changing AUTO Options 4m Demo: Changing Database State 2m Demo: Making a Database Read-Only 2m Demo: Restricting Database Access 3m Demo: Changing Recovery Models 1m Demo: Changing Page Verification Options 2m Demo: Changing Target Recovery Time Options 1m Demo: Changing Collation 1m Demo: Enabling Snapshot Isolation Options 1m Demo: Modifying ANSI Options 1m Demo: Renaming a Database 2m Demo: Change Tracking Configuration 3m Demo: Enabling Transparent Data Encryption 2m Demo: Changing Security Options 2m Demo: Enabling and Changing Service Broker Options 2m Database Mirroring and Availability Group Settings 1m Demo: Changing Containment Settings 1m Module Summary 1m Course Summary 0m
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
Joe Sack
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
SQL Server: Common Query Tuning Problems and Solutions - Part 2
Intermediate
2h 17m
Aug 11, 2014
SQL Server: Common Query Tuning Problems and Solutions - Part 1
Intermediate
2h 31m
Jul 7, 2014
SQL Server: Transact-SQL Common Table Expressions
Intermediate
1h 21m
Feb 14, 2014
More courses by Joe Sack

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT