I'm very happy with my Desire S. Here's how I changed my alarm notification.
Calendar
Settings
Reminders
Select Ringtone
Check Vibrate (if wanted)
Different notification tones can be set for SMS, GTalk, Default, Alarm.
Volume under Settings of the main menu.