Sunday, January 27, 2008

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

Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task - view details
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: data flow,task, fastparce, execution speed

posted by Scott Whigham @ 7:35 AM  

New SQL Server 2005 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: FastParse, text files, multiple, parallel data load

posted by Scott Whigham @ 7: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: index, BCP, clustered index order, comparison, compare,

posted by Scott Whigham @ 4:35 AM  

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

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
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: batch size, load hints, format files, BCP,

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: BCP, utility, BULKINSERT, xml format, .fmt file

posted by Scott Whigham @ 4: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: BULK INSERT, OPENROWSET,BCP, functions, timing, compare, comparison, syntax

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: OPENROWSET, BULK INSERT, DROPCLEANBUFFERS, loading flat file,

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:
  • Possible scenarios
  • What is BCP?
  • Advantages of using Bulk Insert over BCP
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: bulk insert, bcp, loading scenario, bulk operations

posted by Scott Whigham @ 4: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: triggers, create trigger, fire triggers, BCP, BULKINSERT, check constraints

posted by Scott Whigham @ 4: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: BULKINSERT, SSIS, sql server integration services, destination connection,compare

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: filed terminators, format file, xml format file , xml, BCP, running BCP

posted by Scott Whigham @ 4:35 AM  

Saturday, January 26, 2008

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

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

Highlights:

  • How is the PreRender page event useful?
  • Where does the actual DataBinding occur?
  • How to save the viewstate
  • What is the Render event/method?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: PreRender, SaveStateComplete, Render, Unload, page events, databinding,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • WireUp by hand
  • Assigning new Event handlers
  • What is the danger of the AutoEventWireup?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: autoeventwireup,EventWireUp, event handler

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • How is the PreRender page event useful?
  • Where does the actual DataBinding occur?
  • How to save the viewstate
  • What is the Render event/method?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: PreRender, SaveStateComplete, Render, Unload, page events, databinding,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights from this video:

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

��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: Load,Page_Load, PreLoad, LoadComplete

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

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

��

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

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

Keywords Associated with this video: AutoEventWireup, eventwireup, page events

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • WireUp by hand
  • Assigning new Event handlers
  • What is the danger of the AutoEventWireup?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: autoeventwireup,EventWireUp, event handler

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • What are the options for the Recovery Model?
  • How to set the database recovery model to BULK_LOGGED
  • Advantages of BULK_LOGGED
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: bulk operations, intro to bulk operations, recovery model, BULK_LOGGED,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

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

��

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

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

Keywords Associated with this video: AutoEventWireup, eventwireup, page events

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights from this video:

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

��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: Load,Page_Load, PreLoad, LoadComplete

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • How to write conscise IF/SWITCH/CASE�� statements
  • Blocking the thread for a given amount of time
  • Common logic among languages
  • Creating a variable, i.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If, Switch, Select Case, Statements, i, case, data structure, loops,loop, iteration

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • Syntax operators for C# and proper notation
  • How to dictate multiple conditions and operators
  • Code maintenance
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If, and, or, not, operators, statement, expression, code, data structure

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • Concept of Fall Through
  • What does an If Else statement do?
  • When to use brackets
  • String assignment
  • Using a ? in Boolean tests
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If statement, boolean test, If else, brackets, string, ?, data structure

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - ASP.NET Page Lifecycle and Page-Level Events: An Overview

Pt. 1 - ASP.NET Page Lifecycle and Page-Level Events: An Overview - view details
One of the areas that seems to cause a decent amount of confusion in ASP.NET�� is the area of Page Load events. This great instructional video will teach you how the auto event wireup property works in Visual Studio 2005 and what it's purpose is.

Highlights:
  • What is the load event?
  • How to set properties
  • What is the page load event method?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ASP.NET, page events, auto event wireup, autoeventwireup, load event

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • Using an "if" test
  • How to view your logged events
  • Assigning event IDs and categories
  • Creating an event source
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If, logged events, event log, event id, event source, data structure

posted by Scott Whigham @ 4:35 AM  

New C# 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
Event logging is a very important piece of business. In this video you will use the event viewer to write to application event log or to write to a custom log.

Highlights:
  • How to use a console application in C#
  • Working with the event log class
  • Creating strings to store information
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: application event log, event log, string, custom string, data structure

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • Issuing foreach statements in a collection
  • Code syntax shortcuts
  • What exactly can I test inside the switch parenthesis?
  • Using a break in the switch
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If, switch, break, expression, statement, data structure

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: Pt. 1 - ASP.NET Page Lifecycle and Page-Level Events: An Overview

Pt. 1 - ASP.NET Page Lifecycle and Page-Level Events: An Overview - view details
One of the areas that seems to cause a decent amount of confusion in ASP.NET�� is the area of Page Load events. This great instructional video will teach you how the auto event wireup property works in Visual Studio 2005 and what it's purpose is.

Highlights:
  • What is the load event?
  • How to set properties
  • What is the page load event method?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ASP.NET, page events, auto event wireup, autoeventwireup, load event

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • How to write conscise IF/SWITCH/CASE�� statements
  • Blocking the thread for a given amount of time
  • Common logic among languages
  • Creating a variable, i.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If, Switch, Select Case, Statements, i, case, data structure, loops,loop, iteration

posted by Scott Whigham @ 4:35 AM  

Friday, January 25, 2008

New SQL Server Integration Services Video Tutorial: Pt. 2 - How to Schedule a Job to Execute An SSIS Package Using Package Configuration Files

Pt. 2 - How to Schedule a Job to Execute An SSIS Package Using Package Configuration Files - view details
In this second video in the series, your instructor will demonstrate to you how to schedule a job so that your job reads the connection information from the configuration file when executing a SQL Server Integration Services package.

Highlights from this video:

  • Common errors in logic
  • Granting access to SQL Server Agent
  • Working with multiple package configuration 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: job,schedule, package configuration files

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - What Are Package Configurations and How Can I Use Them?

Pt. 1 - What Are Package Configurations and How Can I Use Them? - view details
A new feature in SQL Server Integration Services in the Package Configuration. This first��video tutorial will give you an��introduction to what a configuration pack is and how it can help you when�� it comes to moving from server to server, environment to environment.

Highlights from this video:

  • What is a package configuration
  • Changing/deploying testing package
  • Where package configurations come in handy
  • Direct package configuration and execution

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 configuration, package, intergration services

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job

Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job - view details
In this second video in the series, you will learn how to schedule an��SSIS package that is stored in the msdb, a process that is slightly similar to the one performed in the first video.

Highlights from this video:

  • Importing packages to the msdb
  • Package protection levels
  • Executing stored SSIS package

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: msdb, package, job, scheduling,sql server job

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: How to Use SQL Server Tables to Store Your Package Configurations

How to Use SQL Server Tables to Store Your Package Configurations - view details
This video tutorial will show you how you can set your package configurations to use the SQL Server storage of the configuration, ��giving ��you the most flexible, single repository for all package configurations.

Highlights:

  • Adding new SQL server configuration
  • Customizing configuration connection manager, table, and filter
  • Updating SQL configurations
  • Table definition

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: sql server tables, package, configuration, store package,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Using Package Configurations to Create Dynamic SSIS Package Jobs

Pt. 3 - Using Package Configurations to Create Dynamic SSIS Package Jobs - view details
In this third and final video in the series, your instructor will discuss with you how to use package configurations to create dynamic SQL Server Integration Services package jobs.

Highlights from this video:

  • Changing destination database name
  • Creating/adding ��a new XML configuration 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: package configurations, scheduling, schedule, job

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - A Look at the Various Options Available in Package Configurations

Pt. 3 - A Look at the Various Options Available in Package Configurations - view details
In this third video in the series, you will finish the package configuration discussion with the other features that are avaliable with package configurations.

Highlights from this video:

  • Direct package configuration vs indirect package configuration
  • Creating new environment variables
  • About Registry Entry, Parent Package Variables, and Sql Server configuration 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: package configuration, package, configuration, environment variables

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - How to Schedule an SSIS Package As a SQL Server Job

Pt. 1 - How to Schedule an SSIS Package As a SQL Server Job - view details
One of the most commonly asked questions for Intergration Services is 'How do��I schedule an SSIS package'? In this video tutorial your instructor will demonstrate the process of scheduling a job as well as give you some great tips and tricks on how to avoid pitfalls in scheduling, as SQL Server Intergration Services��is a slightly difficult system to work with and��the process is not very intuitive.

Highlights from this video:

  • ��About package sources
  • Granting SqlAgent account permissions
  • Creating new job and steps

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: sql server, job, scheduling, integration service, package

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Using Proxies and Credentials When Scheduling Your SSIS Package As a SQL Server Job

Pt. 3 - Using Proxies and Credentials When Scheduling Your SSIS Package As a SQL Server Job - view details
Ever wonder how you can simplify privileges when scheduling your SQL Server Integration Serivices package as a SQL Server job? In this thrid video tutorial in the series, Scott will demonstrate how you can do so by assigning proxies and creating credentials.
  • What is a credential?
  • How to create a proxy account
  • Logging in to SQL Server��with credentials
  • Proxy execution of SSIS package stored inside��SQL 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: proxy,credentials,proxies,credentials, job, package

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: How to Use Environment Variables In Your Package Configurations

