By Ray Barley on April 19th, 2012 // No Comments
Since SQL Server Integration Services (SSIS) was released with SQL Server 2005, there have been a variety of issues with the developer experience, deploying packages, and executing packages. SSIS 2012 has addressed a number of the key pain points, particularly in the area of deploying and executing packages.
What's New in SSIS 2012
There are a number of new and useful features in SSIS 2012. They can be broken down into the following categories:
Developer experience
Deployment model
...
Continue Reading
By Jason Petrin on May 25th, 2010 // No Comments
Recently I gave a presentation on BizTalk Server 2009 at the Carolina Code Camp. The presentation covered the basics of BizTalk as well as the new features of BizTalk Server 2009. I showed a short demonstration of a sample Purchase Order process. The components used were the Schema Designer, the Mapper, the Orchestration Designer, and the Consume WCF Service Wizard. PowerPoint slides and demo code are available upon request. ...
Continue Reading
By Jason Petrin on May 12th, 2010 // 3 Comments
After many hours of research and blog reading, I came to the conclusion that there is no out-of-the-box or additional download (from an Adapter Pack or similar) support for REST services in BizTalk 2009. My recommendation is to have a C# helper class make the call for you. This is not what I was hoping to discover, although it does make sense. REST services do not employ formal contracts, while BizTalk relies heavily on strong-typing of messages, these two philosophies contradict. The other is...
Continue Reading
By Isaac Ferreira on February 22nd, 2010 // No Comments
One of the most common questions I get asked when looking at a BizTalk server project is what type of hardware is required and how many servers are needed.This is often a black art.Microsoft has stepped in to help with the release of a BizTalk Benchmark Wizard:http://msdn.microsoft.com/en-us/biztalk/ee946766.aspxBasically this tool is intended to work along side the BizTalk Server 2009 Scale-Out Testing Study:http://msdn.microsoft.com/en-us/library/ee377068(BTS.10).aspxComparing the results of t...
Continue Reading
By Isaac Ferreira on January 28th, 2010 // 1 Comment
I learned something today about SQL 2008 and BizTalk's SQL agent jobs. You must leave all BizTalk databases recovery model to "Full". I encounted a database set with the recovery model that was changed to "Simple" and it caused the agent's jobs to fail.The reason for this is that "TRUNCATE_ONLY" has been deprecated for SQL Server 2008. This flag forces you to keep the recovery model as full. When I changed it back everything began funtioning normally again....
Continue Reading
