alkampfer on June 8th, 2010

In a Tfs Test machine I have I see that there are error in the System log
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {<CLSID>} to the user <user> SID (<SID>). This security permission can be modified using the Component Services administrative tool.

To solve this problem [...]

Continue reading about Event 1006 Distributed Com

alkampfer on April 13th, 2010

I have a database where reports are done with stored procedure over the OLTP database, and we begin to suffer poor performance because we have a lot of data and sometimes reports are locked by transaction issued from components that does bulk data insertion.
A viable solution is moving all data in a DataWarehouse server where [...]

Continue reading about SSIS use parameter with ADO Net source in DataFlow

alkampfer on December 23rd, 2009

Recently I’ve posted about backup, and I want to make another little tough, RAID 1 is not meant to replace backup. During the past I’ve heard people saying, “Hey I’ve this RAID 1 array, so I do not need backup, because if a disk will fail I have data in the other one.
This is WRONG!!!
If [...]

Continue reading about Again on backup, RAID 1 is not backup

alkampfer on December 17th, 2009

I was reading this post, and I really agree with Jeff, every day is international Backup Awareness Day.
People usually learn the importance of a good backup the first time they have a great data loss, or when you see others having greats data loss. I remember, loong time ago, when I worked in a computer [...]

Continue reading about Have you backup your data today?

alkampfer on November 28th, 2009

This is not a new tip, it was already gave by many others, but it worth mentioning again. When you want to try beta software the best solution is using a virtual machine, to avoid the installer to break your dev machine. With windows7 you have another option, the xp mode.

AS you can see [...]

Continue reading about Try visual studio beta with windows 7 with xp mode