How to Use Environment Variables In Your Package Configurations - view details
In this video tutorial you will look at how to do package configurations by setting properties with environment variables.

Highlights:

  • Types of environment variables
  • Creating new system variables
  • Walkthrough of Package Configuration Wizard and Organizer

and 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: environment variables, package, configurations

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Understanding Execution Context When Executing an SSIS Package As a Job

Pt. 2 - Understanding Execution Context When Executing an SSIS Package As a Job - view details
This video will continue the discussion of execution context when you are executing an SSIS package to a remote server. Your instructor will show you what to do when you are working on a development machine designing the SSIS packages for deployment to a remote server, because there is something to consider about the context as well.

Highlights from this video:

  • Techniques for deploying local package to a remote SQL server
  • Common job failure solutions and causes
  • Analyzing 'Context' errors
  • Best practices for remote deployment

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, package execution, remote server, job

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log - view details
This video is the part 4 of a series of 4 videos detailing information about SQL SERVER MANAGEMENT STUDIO (SSMS). This is an excellent conclusion to the video series introducing you to your error logs within SSMS. This video will introduce you to working with Error logs within SQL Server Management Studio (SSMS) as well as some of the following items:
  • Error log viewer
  • Windows Event Log viewable within the Error Log
  • Agents log within the viewer as well
  • Introduction and explanation of the unified log viewer
  • Introduction to integration of reports in management studio
  • Introduction to graphic reports with SSMS
  • Introduction to writing custom reports
This is a perfect conclusion to a very informative video series. After the reviewing the video series in all you should have a very good understanding of SQL Server Management Studio. The
whole video series is a must see and is perfect for the newbie and a great reference to the experienced SQL programmer.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ssms, sql server management studio, management studio, error logs, reports,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries)

Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries) - view details
Another great introduction video to SQL SERVER MANAGEMENT STUDIO (SSMS) by Scott Whigham. This video leaps us onto the next stepping stone for SSMS. Scott not only continues his teachings about Generating Scripts within SSMS, he also gives is the another basic introduction to SSMS and explains why SSMS is the sole tool to utilize when writing TSQL. Included in this video are the following excellent features:
  • SQL SERVER Connection Requirements in 7.0 or 2000
  • SQL SERVER 2005 Color Coded Syntax
  • Disconnect and Switch Connection options
  • Basic Introduction to SAVE ME Asterisks
  • Basic Introduction to MDX and DMX Queries inside SSMS
  • Lack of Intellisense within SSMS
  • History of Intellisense
  • Third party Intellisense software is available
  • SSMS available options
  • Hot keys within SSMS and where to set them
  • SQL SERVER 2005 Chords - ie. Commenting out blocks of code (CTRL+K, CTRL+C)
  • How to comment and uncomment blocks of code with a couple pushes of keys
  • Funny SSMS non malicious bug in SSMS
This video is a must see, even if only for the bug within SSMS SP2. It is funny once you know about it and can be confusing if you see it before you know it is a BUG. Scott does a fantastic job of bringing us up to speed on the newest software used in developing TSQL (SSMS). This video is extremely easy to follow and is very well done.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, SSMS Terminology, SSMS Options, SSMS BUG, COLOR CODED SYNT

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - Understanding How 'Context' Works in SSIS Package Execution

Pt. 1 - Understanding How 'Context' Works in SSIS Package Execution - view details
Explained in this first video in the series is the idea of 'context' with repsect to the SQL Server Integration Services, which is a common problem in package execution.
  • Running a package as a job
  • Troubleshooting job failure due to context
  • About SQL Server Agent

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 execution

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS - view details
This wonderfully designed video hosts part 3 of the 4 part series of videos about SQL SERVER MANAGEMENT STUDIO (SSMS). This video will amaze you with extensive amount of informative material enclosed within its binds and is no exception to the wonderful and easy teaching style. Not only does this video detail out the pros and cons of working with the SSMS when designing or working with tables, writing queries within the AdventureWorks database but also contains information on the following items:
  • Launching SSMS from the Windows Start Menu
  • Intro Pinning Windows in SSMS
  • Intro to Tabbed Environment
  • Common Errors in SSMS and rectifying those errors
  • Object Explorer Right Click Options
  • Intro Properties window
  • Explanation of SAVE ME Asterisks
  • Detailed Explanation of column properties
  • Intro to Identity Columns in column properties
  • Generate Change Script Option
  • Intro to SQL SERVER AGENT
  • Creating and scheduling a SQL SERVER AGENT TASK
  • Common Real World Errors within SQL SERVER AGENT TASKS
  • Rectifying Common Errors within SQL SERVER AGENT TASKS
  • Benefits of the Change Scripts
  • Schema Change Definition
  • Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • Dangers of Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • TSQL INSERT STATEMENT vs. OPEN TABLE Query Designer Graphic User Interface (GUI) in SSMS Comparison
  • Intro to Transactions, Rollback and Commit
The trainer in this video does a wonderful job of continuing the introduction to to SSMS. This video does a fantastic job of combining real world environments, common error probabilities and realistic tasks together in an easy to follow training course.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: query designer, table properties, ssms, sql server management studio, management studio,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries)

Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries) - view details
Another great introduction video to SQL SERVER MANAGEMENT STUDIO (SSMS) by Scott Whigham. This video leaps us onto the next stepping stone for SSMS. Scott not only continues his teachings about Generating Scripts within SSMS, he also gives is the another basic introduction to SSMS and explains why SSMS is the sole tool to utilize when writing TSQL. Included in this video are the following excellent features:
  • SQL SERVER Connection Requirements in 7.0 or 2000
  • SQL SERVER 2005 Color Coded Syntax
  • Disconnect and Switch Connection options
  • Basic Introduction to SAVE ME Asterisks
  • Basic Introduction to MDX and DMX Queries inside SSMS
  • Lack of Intellisense within SSMS
  • History of Intellisense
  • Third party Intellisense software is available
  • SSMS available options
  • Hot keys within SSMS and where to set them
  • SQL SERVER 2005 Chords - ie. Commenting out blocks of code (CTRL+K, CTRL+C)
  • How to comment and uncomment blocks of code with a couple pushes of keys
  • Funny SSMS non malicious bug in SSMS
This video is a must see, even if only for the bug within SSMS SP2. It is funny once you know about it and can be confusing if you see it before you know it is a BUG. Scott does a fantastic job of bringing us up to speed on the newest software used in developing TSQL (SSMS). This video is extremely easy to follow and is very well done.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, SSMS Terminology, SSMS Options, SSMS BUG, COLOR CODED SYNT

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log - view details
This video is the part 4 of a series of 4 videos detailing information about SQL SERVER MANAGEMENT STUDIO (SSMS). This is an excellent conclusion to the video series introducing you to your error logs within SSMS. This video will introduce you to working with Error logs within SQL Server Management Studio (SSMS) as well as some of the following items:
  • Error log viewer
  • Windows Event Log viewable within the Error Log
  • Agents log within the viewer as well
  • Introduction and explanation of the unified log viewer
  • Introduction to integration of reports in management studio
  • Introduction to graphic reports with SSMS
  • Introduction to writing custom reports
This is a perfect conclusion to a very informative video series. After the reviewing the video series in all you should have a very good understanding of SQL Server Management Studio. The
whole video series is a must see and is perfect for the newbie and a great reference to the experienced SQL programmer.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ssms, sql server management studio, management studio, error logs, reports,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS - view details
This wonderfully designed video hosts part 3 of the 4 part series of videos about SQL SERVER MANAGEMENT STUDIO (SSMS). This video will amaze you with extensive amount of informative material enclosed within its binds and is no exception to the wonderful and easy teaching style. Not only does this video detail out the pros and cons of working with the SSMS when designing or working with tables, writing queries within the AdventureWorks database but also contains information on the following items:
  • Launching SSMS from the Windows Start Menu
  • Intro Pinning Windows in SSMS
  • Intro to Tabbed Environment
  • Common Errors in SSMS and rectifying those errors
  • Object Explorer Right Click Options
  • Intro Properties window
  • Explanation of SAVE ME Asterisks
  • Detailed Explanation of column properties
  • Intro to Identity Columns in column properties
  • Generate Change Script Option
  • Intro to SQL SERVER AGENT
  • Creating and scheduling a SQL SERVER AGENT TASK
  • Common Real World Errors within SQL SERVER AGENT TASKS
  • Rectifying Common Errors within SQL SERVER AGENT TASKS
  • Benefits of the Change Scripts
  • Schema Change Definition
  • Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • Dangers of Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • TSQL INSERT STATEMENT vs. OPEN TABLE Query Designer Graphic User Interface (GUI) in SSMS Comparison
  • Intro to Transactions, Rollback and Commit
The trainer in this video does a wonderful job of continuing the introduction to to SSMS. This video does a fantastic job of combining real world environments, common error probabilities and realistic tasks together in an easy to follow training course.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: query designer, table properties, ssms, sql server management studio, management studio,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

