Thanks to the help of everyone here at these forums I have gotten a large part of my site customization done. Recently, I was reading about using multiple loops to do various things. Reading up, and asking the right questions (and most importantly, getting the right answers from this community) have led me to write a tutorial on how I created my own version of a sticky or adhesive post -- one that stays at the top of the index page.
Essentially, it queries the DB twice: first looking for 1 post (the most recent) in the 'featured' category; and secondly, all posts except the post 'featured'. This allows the featured post to be put into multiple categories just like any other post could be, yet treats it as special until a new 'feature' post is published.