Change Data Capture feature of SQL Server do not work with BAM Archiving.

Change Data Capture feature of SQL Server do not work with BAM Archiving.

This topic is related with the issue arise from change data capture (CDC feature of SQL Server) enabled for activity tables active and completed. The Bam arching/purging activity when set up stops change data capture. We designed a solution for one of our major client where we migrate the data from BAM tables to DB2 […]
Blog Post by: shadabanwer

Timeout Publishing Database Project to Azure

Timeout Publishing Database Project to Azure

I had created a new database project in Visual Studio 2013 and every attempt to publish the project to my Azure hosted database failed with this error: Creating publish preview… Failed to import target model [database_name]. Detailed message Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation […]
Blog Post by: James Corbould

SQL Queries to Enable or Disable All BizTalk SQL Server Agent jobs

SQL Queries to Enable or Disable All BizTalk SQL Server Agent jobs

BizTalk is shipped out with a total of 13 SQL Agent jobs. Experienced BizTalk professionals know that all the BizTalk SQL Server Agent jobs except the MessageBox_Message_Cleanup_BizTalkMsgBoxDb job should be enabled and running successfully. Besides this job the other jobs should not be disabled! However one of the most common and important tools to resolve […]
Blog Post by: Sandro Pereira

Installing Redis Cache Locally in a Development Environment

Installing Redis Cache Locally in a Development Environment

I recently blogged about using the excellent Redis Cache – which is now the preferred Azure caching solution – for a recent CRM integration project. In my development environment, I’m pointing against the Azure Redis Cache and while performance is fantastic, I recently saw that Chocolatey have an MS Open Tech version of Redis in […]
Blog Post by: modhul

BizTalk Health Monitor v2 soon available : more reliable and completly customizable

BizTalk Health Monitor v2 soon available : more reliable and completly customizable

Hello,

I'm pleased to inform you that BizTalk Health Monitor (BHM) v2 is finished and will be available very soon on the  Microsoft Download Link Center.

The BHM team improved drastically this MMC snap-in to make it more reliable and very customizable.
In this new version you will be able so to customize completly the dasboard views by creating your own tiles to display custom warnings, specific summary reports entries, or even queries output.
You will be also able to add quickly custom queries and rules.
These features were expected by lot of BHM users to provide more flexibility in this health check console and to use it as a centralized health application. 

In BHM v2, you can so complete easily the query repository of BHM adding  your custom queries executing WMI, .VBS, PowerShell, .CMD or .BAT scripts.
These queries will be stored per group node (renamed "profile" node in BHM v2).

You can also create your own rules in addition to the native BHM rules, using a declarative method to define your own conditions and triggered actions.
These custom rules can target existing native BHM queries but also your own custom queries of course.
These custom rules will also be stored per profile node.

Stay tuned so, BHM availability will be announced on the BHM blog but also on my MBV one.

Thanks !

JP


Blog Post by: JPAUC