Thursday, August 28, 2008

Microsoft BI sites

http://www.microsoft.com/sql/technologies/reporting/default.mspx

http://www.microsoft.com/sql/technologies/analysis/default.mspx

http://www.microsoft.com/sql/technologies/dm/default.mspx

http://www.microsoft.com/sql/technologies/integration/default.mspx

Thursday, August 7, 2008

Sql Server 2005 DMV's

Some interesting DMV's in SQL SERVER 2005

sys.dm_tran_locks
sys.dm_exec_cached_plans
sys.dm_exec_query_plan
sys.dm_exec_sessions
sys.dm_tran_session_transactions
sys.dm_exec_requests