Understanding SQL Server 2008 Data, Storage, and Transaction Logging Architecture

Register Login

Friday, May 18, 2012

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos Database Architecture

Understanding Database Architecture

In this tutorial, you will learn the following:

Schema and Data Structure (Objects)
Storage Architecture
- Data Blocks, Extents, and Segments
- Storage Allocation
- Managing Extents and Pages
- Tablespaces and Datafiles
- SQL Server Data Files
- Mapping of Tablespaces and Filegroups
Logging Model
Data Dictionary

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

Connecting and Reviewing Databases

In this tutorial you will see how to:

Connect to an instance
Review system databases
Review application or user databases

Review Catalogs & Data Dictionary

In this demonstration you will learn how to:

View the dictionary with object explorer
View the data dictionary with catalog views
View the data dictionary within a database
View the data dictionary via system stored procedures

Understanding SQL Server 2008 Data, Storage and Transaction Logging Architecture

In this module, you will learn about schema and data structure (objects), storage architecture, logging model, and the data dictionary.

Privacy Statement

Terms Of Use