January, 2012

The goal of this blog post is to show that it is as easy with SQL Azure as with SQL Server to push data with SSIS. Le but de ce billet est de montrer qu’il est aussi simple de pousser des données avec SSIS vers SQL Azure que vers SQL Server. In this sample, let’s use SQL Server 2008 R2, which is the latest SQL Server version in production (1). Dans cet exemple, utilisons SQL Server 2008 R2, qui est la dernière version sortie de SQL Server (1). The scenario is to push some data from SQL Server 2008...

Prepare an Optimal Learning Environment Prepare for the class by making sure that your workstation meets the minimum requirements, have a stable internet connection, a speakerphone or headset, and check for any firewall issues. By double checking everything before class starts you make the morning of class stress free. Pre-Class Checklist: Wired High Speed Internet Phone line with a speakerphone or headset Firewall Check at www.gotomypc.com/wizard When you’re setting up your learning environment...

You have installed BizTalk? You have installed SQL server? You have installed .NET4.0 ? Everything is fine. Then you reboot, or you restart SQL Server. Enterprise Single Sign-on Does not want to start…. ??? It errors with: Could not create SSOSQL. To fix the problem, reinstall SSO or try 'regasm SSOSQL.dll' from a Visual Studio command prompt.Error Code: 0x80131700 OR Windows could not start the Enterprise Single Sign-On Service service on Local Computer. Error 0x80131700: 0x80131700 OR you...

There is a new BizTalk blog. Another one, yes targeted for BizTalk administrators. Why? There are many blogs out there. Yet most of them are focused on the developer. There is not much on BizTalk administrative topics nor one blog where BizTalk administrators share their knowledge, and experience between each other and with the community. Jeroen Hendriks from Axon Olympus started an initiative to create a blog for BizTalk professionals with a heart for managing BizTalk. He talked this through with...

A couple of weeks ago I wrote a blog post for the Official blog of TechNet Wiki with the topic “Wiki-Ninjas on Technology: BizTalk Server” . In that blog post I wrote a story on contributions of the community and Microsoft employees for the TechNet Wiki . Mid December there were little of 40 BizTalk Wiki Articles and over a month’s time it has grown to little over 70 . That is a tremendous growth of articles (around 30 ). It show increasing popularity of the TechNet Wiki as a channel of information...

  FABRIKAM is a manufacturing company who has CONTOSO as one of its resellers. FABRIKAM would like to get their sales number thru CONTOSO channel, but CONTOSO does not want to give access to their own database and they don’t have the time to create an application to expose this data. FABRIKAM est une entreprise manufacturière qui a parmi ses revendeurs CONTOSO. FABRIKAM voudrait avoir ses chiffres de vente pour ce qui concerne CONTOSO, mais CONTOSO ne veut pas donner accès à sa base de données...

Since this week BizTalk Processing Monitor is available as a Public Beta. It can be obtained here . Why use BizTalk Processing Monitor Depending on how you setup BizTalk Processing Monitor, it helps you, amongst others, with the following needs: Monitoring and notification of any message flow interruptions Get insight in how the BizTalk solution is setup Adds value when doing stress or load tests Informs you when your BizTalk system is throttling and why Informs you in how many messages (in number...

You have a SQL Azure Server. You can access the databases thru the administrator login you specified while creating the SQL Azure Server . On dispose d’un serveur SQL Azure. On peut y accéder avec le compte administrateur qui a été spécifié lors de la création du serveur SQL Azure . In the SQL Azure server, you have the following databases: - master - DB001 - DB002 Dans le serveur SQL Azure, on dispose des bases suivantes: - master - DB001 - DB002 You would like to create a SQL Azure login that has...

It is stupid to compare those two beasts. BizTalk Server is a pricey, huge development and run-time system, it includes tons of the tools, supports tons of protocols and systems. It works for very specialized middle ware integration stack. It integrates...

BizTalk MVP Steef-Jan Wiggers has written some valuable BizTalk articles on the TechNet Wiki. It is great to have community contributions!

I was recently asked if I could help move a virtual machine that had been setup and running in VirtualPC and move it to run under Hyper-V.  The answer is yes it can be done.  Movement from Hyper-V to VirtualPC is not as easy (and many times not possible) but there are a number of blog posts on this topic already so I won’t cover that here.  One of the reasons that it is easier to move from VirtualPC to Hyper-V is that VirtualPC is only 32 bit.  There are a number of steps that...

Tellago’s technology update series keeps rocking. Now is time to talk about Kinect for business applications. Yes, you heard that right. Next Thursday, we will be hosting a webinar to discuss how the upcoming Kinect for Windows can disrupt the enterprise...( read more ) Blog Post by: gsusx

As we move towards the cloud, we need to be able to expose endpoints on the cloud for integration that follows a hybrid model (see my previous post that describes what a hybrid model is) . In the next few days, I will be writing posts that demonstrate how BizTalk can be used to talk to [...] Blog Post by: DipeshA

It is one more description of the Ordered Delivery (OD) in BizTalk. The main article about it is in MSDN . Here I am discussing the BizTalk Ordered Delivery “implementation details”. OD Considerations Ordered Delivery (sequential) mode is opposite of...

Here is one of the use cases of Hadoop on Azure: you have a few applications accumulating data over time and you need to execute batches against this data a few times a month. You need many machines in an Hadoop cluster, but most of the time, you don’t need the cluster, just the data. Voici un des cas d’utilisation d’Hadoop sur Azure: Quelques applications accumulent des données au fur et à mesure et on doit exécuter des batches sur ces données quelques fois dans le mois. On a besoin de machines...

Mike Clarke, CIO at SKYCITY, presented the award to Brian Lomas & I at an event held at SKYCITY on the evening of the 13th December. Mike Clarke said that the award came as a result of the outstanding work that the DATACOM team has delivered for SKYCITY over the course of this calendar year. [...] Blog Post by: mbrimble

This article is a Part 6 of the Interview Questions series. Part 1: BizTalk: Questions for interview without answers Part 2: BizTalk: Interview questions and principles Part 3: WCF: Questions for studying and interview Part 4: WCF: Questions for studying...

The documentation for BizTalk Server 200X is very clear, and has been since BizTalk Server 2006. See the 2010 versions of technet wiki and download . It states: “ Named instances of SQL Server 200X Analysis Services are not supported ” But why is that? I set out to investigate if I could find a reason for it still being true. Examining the history In the beginning, there was a limitation with SQL Server 2000 Analysis Services (SSAS). It was not instance or cluster aware (much like SSIS today). Some...

With the announcement of BizTalk Server 2010 R2, it is clear that there is great commitment from MS for supporting on-premise solutions. However, one other smart move from MS was they are now catering to all the three areas below: Area: On-Premises Integration Products: BizTalk Server Windows Server AppFabric Area: Hybrid Integration Products: BizTalk Server [...] Blog Post by: DipeshA

I have installed the ESB Management Console on a server that does not have Visual Studio installed and I got this error when I tried to open the ESB Management Console on the local host. http://social.msdn.microsoft.com/Forums/ar-SA/biztalkesb/thread/16f6fcbe-ffd6-4fbf-a92f-a97726292256 talks about the same error but none of the solutions in this thread solved my problem. Eventually I discovered [...] Blog Post by: mbrimble