SQL Server 2005 Best Practices Analyzer (January 2008) — Now Available!

It’s a new year and, with it, we come bearing gifts!  We have a pretty significant update to SQL Server 2005 Best Practices Analyzer.  It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools.  And all…


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…


SQL Connections 2007 (Orlando, FL) — Follow-up

After one heck of a trip to Orlando, FL for SQL Connections, I’m back in Redmond.  Here is a quick re-cap of my sessions and links to session content…   SMS312 — Be More Productive with SQL Server 2005 Tools SMS313 — Deep Dive into Database Mail SMS315 — Solving Common Scenarios with Management Studio Reports…


SQL Server Manageability Webcast – SP2 Improvements – Resources

Thank you to those who attended today’s webcast.  As promised, here are links to the resources associated with the demos. Downloads:SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspxSQL Server 2005 Feature Pack (February 2007): http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en SQL Server 2005 Performance Dashboard Reports: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en SQL Server 2005 Best Practices Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63MVP Custom Reports (e.g. EM Taskpad View): http://blogs.msdn.com/sqlrem/archive/2006/12/19/SP2-Dec-CTP.aspx Community Links:Microsoft…


SQL Server Manageability Webcast – SP2 Improvements

I’ll be giving a webcast in one week on the manageability improvements introduced in SQL Server 2005 Service Pack 2.  Feel free to post questions/comments to this blog that you’d like me to address during the webcast. Date: Tuesday, March 20, 2007 1:00 PM Pacific Time Event Overview In this webcast, we discuss the broad…


SQL Server 2005 Best Practices Analyzer (February 2007 CTP)–Now Available

The much-anticipated SQL Server 2005 Best Practices Analyzer is now available on the Microsoft Download Center.  Thank you all for your input on this blog.  Thank you to the MVPs who have given me early feedback on the utility before it officially went live.  Adam Machanic and I had an email exchange last night covering…


SQL Server 2005 Service Pack 2–Now Available

After working on SQL Server 2005 Service Pack 2 for the past 9 months, I am elated to see it be officially released to the web.  This service pack will not only address the most common bugs reported from customers, but it also introduces some cool new functionality.  I am meeting with Kimberly Tripp today…


SP2/BPA Frequently Asked Questions

I have been getting a lot of questions and hearing a lot of speculation about SP2 and BPA. Let me address some of the most common questions. SP2 When will SQL Server 2005 Service Pack 2 be available?SQL Server 2005 SP2 is currently available as a Community Technology Preview. This is a pre-release (beta) and…


SQL Server Best Practices Analyzer – Webcast – Resources

Resources for today’s webcast.   Webcast: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032306503&EventCategory=4&culture=en-US&CountryCode=US   Upgrade Advisor Tool: http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en   TechNet Webcast: Upgrade and Migration: Planning Considerations for SQL Server 2005 (Level 300) Presenters: Michael Raheem and Euan Garden http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032292288&EventCategory=3&culture=en-US&CountryCode=US   Self-help resources from Microsoft: http://www.MicrosoftELearning.com/ http://msdn.microsoft.com/ http://www.microsoft.com/sql/   Paul A. Mestemaker II Program Manager Microsoft SQL Server


SQL Server Best Practices Analyzer – Webcast

There will be a webcast on Thursday, September 7, 2006 at 9:30am on the next version of SQL Server Best Practices Analyzer.  You can follow the link below to register for the event.  I will try to address the questions and concerns that were brought up in previous blog entries.  If you’d like to ask…