Howtos / Articles

Updating Ubuntu with the APT package manager

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 system makes installing/updating/removing packages extremely simple. The first step in the process is to update the APT sources. This downloads the latest package lists, so…

Read more [...]

How to set the PuTTY window title from within Linux

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 (bell) escape commands. The ^[ escape code in ansi format is "\033]0;”. The ^G escape code in ansi format is “\007 “. To set the…

Read more [...]

List all Stored Procedures on a SQL Database

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'…

Read more [...]

What is the Microsoft SQL Browser Service?

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 onto the network, and detect what SQL servers are available. This is generally presented to the end user with a drop down box listing all…

Read more [...]

Setting a static IP address in CentOS

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 always have the same IP address. There are two options for ensuring you get/use the same IP address at every boot. You could set up…

Read more [...]

Page 38 of 42« First...1020...33343536373839404142