Monday, June 30, 2008

New SQL Server Integration Services Video Tutorial: Part 7 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. B)

Part 7 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. B) - view details
In our seventh and final video in the series, we will wrap up our demo of how to import a text file via package configuration by finally adding and implementing the actual package configuration.

Highlights from this video:
  • Adding the Package Configuration
    • 2 various methods
  • Updating your ConfiguredValue
  • What will happen at run-time?
  • Tracking ConfigurationFilter usage
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: package, configure, configuration, import, file, sql, configurationfilter,

posted by Scott Whigham @ 1:26 PM  

New SQL Server Integration Services Video Tutorial: Part 6 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. A)

Part 6 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. A) - view details
In this sixth video in the series, Scott will give you a great real-world demonstration of using a package configuration to import a text file. This first part of the import will focus on setting up your variable, database, and package.

Highlights from this video:
  • Creating your package and working with the Flat File Source Editor
  • Working around the defaults in the Flat File Connection Manager Editor
  • Delaying file validation
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: package, configure, configuration, import, text, ssis,

posted by Scott Whigham @ 1:25 PM  

New SQL Server Integration Services Video Tutorial: Part 5 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. C)

Part 5 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. C) - view details
In this fifth video in the series, Scott will implement the best practices and walk you through the creation of��a table based off of��that approach.

Highlights from this video:
  • Creating the table based of template
  • Creating another configuration filter
  • Shortcut syntax
  • Should ConfigurationFilter and PackagePath be unique?
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: package, configure, configuration, ssis, sql, best practices, filter,

posted by Scott Whigham @ 1:24 PM  

New SQL Server Integration Services Video Tutorial: Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B)

Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B) - view details
In this fourth video in the series, Scott will really delve into the best practices on the package configurations table and discuss why those settings are optimal.

Highlights from this video:
  • Problems with using the ConfigurationFilter defaults
    • Table logic
    • How to effectively run commands
    • Specifying PackagePath correctly
  • Modifying the configuration table
    • Primary key
    • Indexes
      • Where to place an index
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: package, configure, package configuration, best practice, table, configuration, sql, ssis.

posted by Scott Whigham @ 1:23 PM  

New SQL Server Integration Services Video Tutorial: Part 3 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. A)

Part 3 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. A) - view details
After looking through the basics of the table, Scott will now begin working around the defaults and show you the best practices for how to begin using and managing the SQL Server Package Configurations.

Highlights from this video:

  • What happens when I remove my Package Configuration?
  • Reusing or overwriting existing configuration filters
  • Exporting the values of the configurations via Package Configuration Wizard��
  • Updating the table to use the configuration values you want
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: package, configure, package configuration, configurations, wizard, filter, table

posted by Scott Whigham @ 1:23 PM  

New SQL Server Integration Services Video Tutorial: Part 2 - Using SQL Server Package Configurations in SSIS

Part 2 - Using SQL Server Package Configurations in SSIS - view details
This second video in the series will continue where the first video left off by further discussing and demonstrating the use of SQL Server Package Configurations. By the end of this video, you will have successfully created a new Package Configuration.

Highlights from this video:
  • Choosing the appropriate database for your package configurations
    • Creating and working with a database specifically for utilities, such as package configurations
  • Walking through the Package Configuration Wizard
    • Connecting to a database
    • Creating a table
    • Selecting properties to export (objects that will be changed at run-time)
  • Defining Configurations table columns and finishing a Package Configuration
    • ConfigurationFilter
    • ConfiguredValue
    • PackagePath
    • ConfiguredValueType
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: package, configure, package configuration, ssis, wizard, sql,

posted by Scott Whigham @ 1:22 PM  

New SQL Server Integration Services Video Tutorial: Part 1 - What Are Package Configurations and How Do You Use Them?

