Saturday, December 02, 2006

SQL Server 2005 Video Tutorial: TOP Operator: What's New and Why Life Is much Easier Today

TOP Operator: What's New and Why Life Is much Easier Today - view details
The TOP operator has been greatly enhanced over SQL Server 2000's implementation of TOP by adding support for parameterization and the ability to use TOP in all DML statements (instead of just the SELECT). Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through using the new features of TOP and how it differs from previous versions.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: new feature, top parameter, insert, update, delete, select

posted by Scott Whigham @ 11:00 PM    

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

Part 2 - Cross Database Ownership Chaining - What It Is and When to Use It - view details
This video is part 2 in our series on Cross Database Ownership Chaining
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 cross-database ownership chaining

posted by Scott Whigham @ 11:00 PM    

SQL Server 2005 Video Tutorial: Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions

Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions - view details
This video continues our discussion of SET commands and how they work within/outside-of stored procedures. This video also has an excellent discussion of using brackets and double quotes to delimit objects with spaces and/or reserved keywords in the name. Should You Use Brackets or Double-Quotes to delimit objects? In other words, should you use [Order Details] or "Order Details"?

Note: This video was shot on SQL Server 2005 but the concepts are the same for SQL Server 2000.

Highlights from this video:

  • Using SET NOCOUNT ON inside stored procedures and triggers
  • DBCC USEROPTIONS
  • Discussion of Quoted Identifiers and SET QUOTED_IDENTIFIERS ON/OFF
  • Object delimiters and when to use double quotes instead of single quotes
  • Hierarchy of settable options: database-level, connection-level, stored procedures/triggers, hints
  • Using the SQL Server Management Studio (SSMS) to view and change database-level connection options
  • How to change connection-level options
  • How the Query Analyzer and SSMS use connection-level options

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, set quoted_identifier, objects with spaces in the name

posted by Scott Whigham @ 10:00 PM    

Transact SQL Video Tutorial: Creating and Altering Views in the Enterprise Manager (SQL Server 2000)

Creating and Altering Views in the Enterprise Manager (SQL Server 2000) - view details
If you are new to working with SQL Server (and views), then this is an excellent introduction to creating and altering views using SQL Server 2000's Enterprise Manager. This video is focused on SQL Server 2000 but, for those of you using SQL Server 2005, the screens are almost identical in the SQL Server Management 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: create view, alter view, drop view

posted by Scott Whigham @ 10:00 PM    

SQL Server 2000 Video Tutorial: Setting Database Options Using the Enterprise Manager - Setting the Database State Options

Setting Database Options Using the Enterprise Manager - Setting the Database State Options - view details
This is one of those "Oh okay, I didn't know exactly what that did" type of videos. SQL Server MCDBA Scott Whigham walks you through the settable database options that you find in the Enterprise Manager and presents the information in any easy-to-follow format that anyone can understand.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: database options, set database options, alter database

posted by Scott Whigham @ 9:00 PM    

Microsoft SQL Server Video Tutorial: Creating Windows Authentication Logins in the Enterprise Manager

Creating Windows Authentication Logins in the Enterprise Manager - view details
Almost every SQL Server installation has at least one Windows Authentication login allowed making this a very popular authentication choice. Do you know what security privileges the "BUILTIN\Admins" has (is it dangerous)? Should you allow Windows Groups to login to your SQL Server and, if so, what type of architecture should you choose? Experienced SQL Server consultant Scott Whigham shows you all the details about SQL Server's Windows Authentication model in this excellent video. This should be considered "required viewing" for all new SQL sysadmins
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 windows, sql windows login, sql builtin

posted by Scott Whigham @ 8:00 PM    

Exchange 2003 Video Tutorial: Database Management for Multiple Exchange Databases: Managing Storage Limits

