Mar 10

Moving to SQL Azure is not a simple connection string change

Why Customers are every day more interested in moving workloads to the cloud and the ability to have hybrid scenarios is growing constantly, we see

By Ricardo Torre

Dec 3

How to repair "Suspect" database

We were testing some throttling parameters in BizTalk, and for that we were pumping lots of load into our test environment. The system soon became unstable and

By Saravana Kumar

Oct 11

BizTalk Administration Console with custom SQL Server Port

It's one of the common best practices in big enterprises and banks to install SQL server on a custom port rather than the default port 1433 for security

By Saravana Kumar

Dec 8

Linq to SQL strange error

Currently I'm using Linq to SQL in one of my internal projects. After adding a stored procedure to the designer, I started to see the following error "The

By Saravana Kumar

Jun 4

Read this before using bts_CleanupMsgBox stored procedure

Subject: Losing subscriptions after running the sproc, resulting in complete redeploy of BizTalk application(s). bts_CleanupMsgBox is not something new and

By Saravana Kumar

May 25

Create SQL Receive Locations Programmatically.

One of our recent projects involved creating an orchestration, which was bound to a physical one way receive port polling data from SQL server.  There will be

By Saravana Kumar

Feb 21

SQL Adapter and Debatching. Beware when you process a message that contains consecutive empty elements, debatching will fail.

For how to configure SQL Adapter and Debatching see the article writtin by Richard Seroter This problem occurs when you process a message that uses a

By Saravana Kumar

May 23

IntelliSense for SQL Queries on Query Analyser, VS 2003, SQL 2005 Management Studio + few more

One of the feature I anticipated in SQL 2005 management studio was some kind of Intellisense when you type the queries. But, surprisingly there was no support

By Saravana Kumar

Sep 26

SQL Service Broker Management Studio 2005.

I been spending last few months in this project for the connected systems developer competition. After looking at some of the features of SQL server 2005, the

By Saravana Kumar

Back to Top