SQL Server Videos


SQL Server Videos

 Here is link for different video’s : Click …

Leverage Microsoft Attunity Connector for Oracle to enhance Package Performance

How to create, modify, execute, save, and open a query with the database manager for SQL Azure?

How to create and modify a table with the database manager for SQL Azure?

How to create, select, and modify a view with the database manager for SQL Azure?

How to create, modify, and execute a stored procedure with the database manager for SQL Azure?

Import Data Into Master Data Services

PowerPivot Data Refresh in SharePoint

Using PowerPivot Workbooks as a Data Source

Security Context of PowerPivot Connections in a Farm

How to create, modify, and execute a stored procedure with Project Houston?

How to create, select, and modify a view with Project Houston?

How to create, modify, execute, save, and open a query with Project Houston?

How to create and modify a table with Project Houston?

How Do I: Optimize SQL Server Integration Services?

How Do I: Render reports to a wide-range of formats?

How Do I: Create an gallery of reusable report parts?

Creating a Basic Package (SQL Server Video)

Designing Your SSIS Packages for Parallelism (SQL Server Video)

How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)?

How to: Call a Web Service by Using the Web Service Task (SQL Server Video)? (Learn how to call a Web service successfully from an Integration Services package by configuring an HTTP connection manager and the Web Service task. Then, set up an XML task to read the information that you have retrieved, and use that information in the package.)

Exporting SQL Server Data to Excel (SQL Server Video) (This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet.)

How to: Use the Data Profiling Task (SQL Server Video)? (Learn how to use this powerful new task in SQL Server 2008 to become familiar with an unfamiliar database, or to look for problems in existing data. Take a quick look at all eight of the profiles that the task can compute.)

 

Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) (

This video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance: 1) How the limits of the source system affect performance; 2) Why disk I/O is important; 3) Why you should establish a package performance baseline.)

Advertisements