Saturday, December 29, 2007

New Windows 2003 Video Tutorial: Command Line FTP

Command Line FTP - view details
File Transfer Protocol, or FTP, is a�� very commonly used tool on internet and you may find that so many things utilize FTP these days. In this instructional video, Grant will give you an overview of the essentials of FTP and demonstrate to you what it is good for.

Highlights from this video:
  • Uses of FTP
  • Security vulnerability in FTP
  • How to transfer files
  • BINARY vs ASCII mode data connection
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: FTP, file transfer protocol, command line ftp, command line

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: Automate the Command Line FTP Utility in Windows 2003

Automate the Command Line FTP Utility in Windows 2003 - view details
Are you looking for an easy way to upload or download files from an FTP server instead of using daily commands? In this great video tutorial, Grant will walk you through the process of automating the command line FTP utility in Windows 2003 so you can easily use an FTP script to carry out your daily batch jobs.

Highlights from this video:
  • Working with the FTP Utility
  • FTP scripting
  • Targeting specifc 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: ftp, ftp script,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • How to identify the duplicate values
  • What does the RANK function basically do?
  • Where/when to use the RANK function
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: duplicate,rows,values,RANK, function,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Spam Filtering in Outlook

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

Highlights from this video:
  • What is the best level of junk e-mail protection for me?
  • How to block e-mails from specific countries
  • User spam capabilities
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: junk e-mail , protection, control spam, spam block, spam filter, spam capabilities, Outlook

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Configure Mail Forwarding to Send Copies of Messages to Mobile Devices

Configure Mail Forwarding to Send Copies of Messages to Mobile Devices - view details
This video will examine the quickest option for setting a user up who is using a mobile device, like a Blackberry, for mail forwarding.

Highlights from this video:
  • Adding new mail contact
  • What changes do I need to make to my mobile device to allow forwarded mail?
  • About Blackberry Enterprise Server/ Blackberry Enterprise Server Express
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights from this video:
  • ��How to acces Connection Status browser
  • ��Changing settings in Outlook Anywhere
  • ��Downloading address book across different directories
  • Connection diagnostics
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: connection status, diagnostic tools, address book, Outlook Anywhere, Outlook

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:
  • Where can I put the RANK function and where will it accurately work?
  • Reason for JOIN of actual table to duplicates
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: RANK, function, RANK placement, JOIN, delete duplicate, rows, values,table

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Add a Windows 2003 R2 Domain Controller to SBS 2003

Add a Windows 2003 R2 Domain Controller to SBS 2003 - view details
Having a second server in your small business environment is extremely useful and can boost your productivity. In this great instructional video, Grant will walk you through the process of adding a Windows 2003 R2 domain controller to Small Business Server 2003, as there are a couple of tricks with the latest software avaliable from Microsoft for your Windows server.

Highlights from this video:
  • Walkthrough of�� a domain controller promotion
  • Assigning IP addresses
  • Domain prep steps
  • Liscensing impacts
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: windows domain controller, r2, domain controller, windows server, sbs 2003, sbs2003, Small Business Server, Small Business Serve

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights from this video:
  • Using Exchange Management Shell to change access rights
  • Changing sharing permissions in Outlook mailbox
  • Options for PowerShell cmdlet on getting mailbox permissions
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: user control, permissions, management, shell, powershell, sharing, mailbox, rights

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:
  • Using common table expressions
  • Ranking and partitioning within a result set
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: delete, duplicate, RANK, function, table expressions, ranking, partitioning

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:
  • What is the basic idea of the Single Table JOIN design pattern?
  • When to use JOIN/ OUTER JOIN/LEFT JOIN
  • Using single vs multiple tables and query effects
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: JOIN, OUTER JOIN,LEFT JOIN, single table, multiple table, query, subquery, compare

posted by Scott Whigham @ 4:35 AM  

Friday, December 28, 2007

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

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

Highlights:
  • Advantages of stored procedures
  • View vs Function
  • Types of Functions and similarities
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: view,function,stored procedure, functions,compare

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • How to add ASP.NET v2.0 to IIS Web Service Extensions list
  • Repairing .NET framework
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ASP.NET, .NET framework, install, upgrade,troubleshoot

posted by Scott Whigham @ 7:35 AM  

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

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

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

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

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

Keywords Associated with this video: inplace, upgrade,install,in-place, how to,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • Dimensional modeling approach in View
  • Multi-statement functions
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: multi-statement, view,function,stored procedure, dimensional modeling, compare

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • Why do I need to keep my SP 2.0 site?
  • Consequences of shutting down your SharePoint 2.0 site
  • Using IIS Manager to make replacements
  • How to change Internal URLs
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SP 2.0, change internal URL, shut down, parallel installation, install,configure

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • How to get a true XML document in SQL
  • Making a connection between SQL and your XML file
  • Creating a useful stored procedure for�� returning XML data
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: export,xml, connection, stored procedure, ssis,procedure,convert xml

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights
  • Necessary changes to the connection managers
  • What is "FastParce"?
  • Where can I use FastParce
  • Differentiation of execution speeds
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: data flow,task, fastparce, execution speed

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • Timing comparison against other tools
  • Loading from multiple text files into one table
  • What is a Parallel Data Load?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: FastParse, text files, multiple, parallel data load

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • Timing comparison against other tools
  • Loading from multiple text files into one table
  • What is a Parallel Data Load?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: FastParse, text files, multiple, parallel data load

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • A perfect unit test?
  • More ideas of Test Driven Development
  • Purpose of failed tests
  • What are Coder tests?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: unit testing, coder test, failed test, test driven development,

posted by Scott Whigham @ 4:35 AM  

New SQL Server 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 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 @ 4:35 AM  

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

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

Highlights:
  • What is clustered index order?
  • Run-time comparison
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: index, BCP, clustered index order, comparison, compare,

posted by Scott Whigham @ 4:35 AM  

New SQL Server 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 Integration Services Video Tutorial: Pt. 10 - SQL Server Intergration Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
This video will show you how to create a BULK INSERT task in SQL Server Integration Services, SSIS, with Microsoft Visual Studio
  • Using the BULK INSERT task in an SSIS project
  • Configuring destination connection and options of task
  • Comparison against other tools
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: BULKINSERT, SSIS, sql server integration services, destination connection,compare

posted by Scott Whigham @ 4:35 AM  

New SQL Server 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 Integration Services Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

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

