Microsoft TechNet How-to Videos

How Do I: Configure a virtual machine running on Windows Server 2008 R2 with Hyper-V to support hot add storage?

Fri, 30 Oct 2009 22:43:20 +0530

With the release of Windows Server 2008 R2, Hyper-V supports the addition and removal of storage devices for virtual machines while they are running. In this video, Gordon Ryan walks through the process of creating a new virtual machine then adding in a new virtual hard disk, then removing it while the virtual machine is running.

How Do I: Configure Keywords and Best Bets?

Thu, 14 May 2009 19:14:57 -0700

In this video, Hilton Giesenow from The Moss Show (http://www.TheMossShow.com/) examines how to enhance the standard Microsoft Office SharePoint Server search results to include additional rich contextual information related to the search. The video covers both the Keywords functionality, which includes descriptions and additional information related to the search term, as well as "Best Bets" - a suggested list of relevant links.

How Do I: Use the Business Data Catalog?

Mon, 18 May 2009 13:51:55 -0700

The Business Data Catalog (BDC) functionality in Microsoft Office SharePoint Server 2007 enables you to present line-of-business data within MOSS. In this video, Rob Windsor will demonstrate how to configure a BDC Application and how to use external data with Web Parts, Lists and Enterprise Search.

How Do I: Configure Single Sign On (SSO)?

Wed, 24 Jun 2009 00:52:38 +0530

In this video, Hilton Giesenow, host of The Moss Show (http://www.TheMossShow.com/) demonstrates how to configure Microsoft Single Sign On for use within Microsoft Office SharePoint Server 2007 in order to connect to a SQL Server database over a BDC connection using SQL Server credentials.

How Do I: Install and Configure the Faceted Search Add-in?

Wed, 24 Jun 2009 01:10:35 +0530

Faceted Search is a freely-available community add-in for Microsoft Office SharePoint Server, developed in conjunction with Microsoft employees and members of the community. Available at http://facetedsearch.codeplex.com/, Faceted Search is a freely-available community add-in for Microsoft Office SharePoint Server 2007 search user experience with richer abilities to refine search results. Join Hilton Giesenow (http://www.TheMossShow.com/) as he looks into installing and setting up this set of tools.

How Do I: Configure the Active Directory Profile Import Service?

Wed, 24 Jun 2009 01:24:44 +0530

Microsoft Office SharePoint Server 2007 allows you, through the Shared Services Provider, to configure the importing of Active Directory user profiles into SharePoint Server. This allows for a far richer experience of displaying and updating user profiles including features like the ability to track colleagues and display the user’s relative position in the organisational hierarchy. Hilton Giesenow (http://www.TheMossShow.com/) takes us through how to set up and configure this AD profile import service to bring this data in from Active Directory.

How Do I: Create a KPI List and KPI Dashboard?

Wed, 24 Jun 2009 21:54:00 +0530

Join, Hilton Giesenow, host of The Moss Show (http://www.TheMossShow.com/) as he explores how to create a Key Performance Indicator (KPI) list in Microsoft Office SharePoint Server 2007. In the video, we explore how to create various types of KPIs (manual, based on SharePoint lists, and based on an Excel workbook in an Excel Services Trusted Location) and how to create a KPI dashboard based on the list of KPIs.

How Do I: Create and Configure a Business Data Catalog?

Wed, 24 Jun 2009 21:43:27 +0530

This video shows how to integrate data external to Microsoft Office SharePoint Server 2007 by building a Business Data Catalog.

How Do I: Add Forms-Based to an existing Windows Authentication Site?

Wed, 20 May 2009 15:16:13 -0700

Windows SharePoint Services allows you to combine multiple authentication and user management systems in the same web application, each with their own unique URL. This allows you, for instance, to have an internal- and external-facing Intranet , or even an Extranet running within the same site collection. In this video, Hilton Giesenow (http://hilton.giesenow.com) takes you through adding Forms-Based Authentication (FBA) to an existing Windows-based authentication WSS site. My site: http://www.TheMossShow.com/

How Do I: Administer My SharePoint Farm Using Windows PowerShell?

Wed, 20 May 2009 23:29:51 -0700

PowerShell is Microsoft’s next generation, administrator-focused command-line scripting environment. Providing for full access to the SharePoint API, PowerShell unlocks the potential to interact directly with SharePoint to manipulate web applications, site collections, sites, lists and more. In addition, the ability to script these commands and compile a toolbox of these scripts makes for an improved experience in administering Windows SharePoint Server. In this video, Hilton Giesenow (http://hilton.giesenow.com/) looks at how to get started with PowerShell and SharePoint, and takes us through a few sample site collection, list and web application commands. My site: http://www.TheMossShow.com/

How Do I: Work With Solutions Packages?

Tue, 23 Jun 2009 14:46:13 +0530

Solution Packages are SharePoint preferred mode of deploying functionality and components, including, for instance, Web Parts, Features, and Web Services. There are a few steps required to install and deploy these packages though, and that’s just part of the story. In this video, Hilton Giesenow from The Moss Show (http://www.TheMossShow.com/) takes a look at how to deploy, amend and upgrade solution packages, including upgrading functionality and adding language packs.

How Do I: Use Master Pages to Customize the Look and Feel of my Site?

Tue, 23 Jun 2009 14:46:37 +0530

Master Page files allow you to customize the look and feel of a Windows SharePoint Services site in a standardized, centralized way. In this video, Hilton Giesenow from The Moss Show (http://www.TheMossShow.com/) has a look at how to customize the existing Master Pages in a site, use both Default and Custom master page options, and import an external Master Page and related graphics and style for use in your site.

How Do I: Migrate a Content Database?

Tue, 23 Jun 2009 14:46:55 +0530

In this video Hilton Giesenow (http://www.TheMossShow.com/) takes us step by step through the process of migrating a content database from one SQL Server (or instance) to another.

How Do I: Install Windows SharePoint Services on Windows Vista?

Tue, 23 Jun 2009 14:47:14 +0530

In this video Mark Wilson shows you how to install Windows SharePoint Services on Windows Vista. Whilst this is not a supported configuration, it is something that can be very useful to SharePoint developers, perhaps working offline, and can be a useful trick to have up your sleeve.

How Do I: Migrate the Configuration Database ?

Tue, 23 Jun 2009 14:47:40 +0530

In this video Hilton Giesenow (http://www.TheMossShow.com/) takes us step by step through the process of migrating a configuration database from one SQL Server (or SQL instance) to another.

How Do I: Integrate My SharePoint Lists with the Microsoft Office Outlook Client?

Wed, 24 Jun 2009 02:00:12 +0530

Windows SharePoint Services provides for very powerful integration between the Microsoft Office Outlook client and Windows SharePoint Services, enabling users to reuse their existing skills within Outlook, providing offline storage and synchronisation, and adding additional business value. In this video, Hilton Giesenow from The Moss Show (http://www.TheMossShow.com/) explores how to configure this integration, use the additional features, and resolve synchronisation conflicts.

How Do I: Work with Document Templates?

Wed, 24 Jun 2009 23:37:02 +0530

Rather than work with a standard, blank Word, Excel or PowerPoint template off the “New” button in a document library in Windows SharePoint Services,wouldn’t you rather offer your users the ability to create new documents using a more customized company template? Better yet, why not offer multiple predefined templates in the same library, perhaps with a specific set of metadata fields? Join Hilton Giesenow, host of The Moss Show (http://www.TheMossShow.com/) as he explores various ways to customize the templates used in a document library, within a site, or across an entire site collection.

How Do I: Use the SPDiag Tool to Analyze my SharePoint Farm?

Tue, 7 Jul 2009 18:55:24 +0530

Part of the latest SharePoint Administration Toolkit from Microsoft, the SharePoint Diagnostic (SPDiag) tool provides a wealth of information of all kinds across the entire server farm, offering both static and trend analysis and reporting as well as real-time details to assist in analysis, planning and problem avoidance and resolution. In this video Hilton Giesenow (http://www.TheMossShow.com/) takes us through downloading, installing and setting configuring the tool, and looks at how to use some of its features.

How Do I: Install and Configure the Microsoft Application Virtualization 4.5 Client on Workstations and Terminal Servers?

Tue, 19 May 2009 10:45:44 -0700

Microsoft Application Virtualization 4.5 can save administrators money by reducing the management overhead associated with application deployment and maintenance. In this video, Gordon Ryan demonstrates how to install the Application Virtualization client software in Terminal Server and desktop environments and how to use group policy to configure the clients.

How Do I: Configure the Virtual machine Manager 2008 self service portal to enable users to create their own virtual machines?

Thu, 28 May 2009 00:25:52 +0530

The VMM Self-Service Portal is an optional, Web-based component that a VMM administrator can install and configure to allow users to create and manage their own virtual machines within a controlled environment on a limited group of virtual machine hosts. In this video, Gordon Ryan shows how to create and configure a new self service user role, then create a new virtual machine using the self service portal.

How Do I: Back up Hyper-V with System Center Data Protection Manager?

Wed, 3 Jun 2009 23:58:03 +0530

With virtualised workloads, data backup and recovery becomes even more critical. In this video Mark Wilson takes a look at using System Center Data Protection Manager 2007 SP1 to back up a Hyper-V host.

How Do I: Create a cluster on Hyper-V?

Thu, 18 Jun 2009 15:35:52 +0530

Not all virtualisation deployments run on huge farms of clustered servers. In this video, Mark Wilson shows how to create a failover cluster for high availability with both nodes running virtualised on Hyper-V.

How Do I: Backup Hyper-V with Windows Server Backup?

Mon, 22 Jun 2009 02:16:41 +0530

With virtualised workloads, data backup and recovery becomes even more critical. Whilst large companies can use products such as System Center Data Protection Manager to back up multiple servers, that may not always be appropriate for and, in this video, Mark Wilson takes a look at backing up a Hyper-V deployment using the Windows Server Backup utility provided with Windows Server 2008.

How Do I: Install and configure the Microsoft Enterprise Desktop Virtualization 1.0 Management console and client?

Fri, 26 Jun 2009 17:41:29 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the second of a 5 part series, Gordon Ryan shows how to install and configure the MEDV management console on Windows Vista. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Install and configure the Microsoft Enterprise Desktop Virtualization 1.0 Management Server?

Fri, 26 Jun 2009 17:46:08 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the first of a 5 part series, Gordon Ryan shows how to install and configure the MEDV management server. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Create a policy with Microsoft Enterprise Desktop Virtualization to deploy IE6 for an intranet site?

Wed, 8 Jul 2009 00:05:44 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the last of a 5 part series, Gordon Ryan shows how to create a policy that will invoke a virtualized instance of Internet Explorer 6 when a user visits a specific URL. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Deploy a Windows XP virtual machine with Microsoft Enterprise Desktop Virtualization 1.0?

Sat, 18 Jul 2009 01:25:50 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the fourth in a 5 part series, Gordon Ryan shows how to deploy a Windows XP virtual machine using MEDV. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Build and prepare a Windows XP virtual machine image for use with Microsoft Enterprise Desktop Virtualization 1.0?

Sat, 1 Aug 2009 03:19:25 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the third in a 5 part series, Gordon Ryan shows how to build and prepare a Windows XP virtual machine that will be deployed to MEDV clients. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Use the Database Engine Tuning Advisor

Wed, 6 May 2009 12:02:28 -0700

For many database administrators ensuring top performance is a large part of their job. By using the Database Engine Tuning Advisor the database any workload can be analyzed for changes to the database that will increase performance. By taking advantage of the database engine tuning advisor, administrators can reduce the amount of time they spend analyzing the database to increase performance. In this video Scott Golightly shows how to use a SQL script as the input to the database engine tuning advisor to determine how to increase performance in certain tables in the Adventure works sample database.

How Do I: Use PowerShell to Audit Servers?

Wed, 6 May 2009 17:21:37 -0700

Most DBAs spend a portion of their day reviewing servers looking for errors and potential problems. Windows PowerShell offers the ability to automate some of those tasks freeing the DBA to perform other duties. In this video Scott Golightly will show how to use PowerShell to automate reviewing log files and checking SQL Server properties.

How Do I: Use PowerShell to Transfer Data?

Wed, 3 Jun 2009 02:10:39 +0530

PowerShell can be used to export or import data. By creating a simple script you can easily move data between databases. This can be given to developers or testers to allow them to refresh data in their systems.

How Do I: Block Connections to SQL Server By IP Address Using Logon Triggers?

Wed, 3 Jun 2009 02:10:39 +0530

This video shows how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address. This demo shows how to: - Retrieve the IP Address of the client using the EVENTDATA() - Use a Logon Trigger to restrict access to a SQL Server instance

How Do I: Configure Database Mail in SQL Server 2008?

Fri, 5 Jun 2009 14:11:12 -0700

Database Mail is useful for sending e-mail to administrators and end users. Database mail can contain data from queries or from files or other resources on your network. In this video Scott Golightly shows how to configure Database Mail in SQL Server 2008. After setting up Database Mail we see how to test the mail and view the mail log.

How Do I: Import Data from Oracle Databases?

Wed, 10 Jun 2009 22:23:17 +0530

Many organizations have both Oracle and SQL Server databases. In this video Scott Golightly shows how easy it is to use the import data wizard and SQL Server Integration Services to import data from a table in an Oracle database into SQL Server.

How Do I: Use the Service Audit Object in SQL Server 2008?

Wed, 10 Jun 2009 22:35:13 +0530

This video shows how to use the Service Audit Object to record events within SQL Server 2008 Enterprise Edition. This demo shows how to: - Create a Server Audit Object - Create a Server Audit Specification - Create a Database Audit Specification - Examine the audit logs for Login Failed events

How Do I: Use the Row Value Constructor to insert data into a SQL Server 2008 table?

Thu, 11 Jun 2009 01:49:16 +0530

This video shows how to insert data into a SQL Server 2008 table using the Row Value Constructor. This demo shows how to: - Insert data into a SQL Server 2008 table - Four different methods are used to insert bulk data, including the new Data Row Constructor

How Do I: Import Text Files with SQL Server Integration Services?

Thu, 18 Jun 2009 01:52:07 +0530

Many programs produce logs as plain text files. Sometimes these log files need to be imported into SQL Server to allow further analysis of the data. In this video Scott Golightly shows how to use SQL Server Integration Services to import text files into SQL Server

How Do I: Profile Data with the Data Profiling Task and Viewer

Thu, 18 Jun 2009 17:59:34 -0700

Data quality is important to every business. Using the SQL Server 2008 Data Profiling task computes statistics about the data in a database to spot incorrect values. The Data Profiling viewer allows you to view the generated statistics. In this video Scott Golightly shows how to create the data profile and how to review the results.

How Do I: Using the HierarchyID Data Type in SQL Server 2008 to manage data hierarchies?

Sat, 20 Jun 2009 00:50:46 +0530

Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is complex and often onerous. The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues. In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to: - Create tables that implement this datatype - Populate the table with data using CTE - Query the table using some of the inherent functions available for the HierarchyID Datatype.

How Do I: Create a group policy to manage Windows Mobile devices with System Center Mobile Device Manager 2008?

Wed, 17 Jun 2009 04:34:55 +0530

Microsoft System Center Mobile Device Manager 2008 provides IT Pros with a powerful set of tools for managing the Windows Mobile devices in their enterprise. In this video, Gordon Ryan shows you how to create a group policy object that can be used to manage the features of Windows Mobile devices and then how to force an update of the policy settings on a mobile device.

How Do I: Enroll a Windows Mobile Device using Microsoft System Center Mobile Device Manager?

Wed, 17 Jun 2009 04:43:26 +0530

Windows Mobile devices have become a standard component in the information workers arsenal today, but as an network administrator, they can pose a number of challenges when it comes to management and security. Microsoft System Center Mobile Device Manager 2008 lets IT Pros manage Windows Mobile devices in the same way they manage windows PCs. In this video, Gordon Ryan demonstrates how to pre-enroll a device and then from the device, enroll it in the domain.

How Do I: Use powershell to manage Windows Mobile devices with Microsoft System Center Mobile Device Manager 2008?

Thu, 18 Jun 2009 02:21:35 +0530

How Do I: Deploying and Managing Windows Internet Explorer 8?

Wed, 17 Jun 2009 00:41:09 -0700

In this video, Kyle Rosenthal shows you how to use the IEAK 8 Internet Explorer Customization Wizard to create a custom installation of Internet Explorer 8 ready for deployment to your corporate environment.

How Do I: Manage the Forefront Server Security for SharePoint Quarantine and Incidents Databases?

Wed, 17 Jun 2009 09:50:06 -0700

In this video, Gordon Ryan shows how to manage the incident and quarantine databases in Forefront Security for SharePoint. He walks through the process of exporting and moving the database files as well as taking files out of quarantine.

How Do I: Backup Hyper-V with Windows Server Backup

Mon, 22 Jun 2009 03:49:04 +0530

How Do I: Setup and Verify a Domain

Tue, 2 Jun 2009 12:11:21 -0700

This video shows how to complete the steps required to add and verify a domain in Microsoft Online Services This demo shows how to: - Add a domain to Microsoft Online Services - Add a CNAME alias to the domain within a domain registrar account - Run the Domain Verification Wizard within Microsoft Online Services

How Do I: Create a Trial Microsoft Online Services Account

Tue, 2 Jun 2009 23:39:56 -0700

This video shows how to create a trial Business Productivity Online Suite account with Microsoft Online Services This demo shows how to: - Create a Live ID account - Use the LiveID to create a trial MOS account - How to select the Business Productivity Online Suite as the trial product - How to login to the MOS Admin portal after activating the trial account

How Do I: Enable Incoming Email by Creating an MX Record

Thu, 25 Jun 2009 17:29:44 +0530

This video shows how to create an MX record to enable inbound email within Microsoft Online Services This demo shows how to: - Run the Enable inbound email wizard - Set a domain as an authoritative domain within Microsoft Online Services - Create and MX Record

How Do I: Convert Trial Account to Paid Subscription of BPOS

Tue, 7 Jul 2009 18:33:06 +0530

This video shows how to convert a trial account of the Microsoft Online Business Productivity Suite to a paid subscription.

How Do I: Provison a SharePoint Site Collection with Microsoft Online Services

Tue, 14 Jul 2009 19:29:29 +0530

This video shows how to create a new SharePoint site collection using SharePoint Online, part of Microsoft Online Services This demo shows how to: - Find the SharePoint Online administration page within MOS - Create a new SharePoint Site collection - Choose a site template - Allocate space to the site collection

How Do I: Add Users to SharePoint Site Collection in MOS and Configure Security

Tue, 14 Jul 2009 19:31:36 +0530

This video shows how to add users and configure their security settings within Microsoft Online Services' SharePoint Online. This demo shows how to: - Access the SharePoint Online Site Settings website - Add users using the browse function - Add users using the check names function - Configure user security settings for a site collection

How Do I: Get Started with xPerf and xPerfview to Analyze Server Performance?

Mon, 18 May 2009 18:38:20 -0700

This video shows you how to use xPerf to capture User and kernel events on your server while running your application, and how to visually analyze these events using xPerfview. You will be able to see how your application utilizes CPU, and disk, and memory, and network to find out any performance issues with these easy-to-use powerful tools.

How Do I: Use VRTA and Netmon to Check my Website’s Performance?

Wed, 1 Jul 2009 19:16:16 +0530

This video shows you how to use Virtual Roundtrip Analyzer to check performance of your website or web application, and how to trace frames in Network Monitor so you can see what is going on in the network layer when you send a request, and get the response back from the server.

How Do I: Build and prepare a Windows XP virtual machine image for use with Microsoft Enterprise Desktop Virtualization 1.0?

Sat, 1 Aug 2009 03:28:00 +0530

Is your Windows Vista deployment being blocked by a custom application that won't run on a newer operating system? Microsoft Enterprise Desktop Virtualization 1.0 might be what you have been looking for. In this the third in a 5 part series, Gordon Ryan shows how to build and prepare a Windows XP virtual machine that will be deployed to MEDV clients. In this series he will show how to configure MEDV so that when users access an intranet web site it will load in IE6 within a Virtual XP image.

How Do I: Import Text Files with SQL Server Integration Services?

Tue, 23 Jun 2009 00:31:00 +0530

How Do I: Using the HierarchyID Data Type in SQL Server 2008 to manage data hierarchies?

Tue, 23 Jun 2009 00:16:46 +0530

Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is complex and often onerous. The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues. In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to:
-Create tables that implement this datatype
-Populate the table with data using CTE
-Query the table using some of the inherent functions available for the HierarchyID Datatype

How Do I: Profile Data with the Data Profiling Task and Viewer?

Fri, 19 Jun 2009 12:36:24 -0700

Create and Use Accelerators Accelerators

Fri, 1 May 2009 23:06:03 -0700

In this video, Matt Hester demonstrates Internet Explorer 8's Accelerators - technology that allows users to access services from another web site without the need to navigate away from their current page. The video will show how to create and use Accelerators.

How Do I: Configure Database Mail in SQL Server 2008?

Fri, 19 Jun 2009 12:48:00 -0700

InPrivate Browsing

Mon, 22 Jun 2009 23:10:19 -0700

In this video, Matt Hester demonstrates Internet Explorer 8's support InPrivate Browsing mode and discusses the impact on your users' experience for your website and how to work with InPrivate Browsing mode.

How Do I: Use the Filestream Data Type to Store BLOB Data

Wed, 13 May 2009 23:00:47 -0700

In this video Scott Golightly shows how to configure Windows and SQL Server to enable the Filestream data type. After configuring SQL Server to support the Filestream, Scott creates a new database and table that uses the Filestream data type. The Filestream data type is new in SQL Server 2008 and enables storing binary large object (BLOB) data like pictures and music as a file on a share to efficiently store the data while treating it as an integral part of the database so backup and restore operations include the Filestream data as well. Filestream allows SQL Server to efficiently manage the rich data that today's applications demand.

HTML 5 Networking Events

Mon, 13 Apr 2009 22:43:59 -0700

In this video, Matt Hester demonstrates Internet Explorer 8’s new support for the networking events, from the W3C’s HTML 5 working draft, including the onHashChange, onOnline, and onOffline events.

How Do I: Increased Security Using XDR

Mon, 13 Apr 2009 22:33:26 -0700

In this video, Matt Hester demonstrates Internet Explorer 8's support for Cross Domain Requests to secure your mashups. This offers a safe and reliable way for developers to connect anonymously to remote servers in order to exchange data while guarding against cross-site scripting attacks.

How Do I: Authenticated RSS Feeds.

Thu, 7 May 2009 22:30:27 -0700

In this video, Matt Hester shows Internet Explorer 8's full support for authenticated RSS feeds.

How Do I: Create a cluster on Hyper-V?

Fri, 19 Jun 2009 23:21:57 +0530

How Do I - Deploying and Managing Windows Internet Explorer 8?

Wed, 17 Jun 2009 23:11:20 -0700

How Do I: Block Connections to SQL Server By IP Address Using Logon Triggers?

Thu, 18 Jun 2009 03:36:09 +0530

This video shows how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address
This demo shows how to:
- Retrieve the IP Address of the client using the EVENTDATA() function
- Use a Logon Trigger to restrict access to a SQL Server instance

How Do I: Configure the Virtual machine Manager 2008 self service portal to enable users to create their own virtual machines?

Thu, 18 Jun 2009 03:11:26 +0530

How Do I: Import Data from Oracle Databases?

Wed, 17 Jun 2009 22:57:28 +0530

How Do I: Use the Row Value Constructor to insert data into a SQL Server 2008 table?

Wed, 17 Jun 2009 00:51:19 +0530

This video shows how to insert data into a SQL Server 2008 table using the Row Value Constructor This demo shows how to: - Insert data into a SQL Server 2008 table - Four different methods are used to insert bulk data, including the new Data Row Constructor

How Do I: Use the Service Audit Object in SQL Server 2008?

Wed, 17 Jun 2009 00:22:01 +0530

This video shows how to use the Service Audit Object to record events within SQL Server 2008 Enterprise Edition This demo shows how to: - Create a Server Audit Object - Create a Server Audit Specification - Create a Database Audit Specification - Examine the audit logs for Login Failed events

How Do I: Use PowerShell to Transfer Data?

Fri, 5 Jun 2009 09:09:56 +0530

How Do I: Install and Configure the Microsoft Application Virtualization 4.5 Client on Workstations and Terminal Servers?

Fri, 22 May 2009 12:52:20 -0700

Migrating from Windows XP to Windows 7

Fri, 22 May 2009 12:39:44 -0700

Learn how to use the User State Migration Tool (USMT) to migrate user files and settings from Windows XP to Windows 7 using a default installation.

Sequence an application and Deploy it using Microsoft Application Virtualization 4.5

Fri, 22 May 2009 12:22:45 -0700

Microsoft Application Virtualization 4.5 can save administrators money by reducing the management overhead associated with application deployment and maintenance. In this video Gordon Ryan shows how to install the application sequencer which is used to package applications for delivery with Application Virtualization and then he sequences a small application and deploys it to a client.

How Do I: Administer My SharePoint Farm Using Windows PowerShell?

Fri, 22 May 2009 12:11:13 -0700

How Do I: Add Forms-Based to an existing Windows Authentication Site?

Wed, 20 May 2009 15:16:13 -0700

Microsoft Assessment and Planning Toolkit for Hyper-V Virtualization Planning

Thu, 26 Mar 2009 11:55:50 -0700

Use the Microsoft Assessment and Planning (MAP) Toolkit to determine server consolidation candidates with Hyper-V virtualization.

How Do I: Install Microsoft System Center Virtual Machine Manager 2008?

Wed, 25 Mar 2009 13:48:27 -0700

With the ability to manage virtualization hosts running Microsoft Hyper-V and Virtual Server as well as VMWare servers, Microsoft System Center Virtual Machine Manager 2008 provides IT Pros with a cost effective single solution for both homogenous and heterogeneous virtualization environments. In this video, Gordon Ryan takes you through the initial installation of the Virtual Machine Manager Server, console and Self Service portal.

User State Migration Tool

Tue, 17 Mar 2009 14:09:06 -0700

The User State Migration Tool (USMT) for Windows 7 is now part of the Windows Automated Installation Kit (AIK) and provides fast and flexible options to migrate user profiles and data from one operating system to another. Explore how the new Hard-Link Migration feature highlighted in his demonstration can dramatically reduce migration time for in-place operating system migration or computer refresh scenarios.

Windows Troubleshooting Platform

Tue, 17 Mar 2009 14:04:38 -0700

The Windows Troubleshooting Platform can reduce calls to the help desk by diagnosing and resolving common issues, and by providing built-in troubleshooters for several different types of problems including audio, video, and networking. Learn how to develop custom Windows Troubleshooting Packs using Windows PowerShell to help resolve issues commonly encountered in your environment.

User Account Control

Tue, 17 Mar 2009 14:06:10 -0700

User Account Control (UAC) was introduced in Windows Vista to help increase security and improve total cost of ownership by enabling the operating system to be deployed without administrative privileges. See how Windows 7 continues the investment in UAC with changes that enhance the user experience and put users in greater control of their prompting experience. For example, the number of operating system applications and tasks that require elevation is reduced, so standard users can do more than before and will see fewer elevation prompts.

DirectAccess

Tue, 17 Mar 2009 14:07:03 -0700

DirectAccess enables remote users to access the corporate network anytime they have an Internet connection, without the extra step of initiating a virtual private networking (VPN) connection. Find out how to use DirectAccess to provide a more secure and flexible corporate network infrastructure in which computers on and off the network can remain healthy, managed, and updated.

BranchCache

Tue, 17 Mar 2009 14:07:40 -0700

The introduction of BranchCache in Windows 7 is the next step to improving end user productivity in branch offices. BranchCache caches content from remote file and Web servers in the branch location so that users can more quickly access this information. The cache can be hosted centrally on a server in the branch location, or can be distributed across user PCs.

How Do I: Fully utilize IIS Compression for my site?

Fri, 13 Mar 2009 10:27:12 -0700

It's too easy to configure wrong IIS compression on an IIS 6.0 server. This walkthrough shows how to properly configure compression for your site and verify those changes. The results can improve the performance of your site.

How Do I: Deploy Office 2007?

Tue, 10 Mar 2009 12:35:07 -0700

In this video, Kyle Rosenthal steps through preparing to deploy Office 2007. He examines the new xml files that control installations and looks at how to use the Microsoft Deployment Toolkit and Configuration Manager to be able to automate the deployment.

How Do I: Configure Forefront Server Security for Sharepoint to Block Uploading and Downloading of Specific File Types?

Tue, 10 Mar 2009 12:33:15 -0700

As users embrace Sharepoint, IT Pros need to be able control the type of files that they are uploading. While Sharepoint provides the ability to block files based on their extension, Forefront Security for Sharepoint takes this one step further and inspects the file headers so that renaming a file won't allow a user to bypass the blocks. In this video, Gordon Ryan shows you how to configure file blocking in Forefront Security for Sharepoint.

How Do I: Configure Quota Management?

Tue, 10 Mar 2009 12:32:27 -0700

Quotas allow for the management capacity planning of site content in Windows SharePoint Services. In this video, join Hilton Giesenow as he explores how to configure Quota Templates and use these within existing and new site collections. The video also examines the use of locking as well as Blocked File Types.

How Do I: Configure Records Center?

Tue, 10 Mar 2009 12:31:36 -0700

Join Hilton Giesenow as he explores how to create a Records Center site within your site collection and how to configure the records management types and record routing for your SharePoint farm.

How Do I: Setup a Template in Virtual Machine Manager 2008 and Reduce the Time Taken to Deploy New Virtual Machines?

Mon, 9 Mar 2009 12:30:12 -0700

System Center Virtual Machine Manager 2008 lets administrators and users setup virtual machine templates that allow for faster deployment of virtual machines within your environment. In this video Gordon Ryan shows you how to setup an Operating System and Hardware profile and then use those to create a virtual machine template.

How Do I: Add a Perimeter Virtual Machine Host to System Center Virtual Machine Manager 2008?

Thu, 5 Mar 2009 15:33:57 -0800

With the ability to manage a virtual machine host that is located in a perimeter network using only 2 ports, System Center Virtual Machine Manager is ideal for secure environments. Gordon Ryan shows you the two part process of adding a perimeter host in System Center Virtual Machine Manager.

How Do I: Add a Virtual Machine Host to System Center Virtual Machine Manager 2008?

Thu, 5 Mar 2009 15:33:16 -0800

With support for Virtual machine hosts running Hyper-V, Virtual Server or VMware ESX Server, Microsoft System Center Virtual Machine Manager 2008 provides IT Pros with a single heterogeneous management solution. In this video Gordon Ryan shows you how to deploy the Virtual Machine Manager agent to domain joined servers running Windows Server 2003, Windows Server 2008 and Hyper-V Server.

How Do I: Use System Center Virtual Machine Manager 2008 to Migrate a Virtual Server Virtual Machine to Hyper-V?

Thu, 5 Mar 2009 15:32:28 -0800

Have you got virtual machines running on Virtual Server 2005 and you would really prefer they were on your shiny new Hyper-V server instead? Well step this way and watch as Gordon Ryan shows you how to use System Center Virtual Machine Manager 2008 to quickly and easily migrate your virtual machines.

How Do I: Install and Configure Microsoft Hyper-V Server 2008?

Thu, 5 Mar 2009 15:31:53 -0800

Microsoft Hyper-V Server provides the ideal platform for server consolidation, test and development scenarios. In this video, Gordon Ryan, takes you through the installation and initial configuration of a Hyper-V server using both the local tools on the server and remotely from a full Windows Server installation.

How Do I: Use System Center Virtual Machine Manager 2008 to Convert a Physical Server to a Virtual Server?

Thu, 5 Mar 2009 15:30:49 -0800

Spending too much money on your power bills? Why not virtualize some of your older servers? Too hard, too much effort you say? Not with System Center Virtual Machine Manager 2008! Gordon Ryan shows you how you are a wizard away from turning that physical box into a virtual machine!

How Do I: Publish a Dynamic Excel Workbook File to Excel Services?

Thu, 5 Mar 2009 15:27:02 -0800

This video shows how to publish an Excel that includes data from a SQL Server database file to Excel Services The result is a dynamic workbook that resides within Excel Services. This demo shows how to: setup a trusted data connection in SharePoint Administration, read data from SQL Server into Excel and export a Data Connection file to a SharePoint Data Connection Library.

How Do I: Configure Security Policies on my Windows Mobile Devices Using Exchange 2007?

Thu, 5 Mar 2009 15:24:56 -0800

With more users carrying smart phones, the possibilities of sensitive data being compromised as a result of a device being lost is a growing concern for IT Pros. Exchange 2007 provides a no cost option for securing Windows Mobile devices through the use of Active Sync Policies. In this video Gordon Ryan steps through the process the of creating a policy and assigning it to a user.

Configure a Report Portal in SSRS

Thu, 5 Mar 2009 15:23:15 -0800

This video shows how configure a SSRS report portal from scratch. This demo shows how to: setup a Report URL, define an execution account, create a Reports Server database, configure SMTP and more...

Create and Publish a Data Cube for SQL Server Analysis Server 2008

Tue, 17 Feb 2009 16:37:22 -0800

This video shows how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008. This demo shows how to: use BIDS to create a data model project, create Data Sources, Data Views, Dimenions, and Cubes and how to Deploy the project to SSAS 2208.

Remotely Wipe a Windows Mobile Device if an Employee Loses it

Tue, 17 Feb 2009 16:29:04 -0800

Employees' losing mobile devices is a concern for any IT Pro, but with Exchange 2007 and Windows Mobile 6, you remote wipe a lost device and know that the data has been removed. In this video, Gordon Ryan shows you how to do this using Outlook Web Access and the Exchange graphical and Powershell administration tools.

Springboard Series Virtual Roundtable: Windows 7 - To the Beta and Beyond

Tue, 17 Feb 2009 16:27:40 -0800

Watch as Mark Russinovich and a panel of subject matter experts discuss what's in store for IT pros with Windows 7. Learn about the evolution of features like Group Policy, BitLocker To Go, DirectAccess, BranchCache, and AppLocker then get tips on troubleshooting, deployment, and application compatibility.

Windows Vista in Midize Business (Overview)

Tue, 17 Feb 2009 16:26:57 -0800

In this video, Kyle Rosenthal discusses some of the drivers and benefits to implementing Windows Vista in a midsize business environment.He discusses the benefits regarding mobility, desktop optimization, search, security, and compliance.

Windows Vista: Total Cost of Ownership Benefits

Tue, 17 Feb 2009 16:26:13 -0800

In this video, Kyle Rosenthal discusses some of the benefits of deploying Windows Vista with regard to total cost of ownership (TCO). Topics discussed include the benefits of a single image, the new Windows Vista Backup and Restore Center, and new and improved deployment and management tools.

A Day in the Life: Windows Vista Productivity

Tue, 17 Feb 2009 16:25:26 -0800

In this video, Kyle Rosenthal takes you on a journey through the tools that you will use as an administrator on a daily basis to improve your productivity on a Windows Vista machine. Learn about the new integrated search, Windows Aero, sidebar gadgets, Group Policy tools, and more.

A Day in the Life: Windows Vista Security

Tue, 17 Feb 2009 16:23:50 -0800

In this video, Kyle Rosenthal takes you on a journey through the tools that you will use as an administrator on a daily basis to manage and configure the security of a Windows Vista machine, such as Windows Firewall and Windows Defender.

A Day in the Life: Windows Vista Management

Tue, 17 Feb 2009 16:22:58 -0800

In this video, Kyle Rosenthal takes you on a journey through the tools that you will use as an administrator on a daily basis to manage a Windows Vista machine. He examines tools such as the new Event Viewer, the Reliability Monitor, and power management tools.

Advanced Sequencing with Microsoft App-V

Tue, 17 Feb 2009 16:21:59 -0800

Learn how to use Microsoft Application Virtualization (App-V) sequencing tools to sequence non-standard applications. In this video, Kyle Rosenthal will demonstrate how to sequence an application that has a hard-coded drive letter and also how to install applications that are "add-ins" for other applications.

Modifying Boot Records in Windows Vista and Windows Server 2008 Using BCDEDIT

Mon, 16 Feb 2009 11:00:37 -0800

In this video, Kyle Rosenthal steps through the new boot configuration tool: BCDEDIT. He will demonstrate how to view boot records, create new entries, modify settings, and export for back up the Boot Configuration Data (BCD) store.

Windows Vista Tips and Tricks: Part 2

Mon, 16 Feb 2009 10:59:29 -0800

In this video, Kyle Rosenthal shows you some tips and tricks for managing, maintaining, and supporting Windows Vista. Although this video is aimed at the IT professional, anyone using Windows Vista will get something out of it!

Windows Vista Tips and Tricks: Part 1

Mon, 16 Feb 2009 10:58:48 -0800

Creating and Configuring Events Centrally

Mon, 16 Feb 2009 10:58:02 -0800

In this video, Kyle Rosenthal demonstrates the power of the new event subscription tool in Windows Vista and Windows Server 2008. He also examines the customizable views in the new event viewer and creates his own errors using a command line - all of which you could apply to trigger tasks in your own enterprise.

Configuring Windows Deployment Services

Mon, 16 Feb 2009 10:52:21 -0800

In this video, Kyle Rosenthal shows you how to configure Windows Deployment Services for use in your environment. He discusses the basics of adding deployment and capture images as well as how to pre-stage machines for easy deployment of images in your enterprise.

Updating and Upgrading a Sequenced Application Using Microsoft App-V

Tue, 10 Feb 2009 17:55:11 -0800

Learn how to use the Microsoft Application Virtualization (App-V) Sequencer to update an existing package and publish the new version as an active upgrade.

Remote Management Using Windows Remote Management and Windows Remote Shell

Tue, 10 Feb 2009 17:54:19 -0800

Learn how to use Windows Remote Management (WinRM) tools to query remote machines. In this video, Kyle Rosenthal walks you through the initial configuration steps and practical uses for the command line tool. He also looks at Windows Remote Shell (WinRS), which allows administrators to run command-line commands as if they were sitting at a remote machine.

Configuring and Using Advanced Group Policy Management

Tue, 10 Feb 2009 17:53:08 -0800

In this video, Kyle Rosenthal shows you how to use the Advanced Group Policy Management tool contained in the Microsoft Desktop Optimization Pack (MDOP). He looks at the basic configurations for administrator access, controlling and comparing Group Policy objects (GPOs), and deleting and restoring versions of a GPO.

Using Group Policy in Windows Vista and Windows Server 2008

Tue, 10 Feb 2009 17:51:14 -0800

In this video, Kyle Rosenthal examines the improvements and changes in Group Policy management in Windows Vista and Windows Server 2008. He looks at the new format of Group Policy templates, the central store, and multiple local group policies, then drills down into device management using Group Policy.

Windows Vista in Small Business (Overview)

Tue, 10 Feb 2009 17:50:21 -0800

In this video, Kyle Rosenthal discusses some of the drivers and benefits to implementing Windows Vista in a small business environment.He discusses the benefits regarding connectivity, security, reliabity, and flexibility.

Windows Server 2008 Read Only Domain Controllers - Password Replication Policies

Wed, 11 Feb 2009 17:57:49 -0800

Read-only domain controllers (RODCs) are a new feature in Windows Server 2008 allowing domain controllers to be deployed in locations where security might otherwise be a concern (e.g. branch offices). In this video Mark Wilson takes a look at the password replication policies that are used to control credentials stored on RODCs.

Using MDOP Desktop Error Reporting

Fri, 6 Feb 2009 11:35:01 -0800

In this video, Kyle Rosenthal shows you how to use the Microsoft Diagnostics and Recovery Toolset (DaRT) DaRT to monitor and report crash and hang errors in your enterprise. He shows you how to enable client monitoring, implement the required Group Policy settings, examine monitoring options, and use the reporting system to identify issues in your network.

How Do I: Install Configure Microsoft Office SharePoint Server? (Part 1)

Wed, 4 Feb 2009 13:03:08 -0800

Join Hilton Giesenow as he demonstrates how to install the components of Microsoft Office SharePoint Server (MOSS). The video covers installation onto a SQL Server environment and using Active Directory for authentication. In this first part, we look at installing and configuring the MOSS instance and in the second part we will look at finishing the installation and configuring the farm.

How Do I: Install Configure Microsoft Office SharePoint Server? (Part 2)

Wed, 4 Feb 2009 13:04:50 -0800

Join Hilton Giesenow as he demonstrates how to install the components of Microsoft Office SharePoint Server (MOSS). This 2nd half of the series covers configuring the shared services on the server and creating and configuring a new Shared Services Provider as well as creating the first site collection in the new instance.

How Do I: Use Content Types?

Wed, 4 Feb 2009 10:33:47 -0800

Content types are designed to help users organize their SharePoint content in a more meaningful way. A content type is a reusable collection of settings you want to apply to a certain category of content. In this video, Rob Windsor will demonstrate how to use content types to define reusable list schemas, how to use content type inheritance, and how to associate multiple content types with a list or library.

How Do I: Manage Web Parts?

Wed, 4 Feb 2009 10:22:13 -0800

One of the most powerful set of features in Windows SharePoint Services is the ability to make use of Web Parts - the building blocks of web pages in WSS. This video looks at how to use the out-of-box WSS web parts and list web parts, how to manage these and new web parts, and how to install a new web part into the WSS farm in the form of a .wsp solution package.

How Do I: Configure Search Indexing?

Wed, 4 Feb 2009 13:05:25 -0800

In this video, Hilton Giesenow demonstrates how to configure search indexing settings in your Shared Services Provider to index the content of your MOSS web application. The video looks at using the Search site template and also at indexing external content, specifically a network file share.

Provide an Up-to-Date Data Warehouse with Change Data Capture

Tue, 20 Jan 2009 11:26:43 -0800

In this video Scott Golightly introduces us to the Change Data Capture feature of SQL Server 2008. After showing how to configure Change Data Capture on a database Scott shows a sample SSIS package that extracts the changed data from the database.

Automate Report Delivery in SQL Server Reporting Services Using Subscriptions

Tue, 20 Jan 2009 11:24:04 -0800

This video shows how to create report subscriptions to au This demo shows how to: configure a shared data source to store credentials (required for subscriptions), configure SSRS for SMTP email delivery, create a subscription that delivers reports to a file share and create a subscription that delivers reports via email.

Migrate Exchange Mailbox Content to Microsoft Online Services

Tue, 20 Jan 2009 11:21:29 -0800

This video shows how to migrate local Exchange Server mailbox content to Microsoft Online Services. This demo shows how to: activate synchronized MOS accounts, download and install the MOS Migration Tools and use the Migration Tools to move mailbox content.

Synchronize Active Directory with Microsoft Online Services

Tue, 20 Jan 2009 11:18:56 -0800

This video shows how to synchronize users in your local Active Directory with the Microsoft Online Services. This demo shows how to: download and install the MOS Directory Synchronization tool, synchronize Active Directory with MOS, edit an Active Directory user and synchronize with MOS and enable a synchronized account to use MOS.

Incoming E-mail Scan

Tue, 13 Jan 2009 17:56:15 -0800

Join Gordon Ryan as he shows how to configure Microsoft Forefront Security for Exchange Server to scan incoming and outgoing emails. In this video he shows how to configure file and keyword filters as well as configuring notifications.

Exchange Quarantined E-mails

Tue, 13 Jan 2009 17:55:37 -0800

Join Gordon Ryan as he shows how to manage emails and files that have been quarantined by Microsoft Forefront Security for Exchange Server. In this video he shows how to configure the security mode for messages delivered from quarantine, how to export the incident and the quarantine log files, how to redeliver messages and how to save attachments.

Exchange Message Scan

Tue, 13 Jan 2009 17:55:05 -0800

Join Gordon Ryan as he shows how to configure Microsoft Forefront Security for Exchange Server to scan messages that are in the store and as they are accessed. In this video he shows how to configure file filters, content filters and email notifications.

Exchange Remove Files

Tue, 13 Jan 2009 17:54:24 -0800

Join Gordon Ryan as he shows how to use Forefront Server Security for Exchange server to scan the existing messages within an Exchange mailbox store for specific files and then remove them. In this video he shows you how to configure a manual scan job to search for files of a particular type, generate reports for the files that would be removed and then to actually remove the files from the store and place them in the quarantine folder.

Forefront Management Console Part 3

Tue, 13 Jan 2009 17:52:48 -0800

The Microsoft Forefront Security Management Console provides Forefront administrators with a tool that allows them to centrally manage the Forefront server deployments within their environments. In this, the third video in this series, Gordon Ryan demonstrates how to configure alerting using the management console and discuses the use of filters to view the alerts.

Forefront Management Console Part 2

Tue, 13 Jan 2009 17:52:32 -0800

The Microsoft Forefront Security Management Console provides Forefront administrators with a tool that allows them to centrally manage the Forefront server deployments within their environments. In this, the second video in this series, Gordon Ryan demonstrates how to create a scheduled job to download AV signature updates, configure the general options for a server and to modify the operations settings for a group of Forefront servers to respond to a worm outbreak.

Forefront Management Console Part 1

Tue, 13 Jan 2009 17:52:00 -0800

The Microsoft Forefront Security Management Console provides Forefront administrators with a tool that allows them to centrally manage the Forefront server deployments within their environments. In the first video in this series, Gordon Ryan demonstrates how to install the console and then create a package to deploy Forefront Security for Exchange.

Setting up E-mail Co-Existence Between MOS and a Local Exchange Server

Tue, 13 Jan 2009 17:50:23 -0800

This video shows how to setup email co-existence between Microsoft Online Services and your local Exchange server. This demo shows how to: add your registered domain to MOS, verify domain ownership, setup domain as an external relay server for mail and verify email traffic between MOS and your Exchange server.

Setting up a Maintenance Plan to Backup Databases

Tue, 13 Jan 2009 17:47:46 -0800

In this video Scott Golightly shows us how to create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). Scott also shows how to customize plans that were created with the wizard.

Create and Modify Reports Using the Report Builder Tool

Tue, 13 Jan 2009 17:47:11 -0800

In this video Scott Golightly shows us how to use SQL Server 2008 Business Intelligence Studio to create a report model. We then use the report model and the Report Builder tool to create a report. The report is saved to the SQL Server Reporting Services reporting site where it can later be run or modified by other users who want a slightly different report.

NAT Hyper-V

Tue, 13 Jan 2009 17:46:16 -0800

In this video, Gordon Ryan shows how to install the Network Policy and Access Server role on Windows Server 2008 and configure it to use a wireless network adapter to provide internet access for virtual machines running using Hyper-V.

E-mail-Enabling a SharePoint List

Tue, 13 Jan 2009 17:45:20 -0800

Windows SharePoint Services allows you to configure many of your lists to be able to create new items directly via e-mail. In this video, Hilton Giesenow demonstrates how to enable these settings in your farm and to configure your lists to be able to receive e-mails.