Check the recovery model of (BizTalk) databases

Today I was doing a BizTalk assessment of a newly installed BizTalk Server and needed to verify the recovery model of the BizTalk databases, installed on the SQL instance.

Below is a very simple SQL script you can use to do this:

SELECT 
  Name, 
  DATABASEPROPERTYEX(Name, 'RECOVERY') AS [Recovery Model]
FROM 
  master.dbo.sysdatabases

recoverymodels

FYI: This is a screenshot from a SQL Server 2014 (SP1/CU4) machine.

BizTalk Backup job – wrong description

Busy day today, where I was reviewing the BizTalk backup job of the installation I performed and documented earlier. This came to my attention:

Clipboard02

The BizTalk Backup Job Description tells:

“This job performs full database backups (step 1) and log backups (step 2) of BizTalk Server databases.”

However, the BizTalk Backup job was updated with the release of BizTalk 2010, where a new step 1 was added to be able to compress the generated backup files. Meaning that it should mention step 2 and step 3 to be correct. Nitpicking I know, but still wrong.

In BizTalk 2013 R2 it clearly states the wrong steps in the description. I checked and already in BizTalk 2010 this is the case. Seems like this small error has already made it into 3 RTM releases of BizTalk Server and only now this pops up. Unsure if I’m the only person who noticed it so far…

Creating a shortcut in Word to resize a selected image

Today I was documenting the installation of a new BizTalk environment. The document is an overview from A to Z, which describes how to install and configure this particular BizTalk environment. Typically, as one might expect, this type of documentation contains a lot of screenshots/images.

My method was the following:

  • Create a screenshot using Lightshot. It’s a great (and FREE) application which can take screenshots of anything open on your screen, with the added benefit to save to a file immediately, upload to to Imgur, make notes on it, etc…
  • Copy the screenshot to the clipboard
  • Paste it into Word (2016)
  • Right-click the image and select “Size and Position
  • Reset the image to 50% of it’s height, while having the aspect ration locked
  • Clicking OK

Obviously, it involves quite a lot of clicks and is pretty time consuming and pretty tedious… considering the fact I have about 50-100 images to put into the document, I wanted it to become better. The client I was sitting next to, insisted there was a way with Word macros, but didn’t know quite how to do it.

Creating the Macro

10 minutes of Googling and some trial and error, and low-and-behold, this is the button which is now up on my Home toolbar:

word_macro_button_resize

As with many things, it’s actually quite easy to get it for yourself:

  1. Enable the Developer toolbar in Word. Right click any button or space in your toolbar and click “Customize the Ribbon“.
  2. Check the checkbox for the Developer Tab and click OK.
    word_macro_developer
  3. Click the Developer toolbar and click “Macros”
  4. Type the name (e.g. “ResizePictureto50Percent”) and click the “Create” Button.
  5. You should now get the following screen:
    word_macro_emptymacro
  6. Copy/Paste the macro (you can find the code below this list), as below, and close the screen:
    word_macro_macro
  7. Again, customize the toolbar by right clicking any space or button in the toolbar and select “Customize the Ribbon“. Select Macros and insert your new macro as a button into the place you want it to have:
    word_macro_addtotoolbar

You now have a fully functional button (which you can customize to your liking)!

The macro code you need:

Sub ResizePictureto50Percent()

With Selection
 If .InlineShapes.Count > 0 Then
 With .InlineShapes(1)
 .Height = .Height / 2
 End With
 Exit Sub
 Else
 With .ShapeRange
 .Height = .Height / 2
 End With
 End If
End With

End Sub

Testing the Macro

Now, when I copy/paste an image or screenshot in Word, I have the following screen:

word_macro_execute_before

After I select the image (just click it once), click the button, I now get the following:

word_macro_execute_after

It even continues to shrink when I keep clicking it, as it will reduce to half its size every time I do this.

Great stuff and saves me a lot of clicks!

BizTalk CU’s are released as “MyTestPackage”

Yesterday evening I was installing BizTalk 2010 CU9 on one particular VM I had laying around when I found something funny while looking into Task Manager:

BTS2010CU9_taskmgr

The description which the CU shows “Hotfix or Service Pack Self-Extracting Package for MyTestPackage“.

In itself nothing quite noteworthy, until I found myself installing BizTalk 2013 R2 CU3 today. Out of curiosity I checked what the description of the executable there, and what do you know… The same applies here:

BTS2013R2CU3_taskmgr

Funny that the Microsoft BizTalk Team didn’t change that for those CU’s. Makes me wonder if the same applies for other CU’s.

BTUG.be slide deck – Integrate 2016 recap

Yesterday I had a great time at btug.be, while presenting my session on Integrate 2016.

I presented the new changes in BizTalk Server 2016 CTP2, covered the upcoming changes in RTM and the new schema update of Azure Logic Apps, together with the new features available in the public preview of the Enterprise Integration Pack

Thanks again to our company, Codit.eu, for providing me the opportunity to be there!

As promised there, please find my slide deck below via SlideShare:

Contact me if you have any questions regarding the slides, I’d be happy to answer you.

The second speaker yesterday was Eldert Grootenboer. He had a great talk on IoT, gateways, sensors and … boats! Keep an eye out on his blog, since he promised some more IoT posts coming up.

As always, it was nice to talk to the people present. A big thank you to them! Especially since it was not such a great time to attend, just before holiday period and there were a lot of traffic jams around Antwerp yesterday evening. We do have a good community out there!

Enjoy the slide deck!

Pieter