MCTS - I passed the 70-445 exam!

Hi All,
I feel happy to inform you about today I cleared 70-445 exam with 89.9%!!!!!!!!!!!!!!!!!!
;-)
Rav’s

SSIS-Webservice && XML Task - Usage

Hi,
Its a good video to know the usage of Webservice task in SSIS.
http://technet.microsoft.com/en-us/library/cc952927.aspx
In this video, you learned how to call a Web Service by using the Web Service task.
You also learned how to:
Configure an HTTP connection manager.
Configure the Web Service task itself.
Download the WSDL file that describes the Web service.
Call a Web method and supply the expected input values.
Read the return value by using an XML task.
And, use the results from the Web service in the package.
Thanks,Rav's

MSBI-'08 Videos=>> Setup '08,SSIS,SSAS,SSAS-Data Mining,SSRS

'n Joy ;-)
http://technet.microsoft.com/en-us/library/bb418446(SQL.10).aspx

MSBI - Useful Videos

http://siddhumehta.blogspot.com/2009/07/few-more-ssis-ssas-and-ssrs-video.html
http://siddhumehta.blogspot.com/2009/12/microsoft-business-intelligence-ssis.html

SSRS-Table Vs Matrix

The report type defines the structure, or data region, of the data returnedby your query. The Report Wizard lets you present this information as eithera table or a matrix, though you have more options outside the wizard. Themain difference between these two types of data regions is the number ofcolumns. A table has a fixed number of columns; a matrix has a variablenumber determined by the query results.
More Details:
http://technet.microsoft.com/en-us/library/ms157334.aspx
http://www.bronios.com/index.php/2008/04/28/ssrs-performances-matrix-control-vs-table-control/

SSIS-Transactions usage

Use the below Link:
http://www.mssqltips.com/tip.asp?tip=1585

SQL SERVER – Nth Highest Salary

It's good one ;-)
http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/

SSIS - How to read vaiable values directly from Table

Hi,
We have different ways to get the data from DB table to SSIS variables.
1.using Foreach loop container with ADO Enumerator option.2. Configurations like XML config,parent pakcege
Here we discuss with Script task takes the data fro mDatabase to local SSIS-Variables.
http://blog.boxedbits.com/archives/8

SSIS-Performance Tuning Techniques(SSIS Engine Overview,BlockingExecution Trees, Buffer Sizing, Parallelism)

Hi Performance tuning is very important one as a process of data loading using ETL tools.
When you architect data integration solutions, your design decisions not only determine how successfully your solution meets functional requirements, but also how well your solution meets performance requirements. To make the right performance design decisions, you need to understand the performance architecture of your data integration tool and, just as importantly, the techniques that enable you to maximize the tool’s utilization of system resources such as memory and CPU.
Microsoft® SQL Server™ 2005 Integration Services (SSIS) provides full-featured data integration and workflow engines coupled with a rich development environment for building high-performance data integration solutions. SSIS provides a variety of optimization opportunities to help you maximize resource utilization while successfully meeting the needs of your specific data integration scenario.
http://msdn.microsoft.com/en-us/library/cc966529.aspx

http://shujaatsiddiqi.blogspot.com/2008/08/performance-improvement-of-sql-server.html

SSIS-Parallel Execution

Hi,
this is important one to achieve parallel execution using SSIS.

http://shujaatsiddiqi.blogspot.com/2008/10/ssis-multithreading-parallel-execution.html

SQL SERVER-Rebuild Indexes AND Update Statistics

Hi,
Rebuild Indexes and Update statistics is very important to improve the performance of the data.
SQL SERVER 2005 uses ALTER INDEX syntax to reindex database. SQL SERVER 2005 supports DBREINDEX but it will be deprecated in future versions.When any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. DBCC DBREINDEX statement can be used to rebuild all the indexes on all the tables in database. DBCC DBREINDEX is efficient over dropping and recreating indexes.
Execution of Stored Procedure sp_updatestats at the end of the Indexes process ensures updating stats of the database.
We have 2 good scripts to implement to achive our requirements.
Please have a look into this:
http://weblogs.sqlteam.com/tarad/archive/2006/08/14/11194.aspx

http://blog.sqlauthority.com/2007/01/31/sql-server-reindexing-database-tables-and-update-statistics-on-tables/