Tuesday, November 9, 2010

The entry 'XXXXX' has already been added.

Problem:



The entry 'XXXXX' has already been added.

This error has troubled me for over an hour. After deploying the libraries to test environment I have encountered this strange error.

Solution:
Went to web.config file and added


just above the

Root cause
Still havent figured it yet. But will post the solution soon as to what has happened.

Saturday, November 6, 2010

I am not sure if this holds still good. I will do some research before I publish this post. I haven't thought that I will be using SQL server again in my life but things come around in a consulting job and you will use all the databases. So hang on this post will help you to customize your sql server management studio and make your life easy.



create procedure sp_HelpTables
(
@paramTables varchar(30)
)
as
Begin
declare @strSQL varchar(500)
select @strSQL = 'select * from information_schema.Tables where table_name like ''%' + @paramTables + '%'''

Exec(@strSQL)

End
go


create procedure sp_HelpColumns
(
@paramColumn varchar(30)
)
as
Begin
declare @strSQL varchar(500)
select @strSQL = 'select * from information_schema.Columns where column_name like ''%' + @paramColumn + '%'''

Exec(@strSQL)

End
go


create procedure sp_HelpSelect
(
@paramTable varchar(50)
)
as
Begin
declare @strSQL varchar(500)
select @strSQL = 'select * from ' + @paramTable
Exec(@strSQL)
End

go

What is the fresh Windows 7 Ultimate Size after fresh install.

Well I had bought a new Solid State Drive. Kingston SSD from newegg.com.

I wanted to share with you the space it took on hard drive after every fresh install.

After the install the performance is so awesome, my 5 year old inspiron E1505 felt like the new laptop. The reason I would suggest getting a SSD is because, It takes only 20 seconds to build by solution with 50 projects in Visual studio. It is worth a try.

I have installed

  • Windows 7 ultimate.
  • Office 2010.
  • Visual Studio 2010.