MySQL eye for an Microsoft SQL Server guy

As I've been porting Subtext to MySQL, it's been a learning experience. I've come to both marvel at MySQL's simplicity and tear my hair out at the maddening insanity of half-implemented features. I go back and forth between saying "SQL Server should have done this" and "SQL Server had this in 1997, why can't these guys".