BizTalk Adapter Pack 2010: Calling a View in SQL Azure

I have posted a new sample on Code Gallery: BizTalk Server 2010 Adapter Pack: Call SQL Azure View.This is one of samples I have used in my talks on BizTalk Adapter Pack 2010 Integration (A Lap Around BizTalk Adapter Pack 2010) I held in Stockholm for Swedish BizTalk User Group and in Nieuwegein for BizTalk User Group The Netherlands. Hopefully you experiment with it yourself. If you want to work with SQL Azure and want to create a database, see How to Create a SQL Azure Database wiki on TechNet.

Cheers.

My First Ten TechNet Wiki Articles on BizTalk

Last couple of week I written a few wiki article for TechNet Wiki a place, where content is generated by community about Microsoft technologies for the community. I very much like the concept and glad I was able to contribute (see my interview on Wiki). Below you will find a list of my ten completed wiki articles on BizTalk:

• First the featured article BizTalk Server 2010 and discusses BizTalk and shows all resource on its features.
• Second a list on all available BizTalk Server 2010 community tools in BizTalk Server 2010 – Tools.
• Third article is on BizTalk Server 2010 Adapter Pack an enhancement of previous adapter pack 2.0.
• Fourth article is a short overview on BizTalk Server 2010 and created before I written complete article on BizTalk and its features.
• Fifth article on BizTalk databases as a survival type of article listing all relevant resources on how to maintain healthy BizTalk environment with focus on BizTalk databases.
• Subsequently I written another article listing resources for recovery of BizTalk itself not its databases, but this article goes hand in hand with the previous fifth article.
• Seventh article is a BizTalk beginners guide listing all resources for a beginner and a little outline how he/she should proceed.
• Subsequently I also written a preparation guide for 70-595 exam that can be read in conjunction with beginners guide.
• Ninth article talks about monitoring tools for BizTalk and lists all alternatives to SCOM.
• Final tenth article is a collection of resources for BAM and is again a survival type of article.

I hope you will find these articles useful and feel free to edit them (correct, add, enhance) as that is intention of wiki’s. I will be working on next couple of articles in near future, which will be more in depth BizTalk ones.

Cheers!

BizTalk User Group Meeting 30 November 2011

My company Ordina will host next Dutch BizTalk User Group Meeting. This event we will have four speakers and agenda will be:

• Steef-Jan Wiggers (Ordina) - "BizTalk Server Adapter 2010 Integration"
• Jeroen Boiten (GasUnie) – "BizTalk at Gas Unie"
• Jasper Defesche (Axon Olympus) - "BizTalk and Dynamics AX"
• Jeroen Hendriks (Axon Olympus) – "Robust BizTalk DTAP”

It will be all Dutch talks and if you able to attend you can sign up here.

Code Gallery BizTalk Samples : Steef-Jan Wiggers

Past few weeks I have contributed the following samples to MSDN Code Gallery:

• BizTalk Table Operations - Messaging

This sample will show how to perform simple table operations using WCF-SQL Adapter a part of BizTalk Server Adapter Pack. The Sample provided by Microsoft shows only Select statement operation. This sample will show all the other operations. It is based on the BizTalk Adapter Pack 2010 WCF-Custom with sqlBinding Table Operations through Messaging solution post.

• Polling SQL Azure Table - BizTalk Adapter Pack 2010

This sample will show polling a SQL Azure database table. It is based on Polling SQL Azure Database Table with WCF-SQL Adapter blog post.

• Sample - Table Operations on Oracle 11g XE with OracleDbBinding

This sample will show all the Oracle Table operations (in comparison with SQL, but there a few differences!). It is based on Table Operation on Oracle 11g XE with OracleDbBinding blog post.

• WCF-SQL Adapter Stored Procedure : SQL Azure

This sample will make use of BizTalk Adapter Pack as well and call Stored-Procedure in Azure. Sample is based on SQL Azure Stored Procedure blog post.

• ExecuteReader, ExecuteNonQuery, ExecuteScalar Operation with BizTalk Messaging

This sample will demonstrate three query operations through messaging in stead of using the WCF Service Model. BizTalk Server 2010 Adapter Pack Samples show only invoke ExecuteReader operation in SQL Server using ,NET. This sample shows all operations through messaging.

Cheers!