IT Training Videos From LearnItFirst.com

SQL Server 2008 Analysis Services Training Video: Exercise 07: Bu ilding the Cube

Exercise 07: Building the Cube - view details
In this exercise video you will be given the opportunity to use the knowledge you have learned in the previous videos to build a cube.

Highlights from this video:Building the cube
and much more Source: http://www.learnitfirst.com/Course/165/Video/2717/Exercise-Building-the-Cube.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 08:30 (18.6MB) 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, cube, build, 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.

SharePoint 2007 Training Video: Moving a SharePoint Content Datab ase To A Different Disk on the Same System

Moving a SharePoint Content Database To A Different Disk on the Same System - view details
When you install Windows SharePoint Services 3.0 on to Windows 2003 server, by default it will install a SQL Server Embedded edition to host to the database. The database, by default, will be built on the C:/ drive. In this video we're going to take a look at how you can you the SQL Server Express tools to move the database to a different drive letter, because perhaps you're running out of room on the C:/ drive or your database design is needing you to move the database. This is a fairly quick and easy thing to do, provided you have the right tools.

Highlights from this video:Downloading/opening the SSMS tools
Connecting to your SQL ServerWhere is all of my SharePoint content located?
Information about the content databases
Detatching databases from the serverSuggestions for pre-detatchmentWhy did my "Detatch Database" fail?Adding databases to a new disk drive
and much more Source: http://www.learnitfirst.com/Course/225/Video/1542/Move-a-SharePoint-Content-Database-to-a-Different-Disk-on-the-Same-System.aspx Course: http://www.learnitfirst.com/Course/225/SharePoint-2007.aspx Skill Level: 300 (Intermediate) Length: 12:45 (13.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: move, moving, database, sql, ssms, management studio, disk, drive,

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 2005/2008 Queries Training Video: Using EXISTS() with Correlated Subqueries

Using EXISTS() with Correlated Subqueries - view details
This video will take a look at using EXISTS() as an alternative to an OUTER JOIN and also as an alternative to NOT IN. Scott will show you how to use EXISTS() with correlated subqueries.

Highlights from this video:Rewriting an OUTER JOIN to a correlated subquery with EXISTS()
Dealing with negative problem statementsIS NULL
and much more Source: http://www.learnitfirst.com/Course/160/Video/2399/Using-EXISTS-With-Correlated-Subqueries.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 11:45 (28.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server, queries, subqueries, correlated subquery, exists

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.

SQL Server 2008 Reporting Services Training Video: Creating Your First Gauge Reports

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 Reporting Services online training course, SQL Server 2008 Reporting Services. And be sure to check out even more SQL Server Reporting Services training videos.

SSRS 2005 Training Video: Pt. 4 - Troubleshooting a 'Key not vali d for use in the specified state' Error

Pt. 4 - Troubleshooting a 'Key not valid for use in the specified state' Error - view details
This fourth and final video in the section will troubleshoot what you will need to do after you reset your account and receive the error message 'Key not valid for use in the specified state'. Your instructor will lead you out of the circular process of error messages, as you will find that you won't be able to restore,backup, or change that encryption content, and resolve the situation.Highlights from this video:Techniques for starting your server back up againUsing SAC (Surface Area Configuration)Using DOS promptHow to get Report Server to work with original encryption keys Source: http://www.learnitfirst.com/Course/154/Video/1004/Troubleshooting-Key-not-valid-for-use-in-specified-state-Error.aspx Course: http://www.learnitfirst.com/Course/154/SSRS-2005.aspx Skill Level: 500 (Advanced) Length: 14:30 (12.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: encryption, encrypt, lock out, key, surface area configuration, key not valid

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