Cluster Upgrade (SQL Server 2008 R2–> SQL Server “Denali”)

In this blog, I will cover how to upgrade a SQL Server 2008 R2 cluster to the next version of SQL Server called “Denali”. The version of Denali that I am using is a build before the final CTP3 release. The process and dialogs should most be unchanged when the final version of Denali releases….


Installing SQL Server 2008 Best Practice Analyzer (BPA) on a non-domain machine

When installing SQL 2008 R2 BPA on a machine that is not connect to a domain, you may see the following. To verify you are hitting the know issue with the BPA installer trying to enable PowerShell remoting, run the following command to generate an installation log. msiexec /i {full path to BPA MSI} /l*v…