Saturday, February 17, 2007

Microsoft SQL Server Video Tutorial: Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005

Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005 - view details
Part 2 in our series on What's New in SQL Server 2005's Toolbox, Scott Whigham walks you through a few more important tools and changes in SQL Server 2005.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 sql 2005, new sql 2005, feature sql 2005

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: How to Take Ownership of a Folder and File

How to Take Ownership of a Folder and File - view details
The concept of ownership in Windows is very important; every file and folder must be owned by someone. Grant Moyle walks you through the advanced settings of file and folder security in this video. File and folder ownership is a very important concept for Windows administrators and this video gives you a great idea of how to take ownership and/or view ownership conflicts
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: take ownership of file Windows

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: Customize Login Wallpaper

Customize Login Wallpaper - view details
Since so many servers sit at the Windows Logon screen for much of their 'life' many administrators want to change these default screens to something more entertaining and/or useful (such as a clock, calendar, etc). This helps you customize the experience on Windows Server 2003 but the same process will work for Windows XP clients
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: customize login wallpaper, wall paper, change wall paper, modify, computer name, domain name, bginfo

posted by Scott Whigham @ 10:00 PM    

SQL Server 2005 Video Tutorial: Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets

Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets - view details
The opposite of the PIVOT operator is UNPIVOT. Since PIVOT creates cross tab queries (or "pivots" the data across the vertical and horizontal axis by turning row values into columns), UNPIVOT can take a crosstab query's resultset and normalize the results by turning the column data into rows. Make sense? If not, you need to watch this 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: crosstab, cross tab, cross-tab, new feature, select, report, normalize, normalizing

posted by Scott Whigham @ 9:00 PM    

Exchange 2007/2003 Video Tutorial: Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile)

Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile) - view details
This user or new administrator video shows how to setup Microsoft Outlook the first time you run it to access the Exchange Server. When you launch Outlook 2000, Outlook XP, Outlook 2003 or even 2007 for the first time, it will prompt you to walk through the "Configuring Outlook" wizard (similar names among the various versions but all essentially the same). This configures what is called a "Mail Profile" that you can later access/modify via either the Control Panel or within Outlook. To be able to use MS Outlook within an organization that uses Exchange, you must set up a Mail Profile that uses Exchange Server. This video walks you through step-by-step how to configure the Mail Profile along with thorough explanations of what each box and screen means/does.

Confused about what "Use Cached Exchange Mode" is? Should you check the box for it? Watch this video and find out!

This video was a request from one of our subscribers. Do you have any video requests? We'd love to hear from you - visit our page and submit it today!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 outlook with exchange, set up outlook with Exchange, setup outlook, setup mail profile, beginner, beginning, for begin

posted by Scott Whigham @ 9:00 PM    

Windows 2003 Video Tutorial: Installing a New Hard Disk Drive

Installing a New Hard Disk Drive - view details
Grant Moyle walks you through adding new hard drives to your Windows Server 2003. Microsoft changed how hard drives are recognized in Windows Server 2003 and before you can use a new disk you must go through a few simple steps. In this video you'll learn how to assign drive letters and the basics of partitioning and formatting a new hard drive. Once you finish this video you'll be comfortable adding drives to your Windows 2003 Server. This video could've been titled 'Add a New Hard Drive to Your 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: install new hard drive Windows, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:00 PM    

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

Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video covers how to edit your Legacy packages inside the BIDS (Business Intelligence Development Studio). You'll need to watch this to get the full picture of working with SSIS.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 @ 8:00 PM    

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

Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 7.0 Instance - view details
For those of you wanting to upgrade your SQL Server 7.0 to SQL Server 2005, you'll want to run the SQL Server 2005 Upgrade Advisor against your SQL Server 7.0 instance before running the upgrade. This video walks you through running the Upgrade Advisor and provides insights into the meanings of the Upgrade Advisor reports including what is important and what you can safely ignore.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 7.0 upgrade, sql server 7 upgrade

posted by Scott Whigham @ 7:00 PM    

SQL Server 2000 Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - view details
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement 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: sql server performance, sql optimization, optimizing sql server

posted by Scott Whigham @ 6:00 PM    

Exchange 2007/2003 Video Tutorial: Moving Mailboxes

Moving Mailboxes - view details
This video guides you through moving mailboxes between Exchange servers using the Exchange System Manager and the Active Directory. When do I need to move mailboxes? Perhaps one server is under heavy stress yet another Exchange server is not busy enough. There can be many reasons and, in this video, Exchange trainer Grant Moyle walks you through configuring Exchange mailboxes
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: move exchange mailbox

