Tuesday, 25 August 2009

SSRS Exercises Part I

Reporting Services Tutorials

Creating a SQL Server Data Source and Dataset in SSRS

Dynamic Data Sources in SSRS

Dataset Execution Order

Use Stored Procedure Output Parameters in SSRS
Posted by Siva at 09:09

Saturday, 22 August 2009

Codeplex Utilities

ssisUnit - unit testing framework for SQL Server Integration Services

SSIS Community Tasks and Components
Posted by Siva at 11:53

MDX Queries

More thoughts on stored procedures

MDX Sprocs: Usage

MDX Sprocs and Scripting: An Interesting Example

Sample stored procedures for Analysis Services 2005 and 2008

UDM, New Dimension Types and Analysis Services 2005
Posted by Siva at 11:41

SSIS Exercises Part IV

Tutorial: SSIS Performance Videos

Sending email from SQL Server Integration Services (SSIS)

SSIS Package Configuration in SQL Server 2005

Thorough Package Logging - Some Lessons Learned and Recommendations

Data Flows and Problems with Partial Inserts

StepByStep - SSIS Extract data from multiple Excel worksheets

StepByStep - SSIS Using Package Configurations

StepByStep - SSIS Moving huge amount of files

SSIS Conditional Control Flow

SSIS Dynamic File Name Load

Using SSIS to Transfer Data from a SSAS Cube

SSIS Dynamic Data Driven Extracts
Posted by Siva at 11:31

SSIS Exercises Part III

Upgrade SQL Server DTS Packages to SQL Server Integration Services SSIS Packages

SQL Server Integration Services SSIS Package Configuration

Checkpoints in SQL Server Integration Services SSIS to restart from the point of failure
Posted by Siva at 11:20

SSIS Exercises List - Part II

Using the script task to dynamically build SQL Server Integration Services SSIS package variables

Dynamic Flat File Connections in SQL Server Integration Services SSIS

Deploying a SQL Server 2000 DTS Package vs. a SQL Server 2005 Integration Services Package SSIS

Dynamic SQL Server Integration Services SSIS workflow based on variables

Custom Logging in SQL Server Integration Services SSIS

Passing dynamic parameter values to SQL Server Integration Services SSIS

How To Implement Batch Processing in SQL Server Integration Services SSIS
Posted by Siva at 11:15

Guide to MCITP: SQL Server 2008 Developer

Guide to MCITP: SQL Server 2008 Developer
Posted by Siva at 00:00

Friday, 21 August 2009

Exercises in SSIS - Part I

On Error () Logging by Using Event Handlers

Load Data from multiple Excel files with a single SSIS package

Microsoft SQL Server Community Samples: Integration Services

SSIS 2008 Data Profiler
Check for SQL Agent Job Completion

What’s Happening on SQL Server When My Package Fails

XML Destination Script Component

What’s Happening on SQL Server When My Package Fails?

SSIS: Suggested Best Practices and naming conventions

Interview With SSIS Guru Jamie Thomson

5 Books Every Developer Should Read

The Execute SQL Task

For Loop Container Samples

New SSIS tool on Codeplex – SSIS Log Analyzer

Deep Dive Outline
Posted by Siva at 23:15

BI Start

BI learning from Blogs.

Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

http://blogs.msdn.com/performancepoint/default.aspx

http://blogs.msdn.com/performancepoint/archive/2009/01/12/dashboard-basics-courses-now-available.aspx

http://blogs.msdn.com/performancepoint/archive/2009/01/26/creating-pps-kpis-based-on-ssas-kpis.aspx

http://geekswithblogs.net/darrengosbell/Default.aspx - Business Intelligence, SQL Server

http://nickbarclay.blogspot.com/
Posted by Siva at 13:18
Subscribe to: Posts (Atom)