Wednesday, November 28, 2007

New Visual Basic Video Tutorial: Pt. 3 - More Expansive If Statements Using C# Generics and Select Case

Pt. 3 - More Expansive If Statements Using C# Generics and Select Case - view details
In this video tutorial, Scott will provide you with a realistic example of Select Case, the If operator alternative, as well as walk you through the process of writing more expansive If statements.

Highlights:

  • Generic collection and lists
  • With, For Each statements
  • Descision making techniques

��

��

��

��

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: Pt. 3 - More Expansive If Statements Using C# Generics and Select Case

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - How to Create and Use a Custom Event Log

Pt. 2 - How to Create and Use a Custom Event Log - view details
This second video in the series will show you the process of creating and using a custom event log

Highlights:

  • How to delete/create/change mapping
  • How to write to custom event log

��

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: Pt. 2 - How to Create and Use a Custom Event Log

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - How to Write to the Windows Application Event Log

Pt. 1 - How to Write to the Windows Application Event Log - view details
In this first video tutorial in the series, Scott will��talk about how to��write to the event log in Visual Basic and take you through the actual process as well as introducing you to some of the key elements of event logs.

Highlights:

  • Creatingand mapping��an EventSource
  • Types of event log entries
  • Event ID categories

��

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: Pt. 1 - How to Write to the Windows Application Event Log

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If

Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If - view details
This second video in the series on If statements in Visual Basic 2005 will cover additional��branching within your If statements and the multiple conditions (And,Or,Not) you can use when writing expressions, and also using parenthesis to write even more complex expressions.

Highlights:

  • How to combine conditions using If
  • Conditional requirements��of And, Or
  • About ElseIf statements, Else statements

��

��

��

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: Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If

posted by Scott Whigham @ 4:35 AM  

Monday, November 26, 2007

New Visual Basic Video Tutorial: Pt. 1 - Writing If Statements and Boolean Tests

Pt. 1 - Writing If Statements and Boolean Tests - view details
As a developer in any language, you end up writing a whole lot of IF statements inside Visual Basic and Boolean tests as well. This great video will cover all the necessary bases to get you fluent in writing IF statements and all the common uses.

Highlights:

  • Syntax shortcuts and variations
  • When to use "End If"
  • True vs false
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: Pt. 1 - Writing If Statements and Boolean Tests

posted by Scott Whigham @ 4:35 AM  

Wednesday, November 21, 2007

New Transact SQL Video Tutorial: Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
This final video on how to delete duplicate rows in a SQL server table via use of the RANK ( ) function will show you an alternative placement of the ranking function.

Highlights:
  • Where can I put the RANK function and where will it accurately work?
  • Reason for JOIN of actual table to duplicates
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:

posted by Scott Whigham @ 8:35 AM  

New Exchange Server Video Tutorial: Outlook 2007 Connection Status and Troubleshooting

Outlook 2007 Connection Status and Troubleshooting - view details
This video with take a look at the diagnostic tools built into Outlook 2007 that help to determine your type nad connection status to the Exchange server.

Highlights from this video:
  • ��How to acces Connection Status browser
  • ��Changing settings in Outlook Anywhere
  • ��Downloading address book across different directories
  • Connection diagnostics
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:

posted by Scott Whigham @ 8:35 AM  

New Exchange Server Video Tutorial: How to do Message Tracking in Exchange 2007 in the GUI and with PowerShell

How to do Message Tracking in Exchange 2007 in the GUI and with PowerShell - view details
This video will examine how to do message tracking via various methods when using the Exchange server.

Highlights from this video:
  • How to change message tracking parameters
  • Viewing messages in queue
  • Utilizing various PowerShell methods to organize message tracking logs
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: message tracking, PowerShell

posted by Scott Whigham @ 8:35 AM  

New Exchange Server Video Tutorial: Grant Full Acess to a Mailbox

Grant Full Acess to a Mailbox - view details
This video will take a look at how to grant one user full control of anthor users mailbox in Outlook 2007.

Highlights from this video:
  • Using Exchange Management Shell to change access rights
  • Changing sharing permissions in Outlook mailbox
  • Options for PowerShell cmdlet on getting mailbox permissions
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:

posted by Scott Whigham @ 8:35 AM  

New Exchange Server Video Tutorial: Spam Filtering in Outlook

Spam Filtering in Outlook - view details
How cluttered is your inbox with spam, junk e-mail? In this video tutorial Grant Moyle with show you around the avaliable options for controlling spam blocking in Outlook

Highlights from this video:
  • What is the best level of junk e-mail protection for me?
  • How to block e-mails from specific countries
  • User spam capabilities
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:

posted by Scott Whigham @ 8:35 AM  

New Exchange Server Video Tutorial: Share Calendar and Inbox with Other Users via Outlook

