Saturday, January 27, 2007

Visual C# Video Tutorial: Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server

Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server - view details
This introductory video talks to you about the Visual Studio and SQL Server Express Editions - the FREE editions of SQL Server and C#/Visual Basic (among others).

Highlights from this video:
  • Compare and contrast various Express Editions
  • Limitations of certain Express Editions
  • Updating the Express Editions
and much more.

If you are new to C#/SQL Server, THIS IS A GREAT FIRST VIDEO TO WATCH!

NOTE: This video is nearly identical to the 'What Are the Express Editions?' video
< /blockquote>
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: beginner, beginning, intro, introduction, msde, starter

posted by Scott Whigham @ 11:00 PM    

Exchange 2003 Video Tutorial: Global Settings: Mobile Services

Global Settings: Mobile Services - view details
Inside Exchange System Manager you'll find a listing for Global Settings - Mobile Services which allows you to configure how Exchange works with today's mobile devices (Exchange ActiveSync and Outlook Mobile Access [OMA]). If you have to support mobile devices with your Exchange server this is the video for you
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: configure global settings mobile services

posted by Scott Whigham @ 11:00 PM    

SQL Server 2000 Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - view details
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement in SQL Server
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql server performance, sql optimization, optimizing sql server

posted by Scott Whigham @ 11:00 PM    

Microsoft SQL Server Video Tutorial: How to Return Identity Value for a Just-Inserted Row

How to Return Identity Value for a Just-Inserted Row - view details
So many SQL developers use IDENTITY columns (a.k.a. sequences and/or auto-number columns) therefore this video is essential knowledge for SQL developers, DBAs, and even application developers. This tutorial focuses on working with IDENTITY columns as primary keys and how you can retrieve the just-inserted row's primary key value. Several techniques are discussed here with a final discussion on perhaps the "safest" (and recommended) technique.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: identity, @@identity, scope identity, scope_identity

posted by Scott Whigham @ 10:00 PM    

DTS Video Tutorial: Creating a Custom MMC to Manage Your SQL Server and DTS Packages

Creating a Custom MMC to Manage Your SQL Server and DTS Packages - view details
Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, says that this is one of the very first things that he does whenever he builds or works on a new SQL Server 2000/7.0 server; it's one of his favorite little tweaks for working with SQL Server. This video shows you how you can create your own "version" of the Enterprise Manager inside a custom MMC (Microsoft Management Console). Not only is this an easier to way to work with SQL Server but it shows that you know what you're doing when you sit down at a new SQL Server!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: custom MMC, how to customize MMC

posted by Scott Whigham @ 10:00 PM    

Exchange 2003 Video Tutorial: Installing Exchange 5.5 SP4 on NT4 Server

Installing Exchange 5.5 SP4 on NT4 Server - view details
This video in our series on installing a testbed for Exchange 5.5 migrations shows you how to install Exchange 5.5 SP4. In this video, Grant Moyle (author of LearnExchange.com) walks you through installing Exchange Server 5.5 SP4 on an NT 4.0 Server.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: service pack, sp, sp4, exchange 55

posted by Scott Whigham @ 10:00 PM    

Windows 2003 Video Tutorial: How to Remove a Computer (Windows XP) from the Domain

How to Remove a Computer (Windows XP) from the Domain - view details
At some point all administrators will need to remove a computer from the domain. This video helps you understand the effects of removing a computer from the domain and gives you many tips for safe removal
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: remove Windows XP machine from domain

posted by Scott Whigham @ 9:00 PM    

DTS Video Tutorial: Transform Data Task - An Overview of the Screens/Tabs

Transform Data Task - An Overview of the Screens/Tabs - view details
Transform Data Task - An Overview of the Screens/Tabs
To download this video, log in, then visit the video's deta il page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Transform Data Task - An Overview of the Screens/Tabs, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:00 PM    

Visual C# Video Tutorial: Pt. 3 - Our First Console Application

Pt. 3 - Our First Console Application - view details
Pt. 3 - Our First Console Application
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dos, command prompt, command line

posted by Scott Whigham @ 8:00 PM    