posted by Scott Whigham @ 5: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 @ 4:00 PM    

SQL Server 2005 Video Tutorial: Part 5 - Collations and How to Choose the Most Compatible Collation

Part 5 - Collations and How to Choose the Most Compatible Collation - view details
Collations, sort orders, code pages, character sets - whew! Most people, including even some advanced administrators, have a difficult time understanding what collations are and how to effectively use collations. This video walks you through what they are, how they work, and how you use them. You'll also learn why this screen of the setup is perhaps the most important - it's the only choice you'll make during the SQL Server 2005 setup process that cannot be changed later on!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: unicode, collate, international, multinational, multi-national data, default collation, server collation

posted by Scott Whigham @ 4:00 PM    

SQL Server 2000 Video Tutorial: Pages, Extents, and Blocksizes - What They Are and How They Work

Pages, Extents, and Blocksizes - What They Are and How They Work - view details
If knowing the architecture of SQL Server is interesting to you, then you'll enjoy this video from Scott Whigham on how things like pages and indexes work in SQL Server. This is more of a theoretical discussion that discusses the sysinternals of SQL Server at a high level. The goal is to give you an understanding of how SQL Server stores data and indexes and how your index and table design decisions can influence SQL Server in multiple ways
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 architecture, sql design, sql internal design, index pages, extents

posted by Scott Whigham @ 3:00 PM    

Microsoft SQL Server Video Tutorial: Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager

Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager - view details
Quick - what is the default port number for SQL Server's TCP IP connections? Anyone who knows SQL Server knows the default port number and, if you were a hacker who wanted to attack a SQL Server, you would start with trying to go after a SQL Server using the default port number (which, by the way, is 1433). This video shows you how to identify the current port number that SQL Server is using and how to change it. This is an excellent video for configuring your SQL Server for secure connections.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: port, tcp, tcp/ip, tcp ip, change port, change tcp port, change sql server tcp port, change sql server port

posted by Scott Whigham @ 3:00 PM    

SQL Server 2005 Video Tutorial: Part 2 - Choosing the Right Installation For Your Organization

Part 2 - Choosing the Right Installation For Your Organization - view details
Scott Whigham continues the series on installing SQL Server 2005 with this video on the setup choices.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 setup, install, typical, minimal, minimum, custom, set up, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY

Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY - view details
If your queries and stored procedures use @@IDENTITY (perhaps you have legacy code updated from SQL Server 7.0 or earlier), you'll likely get good value from watching this video on replacing @@IDENTITY calls with the T-SQL function SCOPE_IDENTITY(). This video shows very plainly the negative possiblities of using @@IDENTITY today (triggers are a real problem) and, after you watch this tutorial, you'll never want to use @@IDENTITY again!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: scope Identity, dbcc check_ident

posted by Scott Whigham @ 2:00 PM    

Exchange 2007/2003 Video Tutorial: Lecture on Server Design

Lecture on Server Design - view details
Exchange Server and Windows Server guru Grant Moyle lets you in his head as he talks about designing your network solution to fit your users' requirements. Grant talks about how many licenses you'll need, what types of servers (at a minimum) and more. An interesting video - not a lot of demo; mostly lecture - but you'll be glad you watched this one
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: spec out server for Exchange, Exchange server design

posted by Scott Whigham @ 1:00 PM    

Microsoft SQL Server Video Tutorial: Part 1 - Cross Database Ownership Chaining - What It Is and When to Use It

Part 1 - Cross Database Ownership Chaining - What It Is and When to Use It - view details
Cross Database Ownership Chaining was introduced as a settable database and server option in SQL Server 2000's Service Pack 3 yet most people do not even know what it is. SQL Server trainer Scott Whigham shows you all the details about Cross Database Ownership Chaining in this video and also shows you how installing Service Pack 3 completely changes how your SQL Server's security model works. Microsoft does not recommend setting Cross Database Ownership Chaining for your server but why not? If you want to know the answer then watch this series of 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: sql cdoc, sql database ownership chaining

posted by Scott Whigham @ 12:00 PM    

SQL Server Integration Services Video Tutorial: Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
This is the first video in our series on migrating a DTS package to SSIS package. If you're looking for an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. This series takes an interesting DTS package - iterating through each file returned from a result set, downloading that file via FTP, and then inserting that text file's data in a SQL Server table - and lets you see exactly how to migrate this package to SSIS.

