netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss

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

    calendar Feb 21, 2009 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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-c
    IBM DB26,085,166
    Oracle4,092,799
    Microsoft 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

    calendar Feb 17, 2009 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar Feb 16, 2009 · 4 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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 Database
    Network NameLUCAS
    TCP Port50000
    InstanceDB2INST1
    DatabaseSAMPLE …

    Read More

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

    calendar Feb 15, 2009 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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.

GenAI book

Buy the MEAP at manning.com for 45% off with code gaipbl45

AI Integration Series

  • Automation with AI Toolkit + GH Models
  • Getting Started with AI for PowerShell
  • Asking Tiny Questions: Local LLMs
  • Local Models Demystified
  • Asking Bigger Questions: Remote LLMs
  • PDF Text to SQL Data with OpenAI
  • Document Classification in SharePoint
  • Azure Functions Doc Parser

dbatools book

Now available in bookstores and amazon 🥳 Buy it at manning.com for 50% off with code bldbatools50

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 📊

Find me

Find me on Bluesky

recent posts

  • Document Intelligence with Azure Functions: A Practical Implementation
  • Automating Document Classification in SharePoint with Power Platform and AI
  • Asking Bigger Questions: Remote LLMs for Automation Engineers
  • AI Integration for PowerShell Developers: Getting Started with PSOpenAI and GitHub Models
  • AI Automation with AI Toolkit for VS Code and GitHub Models: A Visual Guide
  • Asking Tiny Questions: Local LLMs for PowerShell Devs
  • Local models mildly demystified
  • Let's talk about anti-AI slop: my plead for schools to teach AI literacy

categories

powershell 128 sql-server 123 general 64 security 60 windows 47 sharepoint 42 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 genai 14 github 10
All Categories
active-directory37 ai1 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 devcontainers1 exchange7 genai14 general64 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell128 security60 sharepoint42 sql-server123 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved