Thursday, January 10, 2008

Free Transact SQL Video Tutorial: 01 - An Introduction to Datatype Conversion

01 - An Introduction to Datatype Conversion - download
Datatype conversion is what we, as developers, have to deal with on a daily basis. No matter what the language, data type conversion is a daily event. This video helsp introduce the concept from a SQL Server-specific standpoint.

Highlights from this video:
  • Overview of the various datatypes available in SQL Server
    • Numbers
    • Strings
    • Dates
  • Differences between various datatypes
  • Using 'SELECT 123' statements and how SQL Server implements such queries
  • How SQL Server performs datatype conversions in expressions
and much more
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 3:43 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - download
IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: identity, update identity, autonumber, auto-number, auto number, seed, increment, beginner, beginning, for beginners, introducti

posted by Scott Whigham @ 3:43 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Setup Your DHCP Server

Setup Your DHCP Server - download
Grant Moyle teaches you how to setup your DHCP server so that you can allocate IP addresses dynamically. You'll use the Add/Remove Windows Components dialog box to add/modify your Windows installation for DHCP and then configure the server to assign dynamic IP addresses. You'll also pick up tips on subnetting and creating/working-with subnet masks
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: DHCP server setup

posted by Scott Whigham @ 3:42 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Build Your First Domain Controller

Build Your First Domain Controller - download
This video is perfect for helping you understand (a) the requirements for Active Directory setup, and (2) the setup and usage of your first domain controller. If you haven't used DCPromo before this is the perfect intro video for using DCPromo to promote a machine to become a domain controller. You'll take an existing fresh install of Windows Server 2003 and promote it to a domain controller. You'll assign static IP addresses, add domain accounts and more. This video could also be titled 'Add the First Domain Controller to Your Active Directory'
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Windows 2003 Add New Domain Controller, Create Active Directory using DCPromo, beginner, beginning, for beginners, introduction,

posted by Scott Whigham @ 3:41 PM   0 comments links to this post

Free SharePoint Video Tutorial: How to Customize the Title Bar of Your SharePoint Site

How to Customize the Title Bar of Your SharePoint Site - download
This video will demonstrate how you can customize the title bar across each and every page of your SharePoint site, how to add a static graphic from a port, and how to use a site theme

Highlights:
  • How to use a customized color scheme on your WSS site
  • How to add a graphic to your title bar
  • Customizing graphic hover description
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: customize title bar, add graphic, site theme, customizing wss site

posted by Scott Whigham @ 3:41 PM   0 comments links to this post

Free SharePoint Video Tutorial: Accessing the SharePoint Site as an Anonymous User (Visitor)

Accessing the SharePoint Site as an Anonymous User (Visitor) - download
In this video you will be learning all that visitors, or anonymous users, can do on a SharePoint site. Some key things outlined in this video are how to add new vistors to the site, how visitors can view shared documents, and how to see the results of a survey as a visitor.

Highlights:
  • How to view documents as visitor on a SharePoint site
  • What a visitor on a SharePoint site can access
  • How to see the results from a survey as a visitor
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Anonymous User, Visitor, access, add visitors,permissions

posted by Scott Whigham @ 3:41 PM   0 comments links to this post

Free Exchange Server Video Tutorial: Windows Services: Explanations and Best Practices

Windows Services: Explanations and Best Practices - download
If you've ever looked in the Services applet and wondered 'What does that service do?' then this video is for you! Grant Moyle, veteran Windows trainer and consultant, explains the details of some of the most common services you'll see in Windows. All Windows admins should view this video - it is essential knowledge for any sysadmin
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: windows 2003 services

posted by Scott Whigham @ 3:40 PM   0 comments links to this post

Free Exchange Server Video Tutorial: Storage Groups: What Are They and How They Work

Storage Groups: What Are They and How They Work - download
Storage Groups are inherent to Microsoft Exchange and learning the details on storage groups is a requirement for all Exchange administrators. This excellent video from Exchange guru Grant Moyle is a great tutorial on working with storage groups and the differences between the Standard and Enterprise editions with respect to working with storage groups.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: understanding Exchange storage groups, exchange storage group tutorial, how to work with Exchange storage groups, beginner, begi

posted by Scott Whigham @ 3:40 PM   0 comments links to this post

Free SQL Server Video Tutorial: Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life

Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life - download
Think of this video as the introduction to Design Patters and SQL. This video, recored by Scott Whigham, walks you through the idea of using patterns to simplify your SQL programming. Design Patterns are in nearly every modern language yet they are not often seen in SQL. This video shows you the basics of design patterns and how to use some common patterns. It is suggested that you watch this video before continuing on to the other Design Pattern videos.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: design pattern, go4

posted by Scott Whigham @ 3:39 PM   0 comments links to this post

Free SQL Server Video Tutorial: Pt. 1 - An Introduction to Using Views in SQL Server

Pt. 1 - An Introduction to Using Views in SQL Server - download
Who uses views? We all do! Every developer, DBA, business analyst, systems analyst, manager, CEO, etc uses views to access the data in the database. Views make life so much easier - they are, for many people, the first choice to simplify query-writing and/or create reusable queries.

This video, recorded by resident expert Scott Whigham, is a great introduction to using views and helps with:
  • When should I use a view?
  • Should I use a view or a stored procedure?
  • What is the basic syntax for creating views in SQL Server?
and much more.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql view, stored query, stored queries, views, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 3:39 PM   0 comments links to this post