I've actually broken these queries up into separate blog posts, so here are the links to the individual posts where you will find the queries.
Exposing SQL Server DMV Data to Developers and other non-DBA Users
Using DMV's to Find SQL Server Connection and Session Info
Which Statements Are Currently Running in my SQL Server Database
Finding the Most Expensive, Longest Running Queries in SQL Server
Analyzing Index Usage in SQL Server
(Contains queries for both missing indexes and index usage stats)