Share Calendar and Inbox with Other Users via Outlook - view details
In Outlook 2007 Microsoft gives you the option to share out�� thier mailbox when mail is held on Exchange server. In this video tutorial your instructor , Grant Moyle, will walk you through the step-by-step process of sharing information via Microsoft Outlook.

Highlights from this video:
  • How to change mail sharing permission levels
  • Viewing shared calendars
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: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:35 AM  

New SQL Server Video Tutorial: Pt. 12 - Understanding the FastParse Option

Pt. 12 - Understanding the FastParse Option - view details
This final video in the very long 12 part series will continue to cover all the FastParse bases in SSIS and how to load from multiple text files into one table.

Highlights:
  • Timing comparison against other tools
  • Loading from multiple text files into one table
  • What is a Parallel Data Load?
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:

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - Choosing Between Views, Functions, and Stored Procedures

Pt. 2 - Choosing Between Views, Functions, and Stored Procedures - view details
This instructional video will continue comparing Views, Functions, and Stored Procedures in SQL and present you with the correct option for your task at hand

Highlights:
  • Dimensional modeling approach in View
  • Multi-statement functions
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task

Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task - view details
This instructional video will show you how to utilize a data flow task when importing a flat file with FastParce off/on in SSIS.

Highlights
  • Necessary changes to the connection managers
  • What is "FastParce"?
  • Where can I use FastParce
  • Differentiation of execution speeds
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:

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
Ever find yourself with multiple rows in your SQL Server table? This video tutorial will show you the quickest way to get rid of those "imposter" rows by introducing you to the first couple of steps in the process.

Highlights:
  • How to identify the duplicate values
  • What does the RANK function basically do?
  • Where/when to use the RANK function
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:

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
This video will continue to show you the process of deleting duplicate rows using the RANK function in a SQL server table

Highlights:
  • Using common table expressions
  • Ranking and partitioning within a result set
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 12 - Understanding the FastParse Option

Pt. 12 - Understanding the FastParse Option - view details
This final video in the very long 12 part series will continue to cover all the FastParse bases in SSIS and how to load from multiple text files into one table.

Highlights:
  • Timing comparison against other tools
  • Loading from multiple text files into one table
  • What is a Parallel Data Load?
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:

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: How to Decide Whether to Write a JOIN or Subquery

How to Decide Whether to Write a JOIN or Subquery - view details
This video will show you how to decide whether to write a JOIN or a Subquery by presenting you with some determining scenarios

Highlights:
  • What is the basic idea of the Single Table JOIN design pattern?
  • When to use JOIN/ OUTER JOIN/LEFT JOIN
  • Using single vs multiple tables and query effects
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:

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure

Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure - view details
This video will present some basic guidlines for determining whether to use a View, Function, or Stored Procedure in SQL Server and also define their capabilities.

Highlights:
  • Advantages of stored procedures
  • View vs Function
  • Types of Functions and similarities
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task

Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task - view details
This instructional video will show you how to utilize a data flow task when importing a flat file with FastParce off/on in SSIS.

Highlights
  • Necessary changes to the connection managers
  • What is "FastParce"?
  • Where can I use FastParce
  • Differentiation of execution speeds
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:

posted by Scott Whigham @ 4:35 AM  

Tuesday, November 20, 2007

New SQL Server Integration Services Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
This video will be discussing�� the details of the BULK INSERT and OPENROWSET functions, as well as comparing them back against BCP

Highlights:
  • BULK INSERT syntax
  • Using books online for OPENROWSET
  • Comparison of OPENROWSET, BULK INSERT, and BCP timing
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
This video will be discussing�� the details of the BULK INSERT and OPENROWSET functions, as well as comparing them back against BCP

Highlights:
  • BULK INSERT syntax
  • Using books online for OPENROWSET
  • Comparison of OPENROWSET, BULK INSERT, and BCP timing
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 10 - SQL Server Intergration Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
This video will show you how to create a BULK INSERT task in SQL Server Integration Services, SSIS, with Microsoft Visual Studio
  • Using the BULK INSERT task in an SSIS project
  • Configuring destination connection and options of task
  • Comparison against other tools
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 10 - SQL Server Intergration Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
This video will show you how to create a BULK INSERT task in SQL Server Integration Services, SSIS, with Microsoft Visual Studio
  • Using the BULK INSERT task in an SSIS project
  • Configuring destination connection and options of task
  • Comparison against other tools
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
This 7th video of the 12 part series will walk you through the process of firing tirggers and check constraints in SQL server, as they do not run by default, and finish the discussion of BCP.

Highlights:
  • Creating and modifying triggers
  • Using "hints" to manually fire triggers
  • Building a check constraint
  • Security requirements for using BCP/BULK INSERT
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
This video will show you a comparison between running BCP to load with a table with no indexes and running with a single index.

Highlights:
  • What is clustered index order?
  • Run-time comparison
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
This video will show you a comparison between running BCP to load with a table with no indexes and running with a single index.

