Saturday, February 10, 2007

Windows 2003 Video Tutorial: Part 4 of 4 - Install Exchange 2003

Part 4 of 4 - Install Exchange 2003 - view details
This is the final part of our four-part series on installing Exchange for a small to medium organization (about 100 users or less). In this video everything is ready to install Exchange so we will install and configure Exchange for the first 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: Exchange 2003 installation

posted by Scott Whigham @ 11:00 PM    

DTS Video Tutorial: Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000

Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000 - view details
Do you just need to migrate the data from Access to SQL Server? Maybe just one or two tables? Then this video (and this series) is for you.

Highlights from this video:
  • How to migrate tables in Access 2007/2003/2000 to SQL Server 2000 using Data Transformation Services (DTS)
  • Using the Import/Export Wizard in DTS
  • Potential problems faced when using DTS to migrate Access tables and queries
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: data transformation services wizard

posted by Scott Whigham @ 10:00 PM    

Microsoft SQL Server Video Tutorial: Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services

Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services - view details
SQL Server 2005 introduces a few new services and a few new choices. This video talks about the services in SQL Server 2005 including the MSSQLServer, SqlServerAgent, SqlBrowser, 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: sql service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by Scott Whigham @ 10:00 PM    

Windows 2003 Video Tutorial: Customize Interfaces for Files and Folders

Customize Interfaces for Files and Folders - view details
Windows Server 2003 offers many different options for viewing files and folders. In this video MCSE Grant Moyle walks you through all the options for file/folder management. While much of this video covers the basics of file and folder customizations there are several neat tips inside this video for even the seasoned sysadmins. This video shows you how to customize the file and folder experience using Windows 2003. For those administrators wanting to customize either Windows XP or Windows Server 2003, this is the video for you!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 windows explorer

posted by Scott Whigham @ 9:00 PM    

Microsoft SQL Server Video Tutorial: Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server - view details
Do you know what a collation is in SQL Server? What's the difference between CI and CS collations? How about CP1 versus CP1252 - what's the difference (nothing)? If these questions baffle you, then you might enjoy watching Scott Whigham explain how string (character) data works in SQL Server. If you are trying to understand how SQL Server works with case-sensitive data (or case-insensitive data), then you'll get a lot out of this video. Learn the difference between SQL Collations, Windows Locale, Code Pages, and whether or not a lower-case "a" sorts before or after an upper-case "A"
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: collate, collation, sql collation

posted by Scott Whigham @ 9:00 PM    

Windows 2003 Video Tutorial: Pt. 5 - Adding a Second Node to the Cluster

Pt. 5 - Adding a Second Node to the Cluster - view details
It wouldn't do very well to just have one server in our cluster, would it? This video continues the installation of our cluster and using the Cluster Administrator to set up Node 2.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: cluster, clustering, clustered, node1, node2, node 1, node 2, clnode1, clnode2, local domain, .local, setup, setting up, install

posted by Scott Whigham @ 9:00 PM    

SQL Server 2005 Video Tutorial: Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them

Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them - view details
Common Table Expressions (CTEs) are an interesting addition to SQL Server 2005's Transact-SQL language. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the basics of what CTEs are, the syntax and concepts of using CTE and gives you a few examples in this video. This video is part 1 in our series on CTEs and is designed to be an introduction to the syntax and the concepts of using CTEs.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 recursion, sql hierarchy, hierarchical query

posted by Scott Whigham @ 8:00 PM    

Transact SQL Video Tutorial: When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause

When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause - view details
The traditional areas of difficulty for SQL developers are aggregates, JOINs, and subqueries. Most people have no trouble understanding when to use COUNT instead of SUM but they get "stuck" when it comes to determining how to filter the data. Suppose you are asked to find all orders in 2006 in which customers ordered more than 5 items - how would you solve this query? Obviously you need two filters: for the date (2006) and for orders with more than 5 items. People have difficulty with this type of query however; most people would approach this query along these lines: "SELECT ... FROM Orders JOIN OrderDetails ... WHERE Year(DateOrdered)=2006 AND COUNT(*) > 5". Focus on the WHERE clause for a moment: is that right? If you aren't sure or if you think it is right, then you need to watch this video to understanding why this query must use the HAVING clause.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: having, aggregates where clause, group by

