LearnItFirst.com's New Videos Blog

C# Tutorial Video - 3 - Web Deployment Projects - Installing, Con figuring, and Deploying ASP.NET Websites with WDPs

2009-11-27T20:32:00.001-08:00

C# Video: 3 - Web Deployment Projects - Installing, Configuring, and Deploying ASP.NET Websites with WDPs

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

3 - Web Deployment Projects - Installing, Configuring, and Deploying ASP.NET Websites with WDPs

Description of this video:

Note: This video is from LearnItFirst.com's C# Programming with Visual Studio 2005 training course.

Web Deployment Projects (WDPs for short) are Scott Whigham's favorite way to deploy ASP.NET websites (Scott is the author of our Visual Studio videobooks). If you want to work with the full blown Visual Studio 2005 programming model and want to get the most out of your deployment options, then the WDPs are your best bet.

Highlights from this video:

How WDPs differe from WAPs
Pros and Cons of using the WDPs
Best Practices for updating and maintaining your ASP.NET websites

and much more

SQL Server Video Tutorial - Pt 2 - How to Delete Duplicate Rows i n a SQL Server Table Using the Rank() Function

2009-11-27T08:32:00.001-08:00

MSSQL Programming and Query Writing Screencast: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

A SQL Server training video from the LearnItFirst the web's largest IT Training Video Library

Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

This video will continue to show you the process of deleting duplicate rows using the RANK function in a SQL server table

Highlights:

Using common table expressions
Ranking and partitioning within a result set

N.B.: This training video comes from LearnItFirst's SQL Server Programming (SQL Server 2005/2000): Transact SQL video course.

SharePoint Training Video - Pt. 2 - How to Use Server Admin Templ ates and Site Admin Templates

2009-11-26T20:32:00.001-08:00

SharePoint 2007 Video Tutorial: Pt. 2 - How to Use Server Admin Templates and Site Admin Templates

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Pt. 2 - How to Use Server Admin Templates and Site Admin Templates

Description of this video:

Note: This video is from LearnItFirst.com's Building Portals with SharePoint 2007 training course.

In this second and final video of the section, you will continue learning how to load and use server admin templates and site admin templates. Also in this video you will go behind the scenes and learn about the Computer Equipment site.

Highlights:

More on how to run admin application templates
How to customize the applications on your SharePoint site
Customizing Sharepoint site settings

SQL Server Integration Services Tutorial Video - Options Availabl e for Performing Incremental Updates/Deltas with SSIS

2009-11-26T08:32:00.001-08:00

SQL 2005 Integration Services Video: Options Available for Performing Incremental Updates/Deltas with SSIS

One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. For example: you have a table in your mainframe database that is just huge - 200 million rows. Your company does not expose the mainframe database to the web; instead they've built a complex data movement package that copies the data out of the mainframe and into a SQL Server database that the website uses. Previously, they were able to delete the old rows and simply replace the SQL Server data with the mainframe data - but, with 200 million rows to copy over, this has become impossible. How can you help?

You have a few options - and this videos helps you learn what those options are and when to use each!

This video is part of LearnItFirst's SQL Server 2005 Integration Services training course.

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

2009-11-25T20:32:00.001-08:00

Windows Server Tutorial Video - Obtaining a Commercial SSL Certif icate, Part A

2009-11-25T08:32:00.001-08:00

SharePoint Video Tutorial - How to Export SSL Certificates (i.e., How to Backup Your SSL Certificates) to Move to a New Server

2009-11-24T20:32:00.001-08:00

SQL Server Video Tutorial - Part 4 - Looking at a Filename Patte rn Regular Expression

2009-11-24T08:32:00.001-08:00

SQL Server Video Tutorial - Pt. 9 - BULK INSERT and the OPENROWSE T Functions as Alternatives to BCP

2009-11-23T20:32:00.001-08:00

SQL Server Training Video - Enterprise Manager - Put Table On Filegroup

2009-11-23T08:32:00.001-08:00

MSSQL Server 2000 Video: Enterprise Manager - Put Table On Filegroup

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Enterprise Manager - Put Table On Filegroup

