This expression is used as a way to convey routine, as a song and dance performance is often known as a routine.
Friend: What are you up to today? Me: The usual song and dance.