Now is time to try SQL 2008

SQL Server 2008 is just around the corner. SQLCAT has been working with our customers and partners implementing pre-release builds. We have a lot good lessons learned to share, here are some of the upcoming best practices papers:

· Index Defragmentation Best Practices

· Best Practices for using Resource Governor with a mixed (OLTP and Reporting) workload

· Data Compression: Design and Implementation Best Practices, Performance Impact

· XEvents Toolkit

· SQL 2008 Usage-Based Optimization Efficacy (subject to name change)

· Scale Out Querying with Analysis Services 2008

· Best practices for Data Warehousing in SQL Server 2008

The latest version community technology preview (CTP6) includes many exciting new features like filtered indexes, sparse columns, data compression, Microsoft sync, integrated full text search, Report rendering in Microsoft Word, Data visualization enhancement and the first feature pack. Now is good time to see it yourself! Go here for instruction on how to download.