Category | Databases

100 MySQL Tips You MUST Know

100 MySQL Tips You MUST Know

Here are 100 Tips, Tricks and Optimizations that you absolutely MUST know and learn if you are going to run MySql. [...]

Databases, Linux, Microsoft, Networking, Servers Comments Off

How To Install a LAMP UBUNTU Server

How To Install a LAMP UBUNTU Server

Arguably the most stable web application/database combo out there is LAMP (Linux, Apache, MySQL and PHP).  Often though you need an engineering degree to install the proper flavours and versions for everything to work smoothly.  Up until now.  In about 15 minutes you can have a LAMP server setup and ready to go. This automatic LAMP installation is a feature of UBUNTU Server Edition. [...]

Databases, General, Linux, Networking, Security, Ubuntu Comments Off

SQL Server Maintenace – Database Consistency Checker – Part 1

SQL Server Maintenace – Database Consistency Checker – Part 1

A useful tool for any SQL Server administrator is the Database Consistency Checker or DBCC. Its commands are at the heart of your database maintenance and have been around since the earliest versions of the SQL Server. This article, part of the series on SQL Server maintenance, will introduce you to the basic commands and practices useful maintaining the integrity of your database. [...]

Databases Comments Off

Quick mySQL Tweaks

Quick mySQL Tweaks

This guide is quick, easy and relatively safe way to enhance mysql performance. It is not a complete guide to tuning, it is a out of the box configuration primer to get a little more bang for your buck.  Database performance tuning is an art, and is site specific, these are general tweks to provide optimal mySQL performance, not necessarily database performance. [...]

Databases Comments Off

Can’t Start MySQL: Error 106

Can’t Start MySQL: Error 106

MySQL database is an excellent option for storing data of any sort and size. However, it does have its little quirks and bugs that seem to pop up here and there. One of them is the infamous MySQL Error 106. Many of database administrators have had this error occur for them, but few knew how to fix it or what causes it. It is a Windows Only error, so if you are using Linux, I would suggest you skip this article and read some of our other features and editorials. [...]

Databases Comments Off

Automatically Inventory Your Computers Using OCS Inventory

Automatically Inventory Your Computers Using OCS Inventory

OCS Inventory NG Open Computer and Software Inventory Next Generation is an application designed to help a network or system administrator keep track of computer configuration and software installed on the network. It also allows deploying software, commands or files on Windows and Linux client computers. [...]

Databases, General, Linux, Networking, Ubuntu, Windows Vista, Windows XP Comments Off

Install OTRS Open Source Ticket Request System in Debian

Install OTRS Open Source Ticket Request System in Debian

OTRS is an Open source Ticket Request System (also well known as trouble ticket system) with many features to manage customer telephone calls and e-mails. The system is built to allow your support, sales, pre-sales, billing, internal IT, helpdesk, etc. department to react quickly to inbound inquiries. [...]

Databases, General, Linux, Networking, Ubuntu, Windows Vista, Windows XP Comments Off

Optimize MySQL Response Time

Optimize MySQL Response Time

High Demand websites can get bogged down and slow to respond when a lot of different visitors visit sites querying the same mysql database server.  There are many ways you can improve mysql server response time: by modifying the cache size, stopping dns resolution etc.  Here are the most common ways to improve response time. Disable DNS Hostname Lookup [...]

Databases, Linux, Networking Comments Off

A New Attack Technique Against Oracle Software

A New Attack Technique Against Oracle Software

By Joris Evers, CNET News.com A new attack technique increases the risk of commonly found bugs in Oracle's database software, a security researcher has warned. It was previously thought that an attacker needed high-level privileges on the database to exploit so-called PL SQL injection vulnerabilities. With a new attack technique, that's no longer true, David Litchfield, a database security expert with NGS Software, said on Thursday at the Black Hat DC event in the US. "It is a trick that can be used by attackers with minimal privileges to gain complete control of the database server," Litchfield said in an interview. "You can use the trick through a large number of vulnerabilities that were previously thought not to be that significant." [...]

Databases, Security Comments Off

GLPI Asset Management Software

GLPI Asset Management Software

GLPI stands for “Gestionnaire libre de parc informatique”, GLPI is the Information Resource-Manager with an additional Administration- Interface. You can use it to build up a database with an inventory for your company (computer, software, printers…). It has enhanced functions to make the daily life for the administrators easier, like a job tracking system with mail-notification and methods to build a database with basic information about your network-topology. [...]

Databases, General, Linux, Networking Comments Off

« Previous Entries
Next Entries »

Categories

Archives