Tuesday, October 7, 2008

Who Needs a DSLR?

If I could shoot a picturesque sunset in Boracay using a point and shoot digital camera.

Fujifilm Finepix s5800
aperture : F/9.8
shutter speed: 1/512 sec.
focal length : 81mm
ISO 64

or this preset macro settings.

Fujifilm Finepix s5800
aperture : F/3.5
shutter speed: 1/91 sec.
focal length : 9mm
ISO 64

and another one taken from a park in Tayabas.

Panasonic DMC LS-1
focal length : 6mm
ISO 100

Sunday, October 5, 2008

Risk Management in Systems/Software Development

I have been commissioned by the City of Tayabas to manage the computerization of various systems of the local government unit. Part of managing the project is constant reporting to the project champion and I have been asked to deal with the risks that may occur.

Since risks in software development is inevitable, I have here basic guidelines that you might consider of using.

First thing to do is to assess. Enumerate the risks according to the probability of occurence. Rank them from the most to least dangerous taking into consideration of its possibility to happen.

Second is to control. Make another list on how to mitigate and probably control these risks. There must be a sound strategy. Come up with a technique appropriate to the identified risks and implement it accordingly.

Common risks are as follows;

1. Technical personnel shortfalls and uncooperative users.
2. Schedules and budgets.
3. Continuing stream of requirements changes. This is the old requirements creeping syndrome.
4. Developing incorrect user interfaces, functions and properties.
5. Gold plating. This is where the project team add functionalities and features to the product which is not called for.

I will be posting thourough discussions on this topic in qtechbpo.com website.

JOIN in SQL Data Manipulation Language

JOIN is a predicate in SQL's data manipulation language. This is primarily used in combining tables or relations to derive a new table.

We combine tables to create a query that will require information from more than one table.

Example of simple join query:

SELECT url.urlid, name, companyname
FROM url, company
WHERE url.urlid = company.companyurlid AND company.companyurldesc LIKE 'tayabas.ph'

I will post more on this topic later.