Part 1 - What Are Package Configurations and How Do You Use Them? - view details
A common problem that many people encounter in DTS is moving packages between their development, test, and production environments. In DTS this would require a handful of edits to make sure the connection objects were pointing to the correct servers. Integration Services, SSIS, has fortunately provided us with a solution to this problem - package configurations! Package configurations allow your package to be dynamically updated at run-time, thus saving you time by eliminating those pesky manual edits.

In this video series, we will talk more about package configurations in SSIS and see a little bit more of storing the package configurations inside SQL Server. We will also go over some best practices as well as take our demos beyond what the defaults are. In this first video in the series, Scott will go over the concept of package configurations and demonstrate to you how to use them

Highlights from this video:

  • Basics of Package Configurations via Variables
    • Creating a package
    • Accessing the variable
  • Working with SQL Server 2008 and SQL Server 2005
  • Enabling and Adding configurations for your package
  • Working in the Package Configuration Wizard
    • Getting started
    • Specifying configuration settings
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: package, package configuration, configure, variable, dts, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 1:21 PM  

New Exchange Server Video Tutorial: Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster

Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster - view details
Once you have an Exchange cluster up and running, you will want to begin putting some mailboxes on it. In this video, your instructor will present you with two scenarios for putting a new mailbox on the cluster: creating a new mailbox and/or moving a mailbox.

Highlights from this video:
  • Creating a new user mailbox
    • Proving the mailbox exists on the cluster
  • Cluster administration and about front-end interaction
  • How to move a users mailbox from the standalone server to the cluster
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: cluster, mailbox, create, move, moving, creating, mail box,

posted by Scott Whigham @ 11:48 AM  

New Exchange Server Video Tutorial: Part 5 - Install Exchange 2007 onto Second Node

Part 5 - Install Exchange 2007 onto Second Node - view details
After Server A is running as an active node and��you've restarted the Exchange resource group, we'll install Exchange 2007 as the passive node in CCR��on Server B, which works kind of like the last one we did with a few exceptions.��

Highlights from this video:
  • Installing Windows components
  • Custom Exchange Server installation
    • Passive Clustered Mailbox Role��
  • What are we going to get out of our Exchange cluster?
  • Testing Exchange cluster failover
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: continuous, cluster, replicate, ccr, node, failover,

posted by Scott Whigham @ 11:47 AM  

New Exchange Server Video Tutorial: Part 4 - Install Exchange 2007 onto First Node

Part 4 - Install Exchange 2007 onto First Node - view details
With our Windows 2003 cluster running and setup to work with the Majority Node Set, we'll begin our Exchange 2007 installation on our first cluster node in this fourth video in the series.

Highlights from this video:

  • Pre-installation check
  • Configuration of Custom Exchange Server Installation
    • Installing Active Clustered Mailbo and cluster IP address
  • Adding Windows components for your install
  • Finalizing the install and rebooting your server
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: cluster, continuous, replication, ccr, node, install,server, majority node set,

posted by Scott Whigham @ 11:46 AM  

New Exchange Server Video Tutorial: Part 3 - Majority Node Configuration, Second Cluster Node Install and Testing

Part 3 - Majority Node Configuration, Second Cluster Node Install and Testing - view details
Now that we have our cluster up and running, we'll need to configure it so the majority node set is pointing to our File Witness Share that we created, and we'll also need to add our Exchange Server B to it. In this third video in the series, Grant will walk you through those setup processes.

Highlights from this video:
  • Where does my Majority Node Set currently point?
    • Setting the correct path
    • Configuring the cluster to use Majority Node Set
  • Adding a second cluster node to cluster
  • Test cluster failover
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: cluster, continuous, replication, ccr, node, majority, failover,

posted by Scott Whigham @ 11:45 AM  

New Exchange Server Video Tutorial: Part 2 - Active Directory, File Witness Share and 1st Cluster Node Setup

Part 2 - Active Directory, File Witness Share and 1st Cluster Node Setup - view details
Once we have our servers setup�� and we've configured the network and storage, we're now ready to actually install the cluster pieces. In this video tutorial, Grant will show you how to do just that!

