Blog Archives

How to Import Data into SQL Server 2005 From DB2 (AS400/iSeries)

Ever since I read how much IBM’s DB2 SMOKED Oracle and SQL Server in the tpc-c (OLTP) benchmarks, I’ve wanted to work with it. The benchmarks go a little something like this: RDBMS tpc-c IBM DB2 6,085,166 Oracle 4,092,799 Microsoft

Posted in DB2, SQL Server

IBM DB2: Five Ways to Discover the Hostname of an iSeries Server for Use in a Four-Part Table Name

I admit, I don’t have too much experience with DB2 yet. But it’s on my to-do list and I’m working on it. I recently had to import some data from DB2 hosted on an iSeries server. I had the hardest

Posted in DB2

Create a DB2-C Express 9.5 Linked Server in SQL Server 2008

In order to emulate a DB2/iSeries<->SQL Server setup that I deal with at work, I installed DB2 Express-C on SuSE Linux Enterprise Server 10. The DB2/Linux Server details, as well as a sample database and table name, are as follows:

Posted in DB2, SQL Server

Free DB2 Express-C 9.5 on SuSE Linux Enterprise Server

IBM DB2’s free version “DB2 Express-C” is available for download at So far, I’ve successfully installed and uninstalled DB2 Express on SLES 10 SP2. While there was a command line installer included (db2_install), the server wouldn’t start after a

Posted in DB2, Linux

Migrating SQL Server?

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command.

Available from and github

SqlServer Needs You

SqlServer now has a dedicated engineer and Microsoft is asking for our input!

Upvote priorities and cmdlets now


Chrissy LeMaire

Brandon Abshire
View Brandon Abshire, MCDBA's profile on LinkedIn


Chrissy has been awarded the Microsoft MVP for her work in the PowerShell community.

Join us!

Belgian PowerShell
User Group

  SQL PASS PowerShell
Virtual User Group


Upvotes Needed

Help persuade Microsoft to open source SQL Server's PowerShell module, SQLPS.

Upvote now on Microsoft Connect