Notes on BizTalk 2010

Some notes around installing and configuration of BizTalk 2010

The installation was done on a virtualized Win 2008R2. Follow this document from Microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=11503

The installation consists of following components:

- SQL Server 2008R2 with SSAS,SSRS and SSIS installed. But be sure to read the installation guide

- Visual Studio 2010 (download the trial version from Microsoft)

- Configuration of the SQL Server (deactivate shared memory on the instance)

- Installation of BizTalk 2010

- Configuration of BizTalk 2010

After this, launch the Administration application.

Tutorial for developing your first BizTalk solution:

http://msdn.microsoft.com/en-us/library/aa560270

Create multiple scheduled tasks across n-servers

Needed to create the same scheduled task on several servers. Using a bit of Powershell made the task a bit easier. Below functions can be used to create, delete and view scheduled tasks on a specific server:

Function Get-ScheduledTask
 {
 param([string]$ComputerName = "localhost")
 Write-Host "Computer: $ComputerName"
 $Command = "schtasks.exe /query /s $ComputerName"
 Invoke-Expression $Command
 Clear-Variable Command -ErrorAction SilentlyContinue
 Write-Host "`n"
 }
 
# EXAMPLE: Get-ScheduledTask -ComputerName Server01
 
Function Remove-ScheduledTask
 {
 param(
 [string]$ComputerName = "localhost",
 [string]$TaskName = "blank"
 )
 If ((Get-ScheduledTask -ComputerName $ComputerName) -match $TaskName)
  {
  If ((Read-Host "Are you sure you want to remove task $TaskName from $ComputerName(y/n)") -eq "y")
   {
   $Command = "schtasks.exe /delete /s $ComputerName /tn $TaskName /F"
   Invoke-Expression $Command
   Clear-Variable Command -ErrorAction SilentlyContinue
   }
  }
 Else
  {
  Write-Warning "Task $TaskName not found on $ComputerName"
  }
 }
 
# EXAMPLE: Remove-ScheduledTask -ComputerName Server01 -TaskName MyTask
 
Function Create-ScheduledTask
 {
 param(
 [string]$ComputerName = "localhost",
 [string]$RunAsUser = "System",
 [string]$TaskName = "MyTask",
 [string]$TaskRun = '"C:\Program Files\Scripts\Script.vbs"',
 [string]$Schedule = "Monthly",
 [string]$Modifier = "second",
 [string]$Days = "SUN",
 [string]$Months = '"MAR,JUN,SEP,DEC"',
 [string]$StartTime = "13:00",
 [string]$EndTime = "17:00",
 [string]$Interval = "60" 
 )
 Write-Host "Computer: $ComputerName"
 $Command = "schtasks.exe /create /s $ComputerName /ru $RunAsUser /tn $TaskName /tr $TaskRun /sc $Schedule /mo $Modifier /d $Days /m $Months /st $StartTime /et $EndTime /ri $Interval /F"
 Invoke-Expression $Command
 Clear-Variable Command -ErrorAction SilentlyContinue
 Write-Host "`n"
 }
 
# EXAMPLE: Create-ScheduledTask -ComputerName MyServer -TaskName MyTask02 -TaskRun "D:\scripts\script2.vbs"

Borrowed from: this link 

Doing the BI Certification with Koenig-Solutions in Dubai - Part I

Going to Dubai from Copenhagen is quite easy. I found a flight with Qatar Airways. A quick stop in Doha before arrival in Dubai (1 hour) was OK. Landed in Dubai at 2.10am local time and was kind of tired. Unfortunately many people had choosen to go to Dubai, so getting through customs took about an hour. From here it should be painless, but my suitcase was apparently forgotten in Doha. Luckily many flights go from Doha to Dubai so only 30 minutes of waiting and of to the Koenig Apartment. But now the local time was 4.15am. A quick call to Koenig caretakers to tell them I was coming resultet in a quick welcome and showing to my flat and room. A nice big flat with 2 rooms and 2 bedrooms. Breakfast was at 8am, so not much time to sleep.

A quick shower and rushing to the breakfast which includes eggs, toast, fresh fruit, juice and several types of cerials. Even the ones my kids are not allowed to eat. Then off to the Koenig Office for starting the course, using the Koenig Bus which transports all people, including instructors, to the office. A nice blend of indian, oman, american and danish blend in that bus. At the office the manager at the office welcomed me, informed about the reimbursement of taxi trip and daily cost for lunch. The lunch at the office is done at "food court" where several fast-food stores are present, including KFC and Subway, but also indian and italian style food. Pretty ok selection. Back to what I came for, the SQL 2008 BI course. The instructor - Prakash - introduced to the course, with a overview of the different elements in the course and then we startet. Being the only one on the team is pretty ok. The instruction is a mix of using the traditional (...veryyyyy traditional) Microsoft stuff, with slides and some pretty boring lab exercises. But Prakash also uses a simple whiteboard for introducting the subjects and explaning what the comming module would contain. And this is actually ok. At least when the lab exercies are spiced up with improvised exercises where things not goes as the theory says. And most often, this is where the potential and skills of the instructor becomes visible. But so far its going well. At 13 o'clock it's time for a 1 hour lunch break, which seams like appropriate. Getting some lunch and some rest in the sun is nice. At 17 o'clock the instruction is done, and around 17:15 the bus takes us back to the apartment.