Highlights from this video:
  • Setting up a new cluster service account in the Active Directory
  • Creating a��File Witness share
    • What is it's purpose?
    • Where is it located?
    • Assigning permissions and security
  • Creating a new cluster via the Cluster Adminstrator
    • Adding new nodes to your cluster
    • Advanced configuration
    • Majority Node Set and Quorum
  • Viewing built cluster
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: file witness, share, cluster, node, continuous, replication, majority,

posted by Scott Whigham @ 11:44 AM  

New Exchange Server Video Tutorial: Part 1 - Discussion on Cluster Continuous Replication

Part 1 - Discussion on Cluster Continuous Replication - view details
Offering server high availability and an automated failover process, Cluster Continuous Replication (CCR) is great for those of you who have numerous Exchange 2007 servers. With CCR we can eliminate the need for the storage array in the Storage Area Network, saving you a whole lot of money, by using a local disk. In this video series, your instructor Grant Moyle will walk you through the long process of installing Exchange 2007 in CCR configuration as well as��go over how the cluster actually works and the basic recipe needed to build the cluster. The subsequent videos in this series��will build on this info and install the two cluster nodes, the Windows components of clustering, the Exchange components of clustering, and we'll end the series with a completed Exchange 2007 CCR configuration.

Highlights from this video:

  • About working with��Cluster Continour Replication
  • Prep-work and prerequisites for the cluster setup
  • Examine existing network configuration
    • Configuring a new local area connection
  • Configuring Local Disk and Heartbeat Network
  • Ideal configuration for your servers
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: ccr, cluster, continuous, replication, failover, server, node,

posted by Scott Whigham @ 11:44 AM  

Sunday, June 29, 2008

New SQL Server Video Tutorial: Part 5 - Writing the Stored Proced ure to Copy a Database

Part 5 - Writing the Stored Procedure to Copy a Database - view details
Continued in this fifth video in the series, Scott will show you how to create a handy stored procedure to copy a database by building off your knowledge from the backup and restore procedures.

Highlights from this video:
  • Required parameters for the copy database stored procedure
  • Working with the backup and restore procedures
  • Assigning the datafile and the log via dynamic sql
  • Demo of backup/restore/copy procedures
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: stored, procedure, database, backup, file, copy, restore,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 4- Writing the Stored Procedu re to Restore a Database

Part 4- Writing the Stored Procedure to Restore a Database - view details
After you complete your stored procedure to backup a databse, you can then create a stored procedure to restore a database from those backups. With a stored procedure like this, you will have several credentials to first set. In this fourth video in the series Scott will cover those parameters and demonstrate the exact way to create this awesome stored procedure.

Highlights from this video:
  • Required parameters for restoring a database
  • Creating a base restore database command
    • Why does the command fail?
  • Obtaining the logical file names
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: stored, procedure, database, restore, file,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 3- Writing the Stored Procedu re to Backup a Database: Part B

Part 3- Writing the Stored Procedure to Backup a Database: Part B - view details
In this third video in our series, your instructor Scott will wrap up the creation of��a stored procedure to backup a database.

Highlights from this video:
  • Various date formats for generate a filename
  • Setting a TimeString and CONVERT process
  • ��Setting the path for the backup file
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: stored procedure, procedure, backup, database, file, .bak,

posted by Scott Whigham @ 4:35 AM  

Saturday, June 28, 2008

New SQL Server Video Tutorial: Part 1- Automation with Stored Pro cedures: Automate Backup,Restore, Copy with Stored Procedures

Part 1- Automation with Stored Procedures: Automate Backup,Restore, Copy with Stored Procedures - view details
As a database administrator, you often have to copy a database, restore a database, or backup a database. These monotonous tasks, however, can basically be done for you via automation with stored procedures by simply passing��a few��parameters. In this video series your instructor Scott will not only show you how to create these stored procedures, but he will also talk about the things that are used in creating the stored procedures that will do backups, copy a database, and/or restore a database. In this first video in the series, Scott will walk you through the process of creating a stored procedure that will backup a database, a very essential maintenance task.