Database Management for Multiple Exchange Databases: Managing Storage Limits - view details
This video shows you how to manage multiple Exchange databases and control users' sending/receiving limits. It can become very difficult to manage multiple Exchange servers if you maintain different limits on each database/server. This video walks you through setting policies for multiple Exchange servers so that all Exchange servers can be the same
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 mailbox limit policy

posted by Scott Whigham @ 8:00 PM    

Transact SQL 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 @ 8:00 PM    

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

Exchange 2003 Video Tutorial: Installing Exchange 2003: Perform a Quick Install

Installing Exchange 2003: Perform a Quick Install - view details
If you want just a quick install without too much fuss then this is the perfect video. This is perfect for first-time installs or to get some good pointers on installations. After watching this video you'll be well prepared to install Exchange Server 2003 on your own system. If you want more detail after watching this video, look for installation videos with higher skill-levels; those will go into more details on each option/property you see in the setup screens as well as providing you with recommended configurations, best practices, and more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: install Exchange server 2003, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: Phase 3, Pt. 1 - Installing the First Exchange 2003 Server

Phase 3, Pt. 1 - Installing the First Exchange 2003 Server - view details
Now that you've replicated your Exchange 5.5 mailboxes and users to Active Directory you'll obviously want to install Exchange 2003, right? This video walks you through the installation of your first (and possibly only) Exchange 2003 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 exchange 2003, exchange setup

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server 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, statistics_time, showplan, showplan_all, showplan_text

posted by Scott Whigham @ 6:00 PM    

Windows 2003 Video Tutorial: Helpful Start and Run as Commands (DOS)

Helpful Start and Run as Commands (DOS) - view details
Grant Moyle, author of LearnWindows2003.com and LearnExchange.com, shows you the commonly used DOS commands that every administrator should know. If you aren't comfortable working with DOS and you want to be a successful sysadmin, then you'll get great value out of this excellent 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: dos, command shell, command line

posted by Scott Whigham @ 5:00 PM    

Exchange 2003 Video Tutorial: Database Management for Multiple Exchange Databases: Managing Storage Limits

Database Management for Multiple Exchange Databases: Managing Storage Limits - view details
This video shows you how to manage multiple Exchange databases and control users' sending/receiving limits. It can become very difficult to manage multiple Exchange servers if you maintain different limits on each database/server. This video walks you through setting policies for multiple Exchange servers so that all Exchange servers can be the same
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 mailbox limit policy

posted by Scott Whigham @ 5:00 PM    

SQL Server 2000 Video Tutorial: Pt. 3 - Setting Up Push Subscriptions

Pt. 3 - Setting Up Push Subscriptions - view details
This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

Highlights from this video:
  • Push Subscriptions vs. Pull Subscriptions
  • Synchronization Schedules and Latency
  • How to initialize a new publication using the "Create Publication Wizard"
  • Discussion of the Distribution Agent and how it works (does it run at subscriber?)
  • Discussion of using non-SQL Server subscribers
  • Discussion of service account usage and recommendations
  • Snapshot initialization and how to start the Snapshot Agent
  • Working with multiple subscriptions for a single publication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu

posted by Scott Whigham @ 5:00 PM    

Exchange 2003 Video Tutorial: Part 2 - Testing and Preparing the Active Directory

Part 2 - Testing and Preparing the Active Directory - view details
This video shows you how to test and verify the Active Directory before your migration
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 for Exchange, Exchange Server Active Directory

posted by Scott Whigham @ 4:00 PM    

SQL Server 2005 Video Tutorial: How to Upgrade The Documentation of SQL Server 2005 (Books Online)

How to Upgrade The Documentation of SQL Server 2005 (Books Online) - view details
Although the actual release for public sale of SQL Server 2005 in December of 2006, Microsoft felt compelled to release an update (a "refresh") of the documentation only a few weeks later. This video shows you how you can tell which version of Books Online (BOL) that you are running, how to update your BOL, and walks you through the process. It's actually a pretty hefty update too - over 115MB of "refreshed" documentation for a piece of software released for public sale only a few weeks earlier. You'll definitely want to upgrade your Books Online as soon as possible.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: BOL update, books online, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Creating Databases with the SQL Server Enterprise Manager

