Whenever we use the COUNT function, we invariably use * as an argument to it. It works fine as long as its not joined with another tables. For example, in SQL Sever Pubs database, there are two tables – jobs and employee. If we need to find the number of employees for each job, the following query [...]
Archive for June, 2006
Using COUNT with JOINS…
Posted in Database (SQL Server & Oracle) on June 23, 2006 | Leave a Comment »
Teched 2006 Day 2 (16-Jun-2006)
Posted in Career on June 19, 2006 | Leave a Comment »
Today is my second day in TechEd 2006. Today, I was very selective in choosing the track. So, fairly a good day but for one session.
Session 1: Windows Power Shell : The next generation of Scripting
A good session on introduction to power shell. The concept is very good. Its built up on alias [...]
Agile Chennai User Group Kickoff on 8th July 2006
Posted in Agile on June 15, 2006 | 1 Comment »
I am very much fasciated by Agile. Chennai for a long time didnt have an user group on Agile. I am now in the process of forming an User Group. The idea is the bring together a group of like minded people and meet regulary and learn more about Agile.
We are having a Kick off [...]
Teched 2006 Day 1 (15-Jun-2006)
Posted in Career on June 15, 2006 | Leave a Comment »
Today I went to Teched 2006. Its a two day event and it was held in Chennai Trade Center.
I attended the Developer track. Its fairly a good day. Of the five I attended today, I didnt like 2. I feel that two were more towards marketing the product and so not very informative. Here are [...]
Basics of Object Modelling…
Posted in OOPS on June 6, 2006 | 3 Comments »
Whats Object Modelling?
Object modelling is about creating a blue print of the software system that is to be constructed from objects.
There are many object modelling methodologies. Typically a modelling methodology consists of following three components
1. Process : The how to steps for gathering requirements and determining the abstraction to be modelled. There are many proceses [...]
