Friday, November 28, 2008

Mumbai rocks again...

What the hell is going on in Aamchi Mumbai ?
Have people become so ignorant that they no more care about the lives of thousands of innocent people dying each day due to terrorism. As we saw last time after the local train bomb blasts life resumed in a day. People were more than happy to travel in locals the very next day and were even more proud to say that life is back to normal again as if nothing has happened. This time it was a group of self proclaimed JIHADIS who killed hundreds of innocent people for no gain. How do they think this is going to help them ? Their mentality puts a thinking person in dilemma everytime they create havoc. Why would one embrace death after killing ten or hundreds of people which he dont even know ? Our politicians as usual are pointing fingers to each other or some foreign nation they say. When will our diplomatic officials realise that this is no solution to terrorism. Finishing them is the only solution as was shown by KPS Gill in Punjab.
God save India now...

Wednesday, November 26, 2008

Creating your own Dashboard for Mercury Quality Center in Excel using OTA.

There are very few things which amaze me... OTA is one of them.
It gives such flexibility and easy adaptibility that we can make use of same and create a whole new software for ourselves.
I would start listing a few things Ihave done using OTA in coming days. Comments are always welcome and Iwould be more than happy to help you guys out there.

Tuesday, November 25, 2008

Creating two databases in sync...

We had this unique requirement of having two different tables in two different databases on two different DB servers in sync. (Too many differences huh...)
We created the same in a span of 2 days starting from scratch. We started with creating local triggers for Insert, Update and Delete which would dump the INSERTED / DELETED data in a temporary physical table on same DB server. Then we created stored procedures which would pull data from the remote temporary table and dump the same in local table. (Not the local temporary table.).

We used the Managed Application feature in SQL Server 2005 to run the stored procedure after a fixed interval of time. We did this to avoid updating data on remote Database directly using triggers.

Last but not the least the databases remain out of sync for the time indicated in Managed Application.