Highlights:
  • BULK INSERT syntax
  • Using books online for OPENROWSET
  • Comparison of OPENROWSET, BULK INSERT, and BCP timing
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: BULK INSERT, OPENROWSET,BCP, functions, timing, compare, comparison, syntax

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • A perfect unit test?
  • More ideas of Test Driven Development
  • Purpose of failed tests
  • What are Coder tests?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: unit testing, coder test, failed test, test driven development,

posted by Scott Whigham @ 4:35 AM  

Thursday, December 27, 2007

New Exchange Server Video Tutorial: How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt

How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt - view details
By default when a user usesOutlook Web Access, they will be prompted for thier domain/user name and passowrd. In this video Grant will adjust those settings so that OWA only requires a user name and password at login, which is great when you only have one domain.

Highlights from this video:
  • About the various form-based authentications
  • Customizing your form-based authentication
  • Applying changes and restarting IIS
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: form-based authentication, user name, configure OWA, login, OWA, outlook web access,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • What is a test?
  • The tenet of TDD
  • Principles of unit testing
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: TDD, test driven development, unit, unit testing, test, testing,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • What is a test?
  • The tenet of TDD
  • Principles of unit testing
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: TDD, test driven development, unit, unit testing, test, testing,

posted by Scott Whigham @ 7:35 AM  

New Exchange Server Video Tutorial: How to Configure Anti-SPAM On a Hub Transport Server

How to Configure Anti-SPAM On a Hub Transport Server - view details
Are you in need of some help in configuring your Anti-SPAM capabilities on your Hub Transport Server? In this great video tutorial, Grant Moyle will help you to do so, as well as detail the various anti-SPAM features.

Highlights from this video:
  • About anti-SPAM capabilities
    • Content Filtering
    • IP Allow List
    • IP Allow List Providers
    • IP Block List
    • IP Block List Providers
    • Recipient Filtering
    • Sender Filtering
    • Sender ID
    • Sender Reputation
  • Customizing feature properties
  • Filtering and defining SCL, Spam Confidence Level, thresholds
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: Configure Anti-SPAM , antispam, anti spam

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • The process of test case naming
  • What is a TextFixture?
  • Sequence of testing codes
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: test driven development, TDD, NUnit test, unit test, unit testing,

posted by Scott Whigham @ 7:35 AM  

New Exchange Server Video Tutorial: Configure and Allow File Server Access Through Outlook Web Access (OWA)

Configure and Allow File Server Access Through Outlook Web Access (OWA) - view details
One of the new features in Exchange 2007 is the ability for users to get more than just their email when accessing OWA, or Outlook Web Access, such as gaining access to a remote file server. In this video tutorial, Grant will walk you through the configuration of allowing file server access through OWA.

Highlights from this video:
  • Adding remote file servers to the Allow list
  • Accessing remote file server from Outlook Web Access
  • Public computer file access vs Private computer file access
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: file server access, OWA, outlook web access, configure OWA, remote file server,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

  • The process of test case naming
  • What is a TextFixture?
  • Sequence of testing codes
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: test driven development, TDD, NUnit test, unit test, unit testing,

posted by Scott Whigham @ 7:35 AM  

New Exchange Server Video Tutorial: How to Install and Setup Anti-SPAM on a Hub Transport Server

How to Install and Setup Anti-SPAM on a Hub Transport Server - view details
Did you know that you can do spam filtering and it's various capabilities on a single server configuration? Just because it's not listed in the Exchange Management Console doesn't mean it can't be done! In this video, you and Grant will take a look at how you can easily install and setup Anti-SPAM on your Hub Transport Server.

Higlights from this video:
  • Finding/running a Power Shell script to install Anti-SPAM agents
  • Restarting Microsoft Exchange Transport Services
  • How to manage/access anti-SPAM features
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: install anti-spam, anti spam, anti-spam, anti-spam single server, single server, setup anti spam

posted by Scott Whigham @ 7:35 AM  

New Exchange Server Video Tutorial: How to Build a Custom Address List With Windows Power Shell

How to Build a Custom Address List With Windows Power Shell - view details
Do you feel that the current address list builder in Exchange 2007 is not as good as you might have had in the Exchange 2003? In this video tutorial, Grant will show you how you can build intricate,custom address lists with Windows Power Shell, which will give you more flexibility in creating your address lists.

Highlights from this video:
  • Creating new address list with address list wizard
  • Assigning/working with custom attributes
  • Creating/updating address lists in Power Shell
  • GUI vs EMS
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: custom address list, power shell, address list,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: Pt. 4 - How to Use the FROM Clause in the DELETE Statement

Pt. 4 - How to Use the FROM Clause in the DELETE Statement - view details
This fourth video will detail the process of using a FROM clause in your DELETE statement to reference other tables, a slightly confusing and complex process.

Highlights from this video:

  • About the FROM clause approach
  • Where is it most commonly used?
  • FROM clause process and pattern
  • Common confusion in the FROM clause

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: FROM. DELETE, clause, statement, reference,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? - view details
This is the fifth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Reviewing Ghost Records
  • Introduction and definition of m_ghostRecCnt
  • Introduction and explanation of Housekeeping Threads
  • Real life examples of housekeeping threads
  • Limitations when deleting records before housekeeping threads remove GhostRecords
  • Definition and explanation of correct terminology when utilizing fn_dblog() function
Renowned trainer, Scott Whigham, has completed this video series maximizing your knowledge on page splits by utilizing his years of experience and training to teach us about ghost records. 100 percent of this video is dedicated to ghost records. If you have never heard of ghost records or are just looking to freshen your memory, this is the video for you. All skill levels can understand and follow this video and will be better off for having watched it. This is an excellent conclusion to a series of already absolutely fantastic videos.

NOTE: 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: ghost records, ghost record, internally delete row, m_ghostRecCnt

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? - view details
This is the fifth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Reviewing Ghost Records
  • Introduction and definition of m_ghostRecCnt
  • Introduction and explanation of Housekeeping Threads
  • Real life examples of housekeeping threads
  • Limitations when deleting records before housekeeping threads remove GhostRecords
  • Definition and explanation of correct terminology when utilizing fn_dblog() function
Renowned trainer, Scott Whigham, has completed this video series maximizing your knowledge on page splits by utilizing his years of experience and training to teach us about ghost records. 100 percent of this video is dedicated to ghost records. If you have never heard of ghost records or are just looking to freshen your memory, this is the video for you. All skill levels can understand and follow this video and will be better off for having watched it. This is an excellent conclusion to a series of already absolutely fantastic videos.