Highlights:
  • What is clustered index order?
  • Run-time comparison
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
This video tutorial will continue with more information on the format files and present you with some options for making BCP run faster with data.

Highlights:
  • Effects of setting batch size too small
  • How to do a fast copy of a table with indexes
  • Using "load hints" and advantages
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
This 7th video of the 12 part series will walk you through the process of firing tirggers and check constraints in SQL server, as they do not run by default, and finish the discussion of BCP.

Highlights:
  • Creating and modifying triggers
  • Using "hints" to manually fire triggers
  • Building a check constraint
  • Security requirements for using BCP/BULK INSERT
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:

posted by Scott Whigham @ 8:35 AM  

New Exchange 2007/2003 Video Tutorial: Spam Filtering in Outlook

Spam Filtering in Outlook - view details
How cluttered is your inbox with spam, junk e-mail? In this video tutorial Grant Moyle with show you around the avaliable options for controlling spam blocking in Outlook

Highlights from this video:
  • What is the best level of junk e-mail protection for me?
  • How to block e-mails from specific countries
  • User spam capabilities
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:

posted by Scott Whigham @ 4:37 AM  

New SQL Server 2005 Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
This video tutorial will continue with more information on the format files and present you with some options for making BCP run faster with data.

Highlights:
  • Effects of setting batch size too small
  • How to do a fast copy of a table with indexes
  • Using "load hints" and advantages
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS

Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS - view details
This video will continue the discussion of the overview of the various tools availiable for loading a flat file in SQL server

Highlights:
  • How is OPENROWSET more flexible than BULK INSERT?
  • Tool choices within SSIS
  • What does�� DROPCLEANBUFFERS do 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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File

Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File - view details
This video will dig into the purpose of the .xml format files and how to write the correct syntax for running BCP

Highlights:
  • How to generate a format file using .xml
  • Different character types
  • Specifying field terminators
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File

Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File - view details
This video will dig into the purpose of the .xml format files and how to write the correct syntax for running BCP

Highlights:
  • How to generate a format file using .xml
  • Different character types
  • Specifying field terminators
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios

Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios - view details
In this video Scott will take you through an overview of running the BCP utility with some of our testing scenarios

Highlights:
  • Using command prompt to execute BCP
  • BCP vs BULK INSERT
  • How to save to format file, .fmt
  • Saving as .xml format
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios

Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios - view details
In this video Scott will take you through an overview of running the BCP utility with some of our testing scenarios

Highlights:
  • Using command prompt to execute BCP
  • BCP vs BULK INSERT
  • How to save to format file, .fmt
  • Saving as .xml format
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS

Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS - view details
This video will continue the discussion of the overview of the various tools availiable for loading a flat file in SQL server

Highlights:
  • How is OPENROWSET more flexible than BULK INSERT?
  • Tool choices within SSIS
  • What does�� DROPCLEANBUFFERS do 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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
This video will present you with the different basic and loading scenarios that you have to work with when doing bulk operations in SQL server

Highlights:
  • Possible scenarios
  • What is BCP?
  • Advantages of using Bulk Insert over BCP
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
This video will present you with the different basic and loading scenarios that you have to work with when doing bulk operations in SQL server

Highlights:
  • Possible scenarios
  • What is BCP?
  • Advantages of using Bulk Insert over BCP
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:

posted by Scott Whigham @ 4:35 AM  

Sunday, November 18, 2007

New Transact SQL Video Tutorial: Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
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:

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Performing a Parallel WSS 3.0 Install and Maintaining WSS 2.0 and Existing Content

Performing a Parallel WSS 3.0 Install and Maintaining WSS 2.0 and Existing Content - view details
This video tutorial will demonstrate to you a parallel upgrade from WSS 2.0 to WSS 3.0. Your instructor Grant will show you what a parallel upgrade will do as well as the step-by-step process for doing so.

Highlights:
  • Where did all my content from WSS 2.0 go?
  • How to access the old WSS 2.0�� site
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: sharepoint services 2.0, sharepoint services 3.0, upgrade, migration

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure

Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Performing an In-Place Upgrade of SharePoint Services 2.0 to SharePoint Services 3.0

Performing an In-Place Upgrade of SharePoint Services 2.0 to SharePoint Services 3.0 - view details
This video tutorial will walk you through the positive and negatives of performing an In-Place upgrade of SharePoint Services 2.0 to SharePoint Services 3.0 and also the intricate step-by-step procedure of doing so!

Highlights:
  • How to find the prescan command
  • Monitoring the upgrade
  • How to finalize and complete the upgrade

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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: One Way to Export an XML File Using SSIS

One Way to Export an XML File Using SSIS - view details
This video will walk you through the process of how to convert XML and how to work with XML in SSIS. Also in this video your instructor Scott will be creating a procedure for exporting an XML file using SSIS.

Highlights:
  • How to get a true XML document in SQL
  • Making a connection between SQL and your XML file
  • Creating a useful stored procedure for�� returning XML data
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:

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: How to Decide Whether to Write a JOIN or Subquery