Pt. 1 - An Introduction to SQL Server Management Studio (SSMS) - view details
Scott Whigham does a phenomenal job of introducing you to the new SQL SERVER MANAGEMENT STUDIO (SSMS).This solid introduction begins with the most common uses of SSMS. This lesson does utilize the SP2 version of SQL 2005 however does not require the student to have this installed. This video is filled with a wealth of knowledge and information waiting to be absorbed. This is a fantastic video for the new and old programmers alike. If you are unfamiliar with any of the following than this video is for you:
  • SQL SERVER 2005 terminology.
  • Just in Time terminology and explanation (JIT)
  • JIT Compiling explanation of usage within SQL Server Management Studio
  • SSMS Terminology
  • Pertinent and important options available within SSMS
  • Introduction to working with PINUPS within the WINDOWS Start menu.
  • OBJECT Explorer in SSMS (Closest replacement for Enterprise Manager/Object Browser)
  • Proper usage of the OBJECT Explorer
  • SQL SERVER 2005 Version Number (Version 9)
  • Introduction to beginning troubleshooting with SQL SERVER CONFIGURATION MANAGER
  • Connecting to Reporting Services, Integration Services and Database Engines.
  • Introduction to scripting within SSMS.
  • Non MODAL Windows in SSMS 2005 vs. MODAL Windows in SQL 2000
This video is a must see for all beginners and anyone looking to further their basic knowledge about SSMS. If you are not familiar with SSMS you will be very pleased with how easy this video is to follow & absorb and how quickly Scott makes use of your valuable time in properly teaching the correct way to enter the world of SQL SERVER MANAGEMENT STUDIO.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, JIT Compiling, JIT, SSMS Terminology, SSMS Options, NON MO

posted by Scott Whigham @ 4:35 AM  

Thursday, January 24, 2008

New Reporting Services Video Tutorial: Pt. 2 - Discussion of the Design of the ReportServer Database

Pt. 2 - Discussion of the Design of the ReportServer Database - view details
This second and final video in this series on database discussion will cover in depth more about the most accessible stored procedures in SQL Server Management Studio.

Highlights:

  • Stored Procedures execution
  • Copying code from Profiler to SSMS
  • What does "GET" do/mean?

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: database documentaton , report server database, database, report server, stored procedures, GET, management studio

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation

Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation - view details
This short video tutorial will show you how to do the first half of the install of the SQL Server 2005 Service Pack 2 for your Reporting Services installation, a crucial component for maintainence and patching purposes.

Highlights from this video:

  • Service Pack background
  • Service Pack set-up and install
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sp2 ,reporting services, install sp2, service pack 2 ,installing

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - How to Create your First Report With the Report Server Project Wizard

Pt. 1 - How to Create your First Report With the Report Server Project Wizard - view details
This first video in the series will show you the��beginning of the step-by-step task of creating your first, simple report with the Report Server Project Wizard.

Highlights:

  • ��Using SQL Server BIDS
  • Data source selection options/properties
  • Using the Query Builder and Query Designer

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: create report, build report, BIDS, query builder, query designer, report, first report

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation

Pt. 2 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation - view details
Continued in this video is a walkthrough of ways to determine whether or not there was a successful install of the serivce pack 2 , which requires a little bit of digging.

Highlights from this video:

  • Analyzing the Binary Path
  • Service pack file versions and build

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: sp2 ,reporting services, install sp2, service pack 2 ,installing

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Install Reporting Services on a Machine That Already Has SQL Server 2005 SP1 or SP2

Pt. 2 - How to Install Reporting Services on a Machine That Already Has SQL Server 2005 SP1 or SP2 - view details
Continued in this video is the completion of the install and set-up of Reporting Services for a machine that already has SQL Server SP1/SP2

Highlights from this video:

  • How to spot a successful install
  • Updating Reporting Service to SP1/2
  • Using Reporting Services Configuration Manager

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: install reporting services, reporting services installation, installing, reporting services

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

Pt. 1 - An Introduction to SQL Server Management Studio (SSMS) - view details
Scott Whigham does a phenomenal job of introducing you to the new SQL SERVER MANAGEMENT STUDIO (SSMS).This solid introduction begins with the most common uses of SSMS. This lesson does utilize the SP2 version of SQL 2005 however does not require the student to have this installed. This video is filled with a wealth of knowledge and information waiting to be absorbed. This is a fantastic video for the new and old programmers alike. If you are unfamiliar with any of the following than this video is for you:
  • SQL SERVER 2005 terminology.
  • Just in Time terminology and explanation (JIT)
  • JIT Compiling explanation of usage within SQL Server Management Studio
  • SSMS Terminology
  • Pertinent and important options available within SSMS
  • Introduction to working with PINUPS within the WINDOWS Start menu.
  • OBJECT Explorer in SSMS (Closest replacement for Enterprise Manager/Object Browser)
  • Proper usage of the OBJECT Explorer
  • SQL SERVER 2005 Version Number (Version 9)
  • Introduction to beginning troubleshooting with SQL SERVER CONFIGURATION MANAGER
  • Connecting to Reporting Services, Integration Services and Database Engines.
  • Introduction to scripting within SSMS.
  • Non MODAL Windows in SSMS 2005 vs. MODAL Windows in SQL 2000
This video is a must see for all beginners and anyone looking to further their basic knowledge about SSMS. If you are not familiar with SSMS you will be very pleased with how easy this video is to follow & absorb and how quickly Scott makes use of your valuable time in properly teaching the correct way to enter the world of SQL SERVER MANAGEMENT STUDIO.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, JIT Compiling, JIT, SSMS Terminology, SSMS Options, NON MO

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - How to Install Reporting Services on a Machine That Already Has SQL Server 2005 SP1 or SP2

Pt. 1 - How to Install Reporting Services on a Machine That Already Has SQL Server 2005 SP1 or SP2 - view details
This great video series will provide you with a walkthrough of how exactly you can take an SP1/SP2 instance of SQL server and actually get Reporting Services installed onto that machine because, by default, you might have a little trouble in doing so! In this first video tutorial in the 2 part series, Scott will take you through the background of the install and also the first half of the set-up.

Highlights from this video:

  • How do I know that Reporting Services isn't installed?
  • Required Windows components for install
  • Assigning needed permissions for SSRS
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: install reporting services, reporting services installation, installing, reporting services

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Discussion of the Design of the ReportServer Database

Pt. 1 - Discussion of the Design of the ReportServer Database - view details
This great and very informative video tutorial will be working primarily in SQL Server Management Studio. It will be covering the layout of tables, the structure of the database, and what you can do from query writing or reporting standpoint against your report server as a datasource!

Highlights:

  • Creating/adding Database diagrams
  • Table relations and�� foreign/primary keys
  • Adding tables to diagrams
  • Writing queries from your database diagrams
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: report server, database documentation, database, ssms, management studio, structure, query writing, datasource

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Create your First Report With the Report Server Project Wizard

Pt. 2 - How to Create your First Report With the Report Server Project Wizard - view details
This second video in the series will start with the Query Builder and continue through the end Report Wizard and then start in the Report Designer.

Highlights:

  • Report types and table designs
  • About Deployment and deployment location
  • Changing properties in Report Designer
  • Using the Toolbox

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: report, query builder, report designer, build report, create report, report types, deploy, first report,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - Customizing the Installation: Service Accounts, Tools, and Choosing the Default Installation Option

Pt. 2 - Customizing the Installation: Service Accounts, Tools, and Choosing the Default Installation Option - view details
This second video in the series will cover more of the advanced installation of Reporting Services for SQL Server 2005. It will go into depth about how to customize many aspects��of your install such as service account, tools, and much more!

Highlights:

  • Installing sample databases
  • Customizing for every service account
  • Built-in system account vs domain user accounts
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Service Accounts, Tools, Default Installation, reporting services install, sample databases, system account, domain user account

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - How to Perform a Files Only Installation On the Same Machine

Pt. 1 - How to Perform a Files Only Installation On the Same Machine - view details
This first video in the series will provide you with the beginning of the walkthrough of a files-only installation, particularly suited for those of you who have an existing SQL server in your environment yet now you want to add Reporting Services to that environment.

Highlights from this video:

  • Prep-work and pre-requisites for install
  • Defining service accounts
  • Guarantee of files-only configuration

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: files only install, add reporting services, files only configuration

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 5 - Using SQL Server Management Studio to Manage Reporting Services

Pt. 5 - Using SQL Server Management Studio to Manage Reporting Services - view details
This final video in this series will go into more depth about the SQL Server Management Studio, which you will find you'll be spending a lot of time working with. This video will show you how to use SSMS to manage your reporting services.

Higlights:

  • Launching SSMS
  • Adding new data source
  • Management Service vs Web Service

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: ssms, sql server management studio, intro ssms, datasource, web service, management studio, shared schedule, report server, repo

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - Configuring SQL Server Reporting Services Manually

Pt. 2 - Configuring SQL Server Reporting Services Manually - view details
After the install of Reporting Services, it will now be neccesary to configure Reporting Services to get it up and running. In this second video tutorial in the series you instructor will walk you through the manual configuration and set-up of SQL Server Reporting Services.

Highlights from this video:

  • How to determine if SSRS is configured and running
  • Setting up virtual directories and the report manager
  • Changing application pool properties
  • Modifying the 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: configure reporting services, manual configuration sql server reporting services, service account

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - Tour of How to Use SQL Server Management Studio (SSMS) To Manage SSRS

Pt. 4 - Tour of How to Use SQL Server Management Studio (SSMS) To Manage SSRS - view details
This fourth and final video in this series will provide you with a basic discussion on��how to use SSMS, SQL Server Management Studio, to manage your reports in your Report Server.

