The Helpdesk For I.T. Administrators
A Microsoft SQL database consists of at least two files, a data file (.mdf) and a transaction log file (.ldf). The data file contains all the data for the database, as you would expect. The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes …
Updating the software running on a operating system is an important part of maintaining a computer. Not only does it allow you to keep up to date with the latest features in the applications you use, it is also crucial to keep your system as secure as possible. The YUM (Yellowdog Updater Modified) package management …
Updating the software running on a operating system is an important part of maintaining a computer. Not only does it allow you to keep up to date with the latest features in the applications you use, it is also crucial to keep your system as secure as possible. The APT (Advanced Package Tool) package management …
PuTTY is a popular SSH client for a variety of operating systems. You can set up the window title in the configuration options, but sometimes you may want to display your own information in the window title text. PuTTY lets you do this via escape commands. More specifically by using the ^[ (escape) and ^G …
Ever wanted to know what stored procedures exist on a database, but don’t have access to the SQL managment tools? The script below will produce a list of all the stored procedures on the current database. SELECT Name AS StoredProcedureName FROM sys.objects WHERE type=’P’
The Microsoft SQL Browser Service is a service that runs on a machine that has Microsoft SQL Server installed, and provides information to clients about the SQL server instances installed on the PC. When you are connecting an application to a SQL server, generally the software has the capabilities to send a broadcast query out …
During a default install of CentOS it will try to either automatically obtain an IP address using DHCP, or it wont even set up the network interface automatically. While that may be fine for most desktop users, if you are wanting to set up a server, the chances are you will be wanting it to …
Nginx (pronounced Engine-X) is a fast & lightweight HTTP and HTTPS web server (it can also act as a reverse proxy, and perform load balancing). Its small memory footprint requirements make it great for systems with small amounts of memory, such as low end cloud servers. Nginx is great for serving static files to users, …
During a default install of Ubuntu it will try and automatically obtain an IP address using DHCP. While that may be fine for most users, if you are wanting to set up a server, the chances are you will be wanting it to always have the same IP address. There are two options for ensuring …
The NFS (Network File System) file system allows client machines to access files from another computer/server over a network connection. It was originally developed in 1984, and is still in wide use today. It is typically used with Unix/Linux systems, however many other operating systems contain support for NFS, whether that be inbuilt into the …