Saturday, January 13, 2007

DTS Video Tutorial: Part 1 - A Basic Walkthrough of the Built-In Tasks

Part 1 - A Basic Walkthrough of the Built-In Tasks - view details
Part 1 - A Basic Walkthrough of the Built-In Tasks
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Part 1 - A Basic Walkthrough of the Built-In Tasks, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 PM    

Exchange 2003 Video Tutorial: Pt. 4 - Creating a Custom XML file to Modify SCL Scores Based on Keyword or Phrase

Pt. 4 - Creating a Custom XML file to Modify SCL Scores Based on Keyword or Phrase - view details
In Part 4 of our series on Configuring the Intelligent Message Filter, you'll learn how to customize IMF by working with modifying the XML file to tweak the SCL scores for keywords and phrases.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: imf, scl, keyword

posted by Scott Whigham @ 10:00 PM    

Exchange 2003 Video Tutorial: Pt. 4 - Installing Exchange 2000 SP3 and Update Rollup and check Services and explain Event Log Warnings

Pt. 4 - Installing Exchange 2000 SP3 and Update Rollup and check Services and explain Event Log Warnings - view details
Finishing out the install/integration of Exchange 2000 into your network, this video walks you through the final steps: installing Service Pack 3 and verifying the installation.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sp3, exchange service pack

posted by Scott Whigham @ 10:00 PM    

Free Microsoft SQL Server Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - download
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

Keywords Associated with this video: sql odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 9:00 PM    

SQL Server 2005 Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - view details
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services as well.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by Scott Whigham @ 9:00 PM    

Exchange 2003 Video Tutorial: Clustering Exchange - Pt. 1 - Installing the Cluster and PreRequisites

Clustering Exchange - Pt. 1 - Installing the Cluster and PreRequisites - view details
Exchange clustering is one of the most common uses of clustering in the Microsoft Windows environment. This video, the first video in our series on clustering Exchange, teaches you what the pre-requisites are for installing an Exchange cluster and walks you through prepping the nodes and using the MSCS and Cluster Administrator.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: nntp, cluster, beginner, beginning, clustering

posted by Scott Whigham @ 9:00 PM    

Windows 2003 Video Tutorial: Creating NT 4.0 Install Floppies

Creating NT 4.0 Install Floppies - view details
Creating NT 4.0 Install Floppies
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Creating NT 4.0 Install Floppies, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:00 PM    

Microsoft SQL Server Video Tutorial: Templates in SQL Server Management Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - view details
Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 template, tsql template, xmla, mdx, dmx, parameter, default value

posted by Scott Whigham @ 8:00 PM    

Transact SQL Video Tutorial: Part 3 - Using EXISTS to Control Execution In an IF Statement

Part 3 - Using EXISTS to Control Execution In an IF Statement - view details
EXISTS is a fundamental part of a SQL programmer's arsenal. This video, part three in our series on using control-of-execution statements, explores using IF EXISTS to drop/create objects and detect 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: if exists

posted by Scott Whigham @ 7:00 PM    

Microsoft SQL Server Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - view details
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services as well.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by Scott Whigham @ 7:00 PM    

Microsoft SQL Server Video Tutorial: SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins

SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server Logins - view details
The most basic security in SQL Server starts with SIDs - security Identifiers. If you know someone's SID, then you can track them all through your SQL Server instance, for example. This video explains a little about the architecture of SQL Server by showing you the master database's sysxlogins table and how you manage and work with SQL Server Authentication logins. If SQL Server security is your job or you're an aspiring DBA, this is pretty much a must-watch video
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 sid, sa account

posted by Scott Whigham @ 7:00 PM    

SQL Server 2000 Video Tutorial: Pt. 1 - An Introduction to Using Views in SQL Server

Pt. 1 - An Introduction to Using Views in SQL Server - view details
Who uses views? We all do! Every developer, DBA, business analyst, systems analyst, manager, CEO, etc uses views to access the data in the database. Views make life so much easier - they are, for many people, the first choice to simplify query-writing and/or create reusable queries.