SQL Server 2000 Video Tutorial: Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices

Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices - view details
During the installation of SQL Server 2000 you are asked which Network Libraries you would like to choose (if you choose the Custom installation). For each Network Library, you must choose the Network Address. Which are the most common network libraries used? What are the defaults? What about TCP/IP ports - which TCP port should you use for SQL Server? This video helps you make intelligent decisions that will protect your SQL Server from hackers, worms and viruses
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql network libraries, sql server tcp port

posted by Scott Whigham @ 8:00 PM    

Exchange 2003 Video Tutorial: 5.5 Migration - Replicating Public Folders

5.5 Migration - Replicating Public Folders - view details
5.5 Migration - Replicating Public Folders
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: 5.5 Migration - Replicating Public Folders

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: Management Tools Install

Management Tools Install - view details
Whenever you have multiple domain controllers and an Exchange server on your network you often want to be able to manage the Exchange information from within the Active Directory Users and Computers MMC snap-in. This video guides you through setting up a domain controller to work with the Exchange screens for objects
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: install Exchange management tools

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: Configure Outlook 2003 for Exchange

Configure Outlook 2003 for Exchange - view details
Once you've installed Outlook as your mail client you'll need to configure Outlook to work with Exchange. Outlook is the primary client for Exchange so this is a very useful skill to have. In this video you'll learn about all the options available in Outlook for Exchange and, for those of you new to Outlook 2003, you'll get a quick tour of some of the features within Outlook that you can take advantage of for your Exchange users.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Install Outlook 2003 for Exchange, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 7:00 PM    

SQL Server 2005 Video Tutorial: Part 6 - Verifying Our Installation and Reviewing The Install Logs

Part 6 - Verifying Our Installation and Reviewing The Install Logs - view details
This is, as the title implies, Part 6 in our 7-part series on installing SQL Server 2005 for the first time. In this video, SQL guru Scott Whigham has finished the installation and shows you the logs that SQL Server uses to track the installation along with several of the changes that have now occurred on your system.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql install, setup, sql server log, setup log, sql set up logs, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

DTS Video Tutorial: Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task

Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task - view details
Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Using FOR XML Clauses in SQL Server

Pt. 1 - Using FOR XML Clauses in SQL Server - view details
The FOR XML clauses allow you to generate XML based on your SELECT statements. There are several different ways to generate XML - FOR XML AUTO, FOR XML RAW, FOR XML EXPLICIT, FOR XML PATH, and more. How do you know which to use? What's the difference between RAW and AUTO? Which of these can auto-detect relationships in the data?

Highlights from this video:
  • An overview of the different FOR XML options
  • When should I use FOR XML?
  • Using FOR XML RAW
  • USING FOR XML AUTO
  • Changes in SQL Server 2005
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sqlxml, msxml, sql xml, msxml4

posted by Scott Whigham @ 6:00 PM    

SQL Server 2000 Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constr aint

posted by Scott Whigham @ 5:00 PM    

Windows 2003 Video Tutorial: Creating OU, User and User Group Using VBScript

Creating OU, User and User Group Using VBScript - view details
Windows administration guru Grant Moyle walks you through the automation of your network users, OUs, and groups using VBScript. If you really want to learn the details and inner workings of your Active Directory, learn how to add items to the AD using scripts.

This video download also includes the .vbs files that you can use to do these same actions on your domain and it includes instructions on how to modify the files for your own use.

Highlights from this video:
  • Querying the LDAP using VBScript
  • Examining multiple language attributes in the Active Directory with scripts
  • GetObject(), SetInfo, ADSPath, Add, Put
  • LDAP://OU=Code Sample, dc=learnitfirst, dc=com
  • objGroup.Add objUser.ADSPath
and much more

NOTE: This video was a user request. Have a request? Send it to us here!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: scipting, object domain, ou, organizational units, GetObject, LDAP, objDomain.Create, SetInfo, vbscript, .vbs

posted by Scott Whigham @ 4:00 PM    

Exchange 2003 Video Tutorial: Using Full Plus Incremental with a Recovery Storage Group (RSG)

Using Full Plus Incremental with a Recovery Storage Group (RSG) - view details
You aren't limited to only restoring from full, incremental, differential and transaction logs. The Recovery Storage Group (RSG) is a great way to restore mailboxes. A must-see video
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: backup RSG, backup recovery storage group

