Email Alerts
-
Nullifying foreign key statements when loading a test dev MySQL database
MySQL expert Mike Hillyer gives the shutoff command for foreign key checks when loading data. Ask the Expert
-
Backing up databases without a GUI
MySQL expert Mike Hillyer recommends server volume-specific utilities for backing up a database on a Red Hat enterpise without using a GUI. Ask the Expert
-
Connecting to a remote database from a local VB app
MySQL expert Mike Hillyer recommends checking for firewalls before trying to connect a remote database from a local VB application. Ask the Expert
-
Choosing between MySQL 4.0 and MySQL 5.0 for client server app development
MySQL expert Mike Hillyer explains why sometimes IT shops should be aggressive with newer versions of MySQL. Ask the Expert
-
E-mail notification for database record additions
MySQL expert Mike Hillyer recommends using a combination of a trigger and a user-defined function in order to setup automatic e-mail notification of record additions. Ask the Expert
-
Faster, more efficient searches for large quantities of data
MySQL expert Mike Hillyer describes the pitfalls involved in performing text searches with mulitple tables versus a single table. Ask the Expert
-
Finding an OS solution for parsing MySQL databases
MySQL expert Mike Hillyer recommends two open source programs that deal with the export, scanning, searching and sorting od data. Ask the Expert
-
Open source EAI for adapters, transaction management and data transformation
Open source software and applications expert Bernard Golden recommends open source tool OpenAdapter as an EAI solution for adapters, transaction management and data transformation. Ask the Expert
-
Data roots when queried through a view
Sybase expert Mich Talebzadeh explains where data is derived from when queried from a view. Ask the Expert
-
Page master templates in an Impress presentation
Office suites expert Solvieg Haugland tells users how to create templates with multiple page masters using the Impress presentation tool in OpenOffice 2.0. Ask the Expert