This video, recorded by resident expert Scott Whigham, is a great introduction to using views and helps with:
  • When should I use a view?
  • Should I use a view or a stored procedure?
  • What is the basic syntax for creating views in SQL Server?
and much more.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with th is video: sql view, stored query, stored queries, views, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

Windows 2003 Video Tutorial: Command Line Disk Defragmentation and Schedule

Command Line Disk Defragmentation and Schedule - view details
Did you know that you can schedule disk defragmentation without purchasing any of the fancy tools out there? Windows Server 2003 comes with a command line tool for defragmenting your hard drive. Using the native scheduling tool built into Windows 2003 you can schedule your disk defragmentation to occur at any time. Speed up your server with regularly scheduled defragmentation! This video could also be titled 'Schedule Disk Defragmentation with the Command Line and AT command'
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 2003 disk defragmentation, Defragment a Windows 2003 drive

posted by Scott Whigham @ 6:00 PM    

Exchange 2003 Video Tutorial: Pt. 3 - Customize Outlook to Display the SCL Scores in IMF

Pt. 3 - Customize Outlook to Display the SCL Scores in IMF - view details
In parts 1 & 2 you learned to configure the IMF to work with your Exchange Server and AD. In part 3, Grant Moyle teaches you how to customize Microsoft Outlook so that you can actually see the SCL score from IMF.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ms outlook, outlook express

posted by Scott Whigham @ 6:00 PM    

DTS Video Tutorial: Creating a Custom MMC to Manage Your SQL Server and DTS Packages

Creating a Custom MMC to Manage Your SQL Server and DTS Packages - view details
Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, says that this is one of the very first things that he does whenever he builds or works on a new SQL Server 2000/7.0 server; it's one of his favorite little tweaks for working with SQL Server. This video shows you how you can create your own "version" of the Enterprise Manager inside a custom MMC (Microsoft Management Console). Not only is this an easier to way to work with SQL Server but it shows that you know what you're doing when you sit down at a new 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: custom MMC, how to customize MMC

posted by Scott Whigham @ 5:00 PM    

Windows 2003 Video Tutorial: Promoting NT 4.0 BDC to PDC

Promoting NT 4.0 BDC to PDC - view details
Promoting NT 4.0 BDC to PDC
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Promoting NT 4.0 BDC to PDC

posted by Scott Whigham @ 5:00 PM    

Microsoft SQL Server Video Tutorial: Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)

Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) - view details
Linked servers can really help you get "out of a jam" with SQL. If you'd like to be able towrite SQL queries against Microsoft Access and JOIN the data to a SQL Server table, for example, then you'll love the flexibility that linked servers offer you. This video is just an overview of how linked servers work and how you can use them in your queries to simplify your life.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: excel, access, oracle, sql server 7, remote server, oledb, jet, ole-db

posted by Scott Whigham @ 4:00 PM    

Windows 2003 Video Tutorial: Upgrade Windows 2000 - Configure DNS on the New Server

Upgrade Windows 2000 - Configure DNS on the New Server - view details
Continuining our series on a Step-by-Step Guide to Upgrading Windows 2000, this video shows you how to configure DNS properly on your "new" Windows Server 2003 server after the upgrade process.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dns upgrade, active directory

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 2000 Instance

Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 2000 Instance - view details
Running the Upgrade Advisor is easy enough but understanding the reports requires a little more knowledge and experience. This video walks you through running the SQL Server 2005 Upgrade Advisor and finished with a detailed walk through of the generated reports including what you can safely ignore and what will cause problems after you 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: sql server UA, sql server 2000 upgrade, sql server 2k upgrade

posted by Scott Whigham @ 4:00 PM    

Windows 2003 Video Tutorial: Force Removal of a Domain Controller

Force Removal of a Domain Controller - view details
This video covers the worst of the worst - removing a domain controller. Do you want to have to do it? No. Is it sometimes necessary? Unfortunately, yes. This video will walk you through the How-To, the Why, and Windows guru Grant Moyle shows you a few of his tips and experiences along the way. As Microsoft says, "Forced removal of a domain controller is only intended to be used as a last resort for recovering a domain controller without requiring reinstallation of the operating system." It's good to know how to do it even if you hope to never need to.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: active directory removal, uninstall ac tive directory

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: Overview of the Default Domain Security Policy in Windows 2003

