avoiding cursors

There is some controversy about using cursors in TSQL.  Overall, I believe they tend to tie up resources and are seen as bad.  So how do you get around using them?  Here’s how.