posted by Scott Whigham @ 4:00 PM    

Windows 2003 Video Tutorial: Part 1 of 2 - RIS Setup for Windows XP Deployment

Part 1 of 2 - RIS Setup for Windows XP Deployment - view details
Remote Installation Services, or RIS for short (pronounced 'Rizz'), was a great new feature added to Windows 2003. This video, Part 1 of a two-part series, walks you through automated deployment of Windows XP using RIS. This first video walks you through setting up the package while Part 2 does the automated deployment
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: RIS Windows 2003

posted by Scott Whigham @ 3:00 PM    

SQL Server 2000 Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - view details
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql attack, sql security, sql hack

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: NT 4.0 Server TCP/IP (TCP, TCP/IP) Configuration

NT 4.0 Server TCP/IP (TCP, TCP/IP) Configuration - view details
NT 4.0 Server TCP/IP (TCP, TCP/IP) Configuration
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: NT 4.0 Server TCP/IP (TCP, TCP/IP) Configuration

posted by Scott Whigham @ 3:00 PM    

Free SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - download
If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole series on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this series will dig down in to the topics posed in this video and help you get started with SSIS the right way.

Highlights from this video:
  • Which tools do you use to schedule and execute SSIS packages?
  • What tool(s) do you use to edit and develop SSIS packages?
  • What can you do within SSMS (SQL Ser ver Management Studio)?
  • What can you do within BIDS (Business Intelligence Development Studio)?
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: in tro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

posted by Scott Whigham @ 2:00 PM    

Visual C# Video Tutorial: Pt. 2 - Building Our First Console Application

Pt. 2 - Building Our First Console Application - view details
This video continues our discussion of compiling and executing console applications with discussions on compiling assemblies (library components) and using multiple files.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: assemblies, assembly, multiple files

posted by Scott Whigham @ 2:00 PM    

SQL Server 2000 Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 2:00 PM    

Transact SQL Video Tutorial: Pt. 3 - Input Parameters and Variables

Pt. 3 - Input Parameters and Variables - view details
The bulk of your stored procedures will be dynamic, meaning that they will have parameters and those parameters will be used to make decisions (such as what rows to return). This video talks about how to create parameters and variables as well as working with default parameters ( to make a parameter optional instead of required, for example).
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: declare, local variable, argument

posted by Scott Whigham @ 1:00 PM    

SQL Server 2000 Video Tutorial: How to Change the SQL Server TCP IP Port Number Using the Server Network Utility

How to Change the SQL Server TCP IP Port Number Using the Server Network Utility - view details
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance - do you know? So does everyone else! One of the first things that a DBA does (if he/she wants to setup a secure SQL Server) if to change the default SQL Server port number from 1433 to something else. This video shows you the how, the how it works, and also gives recommendations for network libraries and more. This should be considered required viewing for all SQL Server DBAs.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: change sql tcp ip port number

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Installing NT 4.0 BDC

Installing NT 4.0 BDC - view details
Installing NT 4.0 BDC
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Installing NT 4.0 BDC

posted by Scott Whigham @ 1:00 PM    

Microsoft SQL Server Video Tutorial: SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins

SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins - view details
The most basic security in SQL Server starts with SIDs - security Identifiers. If you know someone's SID, then you can track them all through your SQL Server instance, for example. This video explains a little about the architecture of SQL Server by showing you the master database's sysxlogins table and how you manage and work with SQL Server Authentication logins. If SQL Server security is your job or you're an aspiring DBA, this is pretty much a must-watch video
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql sid, sa account

posted by Scott Whigham @ 12:00 PM    

Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - view details
AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for

posted by Scott Whigham @ 12:00 PM    

SQL Server 2000 Video Tutorial: Creating Linked Servers to Microsoft Access (SQL Server 2000)

Creating Linked Servers to Microsoft Access (SQL Server 2000) - view details
Linked servers are the SQL DBA's technique of writing a query against a "remote" data source (such as MS Access in this case). This video walks you through creating the linked server to an Access database (an .mdb file) and shows you how to query that using Transact-SQL.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: linked server, remote server, access data project

posted by Scott Whigham @ 12:00 PM    

Exchange 2003 Video Tutorial: Message Tracking Policy

