Systems Engineering and RDBMS

Archive for April 3rd, 2008

TFS (Team Foundation Server)

Posted by decipherinfosys on April 3, 2008

TFS is the heart of the Team System and helps to tie together all the resources and the activities that are involved in the application life cycle. If you are new to TFS, here are some good resources to use to get up to speed:

Microsoft Site:

Guide to Team Build:

Community Site: Team System Rocks:

Community Site: TFS Times:

Add-ons for TFS:

TFS Power Tools:

In a very simple 50,000 ft. overview, TFS does all of these:

  1. Version Control: Bye-Bye VSS (Visual SourceSafe) – we will blog in the coming days the differences and advantages of TFS over VSS,
  2. Automated Builds for applications and databases,
  3. Reporting – SSRS (SQL Server Reporting Services) reports are integrated since the data store is SQL Server 2005 and higher up,
  4. Full integration with Visual Studio,
  5. Handles bugs, requirements and tasks, and
  6. Uses Analysis Services for enhanced reporting.

From an installation perspective, it requires:

  1. Windows 2003 – IIS 6.0, .Net Framework 2.0/3.0/3.5, Sharepoint Services (WSS).
  2. SQL Server 2005 – Standard/Enterprise Edition: Make sure to install SSRS and SSAS.

In the days to come, we will blog about the different feature sets.

Posted in Technology | Leave a Comment »

Multi table insert in Oracle

Posted by decipherinfosys on April 3, 2008

This feature has been available in Oracle since 9i. You may or may not have used it in your work. Here is an example:

create table TAB1 (COL1 NUMBER(30), COL2 NUMBER(30) );

Table created.

create table TAB2 (COL3 NUMBER(30), COL4 DATE);

Table created.


Sequence created.

when mod( object_id, 2 ) = 1 then
into TAB1 ( COL1, COL2 ) values ( test_seq.nextval, object_id )
when mod( object_id, 2 ) = 0 then
into TAB2 ( COL3, COL4 ) values ( test_seq.nextval, created )
select object_id, created from all_objects

The benefits are obvious – you run the select statement only once in a multi-table insert i.e. you incur the cost of the select statement only once as opposed to twice in the example above since if they were 2 statements, the cost incurred would have been twice – once for each insert into…select statement. There are variations to this statement like the “Insert All”…it takes the form:

insert all

into ….
into ….
select … from tableX;

You can read up more in Oracle docs here.

Posted in Oracle | Leave a Comment »