NOTE: 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: ghost records, ghost record, internally delete row, m_ghostRecCnt

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: How to Manage Exchange 2007 Permissions

How to Manage Exchange 2007 Permissions - view details
In this video tutorial, Grant will walk you through the process of managing permissions inside an Exchange 2007 organization.

Highlights from this video:
  • About the default organization identities and adding a new Exchange administrator
  • Roles and scopes of identities
  • Adding administrators through the Exchange Management Shell
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: exchange 2007 permissions, manage permissions, exchange management, management

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: How to Assign and Manage Exchange 2007 Email Address Policies

How to Assign and Manage Exchange 2007 Email Address Policies - view details
In this great video tutorial Grant will show you how to adjust email address policies so you can assign the email addresses to users in bulk instead of doing it individually, as well as how to manage your Exchange 2007 Email address policies.

Highlights from this video:
  • Editing e-mail address policy
  • What can Policies do?
  • Creating a new e-mail policy
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: assign policies, manage, e-mail, e mail, email , address policies, create policy

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions

Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions - view details
In this second video of the series, your instructor will be showing you how to re-use/share a shared datasource across multiple projects and solutions, as well as introduce you to some of the tips and techniques of copying and some caveats of copying.

Highlights from this video:

  • Using shared data sources
  • Making a single data source to be shared
  • Changing/editing the data sources

and much more!

��

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

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

Keywords Associated with this video: shared data source, share, changing data sources, data source, sharing

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Pt. 2 - Edge Server to Exchange Network Subscription

Pt. 2 - Edge Server to Exchange Network Subscription - view details
Once you have completed the installation of Exchange Edge Transport server, the next step is to set it up so it can subscribe to one or more Exchange organizations so it can know the list of the users and the email address so it can make descisions on how to route messages. In this second video tutorial, Grant will show you how to do just that!

Highlights from this video:
  • What does the Edge server do?
  • Exporting the Edge subscription file
  • Transferring the exported file to a Hub transport server
  • Creating a new Edge subscription
  • How to start the Edge synchronization and verify
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: edge server, setup edge server, exchange subscription, network subscription

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Two Methods for Creating Inbound Domains: Exchange Management Console and Exchange Management Shell

Two Methods for Creating Inbound Domains: Exchange Management Console and Exchange Management Shell - view details
Once your Exchange server is set-up, you will then need to configure your inbound domain names that you have publicly registered and point them to your Exchange network. In this video tutorial, Grant will walk you through the two methods for creating inbound domains using Exchange Management Console nad Exchange Management Shell.

