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…


Reducing Database Size by Using Vardecimal Storage Format

In addition to the improvements to the management tools in Service Pack 2 that I’ve outlined on this blog, the engine team has introduced the VarDecimal storage format.  They have just published a whitepaper on how to reduce your database size.  Check it out: http://msdn2.microsoft.com/en-us/library/bb508963.aspx. Paul A. Mestemaker IIProgram ManagerMicrosoft SQL Server Manageability


How do you like to learn? *or* SQL Server Agent Proxy Accounts

One of my favorite parts of my job as a Program Manager is evangelizing our products.  I love teaching people how to be more effective by introducing them to new features or tying many existing features together in an end-to-end scenario. I like to learn about technology and I’d imagine that the majority of my…


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 Performance Dashboard Reports — Now Available!

Have you ever noticed one of your SQL Server instances running unusually slowly? Have you had difficulty quickly identifying what areas could be affecting its performance? One of our customer support Escalation Engineers, Keith Elmore, specializes in understanding these types of problems.  He has worked with customers all over the world on diagnosing their toughest and most…


Maintenance Plans Changes — Knowledge Base Article

For all of those who are coming to my blog looking for the latest Maintenance Plan information, please visit: http://support.microsoft.com/kb/933508. In short:* We’ve released a refreshed version of the service pack without the Maintenance Plan bug* We have released a patch that can be applied to users who have installed the initial release of SP2…


Maintenance Plan Changes in SQL Server 2005 SP2

Update (2007-Mar-06): http://blogs.msdn.com/sqlrem/archive/2007/03/06/Maintenance-Plan-Changes-Update.aspx   Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools.   Who is affected?   You are affected if you use SQL Server 2005 maintenance plans, those plans include a History Cleanup Task or…


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…