Microsoft has been doing a great job at releasing new best practice analyzers. They have now released one for SQL Server 2008 R2. The analyzer will look at things like event logs, permissions, and SQL metadata. The BPA will provide recommendations for any warnings or problems. You can download the BPA by following the link below.
BPA For SQL 2008 R2
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
The latest version of the Case Of The Unexplained by Mark Russinovich has been released on the Microsoft Tech Ed website. The case of the unexplained allows you to see how Mark walks through issues step by step to resolve them. Mark uses Microsoft Debugging Tools along with his own tools from Sysinternals. This sessions continues to be one of the most popular sessions at Tech Ed.
Case Of The Unexplained 2010
http://www.msteched.com/2010/NorthAmerica/WCL315
Windows 7 adds a great new security feature called UAC. There are certain situations where you have to disable UAC which you can do by following the below steps.
1. Open control panel by going to the start menu -> Control Panel
2. From the control panel select User Accounts And Family Safety
3. Select User Accounts
4. Select Change User Account Control Settings
5. Move slider bar to the bottom so it is at never notify. Then click OK.
