Saturday, June 30, 2007

New Visual C# Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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 Visual C# Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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 Integration Services Video Tutorial: Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination

Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination - view details
Phew! Finally - the Visual Basic code is finished and we are ready to parse the strings and write out the data to the destination. This video finishes our demo of using the Script Component as a Source and, after that his complete, Scott Whigham (our author), talks to you about final thoughts on when to use the Script Component and using the Script Component as a Destination.
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 6 - Configuring the Standby Server for READ ONLY / STANDBY Access

Pt. 6 - Configuring the Standby Server for READ ONLY / STANDBY Access - view details
Part six shows you how you can configure your standby server for data access using what is called STANDBY recovery mode.

Highlights from this video:
  • How to make your standby server a reporting database
  • Best practices for using log shipping and synchronization schedules
  • How often should you synchronize?
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Log Shipping Concepts, Architecture and Requirements

Pt. 2 - Log Shipping Concepts, Architecture and Requirements - view details
Part two in our SQL Server log shipping tutorial series discusses the concepts and strategies of log shipping including:
  • Requirements for implementing log shipping
  • Basics of log shipping: how synchronizations work
  • The process and architecture of how log shipping works
  • NO RECOVERY mode (sometimes called NORECOVERY) and STANDBY mode
  • How failover works in log shipping9
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 8 - Log Shipping Security: Credentials, Jobs, Proxy Accounts, Login SIDs and More

Pt. 8 - Log Shipping Security: Credentials, Jobs, Proxy Accounts, Login SIDs and More - view details
Disaster recovery is not easy and this video proves it! This video talks about how to assign/change security for your log shipping.

Highlights from this video:
  • Why the SQL Server Agent's service account matters
  • Creating and using credentials for security
  • How proxies work with credentials to give you the ability to run jobs as a specificed Windows account
  • Why directory/folder security is so important
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Why Use Log Shipping? Pros/Cons of Log Shipping and Mirroring/Clustering

Pt. 3 - Why Use Log Shipping? Pros/Cons of Log Shipping and Mirroring/Clustering - view details
Part three focuses on the final lecture bits before we start with the demo and helps you understand the Big Picture of Log Shipping.

Highlights from this video:
  • Why do we need to use Log Shipping?
  • How is log shipping different from clustering and database mirroring?
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Configuring the Standby Server for NORECOVERY and Using a Monitor Server

Pt. 5 - Configuring the Standby Server for NORECOVERY and Using a Monitor Server - view details
Part five shows you how to configure a SQL Server standby server using the NO RECOVERY mode. Also in this video is a discussion of how to configure the monitor server.

Highlights from this video:
  • NORECOVERY mode and how this can affect applications
  • Configuring synchronization schedules
  • Best Practices for configuring high volume log shipping
  • How to view the staus of log shipping
  • Troubleshooting a log shipping problem
  • Requirements for log shipping
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server

Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server - view details
Something bad - really bad - has happened and it's now time to fail over to the standby server. How do you do it? What's the process?

Highlights from this video:
  • How to manually failover
  • How to fail back
  • Concepts of failover
  • How to achieve point in time recovery
  • Best practices for Log shipping
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window

Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window - view details
Finally - the lecture is finished and it's time to actually get your hands dirty by creating your first log shipping database.

Highlights from this video:
  • Using the SSMS tool to create and manage log shipping
  • Explanations of what tools you will use to manage log shipping
  • Setting up primary (a.k.a. the production) database for log shipping
  • Best practices for remote locations
  • Security concerns regarding proxies, credentials and the SQL Server Agent Service account
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Log Shipping in SQL Server 2005

Pt. 1 - An Introduction to Log Shipping in SQL Server 2005 - view details
Log shipping has been around as long as disaster recovery has been a topic. Log shipping (sometimes called setting up a warm standby server) is a simple process that can be written by hand (you 'roll your own') using stored procedures and SQL Server jobs.

This video talks about how log shipping works as well as covering the basic terms and concepts of log shipping.

Highlights from this video:
  • How log shipping can be a disaster recovery (DR) technique
  • How log shipping is different from (and similar to) Database Mirroring and SQL clustering
  • Primary servers, Monitor Servers, and Standby Servers
  • The goals of log shipping
  • How does log shipping work 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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

Friday, June 29, 2007

New Visual C# Video Tutorial: Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts

Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts - view details
This video is just a collection of tips for using namespaces in your applications: do's and don'ts, assembly best practices, namespace best practices and more.

