IT Training Videos From LearnItFirst.com

SQL Server 2008 Analysis Services Training Video: Exercise 02: In stalling the SQL Server 2008 Samples on Your Machine

Exercise 02: Installing the SQL Server 2008 Samples on Your Machine - view details
In this exercise video you will be installing the SQL Server 2008 samples that will be used throughout the course on your machine.

Highlights from this video:Installing the SQL Server 2008 samples on your machine
and much more Source: http://www.learnitfirst.com/Course/165/Video/2628/Exercise-Installing-SQL-Server-Samples.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 100 (Beginner) Length: 13:45 (40.4MB) 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, analysis services, ssas, sql server samples, exercise

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

SQL Server 2008 Analysis Services Training Video: SSAS Cube and D imension Processing, Part 1

SSAS Cube and Dimension Processing, Part 1 - view details
The concepts of doing cube dimension, partition, and measure group processing will be split into three videos. In part one, Scott breaks down the two types of SSAS "work." Having already looked at things that you do one time, you will go into detail about things you do repeatedly with SSAS, and learn to use ETL to make sure the relational data warehouse (RDW) is in sync.

Highlights from this video:Processing SSAS objects
Keeping the relational data warehouse synced
Deciding how frequently to syncArchiving data
Lessening locks on OLTP sources and much more Source: http://www.learnitfirst.com/Course/165/Video/2793/SSAS-Cube-and-Dimensioning-Processing-Part-One.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 500 (Advanced) Length: 14:15 (28.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, analysis services, ssas, ssis, OLAP, OLEDB, RDW, process

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

SQL Server Programming and Queries Training Video: Performance Tu ning Query Tips That Everyone Should Know - Using DBCC and SET Commands

Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands - view details
There are lots and lots of DBCC commands related to performance tuning but did you know that several SET commands can help you out with your query tuning? This video, recorded by SQL consultant Scott Whigham, teaches you several of the most commonly used DBCC and SET commands for performance tuning and provides some tips and tricks for their use. Note: you'll want to likely have a solid foundation in query writing before viewing this video. An understanding of execution plans would also be helpful. Source: http://www.learnitfirst.com/Course/150/Video/428/Performance-Tuning-Query-Tips-Using-DBCC-and-SET-Commands.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 300 (Intermediate) Length: 21:10 (15.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: dbcc, statistics, io, statistics_io, statistics_time, showplan, showplan_all, showplan_text, performance,

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.

SharePoint 2007 Training Video: How to Remove a Site From a Site Collection in SharePoint

How to Remove a Site From a Site Collection in SharePoint - view details
This great instructional video will go into greater depth and detail about the process of how to remove a specific site from a site collection. Source: http://www.learnitfirst.com/Course/225/Video/873/Remove-a-Site-from-a-Site-Collection-in-SharePoint.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 300 (Intermediate) Length: 3:30 (3.95MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: remove site from site collection, remove site, site collection,

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.

SQL Server 2008 Analysis Services Training Video: Tools for Creat ing "Missing" Indexes

Tools for Creating "Missing" Indexes - view details
This video will begin to introduce some of the automated tools you can use to determine what indexes might fit a specific application, report, or script of queries. Starting with SQL Profiler, Scott will walk you through a number of these tools (with examples) so that you can become familiar with what they're for and how to use them. Later, in chapter 11, a lot of these tools will be explored in more detail - this video is designed to give you a basic understanding of them, just enough to get you excited about how cool they are!

Highlights from this video:Built-in automated tools in SQL
What is SQL Profiler?Database Engine Tuning AdvisorConverting scans to seeksMinimizing the cost of your queries

and much more Source: http://www.learnitfirst.com/Course/161/Video/2967/Missing-Index-Tools.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 19:30 (57.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: index, sql profiler, automated, database engine tuning advisor, scan, seek, tool, built in tool

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.

ISA 2006 Training Video: Network Firewall Configuration Templates

Network Firewall Configuration Templates - view details
In ISA Server 2006, Microsoft has included a number of templates to basically allow you to visualize and setup some base configurations for how to use your ISA Server. This video shows you how to set up the ISA Server templates for your use.

Highlights from this video:Using the ISA Server Management tool to browse available templatesUnderstanding the graphical layout in the ISA Management toolUnderstanding Edge Firewall, 3-Leg Perimeter, Front Firewall, Back Firewall, and other templates and much more Source: http://www.learnitfirst.com/Course/223/Video/1152/Network-Firewall-Configuration-Templates.aspx Course: http://www.learnitfirst.com/Course/223/ISA-2006.aspx Skill Level: 200 (Beginner - Intermediate) Length: 6:00 (7.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: intro to isa server, introduction, step by step, beginner, beginning, for dummies

This video comes from the ISA 2006 online training course, ISA Server 2006 Administration. And be sure to check out even more ISA 2006 Admin training videos.