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: Lecture on What Are Instances and When Are They Appropriate

  • ·Skill level: 100 (Beginner)
  • ·Run Time: 09:45
  • ·Instructor: Scott Whigham

Description:

This video will take a formal look at SQL Server instances. In this video the author will discuss when to use instances, what purpose they serve, and clear up some licensing questions about them. The author's presentation is included with your download.

Highlights from this video:
  • What is an instance?
    • Default instance, Named instances
  • Common instance setup
  • What are single instances appropriate for?
  • When to use multiple instances
    • Mixed versions, Mixed editions, Mixed releases
  • Named instance rules
  • Instance licensing in 2008 compared to 2005
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)


NOTE: This video is part of our SQL Server 2008 Database Administration course.
This video is from Chapter 2: Installing and Upgrading to SQL Server 2008

Browse this course's videos now