Free Information Technology Magazines and eBooks

Saturday, August 07, 2010

Monitor File Size Changes With Size Matters

Monitor File Size Changes With Size MattersAlthough size capacity of disks today is not an issue anymore because high-capacity disk are now available for a low price, monitoring of free disk space should still be done from time to time to prevent problems due to low disk space. Files such as log files and database files are common types of files that can grow exponentially in days thats why administrators should closely watch them. To monitor it automatically, you can use size monitoring tools such as Size Matters. It is a free software that can easily track multiple files and their sizes. You can add file to monitor in two ways, one is by selecting individual files or by selecting a folder which all files on that folder will be added to the list of monitored files.

Friday, August 06, 2010

SQL Stored Procedure To Generate INSERT Statements For Any Table In A Database

Last night, I was preparing the SQL scripts to deploy my database project to a new server. I had no problem generating scripts for creating database and tables but I needed help on how to generate script to insert initial records on a maintenance table. I remember that I have used a script before that create a stored procedure that can generate INSERT statements for tables in a database. After minutes of research, I found the "sp_generate_inserts" script. To help other SQL administrators and developers, I will post the download link of the script here. Just open the script in Query Analyzer, then run it, the script will create a stored procedure with name of "sp_generate_inserts" under "master" database.

Thursday, August 05, 2010

C# CSV Writer: Class To Extract Data To CSV File

C# CSV Writer: Class To Extract Data To CSV FileComma Separated Values or CSV is one of the commonly used data exchange format between programs. You can learn how to read CSV by reading the following articles; Read CSV to Array and Read CSV using LINQ. In this post, I will show you how you can write a records from a database in to CSV file. The class wrapper I used here is not originally created by me but was downloaded from the internet. The class has two main functions: one writes and return the data as string, and the second function writes data to text stream. The example I will show you will connect to a database, open records with SqlDataReader class, convert it to DataTable and then write it into a CSV file. Here is the step-by-step procedure.

Wednesday, August 04, 2010

Convert DVD Media Format To Run On Portable Devices With Handbrake

I have posted several media converter before such as freemake and Oxelon but i'm not done yet. Today, I want to introduce another similar software that is consistently voted as the best media converter and DVD ripping tool, it is called Handbrake. It is open-source and available to MacOS X, Linux and Windows. The supported media source are DVD-like source (VIDEO_TS folder, DVD image or real DVD, and some .VOB and .TS files) and any multimedia file that libavformat can read and libavcodec can decode. You can convert any source mentioned to MP4 or MKV which are the most popular format for mobile devices.

Tuesday, August 03, 2010

Check For Invalid Internal Links In Your Website With Site Verify

Verify Valid And Dead LinksWhen webmasters regularly updates their websites, sometimes they forgot to update one or more links. Such mistake is understandable because checking each anchor tag (internal links) on your site can be tedious specially if your have hundreds of them. To verify these links automatically, you can use softwares that were built for that purpose. Site Verify is one of them, it is free tool to check the internal links on your website, to see if they are valid. The program will list all internal links and identify them as blue for visited and red for dead or invalid links.

Check For Invalid Internal Links In Your Website With Site Verify

The usage is simple, just enter the URL to test, select the depth you want to be searched, and then click Go. After the process, you have the option to export the result to TXT or CSV format by going to File > Export List menu. Site Verify runs on Windows OS with .NET Framework 2.0 installed. For this article, I tested it under Windows 7.

Download Site Verify

To stay up-to-date on Cool Softwares, subscribe now.

Monday, August 02, 2010

Free Network Management Tool With The Dude

I was looking for an alternative software for Ipswitch WhatsUp when I stumbled upon The Dude. It is freeware but its features are comparable to commercial products. It was developed by MikroTik, a well-known manufacturer of wireless products. The Dude will automatically scan all devices within specified subnets, draw and layout a map of your networks, monitor services of your devices and alert you in case there are problems. Configuration starts with at least one network device, On first start, you have to enter the subnet number you want to scan for devices. The computer network layout is shown as map after a successful connection. Individual devices are displayed with their IP addresses, names, icons, as well as cpu and disk utilization.

Free Network Management Tool With The Dude

You can also add additional devices manually or automatically by right clicking the layout and choosing one of the devices available in the popup menu. A hover or a click on device will show detailed information about it. On the left side bar are lists of available tools to manage your network. Some of these tools are Logs, Mib Nodes and Outages.

The Dude works on 32bit and 64bit of Windows operating system, Linux Wine and MacOS Darwine.

Download The Dude

To stay up-to-date on Cool Softwares, subscribe now.

Sunday, August 01, 2010

Compare Loading Speed of Two Websites With Which Loads Faster

performance comparison between two web pagesFor webmasters, If content is King and then I think website performance is the prince. You may loss potential visitors in your website if it takes forever to load so it is important to always consider the load speed. To help you compare two websites on which loads faster, there is a free online web service called Which Loads Faster. The web application races two web pages and declares who is faster between them. All you need to do is visit the web site, and enter two page urls into the form at the top and click the Go button. After processing, the page load speed of both websites are displayed in milliseconds. The winner is indicated with an arrow plus a percentage showing how much faster it is than the other web page.