Integration Service is running on rnage of dynamic port and user can’t connect Integration Service remotely.

Raw Materials - Everyone Wants to Win

by Larry Gonick

SQLServerCentral.com

Comic Strip

Leila plays chess against a truly competitive computer.

Free BI Training in June

by Steve Jones

SQLServerCentral.com

Training

Free training from Pragmatic Works, Microsoft and SQLServerCentral. Learn about SSAS performance, SSIS Configurations, GIS in SSRS and more.

SQL Server 2008 and 2008 R2 Integration Services - Message Queuing Using Script Task

by Additional Articles

Database Journal

Integration Services (SSIS)

SQL Server 2008 R2 Integration Services offer a number of built-in features that simplify ETL, but they come with limited functionality. Here's a solution.

The SQL Server BI Quiz

by Press Release

Other

Contest

From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.

Red Gate extends freedom of mobile SQL monitoring

by Press Release

SQLServerCentral.com

press release

Red Gate has released SQL Monitor 2.3, providing improved data analysis and the ability to receive alerts through PagerDuty.

The Care of Data

by Steve Jones

SQLServerCentral.com

Editorial

Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.

Determine SQL Server memory use by database and object

by Additional Articles

MSSQLTips.com

Administration

For many people, the way that SQL Server uses memory can be a bit of an enigma. A large percentage of the memory your SQL Server instance utilizes is consumed by buffer pool (essentially, data). Without a lot of digging, it can be hard to tell which of your databases consume the most buffer pool memory, and even more so, which objects within those databases. This information can be quite useful, for example, if you are considering an application change to split your database across multiple servers, or trying to identify databases that are candidates for consolidation.