Build problems after upgrading from TFS2010 to TFS2012

Recently our TFS Server have been upgraded to TFS2012 + QU1 + CU1. In order to be able to use our Build Server we have had to upgrade it from TFS2010 to TFS2012 as well and, of course, we have found a couple issues related to the build process templates that we had defined which do not…


SSIS, SQL Agent, Credential, Proxies and the -1073741515 process exit code

Recently I have been dealing with a really weird error while trying to execute a SSIS package using a SQL Agent Job with a concrete user credential. The error that I’ve got was: Executed as user: XXXXX. The step did not generate any output. The return value was unknown. The process exit code was  -1073741515….


Useful T-SQL Scripts

A couple of very useful and heavy used T-SQL scripts… Finally, I have decided to post both in order to find them every time I need with out having to re-author: 1. Kill all existing connections to a certain database: USE master DECLARE @DataBaseName varchar(255) = ‘<YOUR_DATABASE_NAME>’ DECLARE @spid INT, @cnt INT,  @sql VARCHAR(255)SELECT @spid =…