Jason L. Froebe - Tech tips and How Tos for Fellow Techies

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 [...]

Migration migraines: the top seven DBA data headaches
Posted by Adrian Bridgwater

Once or twice a year I get to work with an excellent DBA pal from Illinois called Jason Froebe who describes himself as a, “Perlmonger capable of speaking fluent munchkin.” His personal blog is called Ramblings of a Geek, but I keep telling him he [...]

The latest craze from software vendors to companies is to charge for each and every core a machine has regardless of whether or not you’re going to use it.
Get this, if you want to buy a production license for your database/middleware/web server, the vendor (starts with an “S”) wants you to send them the hardware [...]

MyDatabases Volume 1 Issue 1 (July 2008)

MyDatabases Volume 1 Issue 1
Geek Spotlight:  Michael Peppler
Sybase ASE on Ubuntu 8.04
Multicore Processors
VMware Virtualization
Logical Process Manager

I know you can simulate it by creating a temp table with an identity column, delete old rows, get the max, etc but still… PostgreSQL’s create sequence would be very handy…  btw, Oracle has it too
It would allow us to do things like pgTAP with ease..  Check out the slides for pgTAP
just [...]