How to Decide Whether to Write a JOIN or Subquery - view details
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:

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - Choosing Between Views, Functions, and Stored Procedures

Pt. 2 - Choosing Between Views, Functions, and Stored Procedures - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 10 - SQL Server Intergration Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task

Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 12 - Understanding the FastParse Option

Pt. 12 - Understanding the FastParse Option - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task

Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: How to Configure a WSS 3.0 Parallel Installation on Windows SBS 2003

How to Configure a WSS 3.0 Parallel Installation on Windows SBS 2003 - view details
This video tutorial will show you the steps required to configure a Windows SharePoint Services 3.0 parallel installation on Windows Small Business Server 2003. Grant Moyle, your instructor, gives you extra tips for getting your new WSS 3.0 site.

Highlights:
  • Why do I need to keep my SP 2.0 site?
  • Consequences of shutting down your SharePoint 2.0 site
  • Using IIS Manager to make replacements
  • How to change Internal URLs
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:

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: Troubleshooting ASP.NET 2.0 Installation for SharePoint

Troubleshooting ASP.NET 2.0 Installation for SharePoint - view details
In this short video tutorial Grant will help you through the many common problems when installing ASP.NET 2.0, which will help you upgrade WSS 2.0 to 3.0 or to install WSS 3.0.

Highlights:
  • How to add ASP.NET v2.0 to IIS Web Service Extensions list
  • Repairing .NET framework
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 12 - Understanding the FastParse Option

Pt. 12 - Understanding the FastParse Option - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 10 - SQL Server Intergration Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
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:

posted by Scott Whigham @ 4:35 AM  

Saturday, November 17, 2007

New SQL Server Integration Services Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File

Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File

Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
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:

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS

Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Introduction to Bulk Operations in SQL Server

Pt. 1 - An Introduction to Bulk Operations in SQL Server - view details
This first video in the very large 12 part series on Bulk Operations in SQL Server will talk about uploading text files to SQL server. Your instructor Scott will start off this video by walking you through the step-by-step procedure of creating the table and also begin the discussion of the various techniques and scenarios encountered when doing Bulk Operations.

Highlights:
  • What are the options for the Recovery Model?
  • How to set the database recovery model to BULK_LOGGED
  • Advantages of BULK_LOGGED
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios

Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios

Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS

Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS - view details
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:

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Bulk Operations in SQL Server

Pt. 1 - An Introduction to Bulk Operations in SQL Server - view details
This first video in the very large 12 part series on Bulk Operations in SQL Server will talk about uploading text files to SQL server. Your instructor Scott will start off this video by walking you through the step-by-step procedure of creating the table and also begin the discussion of the various techniques and scenarios encountered when doing Bulk Operations.

Highlights:
  • What are the options for the Recovery Model?
  • How to set the database recovery model to BULK_LOGGED
  • Advantages of BULK_LOGGED
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:

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003

Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003 - view details
Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003
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: sbs2003, windows small business server

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
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:

posted by Scott Whigham @ 4:35 AM  

Friday, November 16, 2007

New Transact SQL Video Tutorial: Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
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:

posted by Scott Whigham @ 5:05 PM  

New Transact SQL Video Tutorial: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
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:

posted by Scott Whigham @ 5:05 PM  

New Transact SQL Video Tutorial: Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
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:

posted by Scott Whigham @ 5:05 PM  

New Transact SQL Video Tutorial: How to Decide Whether to Write a JOIN or Subquery

How to Decide Whether to Write a JOIN or Subquery - view details
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:

posted by Scott Whigham @ 5:05 PM  

New Transact SQL Video Tutorial: Pt. 2 - Choosing Between Views, Functions, and Stored Procedures

Pt. 2 - Choosing Between Views, Functions, and Stored Procedures - view details
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:

posted by Scott Whigham @ 5:05 PM  

New Transact SQL Video Tutorial: Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure

Pt. 1 - How to Decide Between Using a View, Function, or Stored Procedure - view details
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:

posted by Scott Whigham @ 5:05 PM  

New SQL Server Integration Services Video Tutorial: One Way to Export an XML File Using SSIS

One Way to Export an XML File Using SSIS - view details
This video will walk you through the process of how to convert XML and how to work with XML in SSIS. Also in this video your instructor Scott will be creating a procedure for exporting an XML file using SSIS.

Highlights:
  • How to get a true XML document in SQL
  • Making a connection between SQL and your XML file
  • Creating a useful stored procedure for�� returning XML data
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:

posted by Scott Whigham @ 5:04 PM  

New SQL Server 2005 Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
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:

posted by Scott Whigham @ 3:04 PM  

New SQL Server 2005 Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
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:

posted by Scott Whigham @ 3:04 PM  

New SQL Server 2005 Video Tutorial: Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
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:

posted by Scott Whigham @ 3:03 PM  