Highlights:

  • Adding a new datasource
  • Web Service vs Management Studio
  • Defining shared schedules
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ssms, sql server management studio, intro ssms, datasource, web service, management studio, shared schedule, report server, repo

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - Looking at the New Installation: SSMS and the Reporting Services Configuration Manager

Pt. 3 - Looking at the New Installation: SSMS and the Reporting Services Configuration Manager - view details
This video will begin at the completion of the SQL Server setup and will take a look at the default configuration of Reporting Services

Highlights:

  • 3 Important SQL Server tools
  • What does SSMS do? (SQL Server Management Studio)
  • RS Exec Role
  • Reporting Service Configuration utility
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ssms, sql server management studio, configure, reporting service, sql server tools, rs exec roles

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - An Introduction to the Various Tools You Will Use With SQL Server Reporting Services

Pt. 3 - An Introduction to the Various Tools You Will Use With SQL Server Reporting Services - view details
In this third video tutorial in this series, you will be taking a look at the various tools you will be using to configure your Reporting Services.

Highlights:

  • Creating your own MMC
  • IIS Manager, SQL Server Management Studio, BIDS
  • Report Server backup
  • Changes to system databases

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: ssrs, sql server reporting services, mmc, IIS manager, ssms, BIDS, report server backup,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - Understanding Configuration Options: Encryption, Virtual Directories, Application Pools and More

Pt. 4 - Understanding Configuration Options: Encryption, Virtual Directories, Application Pools and More - view details
This fourth video in the series will continue the default install by finishing up the configuration of the report server, included database set-up details and options.

Highlights:

  • Types of service credentials
  • Backing up encryption keys
  • Changes in IIS Manager

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: Encryption, Virtual Directories, Application Pools, default install, report server,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Perform a Default Installation of Reporting Services and SQL Server 2005

Pt. 1 - Perform a Default Installation of Reporting Services and SQL Server 2005 - view details
This first video in the series will walk you through the requirements of doing a default installation, and how to set almost everything up for Reporting Services and SQL Server 2005

Highlights:

  • Types/differences of installations
  • Prerequisites for installation
  • Setting up user accounts
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: default install reporting services, installing , reporting services, user accounts

posted by Scott Whigham @ 4:35 AM  

Tuesday, January 22, 2008

New Reporting Services Video Tutorial: Part6-Working With NULL Parameters and Tricks for SSRS

Part6-Working With NULL Parameters and Tricks for SSRS - view details
This sixth video in the series will go pretty deep into the topic of nulls, and nullable values in a column. Scott will get you to a point where you can easily understand what your options are when creating a report with a drop-down list that will show all values, even the null values.

Highlights from this video:
  • Using UNION statements to generate new drop-down items
  • Mapping a value to all items in a table
  • Working with the CASE operator
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Part7-More on Nullable Parameters Including How to Use UNIONs

Part7-More on Nullable Parameters Including How to Use UNIONs - view details
Continued in this seventh video in the series is the discussion of nullable parameters and the options that we have when returning values and rows, which is quite a difficult piece.

Highlights from this video:
  • 3 Possible choices for how to write a query if a value is null
  • Various CASE operator expressions for your query
  • What is the easiest solution?
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Part4- Dropdown Lists and PickLists

Part4- Dropdown Lists and PickLists - view details
This fourth video will continue where the second video left off by discussing the From Query available values, and how to create a�� dynamic dropdown list�� that will query the database.

Highlights from this video:
  • How to create a dynamic dataset
  • Customizing drop down labels and values
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part5-Using Stored Procedures With Parameters

Part5-Using Stored Procedures With Parameters - view details
This fifth video in the series will shouw you how to use stored procedures in your reports with parameters; a process that is not as difficult as ad-hoc sql, but you do need to see it in action.

Highlights from this video:
  • How to use Stored Procedures work in Transact SQL
  • Designing the query and variations for syntax
  • Creating new dataset vs Using Report Wizard
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Manage Mailbox Permissions on Exchange 2007 SP1

Manage Mailbox Permissions on Exchange 2007 SP1 - view details
In SP1 for Exchange 2007, there are some new features. In this video Grant will demonstrate to you the new ability to grant users permission to another user's mailbox without using a powershell command or behind the scenes in the active directory.

Highlights from this video:
  • Two options for reciepient configuration:
    • Manage full access permissions
    • Manage Send-As permissions
  • Where might I use these configurations?
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: mailbox permissions, exchange sp1, service pack 1, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: p1- Preparation Steps for Installing Exchange 2007 Service Pack 1

p1- Preparation Steps for Installing Exchange 2007 Service Pack 1 - view details
In late November 2007, Service Pack 1 was released for Exchange 2007. This service pack includes a year's worth of development on the Exchange 2007 code and is a big push for the Exchange 2007 world. In this video,Grant will show you the essential steps you must take in preparation for the Exchange 2007 SP1 install by bringing your server up to current pack levels.

Highlights from this video:
  • About the Exchange 2007 SP1 download and slip-stream installation
  • Readiness Check
    • What updates do I need?
    • Where are they found?
  • Installing the Microsoft updates
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: install exchange 2007 sp1, exchange 2007, exchange service pack, service pack 1

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: p2-Installing Exchange 2007 Service Pack 1

p2-Installing Exchange 2007 Service Pack 1 - view details
Once you have installed all the pre-req components, you can then begin the install of Exchange 2007 Service Pack 1. In this second and final video in the series, Grant will walk you through the actual install of the service pack.

Highlights from this video:
  • Readiness check..again
  • How long will it take to complete the install?
  • Errors you might encounter
  • Updating Exchange Management tools
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: install exchange 2007 sp1, exchange 2007, exchange service pack, service pack 1

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part2-Basics of Parameters: datatypes, Nullability, and Default Values

Part2-Basics of Parameters: datatypes, Nullability, and Default Values - view details
In this second video in the series, Scott will give you an overview of the basics of the report parameters and how to go about changing them.

Highlights from this video:
  • Changing the default report parameters:
    • What is a null value?
    • Modifying the prompt
    • Hidden and Internal Parameters
    • Non-queried avaliable values
    • Creating lables and values������
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part1-An introduction to Parameters and Parameterized Reports in SSRS

Part1-An introduction to Parameters and Parameterized Reports in SSRS - view details
You often need more advanced reporting such as drop down lists and the ability to use parameters when working in Sql Server Reporting Services. This first video in the series will give a great introduction of how to work with parameters in SSRS, as well as get you started with working with parameters by briefly demonstrating how to create a drop-down list for managing your parameters.

Highlights from this video:
  • Using variables that have not been declared in SSRS vs TSQL
  • Viewing what happens with Auto-Parameterization
  • Viewing Report Parameters
  • How to create a drop-down list
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part3-Syntax for Parameters in OLE-DB, Oracle, and SQL Server

Part3-Syntax for Parameters in OLE-DB, Oracle, and SQL Server - view details
When using parameters from other datasources like OLE DB or ORACLE, it is essential that you know their proper syntax, as it is different than the specific syntax for SQL Server. In this short, third video in the series, Scott will demonstrate to you the correct syntax to use when working with non-sql sources, such as OLE DB and Oracle.

Highlights from this video:
  • Oracle syntax with ":"
  • OLE DB syntax with "?"
  • How the Report Parameters vary between Oracle, OLE DB, and SQL
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: parameters, report parameters, ssrs, reporting services, oracle, ole db

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: VB Basics - Expressions: What They Are and How to Use Them

VB Basics - Expressions: What They Are and How to Use Them - view details
This starter video tutorial will talk about the idea of what an expression is in Visual Basic syntax, as all languages have expressions, and give you a better understanding of how to use expressions.

Highlights from this video:
  • What is an expression?
  • Examples of expressions
  • Parts of expressions
    • Datatype
    • Value
  • Where can I use an expression?
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: expression, expressions, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, b

posted by Scott Whigham @ 4:35 AM  

Monday, January 21, 2008

New Exchange Server Video Tutorial: Manage Mailbox Permissions on Exchange 2007 SP1

Manage Mailbox Permissions on Exchange 2007 SP1 - view details
In SP1 for Exchange 2007, there are some new features. In this video Grant will demonstrate to you the new ability to grant users permission to another user's mailbox without using a powershell command or behind the scenes in the active directory.

Highlights from this video:
  • Two options for reciepient configuration:
    • Manage full access permissions
    • Manage Send-As permissions
  • Where might I use these configurations?
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: mailbox permissions, exchange sp1, service pack 1, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 12:24 PM  

New Exchange Server Video Tutorial: p2-Installing Exchange 2007 Service Pack 1

p2-Installing Exchange 2007 Service Pack 1 - view details
Once you have installed all the pre-req components, you can then begin the install of Exchange 2007 Service Pack 1. In this second and final video in the series, Grant will walk you through the actual install of the service pack.

Highlights from this video:
  • Readiness check..again
  • How long will it take to complete the install?
  • Errors you might encounter
  • Updating Exchange Management tools
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: install exchange 2007 sp1, exchange 2007, exchange service pack, service pack 1

posted by Scott Whigham @ 12:23 PM  

New Exchange Server Video Tutorial: p1- Preparation Steps for Installing Exchange 2007 Service Pack 1