posted by Scott Whigham @ 8:00 PM    

Visual C# Video Tutorial: Pt. 5 - Our First Console Application in Visual Studio

Pt. 5 - Our First Console Application in Visual Studio - view details
Pt. 5 - Our First Console Application in Visual Studio
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: dos, command prompt, command line, services

posted by Scott Whigham @ 8:00 PM    

Exchange 2007/2003 Video Tutorial: Recipient Filtering

Recipient Filtering - view details
If you are constantly getting non-delivery reports for previous employees and users, watch this video on Recipient Filtering. Recipient Filtering allows you to bounce back messages sent to certain email addresses based on your addresses in the 'Block messages that are sent to the following recipients'
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 recipient filtering

posted by Scott Whigham @ 7:00 PM    

SQL Server 2000 Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! - view details
Real-World Scenario - your boss (or client) calls you at 4:54PM on Friday afternoon and says, "All of my people are getting an error working with Application X. Can you check what's going on?" You take a look and, sure enough, your transaction log has taken up the entire disk! Your data file is regular size but your transaction log is HUGE. What do you do? If you answered, "Take a transaction log backup" then you need to watch this video (because the log is full, it will not allow you to take a "traditional" transaction log backup). This video, recorded by resident SQL guru Scott Whigham, presents you with the What-If's, the Why's, and How To's of solving this very problem.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: truncate log, sql truncate, sql log filled up

posted by Scott Whigham @ 7:00 PM    

SQL Server 2005 Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens

Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens - view details
SQL Server Profiler is just an amazing tool and one that every sysadmin should know "backwards and forwards." This video, the first in our series, covers what Profiler is, what traces are, and gives you an introduction to using Profiler. You'll also cover the basic screens when you start Profiler.

Highlights from this video:
  • Differences between SQL Server 2000 Profiler and SQL Server 2005 Profiler
  • Permissions required for SQL Server 2005 Profiler
  • Making decisions on the "General" screen
  • Should you save to file or save to table?
  • Using templates with Profiler
  • What sort of performance impact will Profiler cause? How much?
  • How to minimize the "drag" that Profiler creates
  • Server side vs. client side traces
  • What are rollover files (file rollover)? What should the setting be?
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 trace, sql profiler, sql server 2005 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 7:00 PM    

Transact SQL Video Tutorial: Pt. 2 - Using Return Values to Control Program Execution

Pt. 2 - Using Return Values to Control Program Execution - view details
This video expands on the use of return values in SQL Server and shows you how to make decisions in your code based on a stored procedure's return value.

Highlights from this video:
  • What value does RETURN return by default?
  • What are the most likely conventions/uses of RETURN?
  • Using RETURN to return @@ERROR and SQL error codes
  • Best Practices for stored procedure programming
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

posted by Scott Whigham @ 6:00 PM    

Exchange 2007/2003 Video Tutorial: Pt. 3 - Completing the Setup of Exchange 2007

Pt. 3 - Completing the Setup of Exchange 2007 - view details
Now the fun begins... oh, wait - by 'fun', we mean a long process of watching a progress bar move s-l-o-w-l-y from left to right. The setup takes quite a while but, thankfully, we've taken the pain out of it for you with some (ahem) excellent video editing that removes the waiting and just shows you the important bits.

And we're not kidding - the setup process, for us, took more than an hour and this video is only about 12 minutes long!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, guide, setup, set up, installation, installing, installed

posted by Scott Whigham @ 6:00 PM    

