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 mus