by Jason L Froebe on February 16, 2013, no comments
It doesn’t work with Microsoft Visual Studio 6. It requires Visual Studio 2005 (minimum). Digging out my 2005 disc. Starting to build the DBD::Sybase ActiveState PPMs for Windows 32bit and 64bit. Should have at least one version out tomorrow
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 November 5, 2009, 3 comments
Back in December of 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases. He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design. Dia is available for [...]
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 [...]