A guest editorial from Grant Fritchey today talks examines the free advice that is often given in the forums. It's not free consulting and you shouldn't expect that.

SSIS object search using T-SQL

by James Greaves

SQLServerCentral.com

Integration Services (SSIS)

Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.

Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data

by Additional Articles

SQL Server Performance

Spatial Data

Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.

The ORM Dilemma

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about ORM frameworks and the dilemma of using them. They save time, but might not solve all your problems.

Efficient SQL Server Indexing by Design

by Additional Articles

Database Journal

Indexing

Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.

No More Reviews

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones doesn't like annual performance reviews, and has some evidence that they might be worth getting rid of.

No SFTP Task Component in SSIS 2005/2008? No Problem!

by Stan Kulp

SQLServerCentral.com

Integration Services (SSIS)

SSIS 2005 and 2008 have an FTP Task component, but no SFTP (SSH/TLS-encrypted FTP) Task component. This tutorial explains how to overcome this omission.

How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as a data source in SSRS 2008 R2.