Highlights from this video:
  • Adding new accepted domains for inbound e-mail routing
  • Domain configuration options: Authoritative, Internal Relay, External Relay
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: create inbound domain, inbound domains, accepted domain, inbound e-mail routing,

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log - view details
This is the fourth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Overview of previous videos
  • Introduction and detailed explanation of the undocumented FN_DBLOG() function
  • Introduction to proper syntax for Backing up Log files utilizing TSQL
  • Introduction to proper syntax for Backing up Database utilizing TSQL
  • Introduction to Common real world permission errors
  • Explanation of utilizing LSN''''s when using the fn_dblog() function
  • Properly reading and understanding result sets from the fn_dblog() function
  • Detailed description and explanation of correct terminology when reading the results from the fn_dblog() function
You can expect to learn a ton of information about logs and backing up the database. This video is dedicated to the fn_dblog() function. Everyone watching this video will benefit whether or not you are watching to learn about the undocumented function, you just need a refresher or even just want to compare your knowledge against a professional. Trainer, Scott Whigham does a phenomenal job again by showing us items that we literally would not have any knowledge of due to lack of documentation.

NOTE: 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: transaction log, sql server log, TSQL, FN_DBLOG() function

posted by Scott Whigham @ 4:35 AM  

Wednesday, December 26, 2007

New SQL Server 2005 Video Tutorial: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure - view details
This is the first video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Basic Launching of SQL Server Management Studio
  • Identifying Service Pack 2
  • Proper TSQL Database Creation
  • Index Page Limitations
  • Proper TSQL Table Creation
  • Building a Clustered Index in TSQL Overview
  • Database Console Command (DBCC) function definition and functionality
  • Introduction and explanation of the DBCC IND() function
  • Proper syntax while utilizing the DBCC IND() function
  • Explanation of the functionality of the DBCC IND() function
  • Properly utilizing the INSERT statement in TSQL
  • Discussion about Page Types
  • SQL Script accompanies the video
Trainer, Scott Whigham, gives us an excellent start to a fantastic video series that will put you in the right direction for learning about page splits. This video will provide more information that you knew existed about the different types of functions and how, why and what happens when a page splits. This video is extremely informative and is definitely for everyone that wishes to learn at any level; beginner, intermediate and advanced users of SQL Server alike. Beginner users will want to watch the video and come back and watch it again to get the most of out it.

NOTE: 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: Page Structures, Clustered Index Structure, clustered index, page types,insert, tsql table,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs - view details
This is the third video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction to SQL 2000's DBCC SHOWCONTIG() function with and without TABLERESULTS
  • Proper breakdown of the IndexName utilizing the DBCC SHOWCONTIG() function
  • Extensive review of the DBCC SHOWCONTIG() function output
  • Explanation of DBCC deprecation in SQL Server 2005
  • Introduction to SQL 2005''s Dynamic Management Objects (DM''s)
  • Proper syntax for DM''s in SQL Server 2005
  • Basic introduction to DB_ID() and OBJECT_ID() functions
  • Detailed description of the DM results including but not limited to alloc_unit_type_desc,
  • index_level, page_count, record_count
  • Basic introductory definition of how clustered indexes must return data
  • Page Split definition when working with clustered indexes accompanied with real
  • world examples
  • Introduction and explanation of the following DBCC results: bpageno, m_nextPage, m_prevPage
  • Introduction to fragementation when page splits occur
  • Advanced explanation of Page Splitting
Scott Whigham teaches us how to properly utilize different functions in SQL 2000 and 2005 when working with page splits. This video really finalizes the major functions and all of the explanations for page splitting. This is an extremely easy video to following and understand. Beginners should watch this video once now and once after you have had some further experience with SQL Server to get the full aspect of what is being taught here. All who watch this video will benefit from Scott''s excellent training skills.

NOTE: 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: page split, DBCC, clustered index

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure - view details
This is the first video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Basic Launching of SQL Server Management Studio
  • Identifying Service Pack 2
  • Proper TSQL Database Creation
  • Index Page Limitations
  • Proper TSQL Table Creation
  • Building a Clustered Index in TSQL Overview
  • Database Console Command (DBCC) function definition and functionality
  • Introduction and explanation of the DBCC IND() function
  • Proper syntax while utilizing the DBCC IND() function
  • Explanation of the functionality of the DBCC IND() function
  • Properly utilizing the INSERT statement in TSQL
  • Discussion about Page Types
  • SQL Script accompanies the video
Trainer, Scott Whigham, gives us an excellent start to a fantastic video series that will put you in the right direction for learning about page splits. This video will provide more information that you knew existed about the different types of functions and how, why and what happens when a page splits. This video is extremely informative and is definitely for everyone that wishes to learn at any level; beginner, intermediate and advanced users of SQL Server alike. Beginner users will want to watch the video and come back and watch it again to get the most of out it.

NOTE: 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: Page Structures, Clustered Index Structure, clustered index, page types,insert, tsql table,

posted by Scott Whigham @ 7:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) - view details
This is the second video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction and detailed explanation of the DBCC PAGE() function
  • Proper syntax while utilizing the DBCC PAGE() function
  • Explanation of the functionality of the DBCC PAGE() function
  • Basic introduction to DB_NAME() function
  • Introduction to trace flag 3604 (DBCC Page Output)
  • Introduction to DBCC TRACEON() function
  • Detailed descriptions and discussion on DBCC PAGE() function Output
  • Introduction to the use of the OBJECT_NAME() function
  • Introduction to pminlen, m_slotCnt, m_pageID, bstat, MetaDeta, m_objID, m_ghostRecCnt,
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Properly Adding new records utilizing TSQL
Trainer, Scott Whigham, introduces to us to a variety of functions and other items you will see during page splits. This is an excellent following video to start you in the right direction to show you what happens during a page split. All levels whether you are beginner, intermediate or advanced will be smarter for having watched this video. You can very easily follow this video even if you have had no experience with page splits. Beginner levels should come back and watch the video series again to get the most of out this video.

NOTE: 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: data page, Index Pages, GAM, IAM, PFS, dbcc

posted by Scott Whigham @ 7:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs - view details
This is the third video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction to SQL 2000's DBCC SHOWCONTIG() function with and without TABLERESULTS
  • Proper breakdown of the IndexName utilizing the DBCC SHOWCONTIG() function
  • Extensive review of the DBCC SHOWCONTIG() function output
  • Explanation of DBCC deprecation in SQL Server 2005
  • Introduction to SQL 2005''s Dynamic Management Objects (DM''s)
  • Proper syntax for DM''s in SQL Server 2005
  • Basic introduction to DB_ID() and OBJECT_ID() functions
  • Detailed description of the DM results including but not limited to alloc_unit_type_desc,
  • index_level, page_count, record_count
  • Basic introductory definition of how clustered indexes must return data
  • Page Split definition when working with clustered indexes accompanied with real
  • world examples
  • Introduction and explanation of the following DBCC results: bpageno, m_nextPage, m_prevPage
  • Introduction to fragementation when page splits occur
  • Advanced explanation of Page Splitting
Scott Whigham teaches us how to properly utilize different functions in SQL 2000 and 2005 when working with page splits. This video really finalizes the major functions and all of the explanations for page splitting. This is an extremely easy video to following and understand. Beginners should watch this video once now and once after you have had some further experience with SQL Server to get the full aspect of what is being taught here. All who watch this video will benefit from Scott''s excellent training skills.

NOTE: 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: page split, DBCC, clustered index

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) - view details
This is the second video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction and detailed explanation of the DBCC PAGE() function
  • Proper syntax while utilizing the DBCC PAGE() function
  • Explanation of the functionality of the DBCC PAGE() function
  • Basic introduction to DB_NAME() function
  • Introduction to trace flag 3604 (DBCC Page Output)
  • Introduction to DBCC TRACEON() function
  • Detailed descriptions and discussion on DBCC PAGE() function Output
  • Introduction to the use of the OBJECT_NAME() function
  • Introduction to pminlen, m_slotCnt, m_pageID, bstat, MetaDeta, m_objID, m_ghostRecCnt,
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Properly Adding new records utilizing TSQL
Trainer, Scott Whigham, introduces to us to a variety of functions and other items you will see during page splits. This is an excellent following video to start you in the right direction to show you what happens during a page split. All levels whether you are beginner, intermediate or advanced will be smarter for having watched this video. You can very easily follow this video even if you have had no experience with page splits. Beginner levels should come back and watch the video series again to get the most of out this video.

NOTE: 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: data page, Index Pages, GAM, IAM, PFS, dbcc

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log - view details
This is the fourth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Overview of previous videos
  • Introduction and detailed explanation of the undocumented FN_DBLOG() function
  • Introduction to proper syntax for Backing up Log files utilizing TSQL
  • Introduction to proper syntax for Backing up Database utilizing TSQL
  • Introduction to Common real world permission errors
  • Explanation of utilizing LSN''''s when using the fn_dblog() function
  • Properly reading and understanding result sets from the fn_dblog() function
  • Detailed description and explanation of correct terminology when reading the results from the fn_dblog() function
You can expect to learn a ton of information about logs and backing up the database. This video is dedicated to the fn_dblog() function. Everyone watching this video will benefit whether or not you are watching to learn about the undocumented function, you just need a refresher or even just want to compare your knowledge against a professional. Trainer, Scott Whigham does a phenomenal job again by showing us items that we literally would not have any knowledge of due to lack of documentation.

NOTE: 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: transaction log, sql server log, TSQL, FN_DBLOG() function

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports - view details
This fifth video of a five video series about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard. Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors. You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
    • There is no resolution to this error provided in the video however the resolution to the error is to run the performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards. This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error. You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video. This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general.

NOTE: This video's 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: Performance Dashboard Reports, performance dashboard, SP2

posted by Scott Whigham @ 7:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports - view details
This fifth video of a five video series about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard. Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors. You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
    • There is no resolution to this error provided in the video however the resolution to the error is to run the performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards. This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error. You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video. This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general.

NOTE: This video's 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: Performance Dashboard Reports, performance dashboard, SP2

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works - view details
This excellent step-by-step walk-thru of Scott Whigham's Stored Procedure video is the second video in a series of 3. This is an excellent addition to this series that teaches us about an extremely complex stored procedure in non-technical explained terminology. A few of the highlights but definitely not limited to are as follows:
  • Introduction to properly declared variables
  • TSQL IF and ELSE statements
  • TIMEOUT Statement
  • WAITFOR Statement
  • Basic introduction to xpath and xquery
