Where can I find scenarios to work through T-SQL I've been working through the exam guides for the new 70-461 MCSE data exams and i'm at a point where I want to practice my T-SQL.  Does anyone know of any good resources whereby scenarios are posed and you have to create a solution through practice.  For example, when I learned C# I would work towards a goal of creating a certain type of system or project like a web app or a console app that did a certain thing.  I'm struggling to come up with test scenarios to improve my T-SQL experience because I don't have a frame of reference for what professionals in SQL do in their day jobs.
You could try to answer query-related questions here or on Stack Overflow. The nice thing about this is that you are solving real problems, not made-up ones, and you can also gain knowledge by seeing how other folks solve those same problems. You're also helping folks, potentially.