SQL Server 2005 Video Tutorial: Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages)

Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages) - view details
The second video in our introduction series on Integration Services focuses on creating, importing, and adding packages in the BI Studio (more formally known as the SQL Server Business Intelligence Design Studio). This is an introductory-level video designed as a "first look" into SSIS packages and the BI Studio. Many people get very confused with the basic concepts of the SSIS architecture and this video helps allay some of the intimidation. Scott Whigham walks you through finding the SSIS Package Store, how the file system works within SSIS, and more information about creating packages.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: SSIS package store, create ssis package, ssis package basics, ssis package intro

posted by Scott Whigham @ 5:00 PM    

Exchange 2007/2003 Video Tutorial: How the Exchange Database Works: Database Growth

How the Exchange Database Works: Database Growth - view details
This video shows you what happens to your Exchange databases when your database grows. You'll learn what the STM and the LOG files do along with the EDB files. A great video for Exchange administrators of all levels
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 database explanation, exchange database intro

posted by Scott Whigham @ 5:00 PM    

SQL Server 2005 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 @ 5: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 @ 4:00 PM    

Exchange 2007/2003 Video Tutorial: Pt. 1 - How to Configure the Intelligent Message Filter (IMF)

Pt. 1 - How to Configure the Intelligent Message Filter (IMF) - view details
The first video in our series on configuring and tweaking the IMF, this video teaches you the basics of IMF configuration. Before continuing on to the more advanced configurations in part 2, you'll want to watch this video by Exchange guru Grant Moyle to learn the ins and outs of the Intelligent Message Filter.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 config, optimize imf

posted by Scott Whigham @ 4:00 PM    

Transact SQL Video Tutorial: Rapid Database Development Using Database Diagrams (SQL Server 2000)

Rapid Database Development Using Database Diagrams (SQL Server 2000) - view details
This video tutorial shows you how to use the Enterprise Manager's Database Diagrams to create tables and manage constraints. Instead of having to manually create tables in the Enterprise Manager with the New Table dialog, you can use the Database Diagrams to do proof of concept and rapid database development (similar to rapid application development).

Highlights from this video:

  • Customizing the Database Diagrams to include/exclude columns/metadata
  • Adding Existing Tables to Layout
  • Using the Save Change Script Option
  • Explanations of what the asterisks mean in the Database Diagrams
  • Create Foreign Keys Using the Drag-and-Drop features of the 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: hide columns, meta data, rad tool, rdd tool, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 3:00 PM    

SQL Server 2005 Video Tutorial: Part 6 - Using Aliases with TCP IP Connections

Part 6 - Using Aliases with TCP IP Connections - view details
In our final video on working with the SQL Server Network Libraries, you'll learn how to use client aliases to make your life much easier. Do you currently have to connect to your SQL Server using an IP address? If so, then you'll really get some mileage out of 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: sql client network utility, sql client, sql alias, server alias

posted by Scott Whigham @ 3:00 PM    

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 @ 3:00 PM    

Transact SQL Video Tutorial: Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Server 2000)

Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Server 2000) - view details
This video focuses on the common scalar functions built into SQL Server 2000 (such as GETDATE(), UPPER(), SUBSTRING(), et al). Scott Whigham, author of this site, walks you through the most commonly used functions and does an excellent job of explaining the different types of functions (such as the cryptic term "Niladic Function").

Highlights from this video:

  • Definitions of the terms "Scalar", "Niladic" "System Functions" and more
  • How scalar functions work in SQL Server and where/when to use them
  • Syntax elements of commonly used functions
  • String Manipulation: UPPER(), LOWER(), SUBSTRING()
  • Trimming strings
  • Commonly used functions in triggers; i.e., Auditing Usage with APP_NAME, DB_NAME, etc
  • Overview of User Defined 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: udf, deterministic, db_id, host_name

posted by Scott Whigham @ 2:00 PM    

Visual C# Video Tutorial: Pt. 3 - Our First Console Application in Visual Studio

