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 SQL Server 1,231,433 I mean, I don't work with servers that require nearly that …

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 …

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 …

IBM DB2's free version "DB2 Express-C" is available for download at db2express.com (archived). 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 …

A frustrated administrator friend just messaged me, asking how he can, in VBScript, "run a simple batch file using a simple command line without defining a billion vars and initting a bunch of bullshit." Apparently, this isn't well documented on the web, so I'm taking a stab at it. Set WshShell = …

UPDATE: These days, just use dbatools Copy-DbaLogin (the successor to my original Copy-SqlLogin script from the retired TechNet Gallery). One line, and DBAs love it. To my knowledge, Microsoft has not yet updated their Knowledge Base to inform administrators how to migrate SQL Server logins to SQL Server 2008. The good …

My technical partner-in-crime, Brandon, created this PowerShell script last year in an effort to help him understand PowerShell a bit more. He noted that while it may not all be best practices SQL-wise, he tried his best to use as much PowerShell as possible. Note: This post targets PowerShell 1.0 and SQL Server 2005. …

While attempting to add a new Indexing Server to my firm's SharePoint farm using the SharePoint Products and Technologies Configuration Wizard, I ran into the following error when clicking Retrieve Database Names: ************** Exception Text ************** System.Data.SqlClient.SqlException: Line 1: Incorrect syntax …

This has come up a few times for me, so I'm documenting this mostly for myself. Sometimes, clicking on the SharedServices1 link results in: Error: Access Denied Current User You are currently signed in as: MOSSERVER\AdminLogin Surprisingly, I was using a domain admin account and still ran into this error. According to …

Recently, a friend of mine asked to write a script to compare two SQL Server tables using mostly VBScript. The very thought made me shudder; I wanted desperately to compare the tables in SQL Server but ultimately, the company's requirements prevented us from doing so. Here were the stipulations: First, the script …