SQL Server Denali: SSIS New Features/Enhancement - Video Tutorials

Microsoft improved number of existing features as well as added New features for SQL Server Integration Services (SSIS) along with the release of "Denali".

Some of the Enhancements of SSIS are listed here

Migration and Deployment (Clink on the following list to view the Video..)

1. Working with SSIS projects in Business Intelligence Development Studio (BIDS)
2. Using the Deployment Wizard to deploy an SSIS project
3. Import an SSIS Project from the Project Deployment File
4. Import an SSIS Project from an Integration Services Catalog
5. Migrate an SSIS 2008 Project to the Project Deployment Model
6. Configure an Integration Services project using SQL Server Management Studio (SSMS)
7. Running a package using SQL Server Management Studio (SSMS)

SSIS Designer Enhancements 

1. Working with the Data Flow Task’s Source Assistant and Destination Assistant
2. Resolve Column References in a Data Flow Component 

Note: All these Video are taken from Microsoft SQL Server "Denali" Resource Center.

Denali: SSIS Resolve Column References in Data Flow Task (Video Tutorial)

Resolve Column References in a Data Flow Component:

Denali: SSIS Source & Destination intellisense For Data Flow Task (Video Tutorial)

Working with the Data Flow Task’s Source Assistant and Destination Assistant:

Denali: Execute SSIS Package Via SSMS (Video Tutorial)

Running a package using SQL Server Management Studio (SSMS):

Denali: Configure SSIS using SSMS (Video Tutorial)

Configure an Integration Services project using SQL Server Management Studio (SSMS):

Denali: Migrate SSIS Project To Deployment Model (Video Tutorial)

Migrate an Integration Services 2008 Project to the Project Deployment Model:

Denali: Extract an SSIS Project from SSIS Catalog (Video Tutorial)

Import an Integration Services Project from an Integration Services Catalog:

Denali: Extract an SSIS Project from Deployment File (Video Tutorial)

Import an Integration Services Project from the Project Deployment File 

Denali: SSIS Deployment Wizard (Video Tutorial)

Using the Deployment Wizard to deploy an Integration Services project

Denali: SSIS in BIDS (Video Tutorial)

Working with SSIS projects in Business Intelligence Development Studio (BIDS):

Reporting Services Project “Crescent”

Microsoft makes self-service reporting a reality by providing a highly interactive, web-based data exploration, visualization, and presentation experience to users of all levels from business executives to information workers. Now anyone can create a report in just seconds, transform the  shape of data with a single click, add powerful timed animation sequences to quickly identify trends or anomalies, and make a more convincing case through rich presentation of discovered insights.

Project “Crescent” is new features introduced in Denali Community Technology Preview 3 (CTP 3).  "Crescent" is an interactive data exploration and visual presentation experience targeted at Information Workers who need access to their business data but don‘t have the technical knowledge to write their own queries or specialized knowledge around reporting. Built on top of the BI Semantic Model, which provides a user friendly view of the data, Project "Crescent" gives the user a powerful yet simple to use experience for telling stories with their data.

You can find a Project Crescent Overview on Technet.

You can download the release at SQL Server Code Name "Denali" CTP3. This includes ‘Crescent’ Self-Service BI Capabilities.

What is Contained Database in SQL Server

• Contained database is a new feature launched in SQL Server 2011.
• This model clearly separates the database application from the management of SQL Server. 
• Users can connect to the database without authenticating a login at the Database Engine level. 
• Applications within contained databases can be isolated from other databases from the instance of SQL Server, on which they reside, simplifying development and management. 

 A Video Tutorial and a Presentation on Contained Databases:

Books Online - SQL Server Code-Named "Denali"

Books Online includes

• Setup and upgrade instructions.
• Information about new features and backward compatibility.
• Conceptual descriptions of the technologies and features in SQL Server.
• Procedural topics describing how to use the various features in SQL Server.
• Tutorials that guide you through common tasks.
• Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server.
• Descriptions of the sample databases and applications that are available with SQL Server.

Download - Books Online SQL Server Code-Named "Denali"