2013
Pluralsight
Joe Sack
1h 27m
English

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.

01. Course Introduction
01. Course Introduction.wmv
02. A Myriad of Arguments.wmv
03. Why Not Use the GUI .wmv
04. Course Structure.wmv

02. Creating a Database
01. Module Introduction.wmv
02. Demo CREATE DATABASE Simple Version.wmv
03. Demo Defining Files with Your Database Creation.wmv
04. Demo Creating a Database with Multiple Data Files.wmv
05. Demo Creating a Database with a User-Defined Filegroup.wmv
06. Demo Defining Collation.wmv
07. Demo Recovery Models.wmv
08. Demo Database Ownership.wmv
09. Demo DB_CHAINING and TRUSTWORTHY.wmv
10. Demo Creating a Database by Attaching a File.wmv
11. Demo Creating Database Snapshots.wmv
12. Demo Accommodating FILESTREAM Data.wmv
13. Demo Containment Settings.wmv
14. Module Summary.wmv

03. Modifying Files and Filegroups
01. Module Introduction.wmv
02. Demo Adding and Removing Files.wmv
03. Demo Adding and Removing Filegroups.wmv
04. Demo Changing Growth Options.wmv
05. Demo Relocating User Database Files.wmv
06. Demo Changing a Logical File Name.wmv
07. Demo Making a Filegroup Read-Only.wmv
08. Module Summary.wmv

04. Changing Database Configurations
01. Module Introduction.wmv
02. Demo Changing Compatibility Level.wmv
03. Demo Changing AUTO Options.wmv
04. Demo Changing Database State.wmv
05. Demo Making a Database Read-Only.wmv
06. Demo Restricting Database Access.wmv
07. Demo Changing Recovery Models.wmv
08. Demo Changing Page Verification Options.wmv
09. Demo Changing Target Recovery Time Options.wmv
10. Demo Changing Collation.wmv
11. Demo Enabling Snapshot Isolation Options.wmv
12. Demo Modifying ANSI Options.wmv
13. Demo Renaming a Database.wmv
14. Demo Change Tracking Configuration.wmv
15. Demo Enabling Transparent Data Encryption.wmv
16. Demo Changing Security Options.wmv
17. Demo Enabling and Changing Service Broker Options.wmv
18. Database Mirroring and Availability Group Settings.wmv
19. Demo Changing Containment Settings.wmv
20. Module Summary.wmv
21. Course Summary.wmv

http://pluralsight.com/

Download File Size:307.88 MB

---