Newsletters Archive - 2010

If you would like to know more about the Newsletter, please email me.

  Connect to SQL Server 2008 from Linux using Perl DBI — (19-September-2010)

If you are a system administrator or DBA, you know the importance of scripting. 
For many administrators, the choice is Perl. Given the fact that Perl is open 
source, available on almost all O/S platforms and extremely modular, many 
popular modules have been developed to extend the language. DBAs for example, 
have enjoyed the ease of scripting database functions using the "Database 
independent interface for Perl" or better known as DBI.

The DBI is a database access module for the Perl programming language. It 
defines a set of methods, variables, and conventions that provide a consistent 
database interface, independent of the actual database being used.

The following article describes how to access Microsoft SQL Server 2008 from a 
Linux server using the Perl DBD::Sybase driver module (this is the Sybase 
driver for the Perl DBI) combined with FreeTDS. FreeTDS is a set of libraries 
for Unix and Linux that allows your programs to natively talk to Microsoft SQL 
Server 2008 and Sybase databases.

Connect to SQL Server 2008 from Linux using Perl DBI

Jeffrey M. Hunter, OCP
Sr. Database Administrator