p1- Preparation Steps for Installing Exchange 2007 Service Pack 1 - view details
In late November 2007, Service Pack 1 was released for Exchange 2007. This service pack includes a year's worth of development on the Exchange 2007 code and is a big push for the Exchange 2007 world. In this video,Grant will show you the essential steps you must take in preparation for the Exchange 2007 SP1 install by bringing your server up to current pack levels.

Highlights from this video:
  • About the Exchange 2007 SP1 download and slip-stream installation
  • Readiness Check
    • What updates do I need?
    • Where are they found?
  • Installing the Microsoft updates
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: install exchange 2007 sp1, exchange 2007, exchange service pack, service pack 1

posted by Scott Whigham @ 12:22 PM  

New Reporting Services Video Tutorial: r1-An introduction to Parameters and Parameterized Reports in SSRS

r1-An introduction to Parameters and Parameterized Reports in SSRS - view details
You often need more advanced reporting such as drop down lists and the ability to use parameters when working in Sql Server Reporting Services. This first video in the series will give a great introduction of how to work with parameters in SSRS, as well as get you started with working with parameters by briefly demonstrating how to create a drop-down list for managing your parameters.

Highlights from this video:
  • Using variables that have not been declared in SSRS vs TSQL
  • Viewing what happens with Auto-Parameterization
  • Viewing Report Parameters
  • How to create a drop-down list
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:16 PM  

New Reporting Services Video Tutorial: r2-Basics of Parameters: datatypes, Nullability, and Default Values

r2-Basics of Parameters: datatypes, Nullability, and Default Values - view details
In this second video in the series, Scott will give you an overview of the basics of the report parameters and how to go about changing them.

Highlights from this video:
  • Changing the default report parameters:
    • What is a null value?
    • Modifying the prompt
    • Hidden and Internal Parameters
    • Non-queried avaliable values
    • Creating lables and values������
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:16 PM  

New Reporting Services Video Tutorial: r3-Syntax for Parameters in OLE-DB, Oracle, and SQL Server

r3-Syntax for Parameters in OLE-DB, Oracle, and SQL Server - view details
When using parameters from other datasources like OLE DB or ORACLE, it is essentials that you know their proper syntax, as it is different than the specific syntax for SQL Server. In this short, third video in the series, Scott will demonstrate to you the correct syntax to use when working with non-sql sources, such as OLE DB and Oracle.

Highlights from this video:
  • Oracle syntax with ":"
  • OLE DB syntax with "?"
  • How the Report Parameters vary between Oracle, OLE DB, and SQL
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: parameters, report parameters, ssrs, reporting services, oracle, ole db

posted by Scott Whigham @ 12:15 PM  

New Reporting Services Video Tutorial: r4- Dropdown Lists and PickLists

r4- Dropdown Lists and PickLists - view details
This fourth video will continue where the second video left off by discussing the From Query available values, and how to create a�� dynamic dropdown list�� that will query the database.

Highlights from this video:
  • How to create a dynamic dataset
  • Customizing drop down labels and values
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:15 PM  

New Reporting Services Video Tutorial: r5-Using Stored Procedures With Parameters

r5-Using Stored Procedures With Parameters - view details
This fifth video in the series will shouw you how to use stored procedures in your reports with parameters; a process that is not as difficult as ad-hoc sql, but you do need to see it in action.

Highlights from this video:
  • How to use Stored Procedures work in Transact SQL
  • Designing the query and variations for syntax
  • Creating new dataset vs Using Report Wizard
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:15 PM  

New Reporting Services Video Tutorial: r6-Working With NULL Parameters and Tricks for SSRS

r6-Working With NULL Parameters and Tricks for SSRS - view details
This sixth video in the series will go pretty deep into the topic of nulls, and nullable values in a column. Scott will get you to a point where you can easily understand what your options are when creating a report with a drop-down list that will show all values, even the null values.

Highlights from this video:
  • Using UNION statements to generate new drop-down items
  • Mapping a value to all items in a table
  • Working with the CASE operator
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:14 PM  

New Reporting Services Video Tutorial: r7-More on Nullable Parameters Including How to Use UNIONs

r7-More on Nullable Parameters Including How to Use UNIONs - view details
Continued in this seventh video in the series is the discussion of nullable parameters and the options that we have when returning values and rows, which is quite a difficult piece.

Highlights from this video:
  • 3 Possible choices for how to write a query if a value is null
  • Various CASE operator expressions for your query
  • What is the easiest solution?
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:14 PM  

New Reporting Services Video Tutorial: r8-Multi-value Parameters

r8-Multi-value Parameters - view details
This final video in the series will discuss how to use/how to work with multi-value parameters, which will take some experience to get used to.

Highlights from this video:
  • What are the multi-value parameters?
  • Behind the scenes base query for the multi-value parameters
  • What rules will then apply for null values?
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: parameters, report parameters, ssrs, reporting services,

posted by Scott Whigham @ 12:13 PM  

Friday, January 18, 2008

New Visual Basic Video Tutorial: pt3-How to Configure reCAPTCHA for Use in Your Websites

pt3-How to Configure reCAPTCHA for Use in Your Websites - view details
This third video in the series will show you how to actually add the CAPTCHA server control to your website!

Highlights from this video:
  • Public Key and Private Key : essentials for a successful captcha
  • Modifying the reCAPTCHA controls
  • Moving keys to web.config for multiple pages
  • How to add a CAPTCHA to your page
    • Referencing the reCAPTCHA dll
    • Adding key settings to web.config
    • Register reCAPTCHA
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: VB Basics - Using Comments

VB Basics - Using Comments - view details
This starter video is mainly targeted for those who have not worked with the Visual Basic language and want to know how to comment and what some of the common code conventions are for commenting�� inside of VB.