Highlights from this video:
  • Using the Package Migration Wizard (PMW)
  • Limitations of the PMW
  • What to Do When the PMW Reports Success But Your SSIS Packages Fail
  • Should You Rewrite Your DTS Package or Use the PMW?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only vide o so a subscription is required.

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

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure

posted by Scott Whigham @ 12:00 PM    

SQL Server Integration Services Video Tutorial: Pt. 2 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 2 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
Part two covers the Package Migration Wizard in detail
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: package migration wizard

posted by Scott Whigham @ 11:00 AM    

SQL Server 2000 Video Tutorial: Schemas, Objects, and Ownership in SQL Server 2000

Schemas, Objects, and Ownership in SQL Server 2000 - view details
Schemas in SQL Server 2000 are completely different from schemas in XML, Oracle and even SQL Server 2005. You could argue that the word schema is the most re-defined word in all of the SQL world but you'd probably find that the SET keyword is at least as re-defined if not more. Anyway, this video is all about security and you need to know what schemas and users are in SQL Server 2000 (especially if you plan on moving forward to SQL Server 2005 at some point). The main concept to take away from this video is object ownership and how to change it. It's sort of hidden in the tools/language but is a very important task for all SQL DBAs
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: ch ange object owner, drop user, owns objects, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 AM    

Transact SQL Video Tutorial: RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQL Server 2000)

RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQL Server 2000) - view details
This video is part of our series on using custom error messages in SQL Server and shows you how to create dynamic error messages that are stored in sysmessages (sys.messages in SQL Server 2005).

Highlights from this video:

  • sp_addmessage
  • Storing messages in the master database
  • Calling adhoc messages
  • Substition parameters (%s, %d) and dynamic vs. static parameterization
  • Architecture of error messages in SQL Server 2005 and 2000
  • RAISERROR and severity levels
  • SQL Server error message 50000
  • How to pass scalar functions into RAISERROR (i.e. SUSER_SNAME(), USER_NAME(), DB_NAME())
  • Using RAISERROR in stored procedures for custom error handling
  • Using RAISERROR WITH LOG to log SQL Server errors to the Event Log in Windows

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

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

Keywords Associated with this video: master.dbo.sysmessages, master.sys.messages, log errors, msg_id, sql server error number

posted by Scott Whigham @ 10:00 AM    

SQL Server 2005 Video Tutorial: Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands

Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands - view details
There are lots and lots of DBCC commands related to performance tuning but did you know that several SET commands can help you out with your query tuning? This video, recorded by SQL consultant Scott Whigham, teaches you several of the most commonly used DBCC and SET commands for performance tuning and provides some tips and tricks for their use. Note: you'll want to likely have a solid foundation in query writing before viewing this video. An understanding of execution plans would also be helpful.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dbcc, statistics, io, statistics_io, stat istics_time, showplan, showplan_all, showplan_text

posted by Scott Whigham @ 9:00 AM    

Microsoft SQL Server Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - view details
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 filetype, sql server file types, sql database files, sql server database files

posted by Scott Whigham @ 8:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 2 - CREATE PROCEDURE Syntax and Execution

Pt. 2 - CREATE PROCEDURE Syntax and Execution - view details
This video walks you through the essential syntax elements of the CREATE PROC (or CREATE PROCEDURE if you prefer) statement and also helps you understand how to execute stored procs. At the end of this video, you'll also learn how to modify (ALTER) and remove (DROP) stored procedures.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 proc, create procedure, alter proc, alter procedure, drop proc, drop procedure

posted by Scott Whigham @ 8:00 AM    

Visual C# Video Tutorial: Pt. 1 - Installing Visual Studio 2005 Professional Edition

Pt. 1 - Installing Visual Studio 2005 Professional Edition - view details
This video walks you through setting up the Visual Studio on your machine for the first time. If you are using the Express Edition, you can see an example of the different setup of Visual Studio 2005 Professional.

Highlights from this video:
  • Choosing options for setup
  • Deciding where to place 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: installation, installing, setup, set up, beginner, beginning

posted by Scott Whigham @ 7:00 AM    

Microsoft SQL Server Video Tutorial: Install Named Instance and View Files and Folders

Install Named Instance and View Files and Folders - view details
This video is a good introduction to installing a SQL Server named instance. It also includes a tour of the changes to the file system - the new files, the new folders, and a comparison between how a default instance works versus how a named instance works.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 second instance sql server, sql named instance

posted by Scott Whigham @ 7:00 AM    

SQL Server 2000 Video Tutorial: How to Increase a Database's Size Using the SQL Server Enterprise Manager