New SQL Server 2005 Video Tutorial: Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations

Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations - view details
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:

posted by Scott Whigham @ 3:03 PM  

New SQL Server 2005 Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
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:

posted by Scott Whigham @ 3:03 PM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File

Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File - view details
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:

posted by Scott Whigham @ 3:02 PM  

New SQL Server 2005 Video Tutorial: Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios

Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios - view details
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:

posted by Scott Whigham @ 3:02 PM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS

Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS - view details
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:

posted by Scott Whigham @ 3:01 PM  

New SQL Server 2005 Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
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:

posted by Scott Whigham @ 3:01 PM  

New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Bulk Operations in SQL Server

Pt. 1 - An Introduction to Bulk Operations in SQL Server - view details
This first video in the very large 12 part series on Bulk Operations in SQL Server will talk about uploading text files to SQL server. Your instructor Scott will start off this video by walking you through the step-by-step procedure of creating the table and also begin the discussion of the various techniques and scenarios encountered when doing Bulk Operations.

Highlights:
  • What are the options for the Recovery Model?
  • How to set the database recovery model to BULK_LOGGED
  • Advantages of BULK_LOGGED
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:

posted by Scott Whigham @ 3:00 PM  

Tuesday, November 13, 2007

New Visual C# Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
This video will show you how you can get your project up and running with NUnit and how to install and configure NUnit for your applications.

Highlights:

  • Book suggestions
  • Creating TestFixture and Test method using NUnit
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: Pt. 5 - How to Setup and Configure Your First NUnit Project

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

Pt. 4 - Best Practices and Guidelines for Successful Unit Testing - view details
This video��includes and overview of��the best practices and guidelines for successful unit testing��in Microsoft Visual Studio��

Highlights:

  • A perfect unit test?
  • More ideas of Test Driven Development
  • Purpose of failed tests
  • What are Coder tests?
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: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
This video will show you how you can get your project up and running with NUnit and how to install and configure NUnit for your applications.

Highlights:

  • Book suggestions
  • Creating TestFixture and Test method using NUnit
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: Pt. 5 - How to Setup and Configure Your First NUnit Project

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

Pt. 4 - Best Practices and Guidelines for Successful Unit Testing - view details
This video��includes and overview of��the best practices and guidelines for successful unit testing��in Microsoft Visual Studio��

Highlights:

  • A perfect unit test?
  • More ideas of Test Driven Development
  • Purpose of failed tests
  • What are Coder tests?
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: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

posted by Scott Whigham @ 7:10 AM  

New Visual C# Video Tutorial: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit - view details
This video will continue covering the principles of TDD and how to write an NUnit test that fails as well as how to write your first app using TDD.

Highlights:

  • The process of test case naming
  • What is a TextFixture?
  • Sequence of testing codes
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: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

posted by Scott Whigham @ 7:10 AM  

New Visual Basic Video Tutorial: Pt. 4 - Understanding How AutoEventWireup Works

Pt. 4 - Understanding How AutoEventWireup Works - view details
This video will cover the basics of the AutoEventWireup and how it works in different languages as well as the variations in the defaults and how to change specific handling behaviors.

Highlights:

  • AutoEventWireup value when using codefile
  • How to define your delgate in VB

��

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: Pt. 4 - Understanding How AutoEventWireup Works

posted by Scott Whigham @ 7:10 AM  

New Visual Basic Video Tutorial: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing - view details
In this video your instructor Scott will expand upon the concept of a unit, unit testing and TDD, Test Driven Development.

Highlights:

  • What is a test?
  • The tenet of TDD
  • Principles of unit testing
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: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

posted by Scott Whigham @ 7:10 AM  

New Visual C# Video Tutorial: Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup

Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup - view details
This instructional video will cover some of�� the mistakes made when using EventWireUp in C# in VS2005 and also some quick solutions.

Highlights:

  • WireUp by hand
  • Assigning new Event handlers
  • What is the danger of the AutoEventWireup?
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: Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup

posted by Scott Whigham @ 7:10 AM  

New Visual Basic Video Tutorial: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit - view details
This video will continue covering the principles of TDD and how to write an NUnit test that fails as well as how to write your first app using TDD.

Highlights:

  • The process of test case naming
  • What is a TextFixture?
  • Sequence of testing codes
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: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

posted by Scott Whigham @ 7:10 AM  

New Visual C# Video Tutorial: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing - view details
In this video your instructor Scott will expand upon the concept of a unit, unit testing and TDD, Test Driven Development.

Highlights:

  • What is a test?
  • The tenet of TDD
  • Principles of unit testing
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: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

posted by Scott Whigham @ 7:10 AM  

New Visual C# Video Tutorial: Pt. 4 - Understanding How AutoEventWireup Works

Pt. 4 - Understanding How AutoEventWireup Works - view details
This video will cover the basics of the AutoEventWireup and how it works in different languages as well as the variations in the defaults and how to change specific handling behaviors.