Creating Databases with the SQL Server Enterprise Manager - view details
The Enterprise Manager is probably the easiest tool for creating new databases and, in this video, Scott Whigham shows you all the details of creating databases with EM. This video talks about the options you are presented in the Enterprise Manager including the Logical Filename, physical filename, file growth options, and how collations can influence the database. This video is primarily aimed at those new to creating databases 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: create sql database, create sql server database enterprise manager

posted by Scott Whigham @ 4:00 PM    

Transact SQL Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - view details
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work 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: IDENTITY, auto number, sequence, surrogate key, alternate key

posted by Scott Whigham @ 3:00 PM    

Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of Collation Types and Recommendations

Install SQL Server - Discussion of Collation Types and Recommendations - view details
When you install SQL Server, you make perhaps one of the most important decisions you can make: which default collation you will use. Should you choose Windows Locale or a SQL Collation (and what's the difference)? Are SQL Server Authentication passwords case-sensitive (and why are you asking me that here)? Collations are incredibly important to SQL Server and the collation that you choose during setup can save you hours of frustration later on. Watch this video and get an excellent overview of what collations are and how you should go about choosing the right collation for your 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: sql collations, code page, Cp1252, CP1, Latin1_General, Latin, CP850 multi-lingual

posted by Scott Whigham @ 3:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage

Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage - view details
Stored procedures are the way of the modern programmer and this first video in this series helps you understand the need for and the use of stored procedures in modern applications. You'll learn the basic syntax elements, where to use stored procs, who uses them, and see some rather intricate examples of usage.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 procedure tutorial, stored proc help, stored proc script

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

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

DTS Video Tutorial: Understanding Options for Saving DTS Packages

Understanding Options for Saving DTS Packages - view details
Understanding Options for Saving DTS 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: Understanding Options for Saving DTS Packages

posted by Scott Whigham @ 1:00 PM    

Microsoft SQL Server Video Tutorial: Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs

Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs - view details
This video, the second in our series on using Common Table Expressions (CTEs), walks you through recursion and working with hierarchies with CTEs. This video uses the Northwind database to simplify the learning process and uses some common recursive queries used in Northwind examples to highlight the basic use of the CTE.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 @ 1: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 @ 12:00 PM    

Exchange 2003 Video Tutorial: Creating a Mail-Enabled Contact In the Active Directory

Creating a Mail-Enabled Contact In the Active Directory - view details
A contact is an object that is present in the Active Directory and also present in our Exchange Global Address List but the user cannot log onto our system nor while they have a mailbox. Contacts are used to allow foreign email accounts but to still have them show up in the Global Address List. This video shows you the how, the why, and the how-to work with contacts with Exchange 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: mail-enabled contact AD, mail-enabled contact Active Directory

posted by Scott Whigham @ 12:00 PM    

Exchange 2003 Video Tutorial: Using Full Plus Incremental with a Recovery Storage Group (RSG)

Using Full Plus Incremental with a Recovery Storage Group (RSG) - view details
You aren't limited to only restoring from full, incremental, differential and transaction logs. The Recovery Storage Group (RSG) is a great way to restore 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: backup RSG, backup recovery storage group

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: Management Tools Install

Management Tools Install - view details
Whenever you have multiple domain controllers and an Exchange server on your network you often want to be able to manage the Exchange information from within the Active Directory Users and Computers MMC snap-in. This video guides you through setting up a domain controller to work with the Exchange screens for objects
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: install Exchange management tools

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: Pt. 1 - Pre Installation Steps for Exchange 2000

Pt. 1 - Pre Installation Steps for Exchange 2000 - view details
This video walks you through the pre-requisites for installing Exchange 2000 along with some ideas for setting up the server in preparation to test your upgrade to Exchange 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: prereqs

posted by Scott Whigham @ 10:00 AM    

Exchange 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 @ 10:00 AM    

Windows 2003 Video Tutorial: Customize the Start Menu and Desktop

Customize the Start Menu and Desktop - view details
Windows Server 2003 and Windows XP changed the Start Menu and the Desktop's default configurations. If you're new to Windows Server 2003 and want to understand where everything is check out this video. This video also helps you understand Windows XP's Start Menu and customizations
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 Start Menu, Put My Computer on Desktop, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: How to Restore System State from NTBackup

How to Restore System State from NTBackup - view details
In this video you'll walk through restoring a backup of your machine from a previous file that you created with NTBACKUP, a built-in backup utility. In the 'Advanced Mode' of NTBACKUP you'll be able to restore previous systems. Grant Moyle, guru of the Windows operating system, walks you through how to restore the registry and/or the entire system. Ever wondered what the file 'SAM' was for? Or where the registry is stored in the file system? Check out this video - you'll be glad you did!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: restore system state ntbackup

posted by Scott Whigham @ 8:00 AM    

Microsoft SQL Server Video Tutorial: How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Transaction Log File Size

How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Transaction Log File Size - view details
What would happen to your production database(s) right now if the transaction log was 100% full? Would the files automatically grow so that there would be more space available for data or would your users be shut-out until you manually added more space? What if it happened to your data file(s)? This video talks about various ways that you, the DBA, can be proactive in managing your disk files including increasing the data file size, suggestions on using autogrowth, how the files grow and disk space is allocated 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 this video: alter database sql server, sql server alter database

posted by Scott Whigham @ 8:00 AM    

Windows 2003 Video Tutorial: Installing IIS (Internet Information Services) - the Web server for Windows

Installing IIS (Internet Information Services) - the Web server for Windows - view details
An essential video for all Windows sysadmins
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 IIS 6.0, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 7:00 AM    

Windows 2003 Video Tutorial: Setup Your Windows 2003 Server for DHCP

Setup Your Windows 2003 Server for DHCP - view details
In this video you'll change the server's TCP/IP properties to use DHCP (Dynamic Host Communication Protocol). This is the perfect video to help you master one of the most common terms to any administrator - DHCP. A short video but all Windows sysadmins should have a thorough understanding of DHCP. This video could also be titled 'Assign a Dynamic IP Address for Your Windows 2003 Server Using DHCP'
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: DHCP configuration for Windows 2003, beginner, beginning, for beginners, introduction, step by step

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

Windows 2003 Video Tutorial: Printers: Configuring Printer Hardware Options in Windows 2003

Printers: Configuring Printer Hardware Options in Windows 2003 - view details
If Windows is not recognizing your new print tray you may need to configure a few easy operating system tweaks. In this video you'll learn how to configure your network printer so that the printer is aware of all the printer settings. This video goes well beyond the basics of network printer sharing; this video will teach you all the ins-and-outs of network printer management and configuration. Most sysadmins will pick up a new thing or two watching Windows guru Grant Moyle walk through the printing properties of a network printer. A must for all administrators
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 printer sharing configuration

posted by Scott Whigham @ 6:00 AM    

Friday, December 01, 2006

Exchange 2003 Video Tutorial: Creating a Full Backup

Creating a Full Backup - view details
Many Exchange installations take full backups every night for disaster recovery. Full backups are very important: you cannot restore an Exchange database without one. This video walks you through taking the backup as well as identifying best practices, tips and techniques, and recommended backup choices. 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: full backup Exchange

posted by Scott Whigham @ 8:00 PM    

Windows 2003 Video Tutorial: Windows 2000: Installing Service Pack 4 (SP4)

Windows 2000: Installing Service Pack 4 (SP4) - view details
Many administrators manage multiple operating system versions including Windows Server 2003, Windows 2000 and, of course, Windows XP. This video shows you the installation techniques for Service Pack 4 and how to determine the service pack level of any Windows machine
To download this video, log in, then visit the video's