Is there a way to add resolution steps to each alert definition?

Why not add it into the alert description field?

I have been known to case out sql to provide remediation but it's not the best method.

You could also create a separate remediation table which included alert name, object type, and a remediation note. Join this to the active alerts table in a custom sql report to provide the note based on alert name and object.

You can add a Link to the resolution document (stored in a shared location)  in the alerts description field, which could be accessed by NOC to follow the steps.