Each has its own advantages and disadvantages. I for one enjoy using MySQL because it also offers a free edition and it is also light-weighted on the system and it pretty easy to integrate it with any php site.

So whats yours favorite? Mysql or MSSQL Server