Highlights from this video:
  • Making single-line comments
  • Efficiently commenting and uncommenting out multi-line code
  • Who can see comments?
    • Internal comments - Developer
    • ''' XML documentation - Caller
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: visual basic comment, comment, vb language, common code, comments, introduction, step by step, beginner, beginning, for dummies,

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: pt4-Using the ASP.NET Captcha Control

pt4-Using the ASP.NET Captcha Control - view details
This final video will cover a CAPTCHA control developed by Jeff Attwood, found on CodeProject.com, for ASP.NET that uses an httpHandler and is more configurable than the reCAPTCHA control, and how to add it to your website.

Highlights from this video:
  • CAPTCHA control's configurable settings
    • Min/Max Timeout
    • Characters allowed in the CAPTCHA
    • Text Length, etc
  • Adding the CAPTCHA control to your website
    • Referencing the WebControll dll
    • Modifying your web.config
      • Add-in http handlers
      • Map the CAPTCHA image over to the class
    • Register CaptchaControl1
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: pt4-Using the ASP.NET Captcha Control

pt4-Using the ASP.NET Captcha Control - view details
This final video will cover a CAPTCHA control developed by Jeff Attwood, found on CodeProject.com, for ASP.NET that uses an httpHandler and is more configurable than the reCAPTCHA control, and how to add it to your website.

Highlights from this video:
  • CAPTCHA control's configurable settings
    • Min/Max Timeout
    • Characters allowed in the CAPTCHA
    • Text Length, etc
  • Adding the CAPTCHA control to your website
    • Referencing the WebControll dll
    • Modifying your web.config
      • Add-in http handlers
      • Map the CAPTCHA image over to the class
    • Register CaptchaControl1
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: C# Basics - Expressions: What They Are and How to Use Them

C# Basics - Expressions: What They Are and How to Use Them - view details
This starter video tutorial will talk about the idea of what an expression is in C#, as all languages have expressions, and give you a better understanding of how to use expressions.

Highlights from this video:
  • What is an expression?
  • Examples of expressions
  • Parts of expressions
    • Datatype
    • Value
  • Where can I use an expression?
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: expression, expressions, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beg

posted by Scott Whigham @ 4:35 AM  

New C# Video Tutorial: C# Basics - Using Comments

C# Basics - Using Comments - view details
This great video is for those just coming in to the C# language to detail how to use comments and what some of the common code conventions are.

Highlights from this video:
  • How to make comments
    • Single-line comments
    • Multi-line comments
  • Internal/Whitespace comments
  • Generating XML documentation via special commenting
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: c# comments, comment, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, begi

posted by Scott Whigham @ 4:35 AM  

Thursday, January 17, 2008

New Visual Basic Video Tutorial: pt2-Using reCAPTCHA to Block Spam and Protect Content

pt2-Using reCAPTCHA to Block Spam and Protect Content - view details
In this second video in the series you will start out from completion of the installation of the reCAPTCHA control. Scott will then walk you through some of the basics in it's coding in Microsoft Visual Studio.
��
Highlights from this video:
  • Getting started with reCAPTCHA
  • Working with the reCAPTCHA assembly and control
  • Common properties in the CAPTCHA coding and syntax
    • Page.IsValid
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: CAPTCHA, reCAPTCHA, captcha, captcha code, introduction, step by step,, introduction, step by step, beginner, beginning, for dum

posted by Scott Whigham @ 7:35 AM  

New C# Video Tutorial: pt1-An Introduction to CAPTCHAs and the Various Options

pt1-An Introduction to CAPTCHAs and the Various Options - view details
In this first video in the series, Scott will give you a basic introduction to CAPTCHAs, a piece for internet sites that is used to prevent multiple,automated types of spam by issuing distorted images and text that can only be solved by humans.Also in this video Scott will discuss with you some of the providers of CAPTCHA coding, mainly reCAPTCHA . Continued in the rest of�� this video series will be the different types of CAPTCHAs, how to customize for CAPTCHAs for your own website, and showing you how easy it is to work with them!

Highlights from this video:
  • About the nature of CAPTCHAs
  • reCAPTCHA Web Service
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: CAPTCHA, reCAPTCHA, captcha, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginne

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Part9-Storing Full Result Sets in Variables and Using the Foreach Loop for Iteration

Part9-Storing Full Result Sets in Variables and Using the Foreach Loop for Iteration - view details
The last thing you will cover in this series is how to work with a full result set in variables and how to store a full result set in memory via a Foreach loop in SSIS.

Highlights from this video:
  • Modifying result sets and their mappings
  • Foreach loop Editor
    • Collection and Variable
    • Variable mapping
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: variables, variable, script task, result set, foreach loop, ssis,

posted by Scott Whigham @ 7:35 AM  

New Visual Basic Video Tutorial: pt1-An Introduction to CAPTCHAs and the Various Options

pt1-An Introduction to CAPTCHAs and the Various Options - view details
In this first video in the series, Scott will give you a basic introduction to CAPTCHAs, a piece for internet sites that is used to prevent multiple,automated types of spam by issuing distorted images and text that can only be solved by humans.Also in this video Scott will discuss with you some of the providers of CAPTCHA coding, mainly reCAPTCHA . Continued in the rest of�� this video series will be the different types of CAPTCHAs, how to customize for CAPTCHAs for your own website, and showing you how easy it is to work with them!

Highlights from this video:
  • About the nature of CAPTCHAs
  • reCAPTCHA Web Service
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: CAPTCHA, reCAPTCHA, captcha, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginne

posted by Scott Whigham @ 7:35 AM  

New Transact SQL 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: FastParse, text files, multiple, parallel data load

posted by Scott Whigham @ 7:35 AM  

New C# Video Tutorial: pt3-How to Configure reCAPTCHA for Use in Your Websites

pt3-How to Configure reCAPTCHA for Use in Your Websites - view details
This third video in the series will show you how to actually add the CAPTCHA server control to your website!

Highlights from this video:
  • Public Key and Private Key : essentials for a successful captcha
  • Modifying the reCAPTCHA controls
  • Moving keys to web.config for multiple pages
  • How to add a CAPTCHA to your page
    • Referencing the reCAPTCHA dll
    • Adding key settings to web.config
    • Register reCAPTCHA
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 7:35 AM  

New C# Video Tutorial: pt2-Using reCAPTCHA to Block Spam and Protect Content

pt2-Using reCAPTCHA to Block Spam and Protect Content - view details
In this second video in the series you will start out from completion of the installation of the reCAPTCHA control. Scott will then walk you through some of the basics in it's coding in Microsoft Visual Studio.
��
Highlights from this video:
  • Getting started with reCAPTCHA
  • Working with the reCAPTCHA assembly and control
  • Common properties in the CAPTCHA coding and syntax
    • Page.IsValid
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: CAPTCHA, reCAPTCHA, captcha, captcha code, introduction, step by step,, introduction, step by step, beginner, beginning, for dum

posted by Scott Whigham @ 7:35 AM  

New Transact SQL 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: data flow,task, fastparce, execution speed

posted by Scott Whigham @ 7:35 AM  

New Transact SQL 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: BULKINSERT, SSIS, sql server integration services, destination connection,compare

posted by Scott Whigham @ 7:35 AM  

New Transact SQL 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: batch size, load hints, format files, BCP,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: index, BCP, clustered index order, comparison, compare,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: bulk insert, bcp, loading scenario, bulk operations

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: OPENROWSET, BULK INSERT, DROPCLEANBUFFERS, loading flat file,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: triggers, create trigger, fire triggers, BCP, BULKINSERT, check constraints

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: filed terminators, format file, xml format file , xml, BCP, running BCP

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: BCP, utility, BULKINSERT, xml format, .fmt file

posted by Scott Whigham @ 4:35 AM  

New Transact SQL 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: BULK INSERT, OPENROWSET,BCP, functions, timing, compare, comparison, syntax

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:
  • What are the options for the Recovery Model?
  • How to set the database recovery model to BULK_LOGGED
  • Advantages of BULK_LOGGED
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: bulk operations, intro to bulk operations, recovery model, BULK_LOGGED,

posted by Scott Whigham @ 4:35 AM  

Wednesday, January 16, 2008

New C# Video Tutorial: C# Basics - Using Comments

C# Basics - Using Comments - view details
This great video is for those just coming in to the C# language to detail how to use comments and what some of the common code conventions are.

Highlights from this video:
  • How to make comments
    • Single-line comments
    • Multi-line comments
  • Internal/Whitespace comments
  • Generating XML documentation via special commenting
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: c# comments, comment, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, begi

posted by Scott Whigham @ 2:02 PM  

New C# Video Tutorial: C# Basics - Expressions: What They Are and How to Use Them

C# Basics - Expressions: What They Are and How to Use Them - view details
This starter video tutorial will talk about the idea of what an expression is in C#, as all languages have expressions, and give you a better understanding of how to use expressions.

Highlights from this video:
  • What is an expression?
  • Examples of expressions
  • Parts of expressions
    • Datatype
    • Value
  • Where can I use an expression?
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: expression, expressions, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beg

posted by Scott Whigham @ 2:01 PM  

New Visual Basic Video Tutorial: VB Basics - Using Comments

VB Basics - Using Comments - view details
This starter video is mainly targeted for those who have not worked with the Visual Basic language and want to know how to comment and what some of the common code conventions are for commenting�� inside of VB.

Highlights from this video:
  • Making single-line comments
  • Efficiently commenting and uncommenting out multi-line code
  • Who can see comments?
    • Internal comments - Developer
    • ''' XML documentation - Caller
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: visual basic comment, comment, vb language, common code, comments, introduction, step by step, beginner, beginning, for dummies,

posted by Scott Whigham @ 1:59 PM  

New Visual Basic Video Tutorial: VB Basics - Expressions: What They Are and How to Use Them

VB Basics - Expressions: What They Are and How to Use Them - view details
This starter video tutorial will talk about the idea of what an expression is in Visual Basic syntax, as all languages have expressions, and give you a better understanding of how to use expressions.

Highlights from this video:
  • What is an expression?
  • Examples of expressions
  • Parts of expressions
    • Datatype
    • Value
  • Where can I use an expression?
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: expression, expressions, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, b

posted by Scott Whigham @ 1:59 PM  

New Visual Basic Video Tutorial: pt4-Using the ASP.NET Captcha Control

pt4-Using the ASP.NET Captcha Control - view details
This final video will cover a CAPTCHA control developed by Jeff Attwood, found on CodeProject.com, for ASP.NET that uses an httpHandler and is more configurable than the reCAPTCHA control, and how to add it to your website.

Highlights from this video:
  • CAPTCHA control's configurable settings
    • Min/Max Timeout
    • Characters allowed in the CAPTCHA
    • Text Length, etc
  • Adding the CAPTCHA control to your website
    • Referencing the WebControll dll
    • Modifying your web.config
      • Add-in http handlers
      • Map the CAPTCHA image over to the class
    • Register CaptchaControl1
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 1:52 PM  

New Visual Basic Video Tutorial: pt3-How to Configure reCAPTCHA for Use in Your Websites

pt3-How to Configure reCAPTCHA for Use in Your Websites - view details
This third video in the series will show you how to actually add the CAPTCHA server control to your website!

Highlights from this video:
  • Public Key and Private Key : essentials for a successful captcha
  • Modifying the reCAPTCHA controls
  • Moving keys to web.config for multiple pages
  • How to add a CAPTCHA to your page
    • Referencing the reCAPTCHA dll
    • Adding key settings to web.config
    • Register reCAPTCHA
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: CAPTCHA, reCAPTCHA, captcha, captcha code, server control, asp.net control,

posted by Scott Whigham @ 1:52 PM  

New Visual Basic Video Tutorial: pt2-Using reCAPTCHA to Block Spam and Protect Content

pt2-Using reCAPTCHA to Block Spam and Protect Content - view details
In this second video in the series you will start out from completion of the installation of the reCAPTCHA control. Scott will then walk you through some of the basics in it's coding in Microsoft Visual Studio.
��
Highlights from this video:
  • Getting started with reCAPTCHA
  • Working with the reCAPTCHA assembly and control
  • Common properties in the CAPTCHA coding and syntax
    • Page.IsValid
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: CAPTCHA, reCAPTCHA, captcha, captcha code, introduction, step by step,, introduction, step by step, beginner, beginning, for dum

posted by Scott Whigham @ 1:51 PM  

New Visual Basic Video Tutorial: pt1-An Introduction to CAPTCHAs and the Various Options