So to sum it up, the experience so far has been positive. The course is going well, so far almost covered the SSAS area in 2 days, been to the pool twice, ran 5 kilometers and had some interesting conversations with the two caretakers.

Doing the BI Certification with Koenig-Solutions in Dubai - background

This blogentry is something complete different compared to the little bit of other stuff I've put on the blog. This is about my journey to Dubai for a 12 fast-track course on MS SQL 2008 Business Intelligence. For some time ago I was supposed to attend a course back in Denmark over a couple of months, with a weekly meetup with instructors and fellow students. The course never got off the air and was canceled. This was back in late 2009. Suddenly a opportunity came up for trying to go again, but this time I had heard about Koenig-Solutions, an Indian based course supplier. After a quick check I signed up for a 12 days fast-track course, with base out of Dubai. What this also meant was actually 14 days away from my family, including 3 small kids.

Signing up with Koenig-Solutions was inspired from this guy's blog-post who went to Goa for a course. Going to India is cheaper than going to Dubai, on the contrary Dubai is a shorter flight from Denmark, and no Visa or vaccines is required. Dubai is of course also more western kind-of. So the sum of all is, that I booked 12 days in Dubai with MS SQL 2008 BI Maintain & Development, including 2 MS certifications. The booking and communication with Koenig before the trip has been good, with quick answers on all kinds of questions. Even a question just before scheduled departure because of illness to a family member was handled very well. It turned out that up to start of the course start you can actually cancel and get a almost fully refund. Try that with a european company.

All for now, next blog post will be about the first couple of days in Dubai. 

Learning Ruby

About a month ago I needed something new to learn. And since a long time I have been reading stuff about Rails and how Rails was a fantastic solution for creating websites by using a standard way of handling various common issues when developing websites. Since Rails is build on Ruby I thought it could be a benefit to learn Ruby before opening the big box of Rails. Surfing around the web gave me a link to Rubylearning.org. Rubylearning is a site centeret around learning Ruby and Ruby-centeret stuff like Sinatra. At the time I was ready to learn Ruby they actually launched a Ruby beginner course. The price for the course was low, $14, so what could I loose?

The course was setup with 7 weeks of studying, with a interval of 1 week for each area. Every area would contain some background material to read, and some exercises to solve. Each week has it´s own forum where you upload your exercise-solutions and questions (if any). Within a short time after commiting your stuff a hardworking competent teacher read and commented on your solution. Because everybody could see each other solutions and comments this inspired to change your solution or gave a hint how to solve a exercise. And this was almost the best of the course. In my humble opion the course gave full value for your bucks. Before signing up be prepared to use some extra hours every week on programming puzzles.

So go and see if Rubylearning.org does not have a course for you.

I am hooked on Ruby and have already launched my first Sinatra solution on Heroku used internal at my company. yay

Install Rails 3.0 on Ubuntu 10.10 using RVM

I am on a new tour. I want to find out about that Rails thing. Coming from a .NET world something the Rails world seems interesting enough to have a go at it. I´ve been using a course on www.rubylearning.org for learning the Ruby language itself. I can definitely recommend to do that. A very good course which demands that you actively do something to get through it. But coming back to the Rails thing, this blog-entry should be about how to install Rails 3 on a Ubuntu 10.10. First of all I found out that installing Rails on Ubuntu can be complex but I found out that installing RVM could make life easier. So first of all I installed RVM using this guide: http://ruby.about.com/od/rubyversionmanager/ss/installrvmlinux.htm

After installation of RVM the system should be ready for some Ruby / Rails installation. First install Ruby 1.9.2 by: RVM install 1.9.2

This will fetch the source and compile. So it might take a while before it is done.

Now set the default ruby version with:

ruby --default ruby-1.9.2

now install rails by:

gem install rails <-- don´t use sudo as RVM now takes care of having the gems on your home folder

Mythtv and Wii

This is just great - and nerdy ! My running Mythtv installation have had an ongoing issue with an somewhat not working Remote. Ah, ok, it ain't working at all :-) So the good old keyboard has been hooked up, but it is not that pretty. So yesterday I found the solution. A great guy has made a python script which hooks up your Wii controller to your Mythtv installation. That way you can control the myth-frontend. Even using the build in x-y controllers in the Wii controller.

Links: http://www.benjiegillam.com/mythpywii-installation/