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.

  • Hacking PingPlotter, Part 2

    In the previous column on hacking PingPlotter I discussed how you can use the tool's Web interface and the curl utility to add targets to be tracked, for example, to add a single host you would enter the following on the command line:

  • How to protect yourself against privileged user abuse

    The typical organization loses 5% of its revenues to fraud by its own employees each year, with most thefts committed by trusted employees in executive management, operations, accounting, sales, customer service or purchasing, according to the Association of Certified Fraud Examiners (ACFE). This type of malicious behavior by "privileged users" who have been given broad access to the company's computer assets has captured the attention of CIOs across the country.

  • 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.

  • How to sort your Facebook feed by time on mobile

    Weddings. Job promotions. News articles. Facebook thinks it knows what the best stories are to drop in your news feed. But some users might want to see things their own way.

  • How to change the voice on your Android phone

    Changing the voice used for navigation on an Android phone from robotic to something more natural is easy, but buried in the menus.

  • 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.

  • Learn to build a PC in under two minutes

    Building a computer is a great way to get a custom configuration, save some money and have fun. In a how-to video, we'll show you how to build one in less than two minutes.

  • Saving YouTube videos for offline viewing

    Watching a YouTube video typically requires an Internet connection, but with a little preparation the videos can be saved for later offline viewing.

  • Secure location sharing with smartphone app

    Running late for a meet up with friends or an appointment? Share a location securely and for a limited time period with smartphone application Glympse. It's a free download for Android, iOS, Windows Phone and BlackBerry.

  • 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.

  • Tech Tip: Advanced Google search functions

    Searching Google is a quick way to find information, but more advanced functions can help users find more helpful information faster.

  • Free Amazon Web Services -- and how to make the most of them

    If you avoid some gotchas and keep a close eye on resource usage, you can have a handy server in the Amazon cloud for free

  • How to script: A Bash crash course

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

  • Cyberstalking with LinkedIn

    You just left cocktail hour or a networking event and forgot to grab a business card from the person you'd been chatting with. Don't kick yourself. Instead, log on to LinkedIn to do some cyberstalking. It's a much better resource than Facebook, because with just bits and pieces of information, you're still likely to be able to find your target.

  • Control your TV with your smartphone, tablet

    Using your smartphone or tablet to control your Tivo box is easy and offers a lot of flexibility in recording shows and channel surfing.

  • 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

  • CIO
    ARN
    Techworld
    CMO