Highlights from this video:

  • Building a backup database stored procedure from scratch
    • Requirements
  • About using SYSNAME
  • How to set required/default parameters
  • Two types of parameters with stored procedures
    • Inputs
    • Input 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: stored procedure, backup, copy, restore, database, automate, automation,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 5 - Forced Parameterization vs Simple Parameterization

Part 5 - Forced Parameterization vs Simple Parameterization - view details
In this video tutorial, Scott will discuss your options for using Forced or Simple parameterization in your plan cache as well as go into greater detail about employing forced parameterization.

Highlights from this video:
  • Review of forced and simple (auto) parameterization
  • Two ways to do forced parameterization
    • database level
    • statement level
  • Review of plan reuse for Adhoc and Prepared plans
  • How forced parameterization works at the database level
  • When to use forced parameterization
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: adhoc, plan, query, cache, parameter, parameterization, parameterized, queries, forced, simple, prepared, auto,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 3 - Working with Prepared Plans

Part 3 - Working with Prepared Plans - view details
In this third video in the series, we will continue working with the case when you have two different parameterized values in your queries. Does this result in multiple Prepared plans or just one Prepared plan?Will SQL be able to re-use or will it have to create a new plan? SQL files included in the download.

Highlights from this video:
  • Viewing how Adhoc references the Prepared Queries
  • When does SQL Server have to come up with a new Prepared plan?
  • Implicit datatype conversion and efficiency
  • Various techniques for Dynamic SQL and Prepared Plan
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: adhoc, prepared, plan, query, cache, parameter,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Part 2- Writing the Stored Procedu re to Backup a Database: Part A

Part 2- Writing the Stored Procedure to Backup a Database: Part A - view details
In this second video in the series, we will continue piecemealing our previous coding to create a stored procedure to backup a database. Scott will cover the database name, the backup folder, and the backup extension.

Highlights from this video:
  • Review of Input Output parameters
  • Working with unclosed quotation marks and apostrophes
  • Stringing Dynamic SQL
  • Using CONVERT syntax to generate a file name from the date
  • The problem with the default of appending backup files
    • How to overwrite existing backup files
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: stored procedure, database, backup, automate, automation,file

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 1 - Intro to Query Plans an d the Plan Cache

Part 1 - Intro to Query Plans and the Plan Cache - view details
A query plan is a set of steps used in SQL to access or audit information in your database. In this 6-part video series we will be taking a look at how SQL Server works with plans and how it caches plans. By the end of this series you will be able to troubleshoot problems with plan cache ( formerly known as the buffer cache) performance and be able to reuse existing execution plans. Scott Whigham starts off the series with the essential introduction to query plans and the plan cache, as well as demonstrates how to begin working in the plan cache in SQL Server. Scott's SQL file is included with your download!

Highlights from this video:
  • How SQL Server interprets queries
  • Queries in ShowPlan XML
  • How to eliminate/dump the plan cache
    • FREEPROCCACHE
  • Viewing the cached plans
  • Adhoc plans vs Prepared plans
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: plan, plan guide, cache, queries, query, adhoc, prepared, xml, buffer cache,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 4 - Using Parameterization with the Plan Cache

Part 4 - Using Parameterization with the Plan Cache - view details
Continued in this fourth video in the series, Scott will talk more about sp_executesql, forced parameterization, and the situations in which simple parameterization does not occur.

Highlights from this video:
  • Examples of when plan re-use does not occur with adhoc queries
  • About forced parameterization
  • Using sp_executesql to create a Prepared plan instead of an Adhoc plan
  • What is the best tool to ensure plan reuse?
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: adhoc, plan, query, cache, parameter, parameterization, parameterized, queries, forced, simple, sp_executesql

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 6 - Working with Plan Guides