This whole video is dedicated to the masterfully written stored procedure. This is an advanced video therefore is perfect for the intermediate to advanced SQL SERVER users. You will need to know about TSQL in order to follow a lot of this video. If you do not know about TSQL, you can learn TSQL at TSQL Training.

NOTE: This video's 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: Queues, Routes, Services, Logon Stored Procedure, IF, ELSE, WAITFOR, statement, xpath, xquery

posted by Scott Whigham @ 4: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 @ 4:35 AM  

New SQL Server Video Tutorial: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins - view details
This is the first of three very excellent advanced videos detailing out specific information towards Service Brokers in SQL Server. This video starts out with an introduction to Event Notification, Service Broker, Routes, Queues and Services and proceeds on with the following:
  • Advanced creation of a logon, trapping type of a table
  • Complex script automatically provided with this video
  • Starts out with the end result prior to training
  • Proper Utilization of the Windows Event Viewer
  • Review of types of information logged in with event logging
  • HOW TO Filter Events
  • Common Error resolution when working with event logging
  • Introduction to Database Creation utilizing TSQL
  • Minor Review of SSRS ServiceAccount
  • Basic overview of table creation utilizing TSQL
  • Introduction and proper use of ENABLE_BROKER
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Intro to AUDIT_LOGIN, AUDIT_LOGIN_FAILED
  • Intro to Event Notification Creation
  • Intermediate to Advanced Explanation of the Event Notification
  • Explanation of the importance of ANSI_NULLS, QUOTED_IDENTIFIER and NOCOUNT
Trainer extraordanaire, Scott Whigham, starts another excellent series of videos to help teach us step by step exactly what we should know in order to work with Service Brokers. This is an advanced video and you should have some intermediate to advanced knowledge about SQL Server in order to understand and follow this video.

NOTE: This video's 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: service broker, routes,queues, service, event notification, audit,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log - view details
This is the 3rd of five very excellent advanced videos detailing out specific information towards Service Brokers SQL Server. This video starts out with the necessary resolutions to common real life errors to previously written store procedure as well as the following
  • Basic overview of event and xml logs
  • Basic introductory overview for error 18456 Login Failed
  • Properly reading the SQL related events in the event log within the Windows Operating System
  • Introduction to proper utilization of the COUNT() statement
  • Possible Filter Addons for the previously written stored procedure
The final video in the series of three adds a phenomenal closure and addons to the stored procedures. Scott provides us with written and useful code that is sure to make your life easier whether you are trying to learn about writing TSQL or just would like to utilize the code for your own purposes. This video series is for the advanced SQL Server users.

NOTE: This video's 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: event notification, count (), service brokers, application event log, event notification,

posted by Scott Whigham @ 4: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 @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log - view details
This is the 3rd of five very excellent advanced videos detailing out specific information towards Service Brokers SQL Server. This video starts out with the necessary resolutions to common real life errors to previously written store procedure as well as the following
  • Basic overview of event and xml logs
  • Basic introductory overview for error 18456 Login Failed
  • Properly reading the SQL related events in the event log within the Windows Operating System
  • Introduction to proper utilization of the COUNT() statement
  • Possible Filter Addons for the previously written stored procedure
The final video in the series of three adds a phenomenal closure and addons to the stored procedures. Scott provides us with written and useful code that is sure to make your life easier whether you are trying to learn about writing TSQL or just would like to utilize the code for your own purposes. This video series is for the advanced SQL Server users.

NOTE: This video's 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: event notification, count (), service brokers, application event log, event notification,

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works - view details
This excellent step-by-step walk-thru of Scott Whigham's Stored Procedure video is the second video in a series of 3. This is an excellent addition to this series that teaches us about an extremely complex stored procedure in non-technical explained terminology. A few of the highlights but definitely not limited to are as follows:
  • Introduction to properly declared variables
  • TSQL IF and ELSE statements
  • TIMEOUT Statement
  • WAITFOR Statement
  • Basic introduction to xpath and xquery
This whole video is dedicated to the masterfully written stored procedure. This is an advanced video therefore is perfect for the intermediate to advanced SQL SERVER users. You will need to know about TSQL in order to follow a lot of this video. If you do not know about TSQL, you can learn TSQL at TSQL Training.

NOTE: This video's 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: Queues, Routes, Services, Logon Stored Procedure, IF, ELSE, WAITFOR, statement, xpath, xquery

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins - view details
This is the first of three very excellent advanced videos detailing out specific information towards Service Brokers in SQL Server. This video starts out with an introduction to Event Notification, Service Broker, Routes, Queues and Services and proceeds on with the following:
  • Advanced creation of a logon, trapping type of a table
  • Complex script automatically provided with this video
  • Starts out with the end result prior to training
  • Proper Utilization of the Windows Event Viewer
  • Review of types of information logged in with event logging
  • HOW TO Filter Events
  • Common Error resolution when working with event logging
  • Introduction to Database Creation utilizing TSQL
  • Minor Review of SSRS ServiceAccount
  • Basic overview of table creation utilizing TSQL
  • Introduction and proper use of ENABLE_BROKER
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Intro to AUDIT_LOGIN, AUDIT_LOGIN_FAILED
  • Intro to Event Notification Creation
  • Intermediate to Advanced Explanation of the Event Notification
  • Explanation of the importance of ANSI_NULLS, QUOTED_IDENTIFIER and NOCOUNT
Trainer extraordanaire, Scott Whigham, starts another excellent series of videos to help teach us step by step exactly what we should know in order to work with Service Brokers. This is an advanced video and you should have some intermediate to advanced knowledge about SQL Server in order to understand and follow this video.

NOTE: This video's 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: service broker, routes,queues, service, event notification, audit,

posted by Scott Whigham @ 4: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 @ 4:35 AM  

Tuesday, December 25, 2007

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

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

Highlights:

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

��

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

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

Keywords Associated with this video: windows application event log, event ID, event log, event source,

posted by Scott Whigham @ 7: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 @ 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 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. 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 @ 7:35 AM  

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

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

Highlights:

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

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

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

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

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

Highlights:

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

��

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

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

Keywords Associated with this video: custom event log, write custom log, event log, create log, mapping

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:

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

��

��

��

��

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

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

Keywords Associated with this video: select case, if, statements, if operator, with, foreach,

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

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,

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

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

  • Syntax shortcuts and variations
  • When to use "End If"
  • True vs false
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: If Statements, Boolean Tests, true, false, statement,expression

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,

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

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

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

