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
Rating
(141)
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
Rating
(141)
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
Section Introduction Transcripts
Section Introduction Transcripts

Course Introduction
Hi this is Joe Sack from SQLskills. com and I'm recording this course for Pluralsight. This is the SQL Server: Database Creation, Configuration, and Alteration course. And you're watching the introduction where I'll briefly describe what to expect over the modules that make up this course. So the overall subject of creating and working with databases isn't a very difficult one, but if you're new or relatively new to the subject, there are several questions that you might have along the way. Including questions about which of the many options are actually necessary to modify and designate or which options should you usually change or which ones should be left unchanged. And you might also wonder about any configurations that can generally be dangerous to manipulate versus those changes that have a low impact.

Creating a Database
Hi this is Joe Sack from SQLskills. com and I'm recording this course for Pluralsight. This is the SQL Server: Database, Creation, Configuration, and Alteration course. And you're watching module 2, where we'll cover how to create a new database using Transact-SQL. In this module we'll cover how to create a new database using Transact-SQL and we'll cover how to create a database, how to configure the associated database files and file groups. How to configure file settings, how to configure key settings like recovery model, security options, and collation. And how to create database snapshots, how to enable support for file stream data, and lastly how to enable partial containment, something that was introduced in SQL Server 2012.

Modifying Files and Filegroups
Hi this is Joe Sack from SQLskills. com and I'm recording this course for Pluralsight. This is the SQL Server: Database Creation, Configuration, and Alteration course. And you're watching module 3 where we'll cover how to modify files and file groups for an existing user database. This module will cover how to modify files and file groups for an existing user database using Transact-SQL. We'll cover how to add, remove, and modify files. Add, remove, and modify file groups, how to change growth options, relocate files to new locations, change the logical file names, and make all files in a file group read-only.

Changing Database Configurations
Hi this is Joe Sack from SQLskills. com and I'm recording this course for Pluralsight. This is the SQL Server: Database Creation, Configuration, and Alteration course and you're watching module 4 where we'll cover how to change database configurations using Transact-SQL. In this module we'll cover how to change a variety of database configurations from common ones to a few uncommon changes as well. We'll cover how to change database compatibility levels, how to configure the various auto options, and how to change database state. We'll go over how to make the entire database read-only, how to restrict database access, change recovery and recovery time options, change options like page verification and snapshot isolation options. We'll cover how to enable change tracking, transparent data encryption, and how to enable security and also service broker options. And lastly we'll cover how to convert an uncontained database to a partially contained database.