Alter gear SQL index management

Update 06 April 2010: A new version has been released which saves the connection strings

After 3 hours, and a few other gruelling hours of trying to the get UI working Alter gear Sql index manager is now Alive.

Here is how to run it:

Step 1: Start the application:

Step 2 (optional) : select the Filter (Average fragmentation %)

Step 3 : Select database to tune

Step 4: Choose indexes to Reorganise / Defrag

Click “Defragment selected”

Defrag calls Reorganise, and Rebuild the Rebuild method on the index.

Happy re-indexing

Database index defragmenter

I recently came across a best practise which said – do not defragment all indexes in an SQL database. A few reasons apart fro the obvious of it being a costly transaction. Are there any tools that will let me analyse the indexes and i can choose which ones to defragment? I have started creating an application to do this which will soon be hosted on Codeplex, and yet again under the “Alter gear” project name.

Testing of Windows live writer

Windows live writer – this blog goes from that piece of software. This can be syndicated to my windows live space too :)

Entity framework

Currently reading up Entiy framework on the net. This will by playground to post any links / notes as I make my way up the Entity framework ladder.

Requirements with Visual studio 2008:
.Net 3.5 SP1
Visual studio 2008 SP1

Entity framework as business objects
[Keeing logic out of the design layer (an easy way to implement that)]
Asp .Net:
GridView DataRow to Entity object

Mounting ISO images on Vista

http://www.howtogeek.com/howto/windows-vista/mount-an-iso-image-in-windows-vista/

Visual studio 2008 : Failed to create project

When will this be fixed?

Works perfectly after that :)

Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)

Conditions:
Operating system : 64 bit
Web Application : 32 bit
Probable errors : Could not load assembly

When running any application on IIS and the dll cannot be loaded,
it could be that the application is a pure 32 bit application and the operating system is 64bit

You would need to enable 32 bit applications in IIS

Following is the process explained:
Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)