Merger of Seagate and Maxtor

Two of the largest hard drive manufacturers today announced a planned merger worth $1.9 billion. Subject to obtaining shareholder approval as well as regulatory, the combined company would find Seagate acquiring Maxtor. Read more...

Multiple row insert of data in a single database call

Yesterday one my friends asked me how to insert data of an xml document in to the SQL Server 2000. He was looking for the best method to do that. And he mentioned about OpenXML to do that.

What’s the heck this OpenXML???

OPENXML is a Transact-SQL keyword that provides a rowset over in-memory XML documents. OPENXML is a rowset provider similar to a table or a view. OPENXML allows access to XML data as if it is a relational rowset by providing a rowset view of the internal representation of an XML document. The records in the rowset can be stored in database tables (similar to the rowsets provided by tables and views).



You can find more info at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_94mk.asp

Check out these links also...
Insert Data into SQL 2000 Using OpenXML & ADO.NET
Inserting XML formatted data into SQL Server 2000
Use OPENXML to Minimize SQL Server Database Calls

Migrating from Microsoft SQL Server and Access to MySQL

Now MySql is using everywhere because of it is open source and Cross-Platform. So sometimes it is not a wonder that we have to convert our existing MS databases to MySql. Last night I found that this article by Mike Hillyer is really good because it is discussing not only methods to convert but advantages and disadvantages also.

Check this out.

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

Ganja plantation in parliament

Army commandos who were in searching the Parliament premises for security reasons had spotted abundantly growing Cannabis plants in a garden located on the second floor near the 'Odeon Hall' where only members of parliament could gain access.

Following an immediate probe, parliament staffers have been questioned since no outsiders are allowed to enter the area.

I wonder why MP’s haven’t been questioned in this incident since they are also visitors there. :)

When Google will go to next level?

Yesterday when I was trying to log into Google talk it gave me an error saying that my password is incorrect. I tried several times and then it’s got locked. I’m death sure that I entered password correctly. I think that cause by a bug or sth… This has happened couple of times to me.
Gmail is also behaving unexpectedly sometimes. Still yahoo mail is better than Gmail. Yahoo never gave me errors.

Now it’s quite long time that Gmail is hanging around in it beta stage no? mmm when Google will go to its next level?

Our boyz @ Excel world

Rear row:
Me,Asela,Buddhima,Sumudu,Dinesh

Front row:
Panduka,AJ,Nalinda

These are the guys who are rocking KandySoft...(few are missing Anuradha, Nalin, Gogula & Sanjaya)

Looks like SWAT team ha...:)

Interviewing

Well… Mahasen had an opportunity of interviewing people at virtusa recently.
I was also interviewed by virtusa and failed about 2 years ago :)
Main reason was hadn’t got any idea about the interview. Hadn’t got prepared etc…

Anyway if you are on job hunting these days I recommend you to read this.
Its worth to read since there are really good points.

http://mahasen.blogspot.com/2005/12/interviewing.html

How serious are you about audio?

Are you serious about audio?
Check this site out.

http://www.sonicflare.com/

It’s got daily updates on supper speakers, Home Theaters and the Digital Audio Revolution.

Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error

Last night I tried to pay my internet bill online. Actually it’s a Lankabell CDMA phone bill since I have dedicated that to connect to the internet.

As usual it’s a damn slow connection so I couldn’t complete the payment. So there was a message saying that I can not complete the payment and a back button. I clicked that back button and what happened? It gave me “Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error”. :)