IT Training Videos From LearnItFirst.com

SSRS 2005 Training Video: Pt. 2 - Customizing Profiler and Creati ng Reporting Services-Specific Templates

Pt. 2 - Customizing Profiler and Creating Reporting Services-Specific Templates - view details
This last video in the section will show you another thing you can do with Profiler;��seeing which accounts are being used to execute reports and the effects security has on the particular report.Highlights of this video:Running multiple copies of IE under different accountsSpotting��security changesHow to set-up a custom template in the Profiler to work with SSRSWhat is my NTUserName? Source: http://www.learnitfirst.com/Course/154/Video/994/Customize-Profiler-and-Create-SSRS-Templates.aspx Course: http://www.learnitfirst.com/Course/154/SSRS-2005.aspx Skill Level: 400 (Intermediate - Advanced) Length: 10:30 (8.37MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: profiler, ssrs, reporting services, ntusername, reports,

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.

SQL Server 2008 DBA Training Video: Creating SQL Server Databases - Part 10

Creating SQL Server Databases - Part 10 - view details
In our final video in this section, we will walk through the process of deleting/removing a file from a database as it is not as simple as you would think.

Highlights from this video:
Setting up files to delete
Typical error message received when trying to delete a file
How do I empty a file so it is safe to delete?
Deleting the file��and much more Source: http://www.learnitfirst.com/Course/157/Video/1657/Creating-SQL-Server-2008-Databases-Pt10.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 06:15 (11.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: empty, delete, file, create, database, sql, server, 2008

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.

SSRS 2005 Training Video: Part 5 - More on Working with Series an d How to Customize the Legend

Part 5 - More on Working with Series and How to Customize the Legend - view details
In this video, Scott will wrap up his discussion on series and the category groups and then discuss��how to��format and tailor various aspects about your legend/key.

Highlights from this video:
Implementing a third level in your hierarchy
Positioning the legend
How to the chart changes in response
Legend layout
Displaying the legend in the plot areaCustomizing the legend style propertiesand much more Source: http://www.learnitfirst.com/Course/154/Video/1536/Working-with-Series-and-Customize-Legend-in-SSRS.aspx Course: http://www.learnitfirst.com/Course/154/SSRS-2005.aspx Skill Level: 100 (Beginner) Length: 10: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: introduction, step by step, beginner, beginning, for dummies, chart, chart control, customize, customizing, customization, format,legend, properties

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.

SQL Server 2005/2008 Queries Training Video: Aggregates and Windo w Functions - Breakin' the Rulez

Aggregates and Window Functions - Breakin' the Rulez - view details
This video will break all the rules that were covered in the previous videos in this chapter. Scott will cover using aggregates and window functions in this video.
 
Highlights from this video:Mixing 1:1 and many:1 queries in the same query
Window Functions
Mixing row and group level values
OVER clause
and much more Source: http://www.learnitfirst.com/Course/160/Video/2380/Aggregates-and-Window-Functions.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 11:45 (30.2MB) 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, aggregates, window function, over clause,

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: Exercise 01: C onfigure Authentication for SSRS

Exercise 01: Configure Authentication for SSRS - view details
In this exercise video you will have the opportunity to configure authentication for SSRS. This video is an exercise-demo hybrid; Scott will walk you through the steps involved in this process.

Highlights from this video:Configure authentication for SSRS
and much more Source: http://www.learnitfirst.com/Course/162/Video/2478/Exercise-Configure-Authentication.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 19:00 (65.2MB) 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, security, authentication, configuration, exercise

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.

SSIS 2008 Training Video: How to Add a Progress Bar to Your Output

How to Add a Progress Bar to Your Output - view details
In this video Scott will show you how to add a progress bar to your output using both Visual Basic and C#. This is a useful technique to use during development and debugging. This does not use a popup, but rather the output window. This takes one line of code, but is an extremely useful tool!

Highlights from this video:What is a progress bar?DTS objectevent
FireInformation vs. FireProgressFireInformationwrite to output window
and much more Source: http://www.learnitfirst.com/Course/158/Video/2181/Add-Progress-Bar-To-Output.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 08:15 (22.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, .NET, progress bar, output, fireinformation, dts object, event, C#, VB, Visual Basic

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

SQL Server 2008 DBA Training Video: Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE

Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE - view details
In this demo video we will revisit a few commands that we've talked about in a previous chapter that we will use more heavily in later parts of this course. These commands are the alter database commands.

Highlights from this video:

Effects of the WITH ROLLBACK IMMEDIATE statement
How WITH ROLLBACK AFTER x SECONDS works
What is the WITH NO_WAIT command?
Example of working with the commandsand much more Source: http://www.learnitfirst.com/Course/157/Video/1836/Miscellaneous-ROLLBACK-Commands.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 5:45 (9.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: NO_WAIT, ROLLBACK, backup,restore,sql server,2008

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.

SQL Server 2005/2008 Queries Training Video: ORDER BY: The Basics of the ORDER BY Clause

ORDER BY: The Basics of the ORDER BY Clause - view details
In this video Scott will cover the basics of SORT. SORT and the ORDER BY clause are fairly simple concepts but there are two slightly complicated aspects to these concepts that Scott will go over in this video.

Highlights from this video:ORDER Byalways the last clausewhat can I order by?ascending or descending order
Multiple sorts
Can I sort on an alias?only in ORDER BY
and much more Source: http://www.learnitfirst.com/Course/160/Video/2255/ORDER-BY.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 100 (Beginner) Length: 09:30 (23.7MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: introduction, step by step, beginner, beginning, for dummies, sql server, sort, order by, multiple sorts, alias

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: Misc Tips: How to Add Sorting Ability to Your Columns

Misc Tips: How to Add Sorting Ability to Your Columns - view details
In this video Scott will show you how to make a column sortable. This is fairly simple task, but it's a very valuable technique to know. Scott will walk you through how to do this for both tables and matrices.

Highlights from this video:Demo set-up
Column header
Text box properties
interactive sorting
Sorting with a matrix
sort by a column group
and much more Source: http://www.learnitfirst.com/Course/162/Video/2526/Adding-Sorting-Ability-to-Columns.aspx Course: http://www.learnitfirst.com/Course/162/SSRS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 06:30 (24.7MB) 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, sorting, table, matrix

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.

C# Training Video: 3 - Troubleshooting IIS Website Configurations, Part 1

3 - Troubleshooting IIS Website Configurations, Part 1 - view details
This video is our first video on troubleshooting problems with IIS and Windows XP. You'll see first hand the types of problems that you can experience with using IIS and how to avoid most of the problems all together!

Highlights from this video:Diagnosing and Resolving 'HTTP 401.3 - Access Denied by ACL on resource' errorsWorking with the Anonymous User Account, IUSR_xyzUsing cacls.exe to work around Windows XP dialog box limitationsWorking with default documents and much more Source: http://www.learnitfirst.com/Course/189/Video/789/Troubleshoot-IIS-Website-Configurations-Pt1.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 400 (Intermediate - Advanced) Length: 9:36 (7.50MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: deploy, deployment, xcopy, copy, install, installation, installing, iis 5.1, iis 6, iis 7, iis6, iis7, errors

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.