Pt. 3 - Our First Console Application in Visual Studio - view details
Pt. 3 - Our First Console Application in Visual Studio
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video:

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server Video Tutorial: Part 6 - Verifying Our Installation and Reviewing The Install Logs

Part 6 - Verifying Our Installation and Reviewing The Install Logs - view details
This is, as the title implies, Part 6 in our 7-part series on installing SQL Server 2005 for the first time. In this video, SQL guru Scott Whigham has finished the installation and shows you the logs that SQL Server uses to track the installation along with several of the changes that have now occurred on your 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: sql install, setup, sql server log, setup log, sql set up logs, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Exchange 2007/2003 Video Tutorial: Change SMTP Connection Information

Change SMTP Connection Information - view details
SMTP is the heart of Microsoft Exchange; it's how you send mail and receive mail. One common problem that administrators leave open is the SMTP connection information. When your Exchange server responds via SMTP it passes connection information back to the client. By default, this information contains sensitive information that you might wish to hide from clients. This video helps you establish some basic security guidelines and best practices for SMTP with Exchange. You'll use the IIS Metabase Explorer to view and change the Metabase
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 exchange SMTP connection

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Distributed Link Tracking: Explanation and Use

Distributed Link Tracking: Explanation and Use - view details
This video could be titled 'What is the Distributed Link Tracking Service and how do I use it?' The Distributed Link Tracking service helps maintain links between different disks, systems or even on the same system. In other words when you move a file around your network, if the Distributed Link Tracking service is operating, it will 'remember' where you've moved that file and all shortcuts to that file will point to the new location dynamically
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Distributed Link Tracking Windows 2003

posted by Scott Whigham @ 12:00 PM    

SQL Server 2000 Video Tutorial: Part 2 - How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels

Part 2 - How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - view details
Part 2 in our series on changing authentication modes for SQL Server
To download this video, lo g in, then visit the video's detail page and click "download". This is a subscriber-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 authentication, sql security, sql server security

posted by Scott Whigham @ 12:00 PM    

Microsoft SQL Server Video Tutorial: Query Analyzer - Beyond the Basics (SQL Server 2000)

Query Analyzer - Beyond the Basics (SQL Server 2000) - view details
For those of you who want to go beyond the basics of hitting F5 to execute your query (CTRL+E works as well), this video walks you through some of Scott Whigham's favorite "tweaks" to the SQL Server 2000 Query Analyzer. Scott Whigham is the author of LearnSqlServer.com, LearnDTS.com and LearnTransactSql.com and has many, many years customizing and optimizing SQL Server including the tools. This video will really give you some good ideas for using the Query Analyzer and will help you speed up your day-to-day 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: query analyzer, object browser, object search

posted by Scott Whigham @ 11:00 AM    

Transact SQL 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 @ 11:00 AM    

Windows 2003 Video Tutorial: Part 2 of 4 - Install Exchange 2003

Part 2 of 4 - Install Exchange 2003 - view details
This is part two of a four-part series on installing Exchange for a small to medium organization (about 100 users or less). In order to install Exchange you must have the required services already installed. This video walks you through the basic prep of a machine for Exchange including installing the Windows Support 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: Exchange 2003 installation

posted by Scott Whigham @ 11:00 AM    

SQL Server 2000 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 @ 10:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 4 - Configuring Profiler for Common Tasks (Templates)

Pt. 4 - Configuring Profiler for Common Tasks (Templates) - view details
Scott Whigham, author of LearnSqlServer.com, walks you through one of his favorite tweaks for SQL Server Profiler - creating and customizing templates. This is a very quick video but it's content will save you a ton of frustration and time!

Highlights from this video:
  • Creating templates
  • Best Practices for Backing Up templates
  • Configuring Profiler to auto-start a trace upon 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: trace template, start automatically, profile startup

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: Customizing and Tuning The Mouse for a Server

