SQL Server 2000 Best Practices Analyzer

Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices. These best practices typically relate to the usage and administration aspects of SQL Server databases and ensure that your SQL Servers are managed and operated well.

Download bpasetup.msi

Visual Studio crash when adding items to the toolbox

When I tried to adding items to toolbox thru Visual studio 2008 IDE, then my visual studio has closed automatically. 

I tried many times, but I faced the same issue. I searched in Google and I got many solutions, but nothing is helped me and many people replied that it helps others, I placed the solution here. It may help you
Solution1:
Reinstall add ins by Visual Studio commands
1. devenv /setup
2. devenv /resetuserdata
3. devenv /resetsettings CSharp


Solution 2:
devenv /safemode


Then use Choose Items on toolbox and run through each of the tabs. Once you accept any exceptions raised on loading controls, you can then open Visual
Studio normally and add items.


Solution 3:
If your system contains PowerCommands installed, then


This is taken from
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/e2434065-9921-4861-b914-9cc9d6c55553/


Through Microsoft's help they came up with a work around which is a simple modification to the devenv.exe.config file.


This will exist in (64 bit systems) C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE 
Or (32 bit systems) C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE


Add this XML token to the dependentAseembly list. They had me add it after the office one, but im not sure if that matters.

<dependentAssembly>
<assemblyIdentity name="office" publicKeyToken="71e9bce111e9429c" culture="neutral"/>
<codeBase version="12.0.0.0" href="PrivateAssemblies\Office12\Office.dll"/>
</dependentAssembly>
<!-NEW STUFF-->
<dependentAssembly>
<assemblyIdentity name="Microsoft.PowerCommands" publicKeyToken="null" culture="neutral"/>
<codeBase version="1.1.0.0" href="C:\Program Files (x86)\PowerCommands\Microsoft.PowerCommands.dll"/>
</dependentAssembly>

Now you should be able to run PowerCommands with VS 2008 SP1 and XAML with no crashes. I guess there will be a fix when the next PowerCommands version comes out or on .net 4.0.


Solution 4:
1. Go to your %userprofile% Folder, (Start -> Run -> Type %userprofile% -> Enter)
2. Open Application Data\Microsoft\
3. Then Clear all the content from the following folder


VisualStudio
MSDN
VSA


Then open VS IDE,  try to add the items in the toolbox.
Solution 4 is helped me. Hope it helps you!

New MVPs - April 2010

Microsoft announced the new MVPs for this quarter (April 2010).

Jacob Skaria	Excel
Amal Hashim	Visual C#
Nitin Agarwal	Windows Desktop Experience
Dhananjay Kumar	Connected System Developer
Babu A	SQL Server
Hemantgiri S. Goswami	SQL Server
Jugal Shah	SQL Server
Rajesh Jonnalagadda	SQL Server
Anoop Madhusudanan	Client App Dev
Abhijit Jana	ASP/ASP.NET
Satalaj Tukaram More	ASP/ASP.NET
Tanzim Saqib	ASP/ASP.NET
Avinash Tiwari	ASP/ASP.NET
Kazi Manzur Rashid	ASP/ASP.NET
Krishna Chaitanya	ASP/ASP.NET

Congrats to Everyone!!