The Helpdesk For I.T. Administrators
Sometimes you may encounter data integrity issues with one or more tables on a Microsoft SQL server. These errors may be found during a data integrity check using DBCC CHECKDB, or even via general use of the database. There are 3 options to correct the database integrity issues; safe repair, restore, and non safe repair …
Microsoft SQL server 2008 has the ability to automatically shrink database files. By default this option is disabled. With automatic shrinking of database files turned on, the SQL server will periodically check the available free space within the database files, and will automatically shrink the files if needed. If your database has heavy use, it …
Nginx is a high performance web server, which can also act as a great reverse proxy. Reverse proxy’s are placed in front of the web server handling the processing, to speed the site up, by either caching data, and/or load balancing across multiple back-end web servers. This howto will outline the steps required to set …
A default installation of PHP and Apache on a Ubuntu 13.04 will set a maximum upload limit of 2MB. Quite often you will want to increase this to a larger size. How high you set this limit will depend on your requirements. This howto guide will step you through the process to increase the PHP …
By default, Ubuntu 13.04 doesn’t enable the rewrite engine module after installing Apache. The rewrite engine for Apache allows for on-the-fly URL rewriting/changing. This allows for the use of urls that are human readable, and SEO friendly. The rewrite engine is capable of capturing a website request, running it through a series of expression checks, …
This “how to” guide will step you through the process of setting up Nginx, PHP, and MySQL on Ubuntu 13.04.
If you have a application that uses TCP network communication and it seems to be running slow, you may find that it is because of a feature in Windows called TCP auto tuning. TCP tuning can be used to speed up network communications, but it can also greatly effect performance if not done correctly. By …
Since Windows Vista was released, Windows has had a security feature called the Virtual Store. Some legacy applications will try and read/write configuration files in a location that would require administrative privledges (eg. C:\program files\<application>). The Virtual Store is used to allow these applications to continue to be able to read/write files in this location …
This guide shows you how to view a list of all the listening UDP ports on a Windows machine. This is useful for knowing if a service is listening on a specific port. View all listening UDP ports on Windows: Open the command prompt. Run the following command: netstat -an | find “UDP” | more …
This guide shows you how to view a list of all the listening TCP ports on a Windows machine. This is useful for knowing if a service is listening on a specific port, or if you need to know if a specific port is available to use for something like a web server. View all …