May 28, 2007
Tuning LAMP systems, Part 1: Understanding the LAMP architecture

Applications using the LAMP (Linux®, Apache, MySQL, PHP/Perl) architecture are constantly being developed and deployed. But often the server administrator has little control over the application itself because it's written by someone else. This series of three articles discusses many of the server configuration items that can make or break an application's performance. This first article covers the LAMP architecture, some measurement techniques, and some basic Linux kernel, disk, and file system tweaks. Successive articles investigate tuning the Apache, MySQL, and PHP components.

May 23, 2007
[freetds] Registering the ODBC Driver With unixODBC

Is there anything specific I need to do to make perl aware of the freetds driver?

unixODBC - MS SQL Server

This document will help unixODBC users access an MS SQL Server from a unixODBC equipped client.

Debian -- tdsodbc

FreeTDS is an implementation of the Tabular DataStream protocol, used for connecting to MS SQL and Sybase servers over TCP/IP.

This package includes the ODBC driver for FreeTDS, for use with UnixODBC or iODBC.

Connecting to MS SQL Server from Unix

I've written this page as I keep getting questions on how to access MS SQL Server from Unix. I have never had any reason talk to SQL Server from Unix myself, but since people kept asking me how to do it, I decided to compile an web page with the tiny fragments of information and I have. The main focus is in on Perl programming, but users of other languages should be able to find information here as well.

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.

May 22, 2007
Free or cheap ODBC-to-ODBC bridge from Linux to MS SQL 7.0 software

I need an ODBC to ODBC bridge piece of software that allows a Perl script running on a Linux machine to make SQL queries to a Microsoft SQL Server 7.0. There are commercial products available, but they tend to be rather expensive (e.g., Easysoft). Is there a free or cheap (less than $200) that you KNOW works and is not horribly difficult to install and use on a RH Linux 7.x platform?

Perl DBI/DBD::ODBC Tutorial Part 3 - Connecting Perl on *NIX

This tutorial shows you how to access MS SQL Server databases from Perl on UNIX and Linux by using the Easysoft ODBC-ODBC Bridge (OOB). The OOB is a client/server product. The OOB Client is compatible with Perl DBI/DBD::ODBC. The OOB Server accesses MS SQL Server by using the Windows MS SQL Server ODBC driver.