This video is from our "SQL Server 2008 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: Databases in SQL Server 2008: The Data File and the Transaction Log

  • ·Skill level: 200 (Beginner - Intermediate)
  • ·Run Time: 11:00
  • ·Instructor: Scott Whigham

Description:

In this chapter we will take a look at databases in SQL Server 2008. We'll start off in this video with a great overview of what files the database is made of.

Highlights from this video:
  • About files in a database
    • Data files
    • Transaction log files
  • "Write Ahead Logging" in SQL Server
    • Demonstration
  • Writing transactions in SQL Server
    • Demonstration and samples
and much more

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Chapter 4: Working with Databases
Databases in SQL Server 2008: The Data File and the Transaction Log
2 Databases in SQL Server 2008: System Databases
3 Databases in SQL Server 2008: The Different Types of Databases
4 Creating SQL Server Databases - Part 1
5 Creating SQL Server Databases - Part 2
6 Creating SQL Server Databases - Part 3
7 Creating SQL Server Databases - Part 4
8 Creating SQL Server Databases - Part 5
9 Creating SQL Server Databases - Part 6
10 Creating SQL Server Databases - Part 7
11 Creating SQL Server Databases - Part 8
12 Creating SQL Server Databases - Part 9
13 Creating SQL Server Databases - Part 10
14 How to Configure a SQL Server Database - Part 1
15 How to Configure a SQL Server Database - Part 2
16 How to Configure a SQL Server Database - Part 3
17 How to Configure a SQL Server Database - Part 4
18 How to Configure a SQL Server Database - Part 5
19 An Overview of Defragmenting Indexes - Part 1: Indexes and Page Splits
20 An Overview of Defragmenting Indexes - Part 2: How to Defragment Your Database
21 An Overview of Defragmenting Indexes - Part 3: How to Defragment Your Database
22 An Overview of Partitioning - Part 1: What is Partitioning?
23 An Overview of Partitioning - Part 2: How to Partition Tables and Indexes
24 An Overview of Partitioning - Part 3: How to Partition Tables and Indexes
25 Managing Database Files - Part 1: Removing Databases and Using SQL Scripts
26 Managing Database Files - Part 2: Removing Databases and Using SQL Scripts
27 Managing Database Files - Part 3: How to Shrink a Database and Files
28 Managing Database Files - Part 4: How to Shrink a Database and Files
29 Suggested Changes After an Upgrade - Part 1: Patching and Compatibility Levels
30 Suggested Changes After an Upgrade - Part 2: Patching and Compatibility Levels
31 Suggested Changes After an Upgrade - Part 3: Configuration Changes

NOTE: This video is part of our SQL Server 2008 Database Administration course.
This video is from Chapter 4: Working with Databases

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.