Tuesday, June 17, 2008

Dasavatharam (Tamil)


We travelled to San Jose (about 40 miles away) from San Ramon (where I am residing) to watch Dasavatharam (tamil movie). The movie was running in ‘Century Berryessa 10’ theatre @ San Jose and we watched the 5.30 PM show on June 14 2008.

Cast: Kamal Hassan (in 10 roles), Asin, Mallika Sherawat, M.S.Bhaskar, Napolean, Jayapradha
Music: Himesh Reshammiya
Camera: Ravi Varman
Direction: K.S.Ravikumar

Review
Kamal Hassan’s magnum opus Dasavatharam ends up setting a new benchmark for Indian films. Tamil cinema has entered a new era with Dasavatharam. All in all, Dasavathaaram is an extraordinary movie by Kamal and his team.
It’s an awesome movie!! This is really a Kamal’s achievement. Kamal has played all the 10 roles superbly and I am sure he will reap the benefits of his hard work. The characters of Vincent Poovaragan, Balram Naidu and Krishnaveni Patti (Kicha Patti) done by Kamal stand out!! I really liked the first 15-20 minutes of the movie and the climax part where they showed the replica of Tsunami. The CG team has done a splendid job for the graphics shown all through the movie.

The musical score by Himesh Reshammiyya is bad except for one song.."kallai mattum kandal.." Back ground score by DeviSri Prasad is good!
My gut feels that AR Rahman would have scored a very fantastic music for the theme Kamal and the director has taken but it’s all a matter of time.

The love scene in the last scene was totally unnecessary! One can’t imagine such feelings when a disaster like Tsunami is happening in the background!!

What was the need for Tamil Subtitles if they dont translate NaCl as salt?! Kamal explains George Bush that NaCl is sodium chloride, but who will explain the masses that sodium chloride is just plain salt?! I am sure many people wont understand the link between Tsunami and the movie if they don’t know NaCl is nothing but "Uppu"!!

A must watch movie.

Applause to "Sagala kalaaa vallavan"!

Monday, June 16, 2008

When was a SQL Server SP or Table or View last altered?

You can get the created date and last modified date of Stored Procedures, user created tables and views using the following queries in SQL Server 2005.

Stored Procedures:
SELECT [name], create_date, modify_date
FROM SYS.Objects WHERE type='P'

Alternatively you get can use the below query to get the same information
SELECT [name], create_date, modify_date FROM sys.Procedures


Tables:
SELECT [name], create_date,
modify_date from SYS.Objects WHERE type='U'

An alternate query
SELECT [name], create_date, modify_date FROM sys.tables


Views:
SELECT [name], create_date,
modify_date FROM SYS.Objects WHERE type='V'

An alternate query
SELECT [name], create_date, modify_date FROM sys.views


Of course, in all the above queries you can add a WHERE clause to limit the results. Something like

SELECT [name], create_date, modify_date
FROM sys.views WHERE modify_date > DATEADD(day,-30,GETDATE()) Order By modify_date DESC


Remember catalog views were first introduced in SQL Server 2005, so these queries will not work in SQL Server 2000.