Highlights:

  • AutoEventWireup value when using codefile
  • How to define your delgate in VB

��

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: Pt. 4 - Understanding How AutoEventWireup Works

posted by Scott Whigham @ 7:10 AM  

New Visual Basic Video Tutorial: Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup

Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup - view details
This instructional video will cover some of�� the mistakes made when using EventWireUp in C# in VS2005 and also some quick solutions.

Highlights:

  • WireUp by hand
  • Assigning new Event handlers
  • What is the danger of the AutoEventWireup?
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: Pt. 5 - Avoiding Common Pitfalls Often Seen When Using AutoEventWireup

posted by Scott Whigham @ 7:10 AM  

New Visual Basic Video Tutorial: Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete

Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete - view details
This video tutorial will continue the discussion of Load related page events, PreLoad,Load, and LoadComplete in VS2005.

Highlights:

  • What can I do in Load?
  • When does LoadComplete occur?

��

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: Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 3 - More Expansive If Statements Using C# Generics and Switch Statements

Pt. 3 - More Expansive If Statements Using C# Generics and Switch Statements - view details
This video will take a deeper look into some more complicated If statements and the alternative to If statements, Switch statements, in a Console Application in VS2005.

Highlights:

  • Issuing foreach statements in a collection
  • Code syntax shortcuts
  • What exactly can I test inside the switch parenthesis?
  • Using a break in the switch
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: Pt. 3 - More Expansive If Statements Using C# Generics and Switch Statements

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete

Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete - view details
This video tutorial will continue the discussion of Load related page events, PreLoad,Load, and LoadComplete in VS2005.

Highlights:

  • What can I do in Load?
  • When does LoadComplete occur?

��

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: Pt. 2 - Discussing Load(Page_Load), PreLoad, and LoadComplete

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload

Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload - view details
This final video tutorial in the series will wrap up the last couple of page events found when using VS2005.

Highlights:

  • How is the PreRender page event useful?
  • Where does the actual DataBinding occur?
  • How to save the viewstate
  • What is the Render event/method?
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: Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload

Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload - view details
This final video tutorial in the series will wrap up the last couple of page events found when using VS2005.

Highlights:

  • How is the PreRender page event useful?
  • Where does the actual DataBinding occur?
  • How to save the viewstate
  • What is the Render event/method?
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: Pt. 3 - The Final Page Events: PreRender, SaveStateComplete, Render, and Unload

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Tips for Writing Effecient If, Switch, and Select Case Statements

Tips for Writing Effecient If, Switch, and Select Case Statements - view details
This instructional video will walk you through the��concept of writing itterations,loops and If statements. This video will cover just about any programming language in Visual Studios, as well as boosting your code.

Highlights:

  • How to write conscise IF/SWITCH/CASE�� statements
  • Blocking the thread for a given amount of time
  • Common logic among languages
  • Creating a variable, i.
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: Tips for Writing Effecient If, Switch, and Select Case Statements

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Brackets

Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Brackets - view details
This video will continue the discussion of using IF, And, Or and Not operators in Miscrosoft VS2005.

Highlights:

  • Syntax operators for C# and proper notation
  • How to dictate multiple conditions and operators
  • Code maintenance
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: Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Brackets

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Tips for Writing Effecient If, Switch, and Select Case Statements

Tips for Writing Effecient If, Switch, and Select Case Statements - view details
This instructional video will walk you through the��concept of writing itterations,loops and If statements. This video will cover just about any programming language in Visual Studios, as well as boosting your code.

Highlights:

  • How to write conscise IF/SWITCH/CASE�� statements
  • Blocking the thread for a given amount of time
  • Common logic among languages
  • Creating a variable, i.
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: Tips for Writing Effecient If, Switch, and Select Case Statements

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 1 - Writing If Statements and Boolean Tests

Pt. 1 - Writing If Statements and Boolean Tests - view details
Are you unfamiliar with the proper way to write an If statement or a Boolean test? Then you're just in luck! This video tutorial will shw you the correct syntax elements to be used when��using C#in Microsoft Visual Studio

Highlights:

  • Concept of Fall Through
  • What does an If Else statement do?
  • When to use brackets
  • String assignment
  • Using a ? in Boolean tests
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: Pt. 1 - Writing If Statements and Boolean Tests

posted by Scott Whigham @ 4:35 AM  

Friday, November 9, 2007

New Exchange 2007/2003 Video Tutorial: Part 5 - Final Steps to Complete our Exchange 2007 Migration

Part 5 - Final Steps to Complete our Exchange 2007 Migration - view details
The last steps to complete our Exchange 2003 to Exchange 2007 migration are primarily cleanup steps. Are you using recipient policies? You need to watch this video. What about Recipient Update Services? Will this affect your Exchange migration? How can you change it?

