Create and Modify Reports Using the Report Builder Tool

This video shows us how to use SQL Server 2008 Business Intelligence Studio to create a report model. We then use the report model and the Report Builder tool to create a report. The report is saved to the SQL Server Reporting Services reporting site where it can later be run or modified by other users who want a slightly different report.

Download Video

Length: 20 Minutes 41 seconds

Create a Report with Visual Studio 2008 and Deploy it to SQL Server Reporting Services 2008

This video shows how to build a report using Visual Studio 2008 and then deploy it to SQL Server Reporting Services.

This demo shows how to:

Create report project in Visual Studio

Create an shared data sources

How to design a report

How to add interactive sorting

Change the project settings to deploy the report

Deploy the report

Run the report in SSRS

Download Video

Length: 9 Minutes 7 seconds

Enable Transparent Data Encryption

This video shows how to use the transparent data encryption (TDE) feature of SQL Server 2008 Enterprise Edition. In addition to showing how to create the keys and certificates necessary to enable TDE, the AdventureWorks sample database is encrypted. After encrypting the database, the effect encryption has on your server is dicussed and what happens with database restores when the proper keys are not available is demonstrated.

Download Video

Length: 19 Minutes 41 seconds

Using the Database Engine Tuning Advisor

Ensure top performance by using the Database Engine Tuning Advisor the database any workload can be analyzed for changes to the database that will increase performance. By taking advantage of the database engine tuning advisor, administrators can reduce the amount of time they spend analyzing the database to increase performance. Watch this video and know how to use a SQL script as the input to the database engine tuning advisor to determine how to increase performance in certain tables in the Adventureworks sample database.

Download Video

Length: 13 Minutes 42 seconds

9cqau7pt2n

9cqau7pt2n

Setting up a Maintenance Plan to Backup Databases

Create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). This video also shows you how to customize plans that were created with the wizard.

Download Video

Length: 14 Minutes 29 seconds