Customizing and Tuning The Mouse for a Server - view details
Grant Moyle, Windows and Exchange consultant "extraordinaire", walks you through customizing your Windows server for maximum cocmfort and usability in this video on tweaking the mouse. A quick video but certainly interesting.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 mouse, optimize mouse, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:00 AM    

Exchange 2007/2003 Video Tutorial: POP3 and IMAP4 in Exchange 2003

POP3 and IMAP4 in Exchange 2003 - view details
This video takes a look at the IMAP4 and the POP3 protocol configuration in Exchange System Manager (ESM) so that our Exchange server will listen for IMAP4 and POP3 requests on the internet. Grant Moyle, Exchange trainer, explains what POP3 and IMAP4 are and how they are used on the world wide web 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: POP3 IMAP4 with Exchange, IMAP4 with Exchange, POP3 with Exchange, beginner, beginning, for beginners, introduction, step by ste

posted by Scott Whigham @ 8:00 AM    

Transact SQL Video Tutorial: UNION Queries - What They Are and How to Use Them (SQL Server 2000)

UNION Queries - What They Are and How to Use Them (SQL Server 2000) - view details
Although less popular than JOINs, UNIONs are another way to work with multiple tables in the same query. Much of the time UNIONs are used to generate lists of things; i.e., "Find all Customers and Suppliers in the United States". This video gives you the basic syntax and, more importantly, the logic behind how it works and when to use UNION vs. UNION ALL.

Note: This video was shot on SQL Server 2000's Query Analyzer but the same logic applies for SQL Server 2005

Highlights from this video:

  • Difference between UNION and UNION ALL
  • Performance with UNION
  • Including indicators in result sets to identify which table a row comes from
  • Writing UNION compatible queries
  • Datatype mismatches in UNIONs and how to avoid them
  • ORDER BY in UNION queries

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

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

Keywords Associated with this video: distinct, union all

posted by Scott Whigham @ 8:00 AM    

Transact SQL Video Tutorial: Using SET Commands Inside Stored Procedures and When Executing Stored Procedures

Using SET Commands Inside Stored Procedures and When Executing Stored Procedures - view details
This video is "Must-See TV" for those of you wanting to be better stored procedure programmers. The focus of this video is how the scoping of the SET commands in your stored procedures can impact performance and/or results.

This video was shot on SQL Server 2005 but the same concepts still apply for SQL Server 2000

Highlights from this video:

  • Using SET NOCOUNT ON/OFF
  • Using TOP vs. ROWCOUNT
  • Best Practices for using SET commands in stored procedures
  • Optimizing stored procedures for faster execution and easier client use
  • Temporary tables and scoping
  • Creating temporary stored procedures
  • Using DBCC USEROPTIONS to view connection settings
  • sys.objects/sysobjects
  • Error Handling with transactions using XACT_ABORT and @@ERROR

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 XACT_ABORT ON, while, declare @e int, set @e = @@error, rollback, commit

posted by Scott Whigham @ 7:00 AM    

SQL Server 2000 Video Tutorial: Model Database - An Overview of How to Use It and When to Use It (SQL Server 2000)

Model Database - An Overview of How to Use It and When to Use It (SQL Server 2000) - view details
Most SQL Server administrators and developers do not take full advantage of the model database, whether because they don't need to or don't know how. This video walks you through how SQL Server uses the model database (the architecture of SQL Server's CREATE DATABASE) and gives you suggestions for how you can use the model database to trap errors, perform audits, 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: sql model database, sql server system database, system db

posted by Scott Whigham @ 7:00 AM    

Visual C# Video Tutorial: Pt. 6 - Codefiles, Inline Code, and a Tour of More Controls

Pt. 6 - Codefiles, Inline Code, and a Tour of More Controls - view details
Pt. 6 - Codefiles, Inline Code, and a Tour of More Controls
To download this video, log in, then visit the video 's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: code behind, code file, codebehind, differences

posted by Scott Whigham @ 7:00 AM