Highlights from this video:
  • Installing the Windows Support Tools
  • Using ADSIEdit to diagnose and troubleshoot problems
  • Using Active Directory Sites and Services
  • Message queues, Storage groups, and mailbox cleanup
  • Uninstalling Exchange 2003!
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: upgrade, migration, Exchange 2007, Exchange 2003

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003

Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003 - view details
Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003
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: sbs2003, windows small business server

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003

Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003 - view details
Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003
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: sbs2003, windows small business server

posted by Scott Whigham @ 5:34 AM  

New SharePoint Video Tutorial: Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003

Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003 - view details
Part 1 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003
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: sbs2003, windows small business server

posted by Scott Whigham @ 5:33 AM  

Thursday, November 8, 2007

New Exchange 2007/2003 Video Tutorial: Windows Services: Explanations and Best Practices

Windows Services: Explanations and Best Practices - view details
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, 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 services

posted by Scott Whigham @ 12:19 PM  

New SQL Server 2005 Video Tutorial: Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!)

Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!) - view details
Our final video in our series on how to move tables and indexes to a read-only filegroup covers what requirements there are for assigning a filegroup read-only and how to do it in a production system. There are certain rules you must follow and, unless you follow them, you will not be able to make the database read-only!

Highlights from this video:
  • How to change database state to SINGLE_USER, MULTI_USER or RESTRICTED_USER using ALTER DATABASE and the SQL Server Management Studio
  • SQL script to kill all users in a database
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: performance tuning, advanced, filegroups, data files, read only

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic

Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic - view details
Our final video, part six, is about how security is implemented in SQL Server Reporting Services with a finish on how to integrate Reporting Services reports with the Visual Studio using the Report Viewer Control.

Highlights from this video:
  • Integrating reports with C#, Visual Basic (WinForm/ASP.NET) applications using the Report Viewer Control
  • How roles - system and user-defined - work in Reporting Services
  • How are folders implemented in Reporting Services?
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup

Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup - view details
This video continues from the last video and is really showing how to perform Step 3 in how to make a table read-only.

Highlights from this video:
  • How to create a table so that it is on a filegroup other than PRIMARY
  • What is a heap? Why do clustered and non-clustered indexes matter when talking about making a table read-only?
  • How to move an existing SQL Server table to a new filegroup
  • how to move a clustered index to a new filegroup
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: performance tuning, advanced, filegroups, data files, read only

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary)

Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary) - view details
Further examination of SSRS requires a solid understand of the various terms (such as the 'Report Server'). This video takes you through topics like:
  • RDL files
  • Data Sources (shared and private)
  • Authoring
  • Deployment
  • Management (Reporting)
  • Ad Hoc reporting (ad-hoc)
  • Report Models
  • How deployment works
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: shared data sources, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginni

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Part 1 - How to Make a Table Read-Only in SQL Server

Part 1 - How to Make a Table Read-Only in SQL Server - view details
You are probably already familiar with the idea of how to make an entire database read-only but, if you want to make one or more tables read-only (but not the entire database), it gets complicated fairly quickly. This video, part one in our series on how to make tables read-only in SQL Server 2008/SQL Server 2005, outlines the four steps you must take to make a SQL table read only.

Highlights from this video:
  • Differences between making a database read-only and a table read-only
  • What steps do you have to take to make a table read-only?
  • What are filegroups?
  • How do filegroups help?
  • What are the TSQL commands to add a new filegroup or modify a file group?
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: performance tuning, advanced, filegroups, data files, read only

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: How to Change the Master Database's File Locations

How to Change the Master Database's File Locations - view details
Do you need to know how to move the master database? How to move the master database data file or log file? Then this video is for you! It's short, it's quick and to the point, and it gives you exactly what you need to know to move the SQL Server system database master database files.

Highlights from this video:
  • How to edit the server configuration to move the files in SQL Server 2005 and SQL Server 2008
  • Registry changes
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: service, mssqlserver, configuration manager

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - SQL Server Reporting Services Licensing and Editions

Pt. 2 - SQL Server Reporting Services Licensing and Editions - view details
This video continues where Part 1 left off: SQL Server Reporting Services licensing. Want to know what editions of SQL Server Reporting Services (SSRS) are available? What about how SSRS is licensed? This video is for you!

Highlights from this video:
  • Enterprise, Standard, Developer, Express, and Workgroup Editions
  • How SQL Server licensing works
  • CPU vs. Client Access Licenses (CALs)
  • Scale-out reporting requirements
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - SQL Server Reporting Services Architecture

Pt. 3 - SQL Server Reporting Services Architecture - view details
This video talks about SSRS architecture including Report Servers, Report Manager, SQL Server database, how SQL Server is implemented as an XML web service and more.

Highlights from this video:
  • How SSRS interacts with IIS (Internet Information Services - the Windows web server)
  • Where SSRS stores security, report definitions and cached report data
  • Tools to create reports
  • What can be a data source?
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: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - How to Author and Deploy Reports

