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.

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

sqlis.com

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.

SQL Server Service Broker Components - Message Types, Contracts and Queue

by Additional Articles

Database Journal

Service Broker (SSSB)

Arshad Ali discusses the Initiator, Target, Message Types, Contract and Queue--all components of SQL Server Service Broker (SSBS).

Google FUD

by Steve Jones

SQLServerCentral.com

Editorial

A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.

Paging and Versioning Using ROW_NUMBER()

by Lawrence Moore

SQLServerCentral.com

T-SQL

Paging through results of data, or finding specific sets of data is something that most of us need to do. A new article from Lawrence Moore shows us how we can do this with ROW_NUMBER()

Configure Windows Firewall for SQL Server 2008 Integration Services in Windows Server 2008 R2

Formatting and Readability

Sorting data in the SSIS Pipeline (Video)

Concurrent processing in SSIS – Part 1

Selling Used Cars

Writing a Data Access Layer (DAL) for SQL Server

Archive Backups

SQL Server Service Broker Components - Message Types, Contracts and Queue

Google FUD

Paging and Versioning Using ROW_NUMBER()

Blogs

Advice I Like: Pyramid Schemes

Using Prompt AI for a Travel Data Analysis

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

Forums

Database file shrink issue.

The North Star for the Year

Multiple Escape Characters

Question of the Day

Multiple Escape Characters