Part 6 - Working with Plan Guides - view details
In our final video in this series, Scott will talk about the use of plan guides, a pretty advanced topic in SQL 2005 that helps to create a parameterized version of an Adhoc query. Your instructor will cover how it works, when to use it, proper syntax, and the logic of how plan guides are helpful.

Highlights from this video:
  • Statement level parameterization
  • What are plan guides?
  • Why would I want to use plan guides?
  • How to create/delete plan guides
    • Query template for creating plan guides
  • Where is the plan guide referenced?
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: plan, plan guide, cache, queries, query, adhoc, parameter, parameterized, parameterization, template

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Part 2 - Adhoc Plans vs. Prepare d Plans/ Working in the Plan Cache

Part 2 - Adhoc Plans vs. Prepared Plans/ Working in the Plan Cache - view details
The case of your query (whitespace, special characters) will cause a new plan to be added to the plan cache. In this second video in the series, we will continue by focusing on the characteristics of Adhoc plans and Prepared plans in out attempt to find out if SQL can reuse queries that have varying whitespaces. SQL files included in download

Highlights from this video:
  • Various Dynamic Management Views (DMVs)
  • More on the Adhoc (shell)�� and Prepared Plans������
  • Using a DMF to decrypt the plan_handle
  • Process of query execution
    • When is a new Adhoc created?
    • How the whitespace (line breaks) affects your queries
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: adhoc, prepared, plan, query, cache,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: What is Context_Info?

What is Context_Info? - view details
Context_Info is a new concept for sql server that provides us with a way to store data for the entire duration of the session. In this video tutorial, Scott will divulge the purpose and techniques for working with Context_Info, as well as show you some great examples of using Context_Info.

Highlights from this video:
  • Context_info vs Variables
  • Using the context_info function
    • syntax
    • techniques
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: context_info, variable,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 7:35 AM  

New Visual Basic Video Tutorial: Part 2 - Primitive Types in Visual Basic

Part 2 - Primitive Types in Visual Basic - view details
In this second video in the series, we will be covering the numeric datatypes in Visual Basic, such as the integer types and decimal types.

Highlights from this video:
  • About the integral datatypes and byte boundaries
    • Short
    • Long
  • What is a byte?
  • Signed types and Unsigned types
  • Implicitly Typed Local Variable
    • New to VS2008/ VB 9.0
    • What is this?!
  • Decimal types and Floating Point/Fixed
    • Single
    • Double
    • Decimal
    • Using suffixes to change decimal types
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: type, datatype, primitive,predefined,built-in, byte, signed, unsigned,decimal, floating point, fixed, short, long, introduction,

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: Part 4 - Primitive Types in C#

Part 4 - Primitive Types in C# - view details
Continued in this fourth video in the series, your instructor Scott will talk about the DateTime and the boolean datatypes.

Highlights from this video:
  • About the bool type and values
  • Using boolean expressions
  • Using the DateTime type
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: bool, boolean, type, types, datatype, DateTime, true, false,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Part 1 - Primitive Types in Visual Basic

Part 1 - Primitive Types in Visual Basic - view details
Types in Visual Basic are the fundamentals of the language and its very important that you have a great grasp as to what types are and why they're important. In this first video in the series, Scott will provide you with the essential introduction to types and how to begin using them.

Highlights from this video:
  • What are the various predefined datatypes in VB?
    • Boolean
    • Byte
    • Char
    • Integer, etc.
  • Using console.read to facilitate debugging
  • GetType method and mappings
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: type, types, datatype, predefined, primitive, built-in , gettype, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Part 5 - Primitive Types in Visual Basic

Part 5 - Primitive Types in Visual Basic - view details
In this fifth and final video Scott will introduce you to a class to time your executions (Stopwatch) and a tool to help you to spot memory leakage (CLR Profiler). With these tools we will be conducting a performance comparison between string and StringBuilder.

