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: Suggested Changes After an Upgrade - Part 2: Patching and Compatibility Levels

  • ·Skill level: 300 (Intermediate)
  • ·Run Time: 13:45
  • ·Instructor: Scott Whigham

Description:

This video will be a demonstration of the concepts discussed in the previous video on patching and compatibility changes for your SQL Server 2008 installation.

Highlights from this video:
  • How do I know which databases have been upgraded from a prior version?
    • Viewing compatibility levels
    • Why wouldn't I upgrade all my databases to SQL 2008 compatibility level?
  • About the different compatibility levels
  • Changing compatibility levels in the GUI
  • How to view all compatibility levels for every database
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
1 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
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.