How to Increase a Database's Size Using the SQL Server Enterprise Manager - view details
If you don't know the ALTER DATABASE commands for increasing your SQL Server file sizes (or don't want to use it), then this video is a great head-start to learning file manipulation and management for SQL Server 2000. Veteran SQL Server trainer Scott Whigham shows you a few of his tips and tricks for working with the Enterprise Manager 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: grow database sql server, grow sql file, increase sql database

posted by Scott Whigham @ 6:00 AM    

Microsoft SQL Server Video Tutorial: ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections

ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections - view details
The SQL Native Client, new with SQL Server 2005, is the preferred way to connect to a SQL Server 2005 instance today. 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: connect sql server 2005, new feature, odbc

posted by Scott Whigham @ 6:00 AM    

Windows 2003 Video Tutorial: How to Map Network Drives

How to Map Network Drives - view details
Grant Moyle shows you how to map network drives and discusses the pros and cons of doing so in this excellent video. Required viewing for any new junior sysadmin!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: mapped drives Windows, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 5:00 AM    

SQL Server 2005 Video Tutorial: JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?

JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? - view details
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 union, sql ansi join, sql union all

posted by Scott Whigham @ 5:00 AM    

SQL Server 2005 Video Tutorial: Variables and Scoping - Local Variables and Batch Terminators

Variables and Scoping - Local Variables and Batch Terminators - view details
The rules for variable scoping (i.e., the "life of the variable") in SQL Server might be a little different from the rules in other languages. To understand variable scoping in SQL, you have to have a good understanding of batches. This video helps you understand both!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: GO

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

Windows 2003 Video Tutorial: Differences Between COMMAND and CMD and a Few Command Line Tools

Differences Between COMMAND and CMD and a Few Command Line Tools - view details
Did you know that there are differences between using CMD and COMMAND at the Start-Run prompt? Most people are not aware that these two actually launch two separate processes. In this video you'll learn the differences and learn when to use each. You'll also pick up several helpful DOS writing tips and many of the useful DOS file and folder management commands. This video is essential viewing for any serious system administrator. This video could also be titled 'Using the Win32 DOS Commands to Control Your Server'. Hint: if you need to write batch files this video is a must!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Command line tools Windows 2003

posted by Scott Whigham @ 3:00 AM    

SQL Server 2005 Video Tutorial: Pt. 4 - OUTPUT Parameters and How to Use Them

Pt. 4 - OUTPUT Parameters and How to Use Them - view details
One of the more confusing aspects of the stored procedure is the syntax and usage of OUTPUT parameters. This video tutorial will help you understand what OUTPUT params are, where they are used (in a Singleton pattern, for example), and how to access/assign the values to local variables. Don't miss this 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: stored proc output params, OUT parameters, advanced stored procedures

posted by Scott Whigham @ 2:00 AM    

Exchange 2007/2003 Video Tutorial: 5.5 Migration - Final Video - Removing the last 55 server and cleanup

5.5 Migration - Final Video - Removing the last 55 server and cleanup - view details
5.5 Migration - Final Video - Removing the last 55 server and cleanup
To download this video, log in , then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: 5.5 Migration - Final Video - Removing the last 55 server and cleanup

posted by Scott Whigham @ 2:00 AM    

Windows 2003 Video Tutorial: How to Install Office 2003 and Update to Office 2003 Service Pack 2

How to Install Office 2003 and Update to Office 2003 Service Pack 2 - view details
All admins have to know how to install software, both on the server and on the desktop. You don't get to become the Network Admin generally without knowing the desktop systems extremely well - so you'll want to see the Office 2003 options for rollout.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: How to Install Office 2003 and Update to Office 2003 Service Pack 2, beginner, beginning, for beginners, introduction, step by s

posted by Scott Whigham @ 1:00 AM    

Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - view details
IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: identity, update identity, autonumber, auto-number, auto number, seed, increment, beginner, beginning, for beginners, introducti

posted by Scott Whigham @ 12:00 AM    

Friday, February 16, 2007

SQL Server 2000 Video Tutorial: Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace

Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace - view details
Do you want to know how many times a query has run in your trace? What about finding aggregates like what the minimum duration, maximum duration, and average durations/page reads/CPU? This is a great video that teaches you how to manipulate the trace data into a table for querying. Even then, you still have some work to do...

Highlights from this video:
  • How to save a trace to a table
  • Querying trace tables
  • Writing reporting-style queries against traces
  • Working with ntext data types and GROUP BY/WHERE clauses
  • Modifying your trace table to make it usable in aggregates
  • Saving the queries traced to a SQL file
and much more