netnerds.net
Home
Book
Links icon
GitHub Org GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • How to Import Data into SQL Server 2005 From DB2 (AS400/iSeries)

    Feb 21, 2009 · 2 min read  ·
    Share on:

    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: RDBMStpc-cIBM DB26,085,166Oracle4,092,799Microsoft SQL Server1,231,433 I mean, I don't work with servers that require nearly that horsepower but …


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

    Feb 17, 2009 · 2 min read  ·
    Share on:

    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 time figuring out the hostname and LINKEDSERVER..SCHEMA.TABLE didn't work. Once DTS helped me figure out the hostname, I …


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

    Feb 16, 2009 · 4 min read  ·
    Share on:

    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: IBM DB2 DatabaseNetwork NameLUCASTCP …


    Read More
  • Free DB2 Express-C 9.5 on SuSE Linux Enterprise Server

    Feb 15, 2009 · 2 min read  ·
    Share on:

    IBM DB2's free version "DB2 Express-C" is available for download at db2express.com. 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 supposedly successful install. I figured I …


    Read More

Chrissy LeMaire

SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

preorder

dbatools

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.

available from dbatools.io and github

dbachecks

dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI and is available on github.com 📊

recent posts

  • Rebuilding a Proxmox cluster node
  • Default PowerShell Paths (PSModulePath) on GitHub Runners
  • Add existing directory storage to proxmox without wiping it first
  • InspecTools on Offline Windows
  • Chef inspec: Unable to detect your platform
  • Migrating my WordPress sites to GitHub Pages
  • URL Shortening/Redirects using GitHub Pages and Jekyll
  • My Windows Terminal Retro Theme

categories

sql-server 115 powershell 106 general 63 security 58 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 22 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple22 asp-net2 bi4 db24 exchange7 general63 github3 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell106 security58 sharepoint41 sql-server115 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved