IT Training Videos From LearnItFirst.com tag:typepad.com,2003:weblog-559637 2011-06-26T08:16:07-05:00 This blog hosts our video tutorials for SQL Server 2005 training, Windows Server 2003 training, Exchange 2007 training, Windows 2008 training and more! TypePad SQL Server Programming and Queries Training Video: 09 - Best Prac tices, Writing CASE Statements, and Final Thoughts tag:typepad.com,2003:post-6a00d8341c0d6c53ef01538f72c1be970b 2011-06-26T08:16:07-05:00 2011-06-26T08:16:07-05:00 09 - Best Practices, Writing CASE Statements, and Final Thoughts - view details Originally when Scott Whigham (author of this site) recorded thissection , this video was supposed to be the last video... Source: http://www.learnitfirst.com/Course/150/Video/780/Best-Practices-and-Writing-CASE-Statements.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 400... Scott Whigham

09 - Best Practices, Writing CASE Statements, and Final Thoughts - view details
Originally when Scott Whigham (author of this site) recorded thissection , this video was supposed to be the last video... Source: http://www.learnitfirst.com/Course/150/Video/780/Best-Practices-and-Writing-CASE-Statements.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 400 (Intermediate - Advanced) Length: 6:15 (6.02MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: CASE, Searched case, boolean case, selector case

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sql-server-programming-and-queries-training-video-09-best-prac-tices-writing-case-statements-and-final-thoughts.html Exchange 2007 Training Video: Part 5 - Final Steps to Complete ou r Exchange 2007 Migration tag:typepad.com,2003:post-6a00d8341c0d6c53ef01538f456a68970b 2011-06-18T08:16:02-05:00 2011-06-18T08:16:02-05:00 Part 5 - Final Steps to Complete our Exchange 2007 Migration - view details The last steps to complete our Exchange 2003 to Exchange 2007 migration are primarily cleanup steps. Are you using recipient policies? You need to watch this... Scott Whigham

Part 5 - Final Steps to Complete our Exchange 2007 Migration - view details
The last steps to complete our Exchange 2003 to Exchange 2007 migration are primarily cleanup steps. Are you using recipient policies? You need to watch this video. What about Recipient Update Services? Will this affect your Exchange migration? How can you change it?

Highlights from this video:Installing the Windows Support ToolsUsing ADSIEdit to diagnose and troubleshoot problemsUsing Active Directory Sites and ServicesMessage queues, Storage groups, and mailbox cleanupUninstalling Exchange 2003! and much more Source: http://www.learnitfirst.com/Course/222/Video/1282/Completing-the-Exchange-2007-Migration.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 13:00 (18.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: upgrade, migration, Exchange 2007, Exchange 2003

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/exchange-2007-training-video-part-5-final-steps-to-complete-ou-r-exchange-2007-migration.html SQL Server 2008 Analysis Services Training Video: IDENTITY Column s and Inserts tag:typepad.com,2003:post-6a00d8341c0d6c53ef01538f3a8af1970b 2011-06-16T08:16:08-05:00 2011-06-16T08:16:08-05:00 IDENTITY Columns and Inserts - view details Scott demonstrates working with IDENTITY columns in this video, pointing out some traps to watch for along the way. How should you handle a primary key or unique constraint violation? Highlights from this... Scott Whigham

IDENTITY Columns and Inserts - view details
Scott demonstrates working with IDENTITY columns in this video, pointing out some traps to watch for along the way. How should you handle a primary key or unique constraint violation?

Highlights from this video:Sending conflicting instructions to SQL Server on putting values into a column
Can you change the values of an IDENTITY column?
Successfully inserting specific valuesWhy use surrogate key values?
IDENTITY_INSERT
and much more Source: http://www.learnitfirst.com/Course/161/Video/2985/Identity-Columns-Inserts.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 11:30 (25.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: identity, insert, column, primary key, unique constraint, violiation, value, surrogate

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sql-server-2008-analysis-services-training-video-identity-column-s-and-inserts.html C# Training Video: Pt. 5 - Our First Console Application in Visual Studio tag:typepad.com,2003:post-6a00d8341c0d6c53ef014e8921f680970d 2011-06-14T08:16:17-05:00 2011-06-14T08:16:17-05:00 Pt. 5 - Our First Console Application in Visual Studio - view details This video will give you a first look at the deployment process of a console application and also show you what is necessary for a debug/release build.... Scott Whigham

