Most Recent Articles

Welcome to the Knowledge Database! This is where we share articles on how to use your hosting and the other software we provide to you. We also have a number of technical how-to‘s and script examples.

Archive and Compress a linux directory
Posted By : matt.nelson at 9:11 pm, 03 August 2010    In Group : Linux

Linux LogoFollow the simple instructions in this tutorial to archive and compress a folder in unix. This will work on your home PC or on your server using SSH.


Bypass and remove the VBA password in Excel
Posted By : matt.nelson at 6:11 pm, 23 July 2010    In Group : Excel

Excel IconSo, you want to get at some code that you saved in an excel spreadsheet but you can't remember the VBA password! Dont worry, there are a couple of simple ways to bypass this password altogether.


Essential BASH commands
Posted By : matt.nelson at 9:18 pm, 14 May 2010    In Group : Linux

This tutorial presents the Linux terminal and the "bash" shell to people who have never used a command line to give commands to an operating system before, or who have never done so in Linux/Unix. This is as much a reminder to myself of useful commands as it is for you.


Fix the passive netstat connections in Munin
Posted By : matt.nelson at 11:16 am, 02 May 2010    In Group : Hosting

Munin LogoIf your running Munin in WHM they you may have noticed the passive netstat connections have been rising steadily over the last couple of weeks. This isn't a problem with your server, its a Munin bug that can be easily fixed.


Place a VBA array into an excel range
Posted By : matt.nelson at 2:03 pm, 30 March 2010    In Group : Excel

When using Excel and VBA to sort through large amount of data, most people will simply use a 'For Loop' or a 'While Wend' to write data from an array back to the sheet. This is extremely inefficient. Have a look at this short code snippet to see how to dump large amounts of data from an array into an excel range.


cPanel - Logging in and looking around
Posted By : matt.nelson at 9:03 pm, 18 March 2010    In Group : cPanel

cPanel LogoBy using cPanel you can control almost everything on your server. This includes adding email addresses and FTP accounts, uploading files, creating your own 404 messages and viewing your stats. This tutorial will show where to start and how to access your control panel.



Write articles for SilverArk and get upto a 15% discount on ALL hosting packages!