Email Alerts
-
Oracle and MySQL: Licensing and the Linux enterprise space
Will Oracle trump MySQL in the Linux space? Find out how one expert sees the impact of Oracle's Linux and learn more about the ins and outs of MySQL licensing. Tip
-
PostgreSQL or MySQL: Which is faster?
There isn't always a clear-cut answer in the race between dueling databases, PostgreSQL and MySQL, says an expert. Find out his thoughts and how the two compare. Tip
-
MySQL database features: ACID, buffer pools and blob fields
A MySQL core-certified expert outlines some of the basic functions and purposes of buffer pools, ACID-compliant transactions and more. Tip
-
Chapter 5 of "The Definitive Guide to MySQL 5"
Chapter 5 of "The Definitive Guide to MySQL 5" describes installation and configuration of MySQL Administrator and using SQL commands in Query Browser. Tip
-
Triggers and mutating table errors in MySQL
Discover what can trigger mutating table errors MySQL and learn about the differences between statement and row triggers. Tip
-
Using the data pilot: OpenOffice.org Calc's answer to pivot tables
The data pilot, the OpenOffice equivalent to Excel pivot tables, is a useful feature that lets you apply functions and slice and dice data to see different parts of it in different ways. An expert demonstrates the basics of the data pilot, two filter... Tip
-
Exporting data from an OpenOffice.org Base database
There is no clear-cut method for exporting data from OpenOffice 2.0's Base database, but you can learn how and get some handy shortcuts in this tip. In a snap, you'll get table data into a Writer document and turn it into a spreadsheet or delimited t... Tip
-
Sybase ASE 15 diagram
Sybase expert Mich Talebzadeh has created a diagram of Sybase ASE 15's architecture for those who need a quick reference. Tip
-
Sybase ASE: Performance benefits of DPL and DRL
Take advantage of data page locking (DPL) and data row locking (DRL), two categories of data only locked (DOL) tables in Sybase ASE. These functions offer improved table scans, decreased logical I/O consumption and more. Tip
-
PostgreSQL vs. SQL Server, Oracle: Enterprise-ready and able to compete
Why pay licensing costs and maintenance fees for proprietary databases when you can get open source RDBMS PostgreSQL for free? Discover the drawbacks and advantages to using PostgreSQL over Oracle or SQL Server. Tip