pt1-An Introduction to CAPTCHAs and the Various Options - view details
In this first video in the series, Scott will give you a basic introduction to CAPTCHAs, a piece for internet sites that is used to prevent multiple,automated types of spam by issuing distorted images and text that can only be solved by humans.Also in this video Scott will discuss with you some of the providers of CAPTCHA coding, mainly reCAPTCHA . Continued in the rest of�� this video series will be the different types of CAPTCHAs, how to customize for CAPTCHAs for your own website, and showing you how easy it is to work with them!

Highlights from this video:
  • About the nature of CAPTCHAs
  • reCAPTCHA Web Service
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: CAPTCHA, reCAPTCHA, captcha, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginne

posted by Scott Whigham @ 1:51 PM  

Tuesday, January 15, 2008

New SQL Server Integration Services Video Tutorial: Part6-Variables and the Execute SQL Task

Part6-Variables and the Execute SQL Task - view details
In this sixth video in the series, you will get into the Execute SQL Task�� to retrieve a single value from a SQL statement, as well as map up multiple parameters to multiple variables, and assigning result sets based on columns,a somewhat tedious process .

Highlights from this video:
  • SQL Source types in the Execute SQL Task Editor
  • Entering SQL Queries
  • Result set mapping
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: variables, variable, script task, dts.variables, data flow task, sql statement, sql command, execute sql, sql task,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA)

Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA) - view details
Ever wonder where the box to display your variables is placed or where in the Project Explorer they are located? Well, in this second video in the series you will take a look at how to gain access to your variables using the Script Task in Microsoft Visual Studio, as it is not easily done from the script task editor interface.

Highlights from this video:
  • Viewing/Filtering system variables vs user variables
  • Using Dts.Variables
  • Some annoyances in SSIS with variables
    • Script task editor
    • DTS Script Task Runtime Error
    • AutoSaving script changes
  • CString or ToString for displaying message boxes containing variables
  • ReadOnly variables and ReadWrite variables
  • Behavioral changes in SSIS from DTS
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: variables, variable, script task, user defined variables, system variables, dts.variables

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part8-How to Capture Output Parameters and Return Values From Stored Procedures

Part8-How to Capture Output Parameters and Return Values From Stored Procedures - view details
In the previous video you learned about how difficult it is to do Input parameters. In this first part of the video, Scott will walk you through the easiest way to do input parameters... with expressions! The second part of the video will talk about ouput parameters and return values, which are the otherdirections in parameter mappings.

Highlights from this video:
  • Expression Builder
    • Working with expressions and variables
    • ��Type casts
  • Creating a procedure to trap the value of an ouput parameter
  • Opposite syntax?!
  • About return values
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: variables, variable, script task, dts.variables, data flow task, output parameter, return value, parameter mapping

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part7-A Better Way to Do Input Parameters and Parameter Mapping

Part7-A Better Way to Do Input Parameters and Parameter Mapping - view details
This seventh video in the series will demonstrate to you some very common and confusing mistakes when doing input parameters and parameter mappings, which can be a substantially frustrating process in SSIS.

Highlights from this video:
  • Looking in Profiler
  • Direct Input SQL Source type
  • Parameter mapping directions
    • Input
    • Output
    • ReturnValue
  • Proper Syntax for entering SQL queries and parameter 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: variables, variable, script task, dts.variables, input parameters, parameter mapping,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part5-Using Dynamically Assigned Table/View Names in Your Data Flow Tasks

Part5-Using Dynamically Assigned Table/View Names in Your Data Flow Tasks - view details
A common technique that many use is to create a script task, then assign a SQL statement to a variable and then pass it to the Data Flow Task. In this fifth video Scott will walk you through the process of doing so.

Highlights from this video:
  • Embedding SQL command statements inside of a variable
  • What can the SQL commands do for my variables?
  • Briefly working with Expressions in SSSI
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: variables, variable, script task, dts.variables, data flow task, sql statement, sql command,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part4-Using Variables in the Data Flow Task, Data Sources, and Destinations

Part4-Using Variables in the Data Flow Task, Data Sources, and Destinations - view details
After covering some of the basics like creating variables, viewing some common pitfalls in SSIS, and working with the Script Task, you will now start working with Data Flow task in this fourth video in the series. Your instructor Scott will also cover some helpful info about working with data sources and destinations for the Data Flow Task.

Highlights from this video:
  • Data Access Modes in OLE DB Source Editor
  • About validating external metadata
  • Combining the Script Task with the Data Flow Task
  • More Scope cautions and errors
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: variables, variable, script task, user defined variables, system variables, dts.variables, data flow task, scope,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part3-How Scoping and Namespaces Work With SSIS Variables

Part3-How Scoping and Namespaces Work With SSIS Variables - view details
Continued in this third video in the series, Scott will demonstrate to you how to address a user variable that is in a different namespace other than user, and show you some pretty important cautions and pitfalls when working with variables in SSIS.

Highlights from this video:
  • Locating variables without addressing the namespace
  • Working with variables that have the same name, but different namespaces
    • Ambiguous references
    • Properly addressing variables
  • Cautions of Scope
    • Task-level variables
    • Package-level variables
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: variables, variable, script task, user defined variables, system variables, dts.variables, package level variables, task level,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part1-An Introduction to Using Variables in SQL Server Integration Services

Part1-An Introduction to Using Variables in SQL Server Integration Services - view details
Variables are a very flexible addition to the SQL Services Integration Services package that store values for passing data from Task A to Task B. In this essential introduction to the world of variables in SSIS, Scott will show you how to get started using variables in Integration Services, both directly and indirectly within certain tasks like the script task or the Execute SQL, as well as show you the many things in SSIS they actually can do. Many find that variables are a worthwhile subject for enhancing your SSIS knowledge and this video series will help you to do just that!

Highlights from this video:
  • About the two types of variables and their uses
    • System Variables
    • User-defined Variables
  • Adding new variables and setting their credentials (Name, Scope, Data Type, etc)
  • Namespace differentiations between system variables and user variables
  • Technicalities of names and 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: variables, variable, script task, user defined variables, system variables

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this fourth and final video in the series, you will finish up the dicussion of Dynamic Management Views by learning more about the dm_tran series of DMVs and how they can be beneficial to you.

Highlights from this video:
  • About the sys.dm_tran category
  • Viewing transaction locks on the system
  • Active transactions, transaction types, database transactions
and 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: dynamic management view, DMV, lock, block, transaction,

posted by Scott Whigham @ 4:35 AM  

Monday, January 14, 2008

New SQL Server Integration Services Video Tutorial: Part 9-Storing Full Result Sets in Variables and Using the Foreach Loop for Iteration

Part 9-Storing Full Result Sets in Variables and Using the Foreach Loop for Iteration - view details
The last thing you will cover in this series is how to work with a full result set in variables and how to store a full result set in memory via a Foreach loop in SSIS.

Highlights from this video:
  • Modifying result sets and their mappings
  • Foreach loop Editor
    • Collection and Variable
    • Variable mapping
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: variables, variable, script task, result set, foreach loop, ssis,

posted by Scott Whigham @ 2:35 PM  

New SQL Server Integration Services Video Tutorial: Part 8-How to Capture Output Parameters and Return Values From Stored Procedures

Part 8-How to Capture Output Parameters and Return Values From Stored Procedures - view details
In the previous video you learned about how difficult it is to do Input parameters. In this first part of the video, Scott will walk you through the easiest way to do input parameters... with expressions! The second part of the video will talk about ouput parameters and return values, which are the otherdirections in parameter mappings.

Highlights from this video:
  • Expression Builder
    • Working with expressions and variables
    • ��Type casts
  • Creating a procedure to trap the value of an ouput parameter
  • Opposite syntax?!
  • About return values
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: variables, variable, script task, dts.variables, data flow task, output parameter, return value, parameter mapping

posted by Scott Whigham @ 2:35 PM  

New SQL Server Integration Services Video Tutorial: Part7-A Better Way to Do Input Parameters and Parameter Mapping

Part7-A Better Way to Do Input Parameters and Parameter Mapping - view details
This seventh video in the series will demonstrate to you some very common and confusing mistakes when doing input parameters and parameter mappings, which can be a substantially frustrating process in SSIS.

Highlights from this video:
  • Looking in Profiler
  • Direct Input SQL Source type
  • Parameter mapping directions
    • Input
    • Output
    • ReturnValue
  • Proper Syntax for entering SQL queries and parameter 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: variables, variable, script task, dts.variables, input parameters, parameter mapping,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part6-Variables and the Execute SQL Task

Part6-Variables and the Execute SQL Task - view details
In this sixth video in the series, you will get into the Execute SQL Task�� to retrieve a single value from a SQL statement, as well as map up multiple parameters to multiple variables, and assigning result sets based on columns,a somewhat tedious process .

Highlights from this video:
  • SQL Source types in the Execute SQL Task Editor
  • Entering SQL Queries
  • Result set mapping
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: variables, variable, script task, dts.variables, data flow task, sql statement, sql command, execute sql, sql task,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part5-Using Dynamically Assigned Table/View Names in Your Data Flow Tasks

Part5-Using Dynamically Assigned Table/View Names in Your Data Flow Tasks - view details
A common technique that many use is to create a script task, then assign a SQL statement to a variable and then pass it to the Data Flow Task. In this fifth video Scott will walk you through the process of doing so.

Highlights from this video:
  • Embedding SQL command statements inside of a variable
  • What can the SQL commands do for my variables?
  • Briefly working with Expressions in SSSI
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: variables, variable, script task, dts.variables, data flow task, sql statement, sql command,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part4-Using Variables in the Data Flow Task, Data Sources, and Destinations

