SQL Server Integration Services Tutorial Video - An Overview of t he Various Transformations Available, Part 2

SSIS 2008 Training Video: An Overview of the Various Transformations Available, Part 2

This is the second of three videos covering the various transformations available in SSIS.  This video will cover the next two transformation categories (row set transformations and split and join transformations).  

Highlights from this video:

• Row set transformations
• Create new rowsets
  
• Split and join transformations
  
• Splitting outputs to multiple destinations
  
• Joining multiple inputs into a single output
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Integration Services training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free Exchange Server training videos

SQL Server Video Tutorial - Creating SQL Server Databases - Part 2

MSSQL Server 2008 Video: Creating SQL Server Databases - Part 2

This SQL Server 2008 DBA tutorial comes from the LearnItFirst IT Training Video Library.

Creating SQL Server Databases - Part 2 (Tutorial)

More info about this video:

This instructional video will walk you through a brief overview of the system databases as well as demonstrate the process of creating a new database inside SSMS.

Highlights from this video:

• How to use the model database as a template database
  • Common table designs
• Creating a new database
  • Logical name
  • Path
  • Initial Size
  • Autogrowth

and much more

---

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

SQL Server Integration Services Training Video - What's New in SS IS 2008 - The Obvious Stuff

SQL 2008 Integration Services Tutorial: What's New in SSIS 2008 - The Obvious Stuff

This SSIS 2008 tutorial comes from the LearnItFirst IT Training Video Library.

What's New in SSIS 2008 - The Obvious Stuff (Video Tutorial)

More info about this video:

This video is the second of three in a series of what is new in SSIS 2008, that wasn't in SQL 2005.  If you are brand new to SSIS or came from SQL Server DTS or SQL Server 2000 this video, is not be absolutely necessary for you to watch.  This video will cover the "obvious" new or enhanced features.

Highlights from this video:

• Data Profile Viewer
  
• Data Profiling Task
  
• Data type alignment options
  
• Lookup Transformations
  
• Cache Connection Manager
  
• Cache Transform
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Integration Services training course.

SQL Server Tutorial - An Overview of Partitioning - Part 2: How to Partition Tables and Indexes

MSSQL Server 2008 Training Video: An Overview of Partitioning - Part 2: How to Partition Tables and Indexes

We'll continue our overview of partitioning by now discussing the requirements for creating partitions in SQL Server 2008.

Highlights from this video:

• About the requirements for creating partitions
  • Partitioning function
    • Example
  • Partition scheme
    • Example
  • Table/index

and much more

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free SQL Server videos

SQL Server Integration Services Tutorial - An Overview of SSIS fo r Newbies and Beginners, Part 2

SSIS 2008 Tutorial: An Overview of SSIS for Newbies and Beginners, Part 2

This SSIS 2008 tutorial comes from the LearnItFirst IT Training Video Library.

An Overview of SSIS for Newbies and Beginners, Part 2 (Tutorial Video)

More info about this video:

This video is the second part of an overview of SSIS, especially for newbies and beginners.  You will learn what you can use SSIS for, and what tasks SSIS can perform.
 
Highlights from this video:

• What is an ETL tool?
  
• Backups
  
• Essential Maintenance
  
• Data Mining
  
• File and Folder Management
  
• 6\
• 7
• 8
• 9

and much more

---

This video is part of LearnItFirst's SQL Server 2008 Integration Services training course.

SQL Server Video - Distributed Queries: How to Create and Manage Linked Servers

SQL Server Tutorial Video: Distributed Queries: How to Create and Manage Linked Servers

This SQL Server 2008 DBA tutorial comes from the LearnItFirst IT Training Video Library.

Distributed Queries: How to Create and Manage Linked Servers (Training Video)

More info about this video:

We are now going to discuss linked servers and distributed queries with a basic overview in this video that is more geared towards the database administrator.  We will learn about the advantages of using linked servers for repeated use.

Highlights from this video:

• Distributed queries overview
  
• What are linked servers? When are they used?
  
• Detailed demo of creating a new linked server
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

SQL Server Video Tutorial - Database Mirroring Best Practices

MSSQL Server 2008 Tutorial: Database Mirroring Best Practices

This video wraps up our overview of Database Mirroring with some best practices and frequently asked questions, including asynchronous mirroring versus synchronous mirroring, what safety levels are appropriate for your needs, and when to use Database Mirroring.

Highlights from this video:

• What does architecture refer to?
  
• Safety off versus safety full
  
• Bulk imports
  
• Database mirroring for local or metro-area networks
  

and much more

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

Related Links:

• Video detail page
• Course home page
• Free IT Training Videos
• Free SQL Server videos