JumpStart TV SQL Channel

The SQL Channel

Sponsored Ads

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.

Fixed DB Roles in SQL Server 2005 (Watch it later!)

	Featured Video
Date Published: Monday, December 15, 2008 Author: Brian Kelley Rating: 4.30

Description: In this video for beginners Brian covers the fixed database roles available in SQL Server 2005. He covers what permissions are assigned to each fixed database role.

New Releases

Configuring Network Settings for SQL Server (Watch it Later!)

Date Published: December 15, 2008

Author: Brian Kelley

Rating: 4.50

Description: In this video Brian goes over the different options available for communicating with a SQL Server instance over a network. He then shows you how to enable and disable those options using the SQL Server Configuration Manager. Understanding these settings is important - they rarely change, but when they do, you'll want to know what it all means!

	Using Client Statistics (Watch it Later!) Date Published: September 09, 2008 Author: Grant Fritchey Rating: 3.80 Description: This video explains what client statistics are and how to use them when tuning queries.

Enumerate SQL Server Databases using SMO (Watch it Later!)

Date Published: September 09, 2008

Author: Tim Mitchell

Rating: 4.26

Description: As a DBA it's common to need to loop through all databases on a server to apply a change or check a setting - perhaps making sure that auto shrink is not on. Lots of ways to do the loop, but one way is to use SQL Management Objects (SMO) and you may find it to be a surprisingly elegant approach. Watch this short video to learn the basics of the loop, see Tim's profile for a ton of other content on SMO.

	Basic Formatting with SQL Server Reporting Services (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.04 Description: This video shows you how to do some basic formatting with the Format property of a field. The video also gives a basic overview of how to use an expression to change the properties of a field.

Ordering Full Text Index Search Results by Relevance (Watch it Later!)

Date Published: November 06, 2008

Author: Robert Cain

Rating: 4.47

Description: Full text search provides the ability to search documents and text within SQL Server. There are several ways to query full text indexes. This video by MVP Robert Cain shows you how to return the results of a full text index query ordered by relevance.