software

software - News, Features, and Slideshows

Tutorials

  • 10 more do's and don'ts for faster SQL queries

    Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even if there is no right answer to tuning every query, there are plenty of proven do's and don'ts to help light the way. While some are RDBMS-specific, most of these tips apply to any relational database.

  • Automate image editing with GIMP

    For a project I was recently working on I needed to remove the white background from several hundred images in PNG format and replace it with transparency. I know you can automate Photoshop but that's like getting into a Sherman tank to go shopping at your local supermarket. Another constraint (other than my reluctance to wrangle Photoshop) was the need to be able to do this in the future as part of a process to be built into a virtual machine running Linux.

  • To get the most out of WebRTC, integrate it into existing collaboration tools

    This vendor-written tech primer has been edited by Network World to eliminate product promotion, but readers should note it will likely favor the submitter's approach.

  • 5 tips for data manipulation in Excel

    If you work with data much, you don't need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of data cleaning and reformatting often turn to scripting languages like Python or specialty tools such as OpenRefine or R.

  • Google Earth power user tips

    Google Earth users can do more than just fly around a virtual globe. The free mapping application can display real-time weather, help compose photographs and measure distances much more easily than its Maps cousin.

  • Saving Google Maps destinations for easy navigation

    Saving a destination in Google Maps makes it easier to navigate to and also lessens the chance for error when entering or trying to remember an address.

  • How to script: A Bash crash course

    An easy step-by-step guide to the Bash command-line shell and shell scripting

  • 5 excellent uses of Windows 8 Hyper-V

    Windows 8's bare-metal virtualization layer is a great way to create an app sandbox, run a test machine, launch a VHD appliance, and more

  • How-to: Get started with MySQL

    An easy step-by-step guide to setting up a MySQL database server, along with phpMyAdmin, on Fedora, CentOS, or Ubuntu

  • Internet Explorer 9: A getting started guide

    Microsoft's Internet Explorer 9 officially launched late Monday and is ready for download here.

  • Enable iTunes Home Sharing in iOS 4.3

    The next major iOS update is slated to be released this Friday, March 11, alongside the ultra-hyped iPad 2. One of the key features is a little something called iTunes Home Sharing, which allows users to stream music, podcasts, movies and more from PC to iOS device.

  • Open source FreeOTFE encrypts disks handily

    FreeOTFE may sound like a political bumper sticker, but it stands for "Free On The Fly Encryption." The "Free" part is self-explanatory; "On The Fly Encryption" refers to the encrypting/decrypting of data as it is written to or read from your hard disk.

  • Digitize your movies

    Analog movies can be the easiest--or the hardest--medium to digitize, depending on the format you're working with. While older camcorder and video formats such as 8mm and Hi8 or VHS and Betamax tapes are easy to transfer, digitizing film can be difficult at best.

  • Prepare your PC for future data disasters

    Reformatting and restoring a PC is not fun--in the way spending 2 hours in the dentist's chair is not fun. You have to back up all your data (and pray that you haven't forgotten anything), reformat the hard drive, install Windows, track down missing drivers, find and reload all your software, restore your data, and pull out clumps of hair over the things you inevitably neglected to save. (Firefox plug-ins, anyone?)

  • Stop Facebook from cluttering your inbox

    There's a fine line between awesome and annoying. Take Facebook: Most of the time, it's great, but a few things about the service drive me crazy.