Thursday, March 11, 2010

Reporting Services Video Tutorial - Defining and Using SSL within SSRS

Reporting Services video!

SQL Server 2008 Reporting Services Video: Defining and Using SSL within SSRS

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

Defining and Using SSL within SSRS

Description of this video:

Note: This video is from LearnItFirst.com's SQL Server 2008 Reporting Services training course.

This is a short video that will only apply to a small amount of people who want to use SSL within SSRS.  In this video Scott will show you how to configure SSRS to use SSL.

Highlights from this video:

  • What is SSL?
    • Secure Sockets Layer
    • https://
  • How to get SSL certificate installed in SSRS
    • not covered in this video
and much more

SQL Server 2008 Reporting Services video tutorial

Other Links You Might Be Interested In:

SQL Server Video Tutorial - How to Remove/Uninstall Reporting Ser vices Completely

SQL Server  training video

SQL 2005 Reporting Services Training: How to Remove/Uninstall Reporting Services Completely

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

How to Remove/Uninstall Reporting Services Completely

This video tutorial will walk you through the tricky process of removing every aspect and trace of reporting services from your machine without removing your SQL Server.

Highlights from this video:

  • From where do I uninstall SSRS?
  • Clean-up work after the removal
  • How to tell if there was a successful uninstall

and much more!

SSRS 2005 video tutorial

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

Wednesday, March 10, 2010

SQL Server Video Tutorial - Quick Demo: How to Create a SQL Server Login

SQL Server   training video

SQL Server Tutorial Video: Quick Demo: How to Create a SQL Server Login

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

Quick Demo: How to Create a SQL Server Login

In this short video we will take a look at a demonstration of how to create a SQL Server login and what it looks like in the SQL Server Management Studio.

Highlights from this video:

  • How to create a new login
    • Logging in with your newly created login
  • Diagram of logins
  • Using code to change databases
and much more

SQL Server 2008 DBA video tutorial

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

SQL Server Integration Services Training Video - Pt. 4b - In Plac e Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

SSIS 2005 Screencast: Pt. 4b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

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

Pt. 4b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS (Screencast)

More info about this video:

Yikes! While migrating from SQL 2000 to 2005 and using the DTS Designer Components (downloaded from MSFT), Scott Whigham, our author, had a little unexpected visit from the Demo Gods. This video is somewhat funny in terms of silly the issues are that you may experience and, if for nothing else other than having a laugh, you'll want to watch this video!

SQL Server Integration Services training video

SQL 2005 Integration Services training

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

Tuesday, March 9, 2010

SQL Server Video Tutorial - Using GROUP BY with Aggregates

SQL Server Training: Using GROUP BY with Aggregates

This video will introduce the GROUP BY.  Scott will show you how you can use the GROUP BY with aggregates.  Scott will also show you how to use SQL error messages to diagnose your queries.

Highlights from this video:

  • Diagnosing queries through error messages
  • What is the GROUP BY?
  • Using GROUP BY with aggregates
  • All aggregates return a many-to-one query
and much more

SQL Server 2008/2005 Query Writing training

This video is part of LearnItFirst's Writing Queries for SQL Server (2005/2008 Edition) training course.

Related Links:

SQL Server training videos

Monday, March 8, 2010

SQL Server Integration Services Training Video - How to Send Emai l Using the Script Task (VB)

SQL 2008 Integration Services Tutorial Video: How to Send Email Using the Script Task (VB)

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

How to Send Email Using the Script Task (VB) (Screencast)

More info about this video:

This video will cover using the very basics of the script task to send e-mail using Visual Basic.  Again, this is just an overview video that will be expanded on in later chapters.

Highlights from this video:

  • Defining Class
  • Script Results
  • Overrides
  • SMTP Client
  • Connection required
  • Delivery methods
and much more

SQL Server Integration Services training video

SQL 2008 Integration Services training

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

SQL Server Integration Services Training Video - An Overview of t he Options for Saving Files: File System, Package Store, and msdb Storage

SSIS 2008 Video Tutorial: An Overview of the Options for Saving Files: File System, Package Store, and msdb Storage

This video will cover how you will actually manage (save and deploy) the SSIS packages.  You will learn different places and ways to store the SSIS packages, and the advantages and disadvantages of each system. 

Highlights from this video:

  • Creating a new package
  • Advantages of the File System
  • How do you send a package?
  • .dtsx files
and much more

SQL 2008 Integration Services training

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

Related Links:

SQL Server Integration Services training videos