Pt. 5 - How to Author and Deploy Reports - view details
Now that you've seen the basics - the architecture, the terms, the definitions - it's time to create and deploy reports. This video shows you the basics of report authorship (including which tools you can use to create a report) as well as how deployment works.

Highlights from this video:
  • What does an .RDL file look like?
  • Understanding the basics of report deployment
  • Previewing reports vs. deploying reports
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to SQL Server Reporting Services

Pt. 1 - An Introduction to SQL Server Reporting Services - view details
This video, part one in a six-part series, talks about what SQL Server Reporting Services (SSRS) is and designed for the absolute beginner - someone who wants a high-level overview of Reporting Services. If you want to get a solid Technology Overview of Reporting Services, this is it.

Highlights from this video:
  • Concepts of Server-Based Reporting
  • Where is the report stored?
  • What are .rdl files?
  • Data sources (OLE-DB, ODBC, XML)
  • Licensing options
  • Types of reports available
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

Wednesday, November 7, 2007

New SQL Server 2005 Video Tutorial: How to Change the Master Database's File Locations

How to Change the Master Database's File Locations - view details
Do you need to know how to move the master database? How to move the master database data file or log file? Then this video is for you! It's short, it's quick and to the point, and it gives you exactly what you need to know to move the SQL Server system database master database files.

Highlights from this video:
  • How to edit the server configuration to move the files in SQL Server 2005 and SQL Server 2008
  • Registry changes
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: service, mssqlserver, configuration manager

posted by Scott Whigham @ 9:00 AM  

New Visual C# Video Tutorial: Pt. 2 - How to Create and Use a Custom Event Log

Pt. 2 - How to Create and Use a Custom Event Log - view details
This video tutorial will show you the process of how to create your own custom event log and how to use said event logs.

Highlights:

  • Using an "if" test
  • How to view your logged events
  • Assigning event IDs and categories
  • Creating an event source
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: Pt. 2 - How to Create and Use a Custom Event Log

posted by Scott Whigham @ 4:35 AM  

Tuesday, November 6, 2007

New Transact SQL Video Tutorial: XML Schema Collections and Using Typed and Untyped XML Data

XML Schema Collections and Using Typed and Untyped XML Data - view details
This video is a high-level overview of using XML Schema Collections to constrain the XML data stored in an XML datatype-based column or variable. You'll also learn about using typed and untyped xml data and when to use each.

Highlights from this video:
  • Discussion of the XML schema standard
  • Discussion of how to create XML Schemas
  • Syntax for schemas
  • What are xml schemas and when would I use one?
  • Working with XML datatype variables
  • Creating XML Schema Collections
  • Difference between an XML schema and an XML schema collection
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: typed data, untyped xml data, create xml schema collection, xml dml

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - Using FOR XML Clauses in SQL Server

Pt. 2 - Using FOR XML Clauses in SQL Server - view details
This video takes you through several examples of building hierarchies using XML and using the FOR XML PATH clause. This video talks about using XQuery and XPath to work with the database and generate hierarchical list of XML data.
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: querying xml data

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 2a - Introduction to Using XML with SQL Server

Pt. 2a - Introduction to Using XML with SQL Server - view details
This video continues our discussion on beginning XML with SQL Server with a discussion on when you should/could/would use XML with SQL Server.

Highlights from this video:
  • Using XML with SQL Server 2005/2000
  • When is it appropriate to store XML in the database?
  • What datatypes are supported for working with XML?
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: semistructured data, semi-structured data, hierarchical data

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - Introduction to Using XML with SQL Server

Pt. 3 - Introduction to Using XML with SQL Server - view details
Even more discussion of when to use XML in the database
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: xml, for xml, xml datatype, xml schema collections

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - Introduction to Using XML with SQL Server

Pt. 1 - Introduction to Using XML with SQL Server - view details
This video, part one in our series, is a high level overview of what XML is and when it's appropriate to use XML in a relational system. This is our entry point into using XML in SQL Server. The videos in this series are shot using SQL Server 2005 but, for those of you on SQL Server 2000, you'll be able to follow along as well.

Highlights from this video:
  • When would you use XML in SQL Server?
  • Working with FOR XML AUTO
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: FOR XML AUTO, ROOT, PATH, part 1, beginning, beginners, intro, introduction

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 4 - Introduction to Using XML with SQL Server

Pt. 4 - Introduction to Using XML with SQL Server - view details
This video discusses using XQuery, XPath and XML DML as options for working with XML data.
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: xquery standard, xdr

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 2b - Introduction to Using XML with SQL Server

Pt. 2b - Introduction to Using XML with SQL Server - view details
This video finishes out our discussion of when to use XML in SQL Server with a final discussion of using the XML datatype in SQL Server to store our Newsletter information.
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: newsletter, multiple outputs, xml, xsl, xslt

posted by Scott Whigham @ 8:35 AM  

New Transact SQL 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.

Note: 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 @ 8:35 AM