Pt. 5 - Our First Console Application in Visual Studio - view details
This video will give you a first look at the deployment process of a console application and also show you what is necessary for a debug/release build.
Highlights:What is the deployment strategy?
Structure of .pdb files
How to release a build via configuration change�� Source: http://www.learnitfirst.com/Course/189/Video/672/Writing-Your-First-Console-Application-in-Visual-Studio-Pt5.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 300 (Intermediate) Length: 52:52 (7.44MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: dos, command prompt, command line, services

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/c-training-video-pt-5-our-first-console-application-in-visual-studio.html C# Training Video: Pt. 9 - sp_start_job Options and Security: Cre dentials, Proxy Accounts and More tag:typepad.com,2003:post-6a00d8341c0d6c53ef014e89163f92970d 2011-06-12T08:16:17-05:00 2011-06-12T08:16:17-05:00 Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this... Scott Whigham

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote
machine using a stored procedure called sp_start_job. In this video,
Scott talks about how to execute packages remotely using T-SQL as well
as discussions on executing remote jobs using .NET. This video talks
about scheduling SSIS jobs, credentials, proxy accounts, and more -
this is a very 'deep' video.

Highlights from this video:What are SQL credentials?How can I force execution of the SSIS package with a certain account?What are proxies and proxy accounts in SQL?Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?How to assign parameter values when you execute/call a SQL job for SSISand much more Source: http://www.learnitfirst.com/Course/189/Video/1257/sp-start-job-Options-Credentials-and-Proxy-Accounts.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 500 (Advanced) Length: 9:30 (10.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server proxy account, job credentials

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/c-training-video-pt-9-sp_start_job-options-and-security-cre-dentials-proxy-accounts-and-more.html SQL Server 2008 DBA Training Video: Deprecated and Discontinued I tems in SQL Server 2008 tag:typepad.com,2003:post-6a00d8341c0d6c53ef015432eaeb57970c 2011-06-10T08:16:18-05:00 2011-06-10T08:16:18-05:00 Deprecated and Discontinued Items in SQL Server 2008 - view details In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most... Scott Whigham

Deprecated and Discontinued Items in SQL Server 2008 - view details
In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most widely used and most popular deprecated and discontinued items are listed and discussed. Also,��a .PDF file of Scott Whigham's presentation is included with your download!
Highlights from this video:Defining "deprecated"
Items that may not work in the futureDefining "discontinued"
Items that won't work right nowMost popular discontinued items and their replacements
Widely used deprecated items and their replacementsand much more Source: http://www.learnitfirst.com/Course/157/Video/1587/Discontinued-In-SQL-2008.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 100 (Beginner) Length: 07:15 (12.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: deprecated, discontinued, sql 2008, out of service,, introduction, step by step, beginner, beginning, for dummies

This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sql-server-2008-dba-training-video-deprecated-and-discontinued-i-tems-in-sql-server-2008.html SQL Server 2008/R2 Reporting Services Training Video: Exercise 01 : How to Use the Exercises in this Course tag:typepad.com,2003:post-6a00d8341c0d6c53ef014e88fe1682970d 2011-06-08T08:16:15-05:00 2011-06-08T08:16:15-05:00 Exercise 01: How to Use the Exercises in this Course - view details In this video you will see how the exercises in this course will work and create folders on your hard drive for the exercises and their solutions.... Scott Whigham

Exercise 01: How to Use the Exercises in this Course - view details
In this video you will see how the exercises in this course will work and create folders on your hard drive for the exercises and their solutions.

Highlights from this video:Overview of exercise videos
and much more Source: http://www.learnitfirst.com/Course/162/Video/2448/Exercise-How-To-Use-Exercises.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 100 (Beginner) Length: 06:15 (15.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server 2008, reporting services, exercises

This video comes from the SQL Server 2008/R2 Reporting Services online training course, SQL Server 2008/R2 Reporting Services. And be sure to check out even more SQL Server Reporting Services training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sql-server-2008r2-reporting-services-training-video-exercise-01-how-to-use-the-exercises-in-this-course.html SQL Server 2008/R2 Reporting Services Training Video: Creating Yo ur First Gauge Reports tag:typepad.com,2003:post-6a00d8341c0d6c53ef01538efcbced970b 2011-06-06T08:16:13-05:00 2011-06-06T08:16:13-05:00 Creating Your First Gauge Reports - view details In this video Scott will walk you through how to create a gauge and put it into your report. It is easy to learn the basics of gauges, but in order to... Scott Whigham

Creating Your First Gauge Reports - view details
In this video Scott will walk you through how to create a gauge and put it into your report. It is easy to learn the basics of gauges, but in order to become more advanced it's important that you work with gauges on your own.

Highlights from this video:Some tips on working with gauges
Creating a gauge
Insert Gauge
radial or linear?
Different gauge options
and much more Source: http://www.learnitfirst.com/Course/162/Video/2550/Creating-Gauge-Reports.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 300 (Intermediate) Length: 18:15 (72.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server 2008, ssrs, reporting services, reports, gauge, radial, linear

This video comes from the SQL Server 2008/R2 Reporting Services online training course, SQL Server 2008/R2 Reporting Services. And be sure to check out even more SQL Server Reporting Services training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sql-server-2008r2-reporting-services-training-video-creating-yo-ur-first-gauge-reports.html SharePoint 2007 Training Video: How to Install SharePoint Service s 3.0 on a Domain Controller tag:typepad.com,2003:post-6a00d8341c0d6c53ef014e88e3d94e970d 2011-06-04T08:16:14-05:00 2011-06-04T08:16:14-05:00 How to Install SharePoint Services 3.0 on a Domain Controller - view details In this video you will be learning how to install SharePoint Services on a domain controller, even though it is not recommended. Also you'll learn how to... Scott Whigham

How to Install SharePoint Services 3.0 on a Domain Controller - view details
In this video you will be learning how to install SharePoint Services on a domain controller, even though it is not recommended. Also you'll learn how to configure the application server for IIS, how to utilize the SMTP service, what measure to take when installing on a domain server, allowing ASP.NET to run, using the SharePoint Products and Technologies Configuraton Wizard, and how to check event logs.

Highlights:How to configure the application server for IISHow to turn on the SMTP serviceWhat measures to be taken when installing on a domain serverUsing the Configuration WizardHow to check the event logs for errors Source: http://www.learnitfirst.com/Course/225/Video/856/Install-SharePoint-Services-3-on-a-Domain-Controller.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 400 (Intermediate - Advanced) Length: 14:30 (9.55MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: install sharepoint, domain controller, SMTP service, configure server IIS, domain server, installing,

This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/sharepoint-2007-training-video-how-to-install-sharepoint-service-s-30-on-a-domain-controller.html Exchange 2007 Training Video: Part 1 - Discussion on Cluster Cont inuous Replication tag:typepad.com,2003:post-6a00d8341c0d6c53ef015432b71ca0970c 2011-06-02T08:16:13-05:00 2011-06-02T08:16:13-05:00 Part 1 - Discussion on Cluster Continuous Replication - view details Offering server high availability and an automated failover process, Cluster Continuous Replication (CCR) is great for those of you who have numerous Exchange 2007 servers. With CCR we can... Scott Whigham

Part 1 - Discussion on Cluster Continuous Replication - view details
Offering server high availability and an automated failover process, Cluster Continuous Replication (CCR) is great for those of you who have numerous Exchange 2007 servers. With CCR we can eliminate the need for the storage array in the Storage Area Network, saving you a whole lot of money, by using a local disk. In this video section, your instructor Grant Moyle will walk you through the long process of installing Exchange 2007 in CCR configuration as well as��go over how the cluster actually works and the basic recipe needed to build the cluster. The subsequent videos in this section will build on this info and install the two cluster nodes, the Windows components of clustering, the Exchange components of clustering, and we'll end the section with a completed Exchange 2007 CCR configuration.
Highlights from this video:About working with��Cluster Continour Replication Prep-work and prerequisites for the cluster setup Examine existing network configuration Configuring a new local area connectionConfiguring Local Disk and Heartbeat Network Ideal configuration for your serversand much more Source: http://www.learnitfirst.com/Course/222/Video/1504/Discussion-on-Cluster-Continuous-Replication.aspx Course: http://www.learnitfirst.com/Course/222/Exchange-2007.aspx Skill Level: 300 (Intermediate) Length: 18:30 (14.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: ccr, cluster, continuous, replication, failover, server, node,

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

 http://videotraining.typepad.com/ourvideos/2011/06/exchange-2007-training-video-part-1-discussion-on-cluster-cont-inuous-replication.html