Part4-Using Variables in the Data Flow Task, Data Sources, and Destinations - view details
After covering some of the basics like creating variables, viewing some common pitfalls in SSIS, and working with the Script Task, you will now start working with Data Flow task in this fourth video in the series. Your instructor Scott will also cover some helpful info about working with data sources and destinations for the Data Flow Task.

Highlights from this video:
  • Data Access Modes in OLE DB Source Editor
  • About validating external metadata
  • Combining the Script Task with the Data Flow Task
  • More Scope cautions and errors
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: variables, variable, script task, user defined variables, system variables, dts.variables, data flow task, scope,

posted by Scott Whigham @ 2:33 PM  

New SQL Server Integration Services Video Tutorial: Part3-How Scoping and Namespaces Work With SSIS Variables

Part3-How Scoping and Namespaces Work With SSIS Variables - view details
Continued in this third video in the series, Scott will demonstrate to you how to address a user variable that is in a different namespace other than user, and show you some pretty important cautions and pitfalls when working with variables in SSIS.

Highlights from this video:
  • Locating variables without addressing the namespace
  • Working with variables that have the same name, but different namespaces
    • Ambiguous references
    • Properly addressing variables
  • Cautions of Scope
    • Task-level variables
    • Package-level variables
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: variables, variable, script task, user defined variables, system variables, dts.variables, package level variables, task level,

posted by Scott Whigham @ 2:33 PM  

New SQL Server Integration Services Video Tutorial: Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA)

Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA) - view details
Ever wonder where the box to display your variables is placed or where in the Project Explorer they are located? Well, in this second video in the series you will take a look at how to gain access to your variables using the Script Task in Microsoft Visual Studio, as it is not easily done from the script task editor interface.

Highlights from this video:
  • Viewing/Filtering system variables vs user variables
  • Using Dts.Variables
  • Some annoyances in SSIS with variables
    • Script task editor
    • DTS Script Task Runtime Error
    • AutoSaving script changes
  • CString or ToString for displaying message boxes containing variables
  • ReadOnly variables and ReadWrite variables
  • Behavioral changes in SSIS from DTS
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: variables, variable, script task, user defined variables, system variables, dts.variables

posted by Scott Whigham @ 2:33 PM  

New SQL Server Integration Services Video Tutorial: Part1-An Introduction to Using Variables in SQL Server Integration Services

Part1-An Introduction to Using Variables in SQL Server Integration Services - view details
Variables are a very flexible addition to the SQL Services Integration Services package that store values for passing data from Task A to Task B. In this essential introduction to the world of variables in SSIS, Scott will show you how to get started using variables in Integration Services, both directly and indirectly within certain tasks like the script task or the Execute SQL, as well as show you the many things in SSIS they actually can do. Many find that variables are a worthwhile subject for enhancing your SSIS knowledge and this video series will help you to do just that!

Highlights from this video:
  • About the two types of variables and their uses
    • System Variables
    • User-defined Variables
  • Adding new variables and setting their credentials (Name, Scope, Data Type, etc)
  • Namespace differentiations between system variables and user variables
  • Technicalities of names and 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: variables, variable, script task, user defined variables, system variables

posted by Scott Whigham @ 2:33 PM  

Friday, January 11, 2008

New SQL Server Video Tutorial: Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this third video, you will learn about the dm_exec and relationships among the sql handle, which will show you how to view the code someone is issuing and past calls and metrics. Scott will do so by walking you through several custom scripts, which are included with this video download!

Highlights from this video:
  • Scripts for:
    • Viewing definitions of system objects
    • Getting the most often run queries
    • Viewing cached query plan SQL text
    • Getting top 200 executed SP's ordered by calls/minute
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dmv, dynamic management view, monitor user, block,lock, script,dm_exec

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer

Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer - view details
SQL Internals Viewer is a free piece of fascinating beta software for SQL. In this video tutorial, Scott will get you started with an overview of using the SQL Internals Viewer,�� and understanding how it corresponds to the data inside your SQL server databases.

Highlights from this video:
  • Navigating the SQL Internals Viewer interface
  • What does each little block represent?
  • Viewing the Transaction Log
  • Page Free Space (PFS), Buffer Pool, Allocations
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: SQL internals Viewer, buffer pool, allocations, Page free space,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this second video, you will learn more about the columns and how to get more info from them. Scott will also dicuss with you some of the more useful Dynamic Management View categories and what they can do for you.

Highlights from this video:
  • More about the Exec DMV category
  • About the Server Process i.d.(SPID), and Session i.d.
  • Shared Memory, LPC, TCP, NC,
  • SQL Handle, plan Handle
and 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: dmv, dynamic management view, monitor user, block,lock,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 2: How to View Members of a Windows Group Using SQL

Part 2: How to View Members of a Windows Group Using SQL - view details
Continued in this video on how to view members and users of a Windows Group via SSMS, Scott will write the actual custom script, which is included with this download, and show you how to obtain your desired result sets.

Highlights from this video:
  • Executing the custom script
  • Matching the output in the stored procedure
  • Obtaining a query-able form of data from the xp_logininfo procedure
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: xp_logininfo, view members, view users, members, windows groups,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Building a Custom MMC for Use with SQL

Building a Custom MMC for Use with SQL - view details
In this video tutorial, Scott will demonstrate to you how to build a custom Microsoft Mangement Console and customize it to fit your needs!

Highlights from this video:
  • Launching your own custom MMC
  • Adding and removing snap-ins to your console
  • About the avaliable snap-ins
and 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: mmc, microsoft management console, build mmc,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 1: How to View Members of a Windows Group Using SQL

Part 1: How to View Members of a Windows Group Using SQL - view details
In many large environments we often see that there are a lot of Windows groups in your SQL server as logins, but do you know exactly who the users are of those groups? Consider also the servers with Windows Groups that are part of the system administrator roleand the power that they have. How can you tell which Windows users are actually the members of that group? In this video tutorial, Scott will show you a great script in SSMS that will show you how to determine the members of Windows Groups, as well as some other fun things you can do with the procedure.

Highlights from this video:
  • Identifying groups vs users, adding new Windows groups as logins to SQL Server
  • Login limitations in SSMS ( SQL Server Management Studio)
  • Executing the user-identifying stored procedure
  • Adjusting the parameters of the stored procedure
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: windows groups, windows users, sql login, view members, view user, management studio,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this first video of the series you will be working with multiple connections, troubleshooting locks and blocks in your server, as well as learn who is doing what with your system by going beyond the Activity Monitor and taking advantage of the Dynamic Management Views, DMVs.

Highlights from this video:
  • Problems with the Activity Monitor
  • Using Filter setting in the Activity Monitor
  • About the DMV categories
and 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: dynamic management view, DMV, lock, block, activity monitor,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer

Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer - view details
In this third and final video, Scott will wrap up his overview of the SQL Internals Viewer by further discussing clustered indexes and working with tables.

Highlights from this video:
  • Effects of clustered indexes vs heap
  • About deleting/removing tables
  • Rebuilding tables
and 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: clustered index, heap, SQL internals viewer, internals viewer,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 2-A Deeper Look at Pages and Extents Using SQL Internals Viewer

Part 2-A Deeper Look at Pages and Extents Using SQL Internals Viewer - view details
Continued in this second video of the series, Scott will walk you through the SQL Internals Viewer software, giving you a deeper look inside the SQL system itself!

Highlights from this video:
  • Taking a look at PFS and different extents
  • PFS Status and colored-block legend
  • Minor glitches when switching between PFS,Allocations, and Buffer Pool
  • Creating objects and tables
and 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: page free space, PFS, adding tables, sql internals viewer,

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Zip and Unzip Files Using Built-In Functions

How to Zip and Unzip Files Using Built-In Functions - view details
In this short video tutorial Grant will open and create zip files using the Windows built-in function of compressing files and folders, so you don't have to have the WinZip program installed.

Highlights from this video:
  • How to compress (zip) files/folders
  • Limitations with the built-in zip function
  • Extracting zipped 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: zip,unzip, , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for

posted by Scott Whigham @ 4:35 AM  

Thursday, January 10, 2008

New SQL Server Video Tutorial: Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this fourth and final video in the series, you will finish up the dicussion of Dynamic Management Views by learning more about the dm_tran series of DMVs and how they can be beneficial to you.

Highlights from this video:
  • About the sys.dm_tran category
  • Viewing transaction locks on the system
  • Active transactions, transaction types, database transactions
and 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: dynamic management view, DMV, lock, block, transaction,

posted by Scott Whigham @ 1:35 PM  

New SQL Server Video Tutorial: Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this third video, you will learn about the dm_exec and relationships among the sql handle, which will show you how to view the code someone is issuing and past calls and metrics. Scott will do so by walking you through several custom scripts, which are included with this video download!

Highlights from this video:
  • Scripts for:
    • Viewing definitions of system objects
    • Getting the most often run queries
    • Viewing cached query plan SQL text
    • Getting top 200 executed SP's ordered by calls/minute
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dmv, dynamic management view, monitor user, block,lock, script,dm_exec

posted by Scott Whigham @ 1:35 PM  

New SQL Server Video Tutorial: Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactio