I have installed SQL Server 2008 on Windows Server 2008 R2 and I am unable to connect to SQL Server 2008 Integration Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Integration Services in Windows Firewall for user connectivity.

Cursors Be Gone!

by Gaby Abed

SQLServerCentral.com

cursors

A short tutorial on converting cursors to more conventional loops.

Formatting and Readability

by Oliver Gaudreault

SQLServerCentral.com

Editorial

A guest editorial on formatting and how it relates to programming.

Sorting data in the SSIS Pipeline (Video)

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

In this post I want to show a couple of ways to order the data that comes into the pipeline. a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs. One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.

Concurrent processing in SSIS – Part 1

by Elliott Whitlow

SQLServerCentral.com

Integration Services (SSIS)

In the beginning of a new series, Elliott Whitlow shows us how to process your data movement in parallel, covering six different methods for doing so.

Selling Used Cars

by Andy Warren

SQLServerCentral.com

Editorial

Today we have a guest editorial from Andy Warren that looks at the value of experience.

Writing a Data Access Layer (DAL) for SQL Server

by Additional Articles

MSSQLTips.com

Data access

In this tip, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes and also you can reuse it in other applications that you develop.

Archive Backups

by Steve Jones

SQLServerCentral.com

Editorial

The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.