SQL Server: Database Creation, Configuration, and Alteration

WMV | VC-1 384kbps | English | 1024x768 | 15fps | 1h 27mins | WMA2 stereo 192kbps | 355 MB

Genre: Video Training

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.

│ sql-server-creation-config-alteration.zip

│

├───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