SQLShare SQL Channel

The SQL Channel

Tags

Most Watched Videos

	Speak Like a SSIS Developer (Watch it Later!)

	Creating a Basic SSAS Cube (Watch it Later!)

	Running and Scheduling SSIS Packages (Watch it Later!)

	Change Data Capture with SSIS (Watch it Later!)

	Using the File System Task in SSIS (Watch it Later!)

This channel is dedicated to SQL Server and the technologies that surround it. You'll find videos about SSIS, Replication, Performance and more. Check back daily for updated content.

Working with Foreign Keys (Watch it later!)

	Featured Video
Date Published: Friday, October 02, 2009 Author: Andy Warren Rating: 4.28

Description: This lesson explains how to use foreign keys to make sure valid data is entered and how to create foreign keys using the different techniques available in Management Studio. Foreign keys are an essential part of database design, definitely worth learning!

New Releases

	Computed Columns - Part 2 (Watch it Later!) Date Published: October 01, 2009 Author: Andy Warren Rating: 4.36 Description: Computed columns are an interesting alternative to expressions in a stand alone select or a select contained in a view. Not something you'll use often, but good to know how it works.

	Computed Columns - Part 1 (Watch it Later!) Date Published: October 01, 2009 Author: Andy Warren Rating: 4.27 Description: Computed columns are an interesting alternative to expressions in a stand alone select or a select contained in a view. Not something you'll use often, but good to know how it works.

	Using the Import/Export Wizard (Watch it Later!) Date Published: October 02, 2009 Author: Brian Knight Rating: 3.86 Description: A great demonstration of using the Import/Export Wizard that uses SSIS for the actual moving of data

	Use sp_MSForEachDB Instead of Your Own Loop (Watch it Later!) Date Published: October 02, 2009 Author: Andy Warren Rating: 4.24 Description: Did you know it's possible to loop through databases and tables without writing your own loop? That's right, SQL Server has a couple of stored procedures that handle the looping for you, all you provide is the work!

	Using OpenDataSource to Access Remote Data (Watch it Later!) Date Published: October 02, 2009 Author: Andy Warren Rating: 4.36 Description: OpenDataSource is an adhoc alternative to accessing remote data, whether it's another SQL Server or an Excel file. It makes a lot of sense to use it when you want to define the datasource at runtime.