Highlights from this video:
  • Using the Stopwatch instance
    • Tracking elapsed loop time in specified applications
  • About the CLR Profiler
    • Downloading and installing the CLR Profiler
    • Specifying the application to profile
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: type, datatype, primitive,predefined,built-in, string, stringbuilder, stopwatch, clr profiler, introduction, step by step, begin

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Part 4 - Primitive Types in Visual Basic

Part 4 - Primitive Types in Visual Basic - view details
In this fourth vidoe in the series, your instructor Scott Whigham will discuss the string datatype; more specifically Char, String, and StringBuilder

Highlights from this video:
  • About Char
    • What does Char store?
    • Working and compiling with Char
    • Comparing Char to String
  • What is String?
    • Immutable objects
    • String concatenation
  • Using StringBuilder
    • How is it useful/efficient?
    • Where is StringBuilder found?
    • Mutable object
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: type, datatype, primitive,predefined,built-in, string, char, stringbuilder

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Part 3 - Primitive Types in Visual Basic

Part 3 - Primitive Types in Visual Basic - view details
Covered in this third video in our series, Scott will talk about the Boolean datatype and the Date type

Highlights from this video:
  • Working with the Boolean type
    • Default Boolean values
    • System.Boolean mapping
  • About working with Date
    • Zero-ing out the date
    • Assigning Date
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: date, boolean, bool, mybool, type, datatype, primitive, built-in, predefined,, introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: Part 5 - Primitive Types in C#

Part 5 - Primitive Types in C# - view details
In this fifth video in the series, Scott will focus on the various types of strings; char, string, and StringBuilder.

Highlights from this video:
  • What is the char?
    • Defining the char and compiling
    • Common uses of the char
  • About string
    • Immutable objects
  • Modifying strings with the StringBuilder class
    • Where is StringBuilder?
    • Creating mutable objects
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: string, char, stringbuilder, type, types,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: Part 6 - Primitive Types in C#

Part 6 - Primitive Types in C# - view details
This final video in the series encompasses a demo of using what we learned in the previous video to create a new stopwatch for string and StringBuilder�� to monitor run time etc. Scott will also cover the CLR Profiler tool, which is great for profiling specific applications
��
Highlights from this video:
  • What can the stopwatch class be used for?
    • Mutations on a string
  • Creating a new stopwatch instance and configuring your stopwatch
  • Using a for loop
  • Installing and working with the CLR Profiler
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: stopwatch, string, stringbuilder, clr profiler, type, types, datatype,

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: Part 3 - Primitive Types in C#

Part 3 - Primitive Types in C# - view details
This third video in the series will talk about decimal types. Scott will cover the floating point and fixed datatypes as well as implicitly typed local variables. The code sample is included in your download!

Highlights from this video:
  • About floating point and fixed datatypes and when to use each
  • Common problems when working with decimal based datatypes
  • Suffixes for datatypes
  • Implicitly typed variables
  • Using the GetType function and predefined keywords
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: decimal, type, types, datatype, floating point, fixed, implicitly typed, suffix,, introduction, step by step, beginner, beginnin

posted by Scott Whigham @ 4:35 AM  

Friday, June 27, 2008

New C# Video Tutorial: Part 2 - Primitive Types in C#

Part 2 - Primitive Types in C# - view details
Continued in this second video in the series,Scott will talk about the numeric types in C# such as the integral types, which are integer based.

Highlights from this video:
  • Idea of Signed vs Unsigned types
  • Review of bytes and compiling
  • About the int/uint integral types and bytes of storage
  • About the short/ushort integral types and bytes of storage
  • About the long/ulong integral types
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: integer, numeric, type, datatype, signed,unsigned,integral,short,long,int, uint,ushort,ulong,, introduction, step by step, begin

posted by Scott Whigham @ 11:53 AM