Saturday, April 28, 2007

Exchange 2007/2003 Video Tutorial: How to Fix It: Sharepoint Install Breaks Outlook Web Access (OWA)

How to Fix It: Sharepoint Install Breaks Outlook Web Access (OWA) - view details
What does Kerberos have to do with Sharepoint and why does that break Outlook Web Access? In this video, Grant Moyle shows you how to resolve a common scenario for administrators working with both Sharepoint and Exchange 2003. If you've been working with OWA successfully and then it shows an http error 404, "Page not found" when you browse to your OWA site, then you might have an error caused by installing Sharepoint on the same machine as Exchange Server. Sharepoint and Exchange Server can exist on the same machine without any problems but you must follow a certain number of steps to ensure complete compatibility. After watching this video you'll know what causes the problem and how to fix it.


To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 sharepoint error, problem sharepoint outlook web access, sharepoint owa error

SQL Server 2005 Video Tutorial: How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio

How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio - view details
Curiously enough, Microsoft decided against scripting out the indexes when you script out the table in the SQL Server 2005 Management Studio. This video shows you the default "behavior" of the Management Studio, how you can spot the "problem", and how you "fix" it. It's a strange decision by Microsoft to omit this (an accident, perhaps?) but don't get caught by this "undocumented feature"!


To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 script, generate script, generate sql script

Friday, April 27, 2007

SQL Server 2005 Video Tutorial: Pt. 1 - What Return Values Are and How to Use Them

Pt. 1 - What Return Values Are and How to Use Them - view details
This video is an excellent introduction to using Return Values in your SQL Server stored procedures. Return values can speed up performance of your applications as well as helping make a more logical flow. Anyone writing or maintaining stored procedures needs to know this information. NOTE: This video was shot on SQL Server 2005 but the same concepts apply to all versions of SQL Server.

Highlights from this video:
  • Making decisions using return values
  • Returning values to the caller
  • Using RAISERROR and RETURN values


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

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


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

Windows 2003 Video Tutorial: Pt. 2 - Installing the WSUS 2.0 Software

Pt. 2 - Installing the WSUS 2.0 Software - view details
Pt. 2 - Installing the WSUS 2.0 Software


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

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


Keywords Associated with this video: Pt. 2 - Installing the WSUS 2.0 Software

Thursday, April 26, 2007

Windows 2003 Video Tutorial: Pt. 3 - Installing and Configuring Additional Domain Controllers

Pt. 3 - Installing and Configuring Additional Domain Controllers - view details
This video, part three in our series on installing private namespace domains, covers the installation and configuration of DNS on the second domain controller. Configuring DNS is not a trivial task for an administrator, especially when you have multiple DNS servers on your network therefore this is an excellent video to help you understand the architecture of domains and forests.


Related Videos: On the LearnExchange.com website, we have a video series on how to install Exchange Server on a private namespace domain


To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, .local, local namespace domains

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

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
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: sql odbc, sql odbc driver, sql driver

Wednesday, April 25, 2007

Exchange 2007/2003 Video Tutorial: Moving Databases and Transaction Logs

Moving Databases and Transaction Logs - view details
In this video you'll learn to move your database and log files around your server as well as a few best practices for managing files on your Exchange server. 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: move exchange database, move exchange log

Exchange 2007/2003 Video Tutorial: How to Purge Deleted Items and Manage Delete Item Retention Period

How to Purge Deleted Items and Manage Delete Item Retention Period - view details
This is an excellent video if you're struggling to understand the underpinnings of Microsoft Exchange Server 2003. You'll learn how Exchange works with deleted items, what the 'Deleted Item Retention Period' is and how to configure it. 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: delete items exchange retention

Tuesday, April 24, 2007

Visual Basic Video Tutorial: Pt. 4 - A Complete Example of How to Read Arguments and Parse Arguments

Pt. 4 - A Complete Example of How to Read Arguments and Parse Arguments - view details
Pt. 4 - A Complete Example of How to Read Arguments and Parse Arguments


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

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


Keywords Associated with this video: Pt. 4 - A Complete Example of How to Read Arguments and Parse Arguments

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

How Reporting Services Uses .RDL (Report Definition Language) Files - view details
How Reporting Services Uses .RDL (Report Definition Language) 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: How Reporting Services Uses .RDL (Report Definition Language) Files

Monday, April 23, 2007

Exchange 2007/2003 Video Tutorial: Global Settings: Message Delivery Options

Global Settings: Message Delivery Options - view details
Inside Exchange System Manager you'll find a listing for Global Settings - Message Delivery. By setting Message Delivery options you can control sending/receiving maximums (number of recipients, size of emails) as well as a whole host of other settings. Exchange guru Grant Moyle walks you through setting these options by giving you best practices and many helpful ideas


To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 global settings Message delivery options

SQL Server Integration Services Video Tutorial: Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job

Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job - view details
Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job


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

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


Keywords Associated with this video: Pt. 2 - How to Execute An SSIS Package Stored in SQL Server (msdb) As a SQL Server Job

Sunday, April 22, 2007

SQL Server 2000 Video Tutorial: Pt. 1 - Why Migrate From Microsoft Access to SQL Server?

Pt. 1 - Why Migrate From Microsoft Access to SQL Server? - view details
So it's time to move away from using that friendly, rapid-application-development tool Microsoft Access and start using a full-blown relational database management system such as SQL Server, eh? There are many reasons to move from Access to SQL Server and this video gives you the primary reasons why people move from Access to SQL.

Highlights from this video:
  • Differences between Access and SQL Server
  • Definitions of the ACID test and how it applies to SQL Server but not to Access
  • Memory and CPU support in SQL Server
  • How transactions are handled differently between the two systems
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: upgrade access, upgrade Access 2003, upgrade Access 2007, upgrade Access XP, upgrade Access 2000

SQL Server 2005 Video Tutorial: Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster

Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster - view details
SP2 is the latest service pack from Microsoft and this video helps you view a service pack installation on a cluster. You'll walk through the entire installation as well as the verification of the installation.

Highlights from this video:
  • Installing SQL Server 2005 Service Pack 2 CTP (a.k.a. the Beta version)
  • Best Practices for installing service packs
  • Managing the cluster and verifying the Active/Passive nodes
  • Tips and techniques for a smooth upgrade
  • Viewing the new setup bootstrapping program in SP2
  • Suggestions for disaster recovery/rollback
and much more


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

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


Keywords Associated with this video: sp2, sp1, clustered service packs, SPS, installing, installation, setup.bat