SQL Aloha

Policy-Based Management

If SQL Servers are treated as ‘islands’, each with their own subtly different configurations, managing multiple instances of them can be a frustrating experience for the DBA. SQL Server 2008’s policy-based management aims to help us enforce policies for SQL Server instances throughout an organization. In this article, I look at what policy-based management is, how to implement it, and how to check it is running. Read more…

Be Sociable, Share!

• 

1. Management Studio Improvements in SQL Server 2008
2. How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data Collector
3. SQL Server Database Maintenance Checklist
4. How Do You Defragment Your SQL Server Indexes
5. SQL Server Instance Checklist