1 0
post icon

TSQL – How to find missing or deleted table identity autoincrement values

As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence of autoincrement number on the primary key. To do this you can create a sequence from 1 (or 0 based on setted RESEED) to MAX […]

More »
post icon

TFS find in files version history with Visual Studio 2010 and 2012

Recently I needed to find in all files version history of a TFS 2010 project with Visual Studio 2010. Searching on Google I found Visual Studio 2010 and 2012 extensions, developed by Mattias Sköld, that allow you to achieve the goal. Let’s see how to find inside all version of files with Visual Studio 2010 […]

More »
post icon

Error TF203015: The item $/mypath/myfile has an incompatible pending change.

When you work with Team Foundation Server 2010 and Visual Studio 2008 you cannot merge file changes when you try to unshelve a shelveset. In fact if you try to unshelve  a shelveset which contains file already chenged on the local workspace, you will have the following error: TF203015: The item $/mypath/myfile.cs has an incompatible pending change because the file myfile.cs is checked out on […]

More »
post icon

TSQL – Passing a list to a Stored Procedure

  For different needs, often I had needs to send a list of values ​​to a Stored Procedure. To achieve this goal it is possible to use a workaround with the TSQL function nodes(XQuery) on the types of XML data. We’ll see two examples to better understand the proposed solution. Example 1: How to send […]

More »
April 26th, 2013 @ 03:43
post icon

The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

In the SOA-oriented programming, one of the major mistakes that you make when use WCF services is create an instance of the Transparent Proxy statements within the using statement, as follows: The error you get is the following: Type: System.ServiceModel.CommunicationObjectFaultedException. Message: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the […]

More »
November 30th, 2011 @ 01:14