Strategies for Testing Data Warehouse Applications

When i surfed on internet i found some usefull article writen by Jeff Theobald. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.

Read to obtain further information
http://www.datawarehouse.com/article/?articleid=7331

How to find identiy column of the tables

If you want to know identity columns of the tables of SQL Server, you can use this query;

select o.name as TableName, c.name as ColumnName
from sys.columns c, sys.objects o, sys.schemas s
where c.object_id = o.object_id
and o.schema_id = s.schema_id
and c.is_identity = 1
and o.type_desc = 'USER_TABLE'
and s.name = 'dbo'
order by o.name

This query is usefull when migrating the database from old one. This query search all the user tables not system tables.

An Introduction to Eclipse for Visual Studio Users

Sometimes i think that i should start to learn JAVA. But i couldn't begin unfortunatelly. You may know eclipse is a platform to develop applications with java. i found an article about eclipse. It's a usefull text for visual studio users.

http://www.ibm.com/developerworks/opensource/library/os-eclipse-visualstudio/?ca=dgr-btw01Eclipse-VS