You select a tag, select "Newest" and then manually refresh the page. For instance: https://stackoverflow.com/questions/tagged/sql

On the home page you can manage a list of "Watched Tags". If you add SQL it gives you a bookmark to the page I linked above.