Highlights from this video:
  • Coding standard suggestions
  • Things not to do when organizing your code
  • Visual Basic tips for changing the root namespace
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:47 AM  

New Visual Basic Video Tutorial: Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts

Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts - view details
This video is just a collection of tips for using namespaces in your applications: do's and don'ts, assembly best practices, namespace best practices and more.

Highlights from this video:
  • Coding standard suggestions
  • Things not to do when organizing your code
  • Visual Basic tips for changing the root namespace
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:47 AM  

New Visual Basic Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:46 AM  

New Visual C# Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:46 AM  

New Visual Basic Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:26 AM  

New Visual C# Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:26 AM  

New Visual Basic Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:23 AM  

New Visual C# Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:22 AM  

New Visual Basic Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:18 AM  

New Visual C# Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:18 AM  

New Visual Basic Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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 @ 9:08 AM  

New Visual C# Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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 @ 9:07 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - Using a Script Component as a Source Connection

Pt. 4 - Using a Script Component as a Source Connection - view details
This video talks about when you would need to use a Script Component as a Data Source in a Data Flow task. Need to process unusual text files or text files with multiple delimiters with SSIS and use them as a Data Source? The Script Component is perfect!

Highlights from this video:
  • Reading .INI files as relational data
  • Understanding the Connection Manager tab in the Script Component
  • Using Me.Connections to access connections
  • Best Practices for using Output and Input column names
  • Using <Output Name>Buffer.AddRow()
  • Accessing row properties in Visual Basic .NET
  • Writing VB.NET code to add rows to the output
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Intro to Using the Script Component In a Transformation

Pt. 1 - An Intro to Using the Script Component In a Transformation - view details
The Script Component is a wonderful addition to SSIS and allows you to do transforms, source and destination components all in .NET - you can't get much more flexible that that! This video helps you understand what the Script Component is and shows you how to begin using the Script Component in a Data Flow Task transformation. The Script Component feature of SSIS is perhaps the most flexible of all the tasks/transformations in SSIS. Drag a Data Flow task onto your SSIS Designer surface and then add a Script Component to your Data Flow container. Notice how it can be either a Source, Destination or Transformation? It is clearly very flexible! But, with all that flexibility comes a price: complexity. Newbies have a particularly tough time understanding when to use the Script Component or another task. Even old-timers (that's folks with lots of DTS experience and who are used to using ActiveX/Active X Script transformations in their Transform Data Tasks) often struggle trying to figure out the best approach to solving a problem with the Script Component!

Highlights from this video:
  • Using the Script Component in your SSIS packages
  • What can you do with a Script Component?
  • When should I use the Script Component?
  • How do I use the Script component in a transformation?
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - Customizing the Script Component to be a Data Source

Pt. 5 - Customizing the Script Component to be a Data Source - view details
This video continues the VB.NET coding for creating our Script Component and making it a data source. You learn how to open the text file, read a line, and make a decision as to whether or not the line's data should be written to the destination.

Highlights from this video:
  • How to read a text file in Visual Basic
  • How Peek() works
  • Using the StreamReader, File and String classes
  • How to access connection manager properties (such as Me.Connections..ConnectionString)
  • How to use a MessageBox in SSIS
  • Using ReadLine() to read a line of text in your text file
  • How to notify SSIS that you are at the end of the Source rowset with EndOfRowSet()
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: EndOfRowSet

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Using a Script Component in a Data Flow Task Transformation

Pt. 2 - Using a Script Component in a Data Flow Task Transformation - view details
Picking up from the last video, this video shows you how to add the Script Component to your Data Flow Task. You'll learn how to:
  • Add the Script Component
  • Common errors/pitfalls to avoid with Data Flow and the Script Component
  • Input columns and Output columns in the Script Component
  • Understanding the screens of the Script Component: Input and Output, Script
  • A Visual Studio bug is found :)
  • Mapping data types (DT_STR)
  • How the script works: ProcessInputRow and Input0ProcessInputRow + Input0Buffer
  • How to assign the value of your Output columns via Visual Basic .NET
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Customizing the Script Component Transformation with VB.NET

Pt. 3 - Customizing the Script Component Transformation with VB.NET - view details
This video focuses on editing your Visual Basic script (in the VSA editor) to define your transformations are. You'll use the .NET Framework's string manipulation capabilities to split a single column into two output columns.

Highlights from this video:
  • Using char arrays to store valid delimiters
  • LastIndexOf vs. LastIndexOfAny
  • Using Row.Property and understanding how Row properties are set
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New Reporting Services 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