Description of this video:

Note: This video is from LearnItFirst.com's SQL Server 2000 Database Administration training course.

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

SQL Server Tutorial - Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

2009-11-22T20:32:00.001-08:00

SQL Server Tutorial: Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

Description of this video:

Note: This video is from LearnItFirst.com's SQL Server 2005 Database Administration training course.

This final video in the section will cover the final type of alert, the WMI event, which is new for SQL Server 2005. You'll learn about the syntax for writing WQL queries and how you can understand the WMI namespaces.

Highlights from this video:

WMI Code Creator
Writing WQL to identify events in SQL Server

and much more

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

2009-11-22T08:32:00.001-08:00

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

A SQL Server Integration Services training video from the LearnItFirst the web's largest IT Training Video Library

Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

This video covers how to edit your Legacy packages inside the BIDS (Business Intelligence Development Studio). You'll need to watch this to get the full picture of working with SSIS.

N.B.: This training video comes from LearnItFirst's SQL Server 2005 Integration Services video course.

SQL Server Tutorial Video - How to Configure the SQL Server Agent

2009-11-21T20:32:00.001-08:00

SQL Server Tutorial: How to Configure the SQL Server Agent

This SQL Server 2008 DBA tutorial comes from the LearnItFirst IT Training Video Library.

How to Configure the SQL Server Agent (Tutorial Video)

C# Video - Pt. 5 - How to Author and Deploy Reports

2009-11-21T08:32:00.001-08:00

C# Screencast: Pt. 5 - How to Author and Deploy Reports

Now that you've seen the basics - the architecture, the terms, the definitions - it's time to create and deploy reports. This video shows you the basics of report authorship (including which tools you can use to create a report) as well as how deployment works.

Highlights from this video:

What does an .RDL file look like?
Understanding the basics of report deployment
Previewing reports vs. deploying reports

and much more

This video is part of LearnItFirst's C# Programming with Visual Studio 2005 training course.

SQL Server Integration Services Tutorial - Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

2009-11-20T20:32:00.001-08:00

SQL 2005 Integration Services Training: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. This video, part 1, talks about the options available to you if you need to append rows from a source table to a target table, update only the changed rows with SSIS, or to delete rows at the destination that have also been deleted at the source.

Highlights from this video:

How to know when to use Set-Based incremental deltas or cursor-style (a decision tree)
Using the four part object identification to make addressing objects simpler

and much more

NOTE: Please watch the "Options Available for Performing Incremental Updates/Deltas with SSIS" video before watching this one.

This video is part of LearnItFirst's SQL Server 2005 Integration Services training course.

SQL Server Video Tutorial - Using PowerShell in SQL Server 2008 and Using sqlps.exe, Part 1

2009-11-20T08:32:00.001-08:00

MSSQL Server 2008 Training: Using PowerShell in SQL Server 2008 and Using sqlps.exe, Part 1

A SQL Server training video from the LearnItFirst the web's largest IT Training Video Library

Using PowerShell in SQL Server 2008 and Using sqlps.exe, Part 1

In this video we will see a demo of PowerShell.exe as well as sqlps.exe. We will learn how to use PowerShell in SQL Server 2008.

Highlights from this video:

How to run PowerShell
Enabling PowerShell feature
How to run sqlps.exe
Demo of PowerShell

and much more

N.B.: This training video comes from LearnItFirst's SQL Server 2008 Database Administration video course.

SQL Server Tutorial - Impersonation and EXECUTE AS

2009-11-19T20:32:00.001-08:00

SQL Server 2008 DBA Training: Impersonation and EXECUTE AS

We will discuss in this video tutorial how impersonation works using the EXECUTE AS statement. This video will really focus on helping you understand impersonation at a high-level as our next videos will be centered around these fundamentals.

Highlights from this video:

Security context vs execution context
What can I impersonate and what permissions do I need?
Architecture for the IMPERSONATE permission
Two types of context-switching
Server-level impersonation, database-level impersonation

and much more

