Difference between SSIS and Biztalk

Hi

Can anybody please tell me the basic differences between Biztalk and SSIS and when to choose which technology over other?

Regards,

Sandeep Saran

SSIS is just a small piece of BizTalk. BizTalk is more Business to Business (B2B). SSIS is more simply, data integration.

I suggest you read the documentation for each on Microsoft's site to make your own judgments:
BizTalk
SSIS|||

I asked this question from a Microsoft tech evangelist and I will try and paraphrase the reply:

Biztalk is a "messaging" application basically. It is designed and optomized to move single transactions (called "messages", and consisting of relatively tiny amounts of data in each discrete "message") between different systems or processes in real time. It wraps all user data in XML. As a result, it is extremely verbose during the data movement. It is not fast and would not be very satisfactory to manipulate large data sets using batch processing. Performance would be abysmal most likely.

Whereas SSIS _is_ designed specifically to move and manipulate large datasets using extremely high performance batch processing...

|||

kenambrose wrote:

I asked this question from a Microsoft tech evangelist and I will try and paraphrase the reply:

Biztalk is a "messaging" application basically. It is designed and optomized to move single transactions (called "messages", and consisting of relatively tiny amounts of data in each discrete "message") between different systems or processes in real time. It wraps all user data in XML. As a result, it is extremely verbose during the data movement. It is not fast and would not be very satisfactory to manipulate large data sets using batch processing. Performance would be abysmal most likely.

Whereas SSIS _is_ designed specifically to move and manipulate large datasets using extremely high performance batch processing...

Think EDI - Electronic Data Interchange|||

Sandeep Saran wrote:

Hi

Can anybody please tell me the basic differences between Biztalk and SSIS and when to choose which technology over other?

Start with this whitepaper describing possible approaches:

http://www.microsoft.com/technet/prodtechnol/biztalk/2004/whitepapers/integration.mspx

Difference between left outer join and right outer join

Hello,

What is the difference between left outer join and right outer join. Which one is better.

I know the basic difference wherein for left outer join all rows of table in left are selected and compared whereas in case of right outer join all rows of table in right are selected and compared.

But besides that what difference it has I am not aware of it. Also I am not sure which one is better over the other.

Thank You

Jatin

There's no other difference. You just use one or the other depending on what order the tables are mentioned in the query and which one you want to be the "primary" table.|||If you reverse the order of the two tables, you can use a LEFT JOIN or a RIGHT JOIN, and the results should be the same, the execution should be the same, and the perfomance should be the same.

Difference Between Clustered Index and non Clustered Index

hi all, can u tell me what is basic difference beween
clusterd index and non clusterd index?
Thanks in advance
hrishikeshHello Hrishikesh !
Quioted from DBA-Forum:
--
Assuming SQL 7 or 2K:
A clustered index orders the table and is loaded into memory. SQL Svr
accesses data in the table by directly accessing the Index.
A non clustered index does NOT order the data. It establishes a list of the
locations of the data pages containing the column(s) of the index.
So a clustered index organizes the data for maximum efficient access and a
non clustered index does not.
If you create an index on a field that is NOT in the WHERE clause of a
query, you gain absolutely nothing. Actually, you take a hit because you are
wasting drive space, query time and memory space on a useless index.
If you create an index (Clustered or non clustered) that IS in the WHERE
clause, you will gain a benefit because the index points to the data.
--
HTH, Jens Süßmeyer.|||BOL says:
A clustered index determines the physical order of data in a table. A
clustered index is analogous to a telephone directory, which arranges data
by last name. Because the clustered index dictates the physical storage
order of the data in the table, a table can contain only one clustered
index. However, the index can comprise multiple columns (a composite index),
like the way a telephone directory is organized by last name and first name.
Nonclustered indexes have the same B-tree structure as clustered indexes,
with two significant differences:
a.. The data rows are not sorted and stored in order based on their
nonclustered keys.
b.. The leaf layer of a nonclustered index does not consist of the data
pages.
"Hrishikesh Musale" <musaleh@.mahindrabt.com> wrote in message
news:0da301c36d4f$2ca746f0$a101280a@.phx.gbl...
> hi all, can u tell me what is basic difference beween
> clusterd index and non clusterd index?
> Thanks in advance
> hrishikeshsql

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased
the package Visual Basic Step By Step and put it on the server hoping to ac
cess the SQL Server on the server PC. But VB Step by Step won't recognize th
e SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Se
rver, could I put it on my server or would I have to move VB to my desktop P
C, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC
"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition

Hi All,
I have a very basic licensing question. SQL Server Developer edition is
about $50. Does this include the whole software or is it just a cheaper seat
/ license for an existing SQL Server ?
ThanQ for the information.
Sashank SinguluriThe $50 includes the complete server software, with all the features of SQL
Server Enterprise Edition. There are limitation on how you can use it
though, it is only allowed for development and testing, not production.
Jacco Schalkwijk
SQL Server MVP
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>|||It includes the whole software. But... you can not use it for a production
application...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>

Developer Edition

Hi All,
I have a very basic licensing question. SQL Server Developer edition is
about $50. Does this include the whole software or is it just a cheaper seat
/ license for an existing SQL Server ?
ThanQ for the information.
Sashank SinguluriThe $50 includes the complete server software, with all the features of SQL
Server Enterprise Edition. There are limitation on how you can use it
though, it is only allowed for development and testing, not production.
--
Jacco Schalkwijk
SQL Server MVP
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>|||It includes the whole software. But... you can not use it for a production
application...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Sashank Singuluri" <sasmo@.hotmail.com> wrote in message
news:OL3P53t%23DHA.552@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a very basic licensing question. SQL Server Developer edition is
> about $50. Does this include the whole software or is it just a cheaper
seat
> / license for an existing SQL Server ?
> ThanQ for the information.
> Sashank Singuluri
>