Wednesday

tsql select from xml with xmlns

tsql select from xml with xmlns here is how to do that :
       
declare @document xml ='<TypedPollingResultSet0 xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling/ModifiedProductsGet"><TypedPollingResultSet0><id>2</id><ProductID>M10570</ProductID><OriginalCatalog> Master Recipes HE</OriginalCatalog><Status>0</Status><DateTimeCreated>2014-10-20T11:48:10.373Z</DateTimeCreated></TypedPollingResultSet0><TypedPollingResultSet0><id>1</id><ProductID>M9519</ProductID><OriginalCatalog> Master Recipes HE</OriginalCatalog><Status>0</Status><DateTimeCreated>2014-10-20T11:48:10.373Z</DateTimeCreated></TypedPollingResultSet0></TypedPollingResultSet0>'
;WITH XMLNAMESPACES(DEFAULT 'http://schemas.microsoft.com/Sql/2008/05/TypedPolling/ModifiedProductsGet')
Select T.N.value('id[1]', 'int') as id
from @document.nodes('/TypedPollingResultSet0/TypedPollingResultSet0') as T(N)

mplayer play random file into folder

to shuffle and play random audio files in folder , create following .bat file:

cd C:\Audio\mix\
c:\tools\mplayer\mplayer -quiet -shuffle *


Monday

BizTalk Archive not available or not configured. Timeout error

Here are steps how to resolve BizTalk timeout issue and see tracked messages:

1.purge all tracking data
USE [BizTalkDTADb]
GO
DECLARE              @return_value int
EXEC      @return_value = [dbo].[dtasp_PurgeAllCompletedTrackingData]
SELECT  'Return Value' = @return_value
GO

2.submit  messages to BizTalk

3.After messages are placed run this job on BizTalk server in order to see messages bodies:
TrackedMessages_Copy_BizTalkMsgBoxDb


test smtp server with powershell

Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...