Sunday, January 30, 2011

Vehicle Routing Problem

Goal:
  1. Come up with a close to optimal solution to Vehicle routing problem related to Cab Management system which can be arrived at linear space and time
  2. Finally publish an article on it.

Create a Facebook App (done)

Goal:
  1. Create a Facebook App.
Done:
  1. Created a small app for QwestIndia site at Facebook named Job 'Openings'.
  2. It pulls data from our Qwest India site: Current Opening's Page .
  3. Its a simple .NET app on Qwest India site which publishes the Current Openings Page at QI site in raw restricted format of HTML allowed by FB.
  4. Details about it is available at FB developers site for Canvas.

Facebook Album Downloader

Goal:
  1. Write a .NET/Java app which can download albums from Facebook.
  2. Port it to Android :)
  3. Publish it

Authentication of WCF services using IIS/AD

Goal: Should write a comprehensible article of WCF Bare webhttp services with authentication with code

TODO's

I was planning to maintain a list of TODO's and was looking for something good to maintain it.
The GMail task list, Outlook task list are pretty basic. Others available will need me to maintain a new account.
So used this blog to maintain it.
Posts labeled as TODO is a todo :)

Tuesday, January 4, 2011

Find locks in Oracle Tables

A lot of time we as developers see Oracle tables being locked. As we all share one dev database, the reason might be some long running query or service on some other workstation.

An easy way to find it out is through a query:


SELECT s1.username
'.'
s1.program
'@'
s1.machine
' ( SID='
s1.sid
' ) is blocking '
s2.username
'.'
s2.program
'@'
s2.machine
' ( SID='
s2.sid
' ) '
AS blocking_status
FROM v$lock l1,
v$session s1,
v$lock l2,
v$session s2
WHERE s1.sid = l1.sid
AND s2.sid = l2.sid
AND l1.BLOCK = 1
AND l2.request > 0
AND l1.id1 = l2.id1
AND l2.id2 = l2.id2

Tuesday, August 10, 2010

Seattle - Seafair Parade and visit to USS Port Royal

This weekend saw the Airshow as part of the Seattle Seafair. Videos are available in the site : http://www.seafair.com/weekend/airshow/. The start was boring but when the F-18's came, it was good. They were so fast that even when they reached the center show point, there was no sound (as it was trailing behind). So if one is not focused, then he can miss half of the show. That was followed by the thundering engine noise. Once it passed over our head at like 1500 feet (500 mts) and it was deafening. Saw in the news later that some windows in nearby house broke due to it.




Followed that, we had a visit to USS Port Royal. More about it in here. One of the last of its kinds, it had some big 5 inch guns, and house Tomahawak Cruise Missiles and had a stealth coating in it. It was a guided tour for 1 and half hours but was worth it. Built in 1994, it still had Windows 95 as OS for one of its radars :) - and we blame India for carrying legacy systems.