Mark Barto's Blog
Technical Blog about the Microsoft .NET Platform and everything that surrounds it such as .Net, C#, BizTalk, WCF, ASP.NET, SQL, Silverlight, IIS ...SQL: Activity Monitoring missing within SSMS
When searching for the Activity Monitoring within SQL Server Management Studio 2008 under the management folder you determined that it isn't there anymore. After some research I came across an interesting article where is explained where you can find the Activity Monitor.
SQL, SSIS: Execute SSIS Package within Stored Procedure
I have a stored procedure which returns data from a database. Before I want to return this data I want to execute a SSIS package which populate this data. Unfortunately there is not any SQL statement to start a SSIS package within a Stored Procedure. But there is a work-a-round for it.
BizTalk: WCF-SQL Adapter not displayed on x64
When installing the SQL Adapter for x64 the adapter will not be displayed in BizTalk Administration when trying to add the adapter.
Because BizTalk Server Administration console runs as a 32-bit process and not in a 64-bit process it will not be displayed in the dropdown when registering the adapter in BizTalk Administration.
BizTalk: WCF - SQL Adapter for BizTalk 2009
If you are using the standard SQL adapter what is part of BizTalk you must be known that this adapter in the nearby future will not be supported anymore by Microsoft.
Because of this reason it is a best-practice to replace this adapter to the new WCF-SQL adapter.
This adapter which is also part of the BizTalk Adapter Pack 2.0 is also available as stand-alone download.
Read More ...
SQL Server 2008: Change Data Capture (CDC)
Within SQL Server 2008 there is a new feature called Change Data Capture (CDC). This features makes it possible to track changes such as insert, update or delete of a specific table within a database.
It will read the transaction log within SQL Server by running a job and will write the changes in a new system table within the database which you can query to get the changes.
BizTalk, ESB: Error converting data type nvarchar to datetime
When using the Exception Handling within ESB (Enterprise Service Bus) for BizTalk 2009 there will be a Sendport All.Exception in the Microsoft.Practices.ESB Application. This sendport will be executed if there is a failed message generated in the messagebox, if you have checked the option Enable routing for failed messages.
Read More ...