Keywords Associated with this video: If, Switch, Select Case, Statements, i, case,

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

posted by Scott Whigham @ 4:35 AM  

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

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

Highlights:

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

��

��

��

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

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

Keywords Associated with this video: And, Or, Not Operators, Parentheses, Else If, statements,else, and ,or,not

posted by Scott Whigham @ 4:35 AM  

Monday, December 24, 2007

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 @ 7: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, ?

posted by Scott Whigham @ 7: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 @ 7:35 AM  

New Exchange Server Video Tutorial: How to Install Exchange Server 2007 x64 (64-bit) on a Domain Controller

How to Install Exchange Server 2007 x64 (64-bit) on a Domain Controller - view details
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: install exchange server, 64 bit, x64, domain controller,

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: Rename a Windows Server 2003 Domain Controller

Rename a Windows Server 2003 Domain Controller - view details
In this video tutorial you will take a look at how you can go about renaming a domain controller, which might seem a little risky for a large environment, as well as checking to make sure that your name change was successful.

Highlights from this video:

  • What happens during a domain re-name?
  • How to change computer name
  • Using Event Viewer to manage name change

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: rename domain controller, domain controller, re-name, name change

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: How to Install Service Pack 2 for Windows Server 2003

How to Install Service Pack 2 for Windows Server 2003 - view details
Every couple of years, Microsoft will release a new service pack for their operationg system. In this video tutorial, you will be installing Service Pack 2 for Windows Server 2003 as well as receiving some information on what the SP2 includes.

Highlights from this video:

  • What is a service pack?
  • From where do I download SP2?
  • Determining if there was a successful install
  • New updates and tools from SP2
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 pack,2, sp2,

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: Pt. 1 - How to Install Windows 2003 on a 64-Bit Machine

Pt. 1 - How to Install Windows 2003 on a 64-Bit Machine - view details
This is an excellent series with just a ton of valuable 'brain dumps' from our author, Grant Moyle, about how 64-bit architecture benefits your applications. A must for anyone wanting to know how 64-bit works!

While performing a Windows 2003 64-bit installation, Grant talks to you about why you might be interested in 64 bit computing, how it helps your applications, and how the architecture of 64 bit works. Grant was building a 64 bit machine for his Exchange Server 2007 demos on LearnExchange.com and recorded this series while building the machine. Lots of good info here!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: x64, 64 bit, install windows, installing, installation

posted by Scott Whigham @ 7:35 AM  

New Exchange Server Video Tutorial: Disable and Delete an Exchange 2007 Mailbox

Disable and Delete an Exchange 2007 Mailbox - view details
Have you ever wondererd how to recover a mailbox if it is accidently deleted or what happens when an admin disables a mailbox? In this instructional video, Grant will show you how to disable and delete and Exchange 2007 mailbox, as well as show you how to recover the mailbox.

Highlights from this video:
  • How to disconnect/disable/delete a user from their Exchange 2007 mailbox
  • Recovery for deleted user mailboxes
  • For how long does the Exchange server keep disconnected mailboxes?
  • Removing a mailbox
  • Differences between Disable and Remove
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: disable mailbox, delete mailbox, recover mailbox, disconnect, connect, mailbox

posted by Scott Whigham @ 7: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 @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - An Overview of Reporting Services Security

Pt. 4 - An Overview of Reporting Services Security - view details
This fourth and final video will wrap up this advanced series by discussing some specific aspects of item security, such as locking down individual reports or folders therefore altering user securities and roles.

Highlights:

  • Flexibility of custom roles
  • Folder heirarchy
  • How to create a role with viewing permissions only

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: reporting services, security, roles, permissions,

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 Reporting Services Video Tutorial: Pt. 2 - Understanding Item-Level Security in Reporting Services

Pt. 2 - Understanding Item-Level Security in Reporting Services - view details
This second and final video in this short series will finish covering the 4 connection options for the Data Source in Report Manager, and understanding item-level security in Reporting Services.

Highlights:

  • Modifying dataset properties
  • Creating subscriptions
  • SQL Server Profiler
  • Windows Integrated security

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: item level security, reporting service, data source connection, slq server profiler, windows integrated security,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - Troubleshooting a 'Key not valid for use in the specified state' Error

Pt. 4 - Troubleshooting a 'Key not valid for use in the specified state' Error - view details
This fourth and final video in the series will troubleshoot what you will need to do after you reset your account and receive the error message 'Key not valid for use in the specified state'. Your instructor will lead you out of the circular process of error messages, as you will find that you won't be able to restore,backup, or change that encryption content, and resolve the situation.

Highlights from this video:

  • Techniques for starting your server back up again
  • Using SAC (Surface Area Configuration)
  • Using DOS prompt
  • How to get Report Server to work with original encryption keys
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, encrypt, lock out, key, surface area configuration, key not valid

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Understanding Item-Level Security in Reporting Services

Pt. 1 - Understanding Item-Level Security in Reporting Services - view details
Ever wonder how item-level security works in Reporting Services with respect to the credentials to a particular report and how they get passed to the datasource itself? That is exactly what this short video tutorial will cover!

Highlights:

  • What is Deployment?
  • 4 connection options for Data Source
  • Changing properties of credentials

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: item level security, reporting services, deploy, deployment, data source, credentials

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Backup and Restore Your SSRS Encryption Keys

Pt. 2 - How to Backup and Restore Your SSRS Encryption Keys - view details
This second video in the series will show you what will happen and what to do��if your key is corrupted or encryption is deleted as well as discuss a little bit about encryption key management.

Highlights from this video:

  • When/how to change encryption information
  • Effects of deleting encrypted content
  • Restoring encrypted content

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: backup keys, restore key, key management, encryption,encrypt, restore

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - What to Do If your Reporting Services Service Account Is Locked Out

Pt. 3 - What to Do If your Reporting Services Service Account Is Locked Out - view details
Ever faced the dreaded account lockout? In this third video in the series your instructor will discuss with you what that will mean to you from an encryption standpoint and what to do if you Reporting Services Service account is locked out.

Highlights from this video:

  • Windows authentication vs SQL Server authentication
  • When does a lockout occur?
  • Using Event Viewer in conjunction with Configuration Manager
  • Reseting account lock-out

��

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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,encrypt, reporting service, windows authentication, sql authentication, account lock out

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - A Discussion of How Reporting Services Uses Encryption

