SQL Server 2005 Best Practices Analyzer (July 2007) is available

This week we celebrate independence.  No, I'm not referring to Independence Day in the United States.  I'm announcing the official release of SQL Server 2005 Best Practices Analyzer as an independently serviceable tool.

 

What do I mean by independently serviceable?

Software is a rapidly changing industry.  The products that we produce, the scenarios that we enable, and the expectations from our customers all change very quickly.  As all of these change, so do our recommendations and best practices.  When we learn something new, it is important to have an open channel to the customers to share this knowledge.  We will be using SQL BPA as one of the primary channels to communicate our knowledge to our broad customer base.

 

The SQL Server Customer and Partner team is dedicated to learning about how real world customers use our products to power their businesses and sharing this information with the community.  They have released a number of white papers and blog posts.

 

Starting this week, I will be transitioning from the SQL Server Manageability Team to the SQL Server Customer and Partner team.  I will take their real-world experience and knowledge and turn it into a set of rules for BPA.  The new BPA rules will be released independently from Service Packs so that we can help the community with the products currently available without requiring any change to your environment.

 

I recommend that you check out the latest version of SQL Server 2005 Best Practices Analyzer.  If you have any suggestions for improvements to the tool or a rule that would be useful, please submit your idea on Microsoft Connect.

 

Please Note:

  • Uninstall the February 2007 CTP before installing the July 2007 RTW version.

 

Resources:

SQL Server 2005 Best Practices Analyzer (July 2007)

https://www.microsoft.com/downloads/details.aspx?familyid=da0531e4-e94c-4991-82fa-f0e3fbd05e63

 

SQL Server Best Practices

https://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

 

Happy Fourth of July!

 

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server