This video is part of LearnItFirst's SQL Server 2008 Database Administration training course.

SQL Server Integration Services Tutorial Video - Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Task s

2009-11-19T08:32:00.001-08:00

SQL 2005 Integration Services Video: Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks

This SSIS 2005 tutorial comes from the LearnItFirst IT Training Video Library.

Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks (Tutorial)

Visual Basic Tutorial - Part 2 - What is .NET?

2009-11-18T20:32:00.001-08:00

Visual Basic .NET Video: Part 2 - What is .NET?

This Visual Basic .NET tutorial comes from the LearnItFirst IT Training Video Library.

Part 2 - What is .NET? (Tutorial)

Windows Server Training Video - Password Management

2009-11-18T08:32:00.001-08:00

Windows Server Tutorial: Password Management

This Windows 2003 tutorial comes from the LearnItFirst IT Training Video Library.

Password Management (Tutorial)

Exchange Server Tutorial Video - Sending Multiple Email Messages Using a .CSV File (External Flat file) and VBSscript (VBS)

2009-11-17T20:32:00.001-08:00

MS Exchange 2003 Video: Sending Multiple Email Messages Using a .CSV File (External Flat file) and VBSscript (VBS)

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Sending Multiple Email Messages Using a .CSV File (External Flat file) and VBSscript (VBS)

Description of this video:

Note: This video is from LearnItFirst.com's Exchange Server 2003 Administration training course.

If you know how to use simple a simple VBScript to send an e-mail message, then this video will be a great follow-up as it will take that concept to a whole new level by having the system read a comma seperated variable file, or CSV, to send an individual email to each of the people listed in the .csv file.

Highlights from this video:

Format/navigation of the VBScript script file
Delays in Exchange
Working in your CSV file

and more!

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

2009-11-17T08:32:00.001-08:00

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

A C# training video from the LearnItFirst the web's largest IT Training Video Library

Pt. 6 - Codefiles, Inline Code, and a Tour of More Controls

In this video��you will continue building your web page by adding some new items from the Toolbox and editing their respective properties��.

Highlights:

What is the difference between a page that has a Codefile and a page that has Inline Code?
How to auto-generate Event Handlers
Adding hyperlinks
How to add a ListBox

��

N.B.: This training video comes from LearnItFirst's C# Programming with Visual Studio 2005 video course.

Visual Basic Tutorial - 1 - Using Cassini or IIS: An Overview of Web Server Options With ASP.NET Websites

2009-11-16T20:32:00.001-08:00

Visual Basic .NET Training: 1 - Using Cassini or IIS: An Overview of Web Server Options With ASP.NET Websites

After you've built your first web application in ASP.NET, you'll likely want to deploy this to a web server (such as IIS, a.k.a. Internet Information Server). This section focuses on how to configure Cassini, the built-in web server for ASP.NET, and how to configure IIS 5.1 to work with Windows XP.

Highlights from this video:

Options for default web servers on Windows XP
Installing IIS on Windows XP

and much more

This video is part of LearnItFirst's Visual Basic Programming with Visual Studio 2005 training course.

SQL Server Training Video - Quick Demo: How to Create Windows Gr oup Logins and Prevent Certain Users

2009-11-16T08:32:00.001-08:00

MSSQL Server 2008 Training Video: Quick Demo: How to Create Windows Group Logins and Prevent Certain Users

This SQL Server 2008 DBA tutorial comes from the LearnItFirst IT Training Video Library.

Quick Demo: How to Create Windows Group Logins and Prevent Certain Users (Training Video)

C# Video Tutorial - Pt. 1 - Installing Visual Studio 2005 Profess ional Edition

2009-11-15T20:32:00.001-08:00

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

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

Highlights from this video:

Choosing options for setup
Deciding where to place files

and much more

This video is part of LearnItFirst's C# Programming with Visual Studio 2005 training course.

LearnItFirst.com's New Videos Blog

C# Tutorial Video - 3 - Web Deployment Projects - Installing, Con figuring, and Deploying ASP.NET Websites with WDPs