Overview of the Default Domain Security Policy in Windows 2003 - view details
Overview of the Default Domain Security Policy in Windows 2003
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Overview of the Default Domain Security Policy in Windows 2003

posted by Scott Whigham @ 3:00 PM    

SQL Server Integration Services Video Tutorial: Pt. 4 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 4 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video goes a little bit deeper and shows you how to migrate a complex DTS package to SSIS using the Package Migration Wizard.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: Removing Upgraded PDC

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

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

Keywords Associated with this video: Removing Upgraded PDC

posted by Scott Whigham @ 2:00 PM    

Exchange 2003 Video Tutorial: How to Build a User With Established Email (Forward Mail to Another Account)

How to Build a User With Established Email (Forward Mail to Another Account) - view details
Infrequently you need to give users access to your Active Directory who have limited access. This video shows you how to forward messages sent to an Active Directory contact to an 'outside' email address. This user will be able to log on to the network but will not have a mailbox on our system
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: forward email Exchange

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server Video Tutorial: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

How SQL Server Logs Errors - The SQL Server Error Log and Configuration - view details
The SQL Server Error Log Viewer in SQL Server 2000 leaves quite a bit to be desired. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 error, sql error log, sql log

posted by Scott Whigham @ 2:00 PM    

Transact SQL Video Tutorial: Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000)

Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000) - view details
There seems to be two camps with respect to database design in SQL Server with respect to NULLs in the database: one group believes that NULLs are unnecessary and should not be allowed in the database while the other sort of shrugs their shoulders and says, "I'll use NULLs if it makes sense to use NULLs."; in other words, they don't go out of their way to avoid NULLs.

This video shows you how you can design your tables so that the columns do not have to allow NULLs using a Gender and Address1/Address2 example.

Highlights from this video:

  • Address schemes in the database
  • DDL syntax for DEFAULT constraints
  • DDL syntax for ALTER TABLE
  • How IDENTITY columns work internally in SQL Server
  • How defaults apply to columns that allow NULLs

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

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

Keywords Associated with this video: null, identity, scope_identity, @@identity

posted by Scott Whigham @ 1:00 PM    

Exchange 2003 Video Tutorial: Using Exmerge to Extract Live Mail Data

Using Exmerge to Extract Live Mail Data - view details
This video shows you how to use the Exchange Mailbox Merge Wizard (ExMerge) to extract live mail from your Exchange Server. A tool for every Exchange administrator - a must-see video
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ExMerge tutorial, how to use ExMerge, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Free Microsoft SQL Server Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - download
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

Keywords Associated with this video: sql erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Configure Automatic Updates

Configure Automatic Updates - view details
Whenever you see that little yellow icon/shield in your system tray it's time to do something with Automatic Updates. Security expert Grant Moyle walks you through some suggested configurations of Automatic Updates in this essential video. This video shows you how to configure Automatic Updates on Windows Server 2003 but, for those of you working with Windows XP clients, the same process occurs for Windows XP
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: automatic updates Windows 2003

posted by Scott Whigham @ 12:00 PM    

Transact SQL Video Tutorial: Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them

Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them - view details
SET commands in T-SQL control the environment in which SQL Server or the client processes that client queries. This view shows you some of the more common SET commands, how they work, scoping (are they scoped to the statement, the batch, the connection?), and how you can use SET commands to increase throughput and help increase your SQL knowledge.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SET NOCOUNT ON, OFF, QUOTED_IDENTIFIERS, ANSI_NULLS

posted by Scott Whigham @ 12:00 PM    

Exchange 2003 Video Tutorial: Directly Communicate with SMTP to Send a Message

Directly Communicate with SMTP to Send a Message - view details
Grant Moyle uses Telnet to show you how you can directly communicate via SMTP to send a message. Telnet is not a commonly used application today but it does help us see how things work underneath the covers, so to speak, within Windows and Exchange. An interesting video - useful for diagnosing problems with mail clients and/or working at the Exchange server without an email client.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SMTP test message, Exchange SMTP Telnet

posted by Scott Whigham @ 12:00 PM    

Microsoft SQL Server Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - view details
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 attack, sql security, sql hack

posted by Scott Whigham @ 11:00 AM    

Windows 2003 Video Tutorial: Create Mailbox on an Existing User

Create Mailbox on an Existing User - view details
In this video you'll learn how to take existing users and add mailboxes for their accounts. In the Active Directory you'll work with OUs (Organizational Units) to add mailboxes. A must-see video
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: add mailbox to existing user Exchange, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: Configure DNS with a CNAME for Webmail

Configure DNS with a CNAME for Webmail - view details
If you want your users to be able to locate your Exchange server without having to know the name of the physical machine, you'll want to configure an alias (also called a CNAME) in DNS (typing in webmail.LearnExchange.com instead of MachineName.LearnExchange.com). This is an excellent video if you want to get a solid understanding of DNS and how it works on your network
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: DNS CNAME Exchange, DNS Exchange Webmail CNAME

posted by Scott Whigham @ 10:00 AM    

SQL Server 2000 Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)

Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000) - view details
For those of you taking full advantage of Microsoft Excel's ability to expose "tables" to SQL Server, this videos helps you understand how you can query even the most advanced Excel spreadsheets and worksheets. No longer are you tied to querying the worksheet element; now you can query certain "tables" *called "named regions") in the worksheet and make your life much easier.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: excel, jet, worksheet

posted by Scott Whigham @ 10:00 AM    

SQL Server Integration Services Video Tutorial: Pt. 2 of Working with the Container Tasks - the For Loop Container

Pt. 2 of Working with the Container Tasks - the For Loop Container - view details
The For Loop Container is akin to working with a programming language like C/C#/VB/Java in this respect:

for (int i = 0; i < 10; i++ )
{
���� // do something here
}

or, in a SQL language:

DECLARE @i INT
SET @i = 0
WHILE @i < 10
������ BEGIN
������ ���� -- do something here
������ ���� SET @i = @i + 1
������ END

These types of loops/iterations are very commonly needed in programming languages and, if you need to do them in SSIS, you can - BUT you have to know the expression syntax to do so!

Highlights from this video:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion

posted by Scott Whigham @ 10:00 AM    

Transact SQL Video Tutorial: Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test)

Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test) - view details
We have multiple SQL tutorials for writing queries to return duplicate data in a column or multiple columns. This video focuses on spotting dupes across multiple columns. Although primary keys prevent duplicate rows, having a Primary Key on "EmployeeId" does not prevent users from entering duplicate LastName/FirstName combinations. This video shows you how to use subqueries (both correlated and simple) along with EXISTS to locate non-unique rows.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 check

posted by Scott Whigham @ 9:00 AM    

SQL Server 2005 Video Tutorial: Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life

Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life - view details
Think of this video as the introduction to Design Patters and SQL. This video, recored by Scott Whigham, walks you through the idea of using patterns to simplify your SQL programming. Design Patterns are in nearly every modern language yet they are not often seen in SQL. This video shows you the basics of design patterns and how to use some common patterns. It is suggested that you watch this video before continuing on to the other Design Pattern videos.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: design pattern, go4

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast

Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast - view details
Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast
To do wnload this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast

posted by Scott Whigham @ 9:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces

Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces - view details
The filters you choose (or don't choose) can definitely give you improved throughput for your traces. This video walks you through how to set up the filters and designing traces for performance. At the end of this video, a great demo of how organize your traces for easier readability and troubleshooting.

Highlights from this video:
  • What filters should I use when I want to filter for long running/slow queries?
  • What are Reads and Duration and why are they important?
  • How can I only trace my application (not SQL Server Agent, for example)
  • Tracing for performance tuning
  • What Event Classes use what Filters
  • Suggestions for using filters to create more manageable traces
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 TS CC codec installed to view this video

Keywords Associated with this video: sql trace, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql, grouping, filtering, limit

posted by Scott Whigham @ 8:00 AM    

Exchange 2003 Video Tutorial: Co