Hot topics to work on in SQL 2008

Posted by Deepak Kumar | Posted in SQL DBA | Posted on 02-07-2010


    I am working on some of following topics that are considerably new in SQL 2008. Leave a comment, if you have more topics like these or experience to share with us?

  • Prepare a Audit script using SQL 2008 feature for High, Moderate or Low category servers

  • Setup a Central Management Servers

  • Standardize & implement Data Collector and Management Data Warehouse for High category SQL Servers

  • Implement Data Compression to reduce the size of your VLDB

  • Apply policy based management for all DB Servers in your organization

  • Distribute your high volume application’s workload, T-SQL streams using resource governor

  • Use TDE in your environment

© 2010 Increase your website traffic with