Ask the Experts

Ask the Experts

• Detection deadlock algorithms in MySQL

  An expert describes where to find information on detection deadlock algorithms in MySQL.  Continue Reading

• Xandros, Linspire and Microsoft

  An open source issues and strategies expert discusses the impact of patents, licensing and the partnerships between Xandros, Linspire and Microsoft.  Continue Reading

• Preserving templates in Oxygen Office Professional 2.0.4 and OpenOffice 2.0

  An office suite expert tells how to save office templates in one office suite, Oxygen Office Professional 2.0.4., for a user considering an upgrade to OpenOffice 2.0.  Continue Reading

• MySQL query cache

  An expert defines MySQL's query cache and describes when to use it and when to avoid it.  Continue Reading

• Comparing functions in Excel vs. Base

  An OpenOffice expert describes how to perform the Excel tasks, like math functions and the "insert merge field" command, in OpenOffice's database program, Base.  Continue Reading

• Integrating applications with Linux

  A Unix-Linux migration expert offers some key points to consider when transferring native applications from Unix to Linux.  Continue Reading

• 3 ways for inserting spreadsheets Writer documents

  An OpenOffice expert describes three methods for inserting spreadsheets into a Writer document in OpenOffice 2.0.  Continue Reading

• MySQL's query optimizer

  A MySQL expert describes the role of the query optimizer and provides an example of how it works.  Continue Reading

• Setting up SSH for remote, secure server access

  A Linux security expert gives non-operating system specific advice on setting up Secure Shell (SSH) for remote access from a server.  Continue Reading

• SquidGuard as Linux proxy for Windows XP

  A Linux security expert recommends a helpful SquidGuard tutorial for a user having trouble running redirec_program /usr/bin/squidGuard.  Continue Reading

• Securing Fedora Core 5 against attackers

  A Linux security expert recommends several best practices for hardening your Fedora Core 5 proxy server.  Continue Reading

• Alert vs. log in the Snort /var/log/snort directory

  A Linux security expert explains that the difference between the Snort alert and log logs in the Snort /var/log/snort directory is based on how rules are written.  Continue Reading

• Running Nagios on RHEL 5 or Solaris 10

  A security expert recommends using a Linux-based operating system, like Red Hat, with open source network monitoring tool Nagios.  Continue Reading

• Creating triggers to remove users

  A MySQL expert gives an example of a foreign key and a trigger to use when removing users from tables.  Continue Reading

• Reporting Nagios data to BMC Patrol

  A security expert describes how to configure open source network monitoring tool Nagios so that data alerts, reports and other information generated are sent to BMC Patrol, which will be used as an alert tool.  Continue Reading