Message Tracking Policy - view details
You'll learn how to manage Exchange by using policies. Policy management is far easier than individual server management for administrators managing multiple Exchange servers. Policies allow for conformity among multiple servers so that each server has the same settings.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Exchange message tracking policies, exchange policy

posted by Scott Whigham @ 11:00 AM    

SQL Server 2000 Video Tutorial: Creating Databases with the SQL Server Enterprise Manager

Creating Databases with the SQL Server Enterprise Manager - view details
The Enterprise Manager is probably the easiest tool for creating new databases and, in this video, Scott Whigham shows you all the details of creating databases with EM. This video talks about the options you are presented in the Enterprise Manager including the Logical Filename, physical filename, file growth options, and how collations can influence the database. This video is primarily aimed at those new to creating databases in SQL Server
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: create sql database, create sql server database enterprise manager

posted by Scott Whigham @ 11:00 AM    

DTS Video Tutorial: Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS

Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS - view details
This video could be subtitled, 'How to Import Very Complex Excel Spreadsheets into SQL Server the Easy Way' just for easier classification.

In this example, you'll learn how to deal with worksheets that have multiple data sets on them (multiple named ranges) so that you can load these into SQL Server. This is absolutely essential knowledge for anyone who works seriously with DTS! This video uses a complex Excel example and loads it into multiple SQL Server tables in one DTS package using the Import/Export wizard.

Highlights from this video:
  • Creating and managing named ranges in Microsoft Excel
  • Dealing with complex Excel spreadsheets and locating just one piece of data
  • Writing JOIN queries in Jet-SQL using the Query Builder
  • Best Practices for datatype mapping from Excel to SQL Server
  • Adding primary keys to the destination table
  • Writing ActiveX Script transformations using VBscript
  • Dealing with Sheet1$, Customers$, Orders$ and worksheets
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: named region, named range, set of cells, named cells, excel data, excel spreadsheet, subset, data type

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: 5.5 Migration - Preparing a Server for running Exchange 2003

5.5 Migration - Preparing a Server for running Exchange 2003 - view details
This video shows you best practices for preparing your server to run Exchange 2003
To download this video, log in, then v isit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Exchange server prep

posted by Scott Whigham @ 10:00 AM    

Visual C# Video Tutorial: Pt. 4 - Using the SQL Server Configuration Manager

Pt. 4 - Using the SQL Server Configuration Manager - view details
Pt. 4 - Using the SQL Server Configuration Manager
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql port number, server network utility, client network utility, services

posted by Scott Whigham @ 9:00 AM    

Exchange 2003 Video Tutorial: Installing Exchange 5.5 SP4 on NT4 Server

Installing Exchange 5.5 SP4 on NT4 Server - view details
This video in our series on installing a testbed for Exchange 5.5 migrations shows you how to install Exchange 5.5 SP4. In this video, Grant Moyle (author of LearnExchange.com) walks you through installing Exchange Server 5.5 SP4 on an NT 4.0 Server.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: service pack, sp, sp4, exchange 55

posted by Scott Whigham @ 9:00 AM    

Free Transact SQL Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - download
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.
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, auto number, sequence, surrogate key, alternate key

posted by Scott Whigham @ 8:00 AM    

Windows 2003 Video Tutorial: Using Recovery Console to Repair Disks

Using Recovery Console to Repair Disks - view details
This video shows you how to use the Recovery Console to repair a damaged Windows installation. While no one wants to have to use the Recovery Console, expert trainer Grant Moyle shows you all the details of this infrequently-used-yet-indispensable tool
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: windows 2003 recovery console

posted by Scott Whigham @ 8:00 AM    

DTS Video Tutorial: DTS Architecture - A Look at the MSDB System Stored Procedures

DTS Architecture - A Look at the MSDB System Stored Procedures - view details
If you want to learn the inner workings of DTS, you'll want to know about working within the MSDB database and it's stored procedures. This video talks about using the stored procedures to manage your SQL Server's DTS and how the Enterprise Manager uses these behind-the-scenes stored procedures for commonly used tasks.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sp_, sp_adddtspackage

posted by Scott Whigham @ 7:00 AM    

Windows 2003 Video Tutorial: Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup

Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup - view details