Pt. 1 - A Discussion of How Reporting Services Uses Encryption - view details
In this first video in the video series, your instructor will begin by walking you through the set-up of your Report Server for accessing different encryption key scenarios and problems.

Highlights from this video:

  • Deploying solutions to Report Server
  • Encrypted connection strings and backup

��

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

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

Keywords Associated with this video: reporting services, encryption ,encypt, key, encrypted connection strings, deploy solution

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - An Overview of Reporting Services Security

Pt. 3 - An Overview of Reporting Services Security - view details
This lengthy third video will delve a much deeper into the item level security in the Report Server.

Highlights:

  • Permissions model at the item level
  • Default folder security options
  • Parent-child folder permissions and inheriting
  • Giving access to Report Builder

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 server, reporting services, security, permission, security, parent child, inherit

posted by Scott Whigham @ 4:35 AM  

Sunday, December 23, 2007

New Reporting Services Video Tutorial: Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS)

Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS) - view details
Part 2 of this series will cover the actual process of how to implement and integrate custom level admin reports in SQL Server Management Studio.

Highlights:

  • Using example query in Report Wizard
  • Adding custom reports to management studio
  • Filtering stored procedures

and much more!

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

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

Keywords Associated with this video: custom reports, ssms, management studio, admin level reports

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - Further Uses of the Unattended Execution Account

Pt. 2 - Further Uses of the Unattended Execution Account - view details
This second and final video in this short series will continue talking about the Unattended Execution Account and how it works with scheduling and subscriptions.

Highlights:

  • Item-level/ report-level security
  • 4 connection credential options
  • "Override" credentials with execution account
  • Subscription sharing credentials and impersonation
  • Reversible encryption

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: unattended execution account, credential, scheduling, subscriptions

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - What is the Unattended Execution Account?

Pt. 1 - What is the Unattended Execution Account? - view details
When you go through and setup your Report Server you probably want that nice warm fuzzy feeling that everything turns green. There's one item,however, that remains yellow when configuring your report server in the Reporting Services Configuration Manager. In this video series, Scott Whigham will be discussing with you what the Execution Account is, and help you to decide whether or not to use the Unattended Execution Account

Highlights of this video:

  • What is the Execution Account's purpose and when is it used?
  • Using Windows Integrated Security and editing connection credentials
  • Permissions of Execution Account
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: unattended execution account, windows integrated security, account permissions, reporting services,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Using SQL Server Profiler to Learn the Inner Workings of Reporting Services

Pt. 1 - Using SQL Server Profiler to Learn the Inner Workings of Reporting Services - view details
An essential tool for learning TSQL, SSIS and especially Reporting Services is SQL Server Profiler. Profiler is commonly used to see what queries reports are built off of what reports are beng run and what accounts are going to be using particular datasources. This first video in the series will provide you with a great introduction to many of the aspects of Profiler.

Highlights from this video:

  • Creating a new Trace
  • Tips for using Profiler that will help you filter data
  • Specifying column filters

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 profiler, profiler, ssrs, reporting services, trace, reports

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - An Overview of Reporting Services Security

Pt. 1 - An Overview of Reporting Services Security - view details
This first video in the four part series will begin your walkthrough of the several layers of security in Reporting services.

Highlights from this video:

  • Helpful tools with which to assign security
  • About the System Administrator and System User roles
  • Using Report Manager vs Management Studio
  • How run applications as different users

��

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

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

Keywords Associated with this video: reporting services, security, roles, permissions, administrator, user, report manager, management studio,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - Customizing Profiler and Creating Reporting Services-Specific Templates

Pt. 2 - Customizing Profiler and Creating Reporting Services-Specific Templates - view details
This last video in the series will show you another thing you can do with Profiler;��seeing which accounts are being used to execute reports and the effects security has on the particular report.

Highlights of this video:

  • Running multiple copies of IE under different accounts
  • Spotting��security changes
  • How to set-up a custom template in the Profiler to work with SSRS
  • What is my NTUserName?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: profiler, ssrs, reporting services, ntusername, reports,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - Writing Reports That Return Reporting Services Security Information

Pt. 3 - Writing Reports That Return Reporting Services Security Information - view details
This third video and final video��in the series will finish with the creation of a custom report that will return reporting services security information and will also cover some aspects of the writing process.

Highlights:

  • Running a subquery
  • Tables and their binding
  • Changing textbox properties
  • Report.rdl parameters

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, reporting services, admin level reports, custom reports, security,report

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - An Overview of Reporting Services Security

Pt. 2 - An Overview of Reporting Services Security - view details
This second video in the series will continue with the overview of the security in Reporting Services by covering more about the user accounts, roles, permissions, and levels of security.

