SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typically there are refinements or caveats that should be taken into account as part of their implementation. This principle becomes quite evident when considering use cases of Sort transformation, which is the subject of this article.

Database Performance Transparency

by Ron Johnson

SQLServerCentral.com

Performance Tuning

Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.

Going Solo

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on Mar 20, 2007. It is being republished as Steve Jones is on vacation. Today Steve Jones talks about going into business for yourself, and reminding you it's not as simple as it might seem.

Rebuilding SQL Server indexes using the ONLINE option

by Additional Articles

MSSQLTips.com

Indexing

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.

Feedback and Big Data

by Steve Jones

SQLServerCentral.com

Editorial

Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.

Raw Materials - Consultant, Superstar

by Larry Gonick

SQLServerCentral.com

Raw Materials

Does success in one field transfer to another?

TSQL function to detect SQL Agent job state

by Bret Lowery

SQLServerCentral.com

T-SQL

This article has a T-SQL function to detect the SQL Agent job state.

Converting String Data to XML and XML to String Data

by Additional Articles

SimpleTalk

In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.

Aggregate Function Product()

by Paul McPherson

SQLServerCentral.com

T-SQL

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.

Insider Security Threats

by Steve Jones

SQLServerCentral.com

Editorial

The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.

SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation

Database Performance Transparency

Going Solo

Rebuilding SQL Server indexes using the ONLINE option

Feedback and Big Data

Raw Materials - Consultant, Superstar

TSQL function to detect SQL Agent job state

Converting String Data to XML and XML to String Data

Aggregate Function Product()

Insider Security Threats

Blogs

Database AI Agents: The Read-Only Rule

Creating a SQL Stored Procedure to Load a SCD2

Funny Money: #SQLNewBlogger

Forums

Pro SQL Server Internals

SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry

Running SQLCMD II

Question of the Day

Running SQLCMD II