The Helpdesk For I.T. Administrators
If you have just tried to install a copy of OSX86, upon rebooting, you may just get a black screen with the following error in the top left corner: boot0: error One of the more common reasons for this is because the OSX86 installation was done to a extended partition, instead of a primary partition. …
Microsoft SQL Server allows you to add multiple triggers on a specific table. This is a great feature of Microsoft SQL Server, however one of the issues that can catch people out is in the order that the triggers will ‘fire’. By default, the triggers will run in the order that they were created/added to …
Minimizing the time it takes for an MS SQL query to run is important when creating an application or website. You can always add more resources on the SQL server, such as RAM and CPU, but that doesn’t really fix the source of the issues, especially if the there are large volumes of SQL transactions. …
This ‘How To’ article outlines the steps required to compile and install the Firebird database server on a Linux machine. Download the latest version of the source code from http://www.firebirdsql.org/en/server-packages/ At the time of writing this article, the latest version was 2.5.1.26351-0. Replace the URL below with the latest version, or get the source code …
HAProxy is a free, reliable, high performance load balancing solution capable of proxying TCP and HTTP applications. This article will outline how to set up a simple HAProxy server to allow you to load balance web site requests to one or more back-end web servers. While this example may not be suitable for a production …
Its always good to have a firewall set up to prevent users from accessing services they shouldn’t have access to, however this usually means that you need to explicitly allow specific ports and protocols to allow users to access services they need to access. One such service would be a database server. Below is a …
Below is a list of my top 5 network monitoring tools for Linux, in no particular order. Nagios Nagios is a network monitoring application that is capable of alerting a system administrator in the event that something goes wrong on a network, and even when it comes good again. Nagios lets you monitor network services …
In Microsoft SQL server 2000 and 2005, as part of the ‘BACKUP LOG’ command, there was an option to truncate the log file, without storing a backup to file. In Microsoft SQL Server 2008, this option has been removed, and you can now no longer use the ‘TRUNCATE_ONLY’ option when performing a transaction log backup. …
The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes in the database are first saved to the transaction log, before being updated in the main data file. The transaction log file can allow a database administrator to recover a database back to a …
The “ApacheTop” package has been written to allow users to monitor real time statistics based on the Apache log files. ApacheTop is a great way to keep an eye on your Apache web server statistics. It allows you to monitor how many requests you get (total and per second), bandwidth usage (total and per second), …