by Jason L Froebe on March 10, 2013, 2 comments
You can run KVM on just about any modern Linux distribution provided that your host is capable of providing virtualization. The folks over at HowtoForge go through the steps for Ubuntu 12.10. What you will need for the KVM virtual machine: Ubuntu Server 6.06.2 for Intel x86 Sybase SQL Server 11.0.3.3 esd 6 for Linux [...]
by Jason L Froebe on February 20, 2013, 2 comments
Compiling the DBD::Sybase Perl module really requires Microsoft Visual C++ 2005 or higher. To get started open the “Visual Studio 2005 Command Prompt”. You will need to fix the Makefile.PL file: if ( $^O eq ‘MSWin32′ ) { $lib_string = “-L$SYBASE/lib -llibct.lib -llibcs.lib -llibtcl.lib -llibcomn.lib -llibintl.lib -llibblk.lib $attr{EXTRA_LIBS} -lm”; to if ( $^O eq ‘MSWin32′ [...]
by Jason L Froebe on February 15, 2013, no comments
The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]
by Jason L Froebe on November 28, 2011, no comments
Position Responsibilities Provides DBA services for Production, test, and development databases Administers and maintains the production, test, and development databases. Performs SQL code releases Reviews application designs for compliance with production acceptance requirements. Complies with IT policies and procedures, especially those for quality and productivity standards Complies with Information Security policies and procedures. Verifies deliverables [...]
by Jason L Froebe on March 10, 2009, one comment
QweryBuilder uses innovative ideas to provide developers with the ability to easily insert, extract and modify data from a variety of databases. The goal of QweryBuilder is to increase a database developer’s productivity. It contains many time saving features. SQL Editor Script auto complete Custom auto complete lists Code Templates Display column list for tables [...]