Email Alerts
-
Setting limits to slave numbers in MySQL 5.0
MySQL expert Mike Hillyer describes how increasing the number of slaves will impact operations traffic on the master side. Ask the Expert
-
Using the SELECT and WHERE clauses to display data
MySQL expert Mike Hillyer explains the command sequences needed for using the SELECT and WHERE clauses to narrow down data results. Ask the Expert
-
HTML interface for a MySQL server
MySQL expert Mike Hillyer recommends using phpmyadmin to create an HTML interface for users who want to link to MySQL. Ask the Expert
-
Finding a utility to import fixed field data
MySQL expert Mike Hillyer explains how a user can import fixed field and delimited files using the LOAD FILE INFILE syntax of MySQL instead of using Microsoft Access. Ask the Expert
-
MySQL CEO Mickos: Beware of proprietary vendors' giveaways
Beware proprietary vendors bearing free software. MySQL AB CEO Marten Mickos warns users to watch out for vendor lock-in strategies and overpriced service organizations. Article
-
PostgreSQL vs. SQL Server: PostgreSQL is right for the Microsoft stack
Is open source database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column. Article
-
Golden's Rules: Migrating from SQL Server to MySQL
Databases are a key piece of every organization's software infrastructure. They are complex pieces of software that we rely on to rapidly spit out data in response to queries and to reliably track transactions, never losing track of the fact that a p... Column
-
Test versions of Sybase
Sybase expert Mich Talebzadeh recommends a link to a user seeking to test out Sybase. Ask the Expert
-
Avoiding deadlocks in ASE
Sybase expert Mich Talebzadeh gives tips on how to avoid deadlocks in ASE, such as using stored procedures and writing transactions to acquire locks in the same order on the system. Ask the Expert
-
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