Users Online
· Guests Online: 61
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - SQL Server Database Creation, Configuration and Alteration
DEMO - SQL Server Database Creation, Configuration and AlterationMicrosoft Technologies Courses |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 01.04.16 | 814 | No Rating | |
| 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. TOC Course Introduction4m 7s Course Introduction0m 55s A Myriad of Arguments0m 45s Why Not Use the GUI?1m 38s Course Structure0m 49s Creating a Database34m 41s Module Introduction0m 50s Demo: CREATE DATABASE Simple Version4m 46s Demo: Defining Files with Your Database Creation3m 27s Demo: Creating a Database with Multiple Data Files2m 5s Demo: Creating a Database with a User-Defined Filegroup2m 6s Demo: Defining Collation2m 26s Demo: Recovery Models2m 18s Demo: Database Ownership1m 38s Demo: DB_CHAINING and TRUSTWORTHY2m 1s Demo: Creating a Database by Attaching a File2m 34s Demo: Creating Database Snapshots3m 27s Demo: Accommodating FILESTREAM Data3m 19s Demo: Containment Settings3m 19s Module Summary0m 25s Modifying Files and Filegroups14m 21s Module Introduction0m 43s Demo: Adding and Removing Files2m 9s Demo: Adding and Removing Filegroups2m 36s Demo: Changing Growth Options2m 12s Demo: Relocating User Database Files2m 57s Demo: Changing a Logical File Name1m 12s Demo: Making a Filegroup Read-Only2m 14s Module Summary0m 18s Changing Database Configurations34m 19s Module Introduction1m 4s Demo: Changing Compatibility Level1m 37s Demo: Changing AUTO Options3m 40s Demo: Changing Database State1m 31s Demo: Making a Database Read-Only1m 55s Demo: Restricting Database Access3m 21s Demo: Changing Recovery Models0m 43s Demo: Changing Page Verification Options1m 51s Demo: Changing Target Recovery Time Options1m 17s Demo: Changing Collation1m 11s Demo: Enabling Snapshot Isolation Options1m 29s Demo: Modifying ANSI Options0m 53s Demo: Renaming a Database1m 31s Demo: Change Tracking Configuration3m 17s Demo: Enabling Transparent Data Encryption2m 8s Demo: Changing Security Options1m 53s Demo: Enabling and Changing Service Broker Options2m 19s Database Mirroring and Availability Group Settings0m 34s Demo: Changing Containment Settings1m 8s Module Summary0m 37s Course Summary0m 20s | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.