Today Steve Jones talks about interviews and the way in which he approaches them to make sure that the job is the best fit for both the company and the candidate.

SSIS FTP Task – Receive Files from FTP Site

by Raunak Jhawar

SQLServerCentral.com

FTP Task

This article will show you how to configure the FTP task in SSIS to recieve files from remote server using the FTP protocol.

Database Continuous Integration 101

by Additional Articles

Other

Continuous Integration (CI)

We talk a lot about continuous integration here on the Atlassian Dev Tools blog, and many readers are bonafide CI gurus. Now that you are integrating your application code, test code, config files and deploy scripts, are you ready to take it to the next level? An increasing number of engineering shops are starting to bring the continuous integration discipline into their database development.

The PoSh DBA: Grown-Up PowerShell Functions

by Additional Articles

SimpleTalk

PowerShell

Laerte Junior goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's chores.

Connect QuickBooks to SQL Server through SSIS

by Eric Madariaga

SQLServerCentral.com

Integration Services (SSIS)

This example uses an SSIS workflow to populate a database with QuickBooks data.

Happy Memorial Day 2012

by Steve Jones

SQLServerCentral.com

Editorial

It's Memorial Day in the US and Steve out is paying tribute to our soldiers and cutting grass on the tractor. He's left you a blooper reel to enjoy.

To Specialize or Not to Specialize: that is the $132,000 Question

by Rodney-Landrum

SQLServerCentral.com

Database Weekly

In a guest editorial, Rodney Landrum reflects on his career path as a an information-hungry generalist.

Simple step by step process to import MS Access data into SQL Server using SSIS

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

Sometimes we need to import information from MS Access. We could use the Microsoft SQL Server Migration Assistant, but sometimes we need to add custom transformations and it is necessary to use more sophisticated tools. In this tip, we are going to walk through step by step how to migrate a MS Access table to SQL Server using SQL Server Integration Services (SSIS).