Table: manager_changes_0809
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

Question: Who was the outgoing manager of the Heart of Midlothian?
SQL: SELECT "outgoing_manager" FROM manager_changes_0809 WHERE "team" = 'heart of midlothian'

Question: What is the vacancy date of Dundee?
SQL: SELECT "date_of_vacancy" FROM manager_changes_0809 WHERE "team" = 'dundee'

Question: Who was the outgoing manager that was replaced by Tony Mowbray?
SQL: SELECT "outgoing_manager" FROM manager_changes_0809 WHERE "replaced_by" = 'tony mowbray'

Question: What date was Dundee appointed?
SQL: SELECT "date_of_appointment" FROM manager_changes_0809 WHERE "team" = 'dundee'