Highlights:

  • Removing users/denying access
  • Where to assign security (item level and system level permissions)
  • Changing system role properties
  • Viewing actual permissions of users
  • Creating new system roles

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: user accounts, roles, permission, security level, system roles, report server, reporting services

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - How to Create Administrative Reports Based on the ReportServer Database (Your Report Server's Database)

Pt. 1 - How to Create Administrative Reports Based on the ReportServer Database (Your Report Server's Database) - view details
This first video in this helpful series will give you a basic introduction of how to create custom administrative reports that are based on your ReportServer Database.

Highlights:

  • What can/will this database be able to accomplish?
  • Example of a custom report
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: adminstrative level reports, report server database, report server, custom 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 @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - Understanding the Difficulties of Managing the Reporting Services Permissions Model

Pt. 3 - Understanding the Difficulties of Managing the Reporting Services Permissions Model - view details
This third and final video will wrap up the series by discussing in more depth about how to revoke permissions and the difficulties of roles and permissions in Reporting Services.

Highlights:

  • "A major hole" in security of Reporting Services
  • User permissions and their difficulties
  • Windows domain-level Groups

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: reporting services permissions model, manage reporting services, user permissiosn, domain-level groups, roles,

posted by Scott Whigham @ 4: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 @ 4: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 @ 4:35 AM  

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

New Reporting Services Video Tutorial: Pt. 2 - How to Create and Work With Custom Roles In Reporting Services

Pt. 2 - How to Create and Work With Custom Roles In Reporting Services - view details
In this second video tutorial in the series, Scott��will be teaching you how to create and work with custom roles in Reporting Services as well as giving you some real-world scenarios and some best practices and suggestions!

Highlights of this video:

  • Assigning unique permissions for new roles
  • Adding users to roles
  • Inheriting parent��roles

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: custom roles, roles, reporting services, permissions, users, parent roles,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Using Roles for Reporting Services Security

Pt. 1 - Using Roles for Reporting Services Security - view details
If you know just a little bit about system level roles, even less about reporting service security, and not much at all about�� item level roles, then this video is just right for you! Discussed in this video are item level roles and how you can customize them to fit any scenario you need them to.

Highlights of this video:

  • Role permissions (System Admin vs System User)
  • Individual report security
  • Role security properties
  • Content Manager, Browser

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: reporting services, security, item level roles, roles, permissions, report security

posted by Scott Whigham @ 4: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 @ 4: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 @ 4:35 AM  

Saturday, December 22, 2007

New Reporting Services Video Tutorial: How Reporting Services Uses .RDL (Report Definition Language) Files

How Reporting Services Uses .RDL (Report Definition Language) Files - view details
This great video tutorial will provide you with an introduction to the crucial and beneficial RDL files, Report Definition Language, and how reporting services uses it as the base for it's reports.

Highlights of this video:

  • Benefits of .rdl as .xml files for demos and browsing
  • What exactly is RDL and what are its advantages?
  • Syntax and expressions in Report 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: rdl, report definition language, reporting services, report, rdl syntax

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,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: How to Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL

How to Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL - view details
Certificates are very helpful when passing authentication credentials from one site to another when you want your information encrypted. In this video tutorial your instructor will show you the process of how to configure Reporting Services to use a Certificate (SSL) using SelfSSL, which will create a private channel for you to use between your server and a limited group of users.

Highlights from this video:

  • Where to download SelfSSL
  • Determining your site ID
  • How to assign SSL certificates
  • Making your SelfSSL trusted

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: certificate, SSL, SelfSSL, reporting services, assign SelfSSL

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: How to Silently Install Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools

How to Silently Install Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools - view details
This great video tutorial will give you a walkthrough of service pack 1 silent installation for Visual Studio 2005 for your Reporting Services Tools.

Highlights from this video:

  • Where to download SP1 for VS2005
  • Executing the service pack in DOS prompt
  • What is "quiet mode"?
  • How to tell if SP1 is successfully installed
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: quiet mode, service pack 1 visual studios, SP1 visual studio, visual studios, 2005, reporting services tools,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: How to Change the ReportingServicesService.exe Service Account Password

How to Change the ReportingServicesService.exe Service Account Password - view details
Just as with SQL Server 2005, Reporting Services has a little bit of a trick to it when you're going to change the service account password. This great video tutorial will lead you through the process of making that change!

Highlights:

  • Password expiration/history
  • Local/Group/Domain security��policies
  • Stopping/starting SSRS
  • Wrong Way vs Correct Way to change password

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: change service account password, service account password, change password, reporting services

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: An Introduction to the Business Intelligence Development Studio (BIDS) Environment

An Introduction to the Business Intelligence Development Studio (BIDS) Environment - view details
This great video will show you how to get the most out of the BIDS with some tips and tricks that Scott, your instructor, uses, as well as a basic walkthrough of some of the elements in the intergrated development environment.

Highlights:

  • About Microsoft VS2005
  • Auto-hide and important panes
  • Toolbox, Solution Explorer, Properties Window,Server Explorer

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: intro BIDS, business intelligence development studio, toolbox, solution explorer, properties, server explorer, BIDS,

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,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: How to Remove/Uninstall Reporting Services Completely

How to Remove/Uninstall Reporting Services Completely - view details
This video tutorial will walk you through the tricky process of removing every aspect and trace of reporting services from your machine without removing your SQL Server.

Highlights from this video:

  • From where do I uninstall SSRS?
  • Clean-up work after the removal
  • How to tell if there was a successful uninstall

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: remove ssrs, reporting service uninstall, uninstallation, ssrs, remove reporting services,

posted by Scott Whigham @ 7:35 AM  

New Reporting Services Video Tutorial: How Solutions and Projects Work in the Business Intelligence Development Studio (BIDS)

How Solutions and Projects Work in the Business Intelligence Development Studio (BIDS) - view details
This video is perfect for those of you who are just coming in to the reporting services world and starting to use the Visual Studio environment to manage your reports! This video will provide you with a solid understanding of how exactly solutions and projects work in BIDS, Business Intelligence Development Studio, and what they are.

Highlights:

  • How to create a new project/solution
  • Solution vs Project vs Reports
  • Using the Solution Explorer
  • Adding a new projects/solution folders

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: solution, project, BIDS, business intelligence devolpment studios, report,

posted by Scott Whigham @ 7: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. 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. 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. 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. 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 - 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. 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  

Friday, December 21, 2007

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

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

Highlights:
  • How to generate a format file using .xml
  • Different character types
  • Specifying field terminators
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: filed terminators, format file, xml format file , xml, BCP, running BCP

posted by Scott Whigham @ 7:35 AM  

New SQL Server 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 @ 7:35 AM  

New SQL Server 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 @ 7:35 AM  

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

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

Highlights:
  • Creating and modifying triggers
  • Using "hints" to manually fire triggers
  • Building a check constraint
  • Security requirements for using BCP/BULK INSERT
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: triggers, create trigger, fire triggers, BCP, BULKINSERT, check constraints

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • Using command prompt to execute BCP
  • BCP vs BULK INSERT
  • How to save to format file, .fmt
  • Saving as .xml format
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: BCP, utility, BULKINSERT, xml format, .fmt file

posted by Scott Whigham @ 7:35 AM  

New SQL Server 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 @ 7:35 AM  

New SQL Server 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 @ 7:35 AM  

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

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

Highlights:
  • Effects of setting batch size too small
  • How to do a fast copy of a table with indexes
  • Using "load hints" and advantages
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: batch size, load hints, format files, BCP,

posted by Scott Whigham @ 7:35 AM  

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

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

Highlights:
  • How is OPENROWSET more flexible than BULK INSERT?
  • Tool choices within SSIS
  • What does�� DROPCLEANBUFFERS do in SQL server?
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: OPENROWSET, BULK INSERT, DROPCLEANBUFFERS, loading flat file,

posted by Scott Whigham @ 7: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 @ 7:16 AM  

New Windows 2003 Video Tutorial: Command Line FTP

Command Line FTP - view details
File Transfer Protocol, or FTP, is a�� very commonly used tool on internet and you may find that so many things utilize FTP these days. In this instructional video, Grant will give you an overview of the essentials of FTP and demonstrate to you what it is good for.

Highlights from this video:
  • Uses of FTP
  • Security vulnerability in FTP
  • How to transfer files
  • BINARY vs ASCII mode data connection
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