Yesterday I learn saw buck Woody’s Webcast on 1032391435_Real-World DBA Improvements for SQL Server 2008 .Its great.
1.Manage by Policies: Like if we want to restrict the policy as all store procedure should start with ups_ we can manage this. we can manage compliance
2.Manage with insight: Management warehouse database,
3.Manage interactivity:Activity monitor, Object search, windows power shell, T-sql intelligence, multi-server queries, T-sql Debugger.
*Activity monitor will not work for sql server 2000 and old servers.
Thanx Buck woody… it was great.