How do SSL and Basic Auth on an Orchestration Published as a WCF WebService

In the BizTalk world, the person who publishes the orchestration usually creates a small client program to call the webservice and to test it. This is a good practice before going to another developer (either in your company or to a customer) and telling them the service is “working” when you haven’t even tested it […]

IIS8 – The binding “*:80′ is assigned to another site

One of the errors I had to overcome with IIS version 8 was: “IIS8 – The binding “*:80′ is assigned to another site “. I’m upgrading from a Windows 2003 server that I’ve had since about 2007 to Windows 2012/R2 hosted on Amazon EC2 (Elastic Cloud). I only run three sites on it at this […]

BizTalk Error: The document specification failed to load

Error: The document specification <ddlname.schemaName+SchemaRootNode> from assembly <etc…> failed to load.  Verify the schema for this document specification is deployed and is in the Global Assembly Cache. Solution 1: In our case, this happened when we ran a C# client tester program that called an orchestration published as a WCF service.  The Application Pool was […]

New Port Doesn’t Appear in WCF Publishing Wizard

I think most blogs talk about requiring that the PortType be “Public” instead of “Internal”.  However, today I learned that not only do you have to build (compile) the orchestration, you must also deploy it.  Even though I compiled, the new port was not appearing in the WCF Publishing Wizard.  I was getting desparate, finally […]

BizTalk Error: Unable to serialize web directory

When trying to export an MSI from BizTalk Admin Console for an application, I got this error: “Unable to serialize web directory… Verify the location exists and it is accessible” Example of error in BizTalk Admin Console   In my case, we had SharePoint on the same machine as BizTalk, and thus a coworker set […]

“AutoAudit” – CodePlex Free Utility to Build SQLServer Triggers – Documentation and Example

CodePlex is long gone, but the script can now be found here: https://github.com/koenmd/AutoAudit/blob/master/README.md A few years ago I discovered a great utility called “Auto Audit” on CodePlex by Paul Nielson (author of “Sql Bible”) and John Sigouin. The best thing is that it creates triggers that audit insert, update, and deletes on any desired table. […]

Using PowerShell to Harvest Data from a Web Page

Powershell can be useful for parsing or harvesting data from the web via means of the “Invoke-WebRequest”. Among other things, it can return a collection of links. The code below loads a page from Wikipedia and loops through the collection of links, looking for a certain pattern to find all the cities in a state. […]

Three Ways to Format Output of a PowerShell cmdlet

Today’s Powershell example is something that I know I will re-use, so I wanted to put it in a place where I could always find it, i.e. on my blog. The main purpose of this example is to show how to route output from a cmdlet to a formatted or “pretty” output, such as as […]

SpinTax and Calling C# from PowerShell

What is SpinTax? SpinTax is a way of “spinning” text. It’s often used by somewhat spammy marketing programs to post different words, phrase, or articles to different web or social media sites. It is designed to create somewhat readable but yet random text, based on changing synonyms for various words. There are actually programs that […]

Error: No BizTalk Configuration database(s) found on server ‘(local)’

It’s a fairly common practice to change the Deploy Server from a specific machine name to “.” or “(local)”. I’m at a new client, where the security isn’t all set up properly. So when I changed the server name to “(local”) I got the error: No BizTalk Configuration database(s) found on server ‘(local)’ Since I’m […]