C# Video: 3 - Web Deployment Projects - Installing, Configuring, and Deploying ASP.NET Websites with WDPs

Description of this video:

Other Links You Might Be Interested In:

SQL Server Video Tutorial - Pt 2 - How to Delete Duplicate Rows i n a SQL Server Table Using the Rank() Function

MSSQL Programming and Query Writing Screencast: Pt 2 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

SharePoint Training Video - Pt. 2 - How to Use Server Admin Templ ates and Site Admin Templates

SharePoint 2007 Video Tutorial: Pt. 2 - How to Use Server Admin Templates and Site Admin Templates

Description of this video:

Other Links You Might Be Interested In:

SQL Server Integration Services Tutorial Video - Options Availabl e for Performing Incremental Updates/Deltas with SSIS

SQL 2005 Integration Services Video: Options Available for Performing Incremental Updates/Deltas with SSIS

Related Links:

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

Windows Server Tutorial Video - Obtaining a Commercial SSL Certif icate, Part A

SharePoint Video Tutorial - How to Export SSL Certificates (i.e., How to Backup Your SSL Certificates) to Move to a New Server

SQL Server Video Tutorial - Part 4 - Looking at a Filename Patte rn Regular Expression

SQL Server Video Tutorial - Pt. 9 - BULK INSERT and the OPENROWSE T Functions as Alternatives to BCP

SQL Server Training Video - Enterprise Manager - Put Table On Filegroup

MSSQL Server 2000 Video: Enterprise Manager - Put Table On Filegroup

Description of this video:

Other Links You Might Be Interested In:

SQL Server Tutorial - Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

SQL Server Tutorial: Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

Description of this video:

Other Links You Might Be Interested In:

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

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

SQL Server Tutorial Video - How to Configure the SQL Server Agent

SQL Server Tutorial: How to Configure the SQL Server Agent

How to Configure the SQL Server Agent (Tutorial Video)

More info about this video:

C# Video - Pt. 5 - How to Author and Deploy Reports

C# Screencast: Pt. 5 - How to Author and Deploy Reports

Related Links:

SQL Server Integration Services Tutorial - Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

SQL 2005 Integration Services Training: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Related Links:

SQL Server Video Tutorial - Using PowerShell in SQL Server 2008 and Using sqlps.exe, Part 1

MSSQL Server 2008 Training: Using PowerShell in SQL Server 2008 and Using sqlps.exe, Part 1

SQL Server Tutorial - Impersonation and EXECUTE AS

SQL Server 2008 DBA Training: Impersonation and EXECUTE AS

Related Links:

SQL Server Integration Services Tutorial Video - Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Task s

SQL 2005 Integration Services Video: Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks

Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks (Tutorial)

More info about this video:

Visual Basic Tutorial - Part 2 - What is .NET?

Visual Basic .NET Video: Part 2 - What is .NET?

Part 2 - What is .NET? (Tutorial)

More info about this video:

Windows Server Training Video - Password Management

Windows Server Tutorial: Password Management

Password Management (Tutorial)

More info about this video:

Exchange Server Tutorial Video - Sending Multiple Email Messages Using a .CSV File (External Flat file) and VBSscript (VBS)

MS Exchange 2003 Video: Sending Multiple Email Messages Using a .CSV File (External Flat file) and VBSscript (VBS)

Description of this video:

Other Links You Might Be Interested In:

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

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

Visual Basic Tutorial - 1 - Using Cassini or IIS: An Overview of Web Server Options With ASP.NET Websites

Visual Basic .NET Training: 1 - Using Cassini or IIS: An Overview of Web Server Options With ASP.NET Websites

Related Links:

SQL Server Training Video - Quick Demo: How to Create Windows Gr oup Logins and Prevent Certain Users

MSSQL Server 2008 Training Video: Quick Demo: How to Create Windows Group Logins and Prevent Certain Users

Quick Demo: How to Create Windows Group Logins and Prevent Certain Users (Training Video)

More info about this video:

C# Video Tutorial - Pt. 1 - Installing Visual Studio 2005 Profess ional Edition

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

Related Links: