1. Two Random Asterisk-Related SQL Queries

    Posted on in voice

    I hate losing useful SQL queries, so I tend to save them. Ever so often, I stumble across a file of queries from some work I was doing months ago. The following two queries are just such a case. I was analyzing some call data for a call center that …

  2. Is Microsoft Security Essentials for Business?

    Posted on in IT Management

    Considering the economy and the crunch that many IT departments are feeling, it is no surprise that many small to medium businesses are curious about using Microsoft's free security product as a replacement to the enterprise security solutions they have been using. Individual businesses will have to decide if Microsoft …

  3. Cisco iperf Equivalent or Cisco-based Bandwidth Testing

    Posted on in Networking

    If you've worked on networks long enough, you're probably familiar with iperf. This application is great for testing throughput between two computers on your network. Unfortunately, if you find yourself in a situation where you have less than two computers to test with, iperf is less than ideal.

    Fortunately, Cisco …

  4. Subversion: Revert to Earlier Version

    Posted on in Programming

    This is one of those annoying little things I have to do ever so often. There are two different commands to accomplish this task depending on the specific situation.

    If you've made a lot of changes to a file and need to back all of those changes out, you can …

  5. Rate-limiting SSH connections with iptables

    Posted on in System Administration

    If you have SSH open toward the Internet, you are surely aware of the number of brute force password attempts your server sees everyday. Although a good password policy may make these attempts nothing more than an annoyance, each connection to your SSH daemon takes up valuable server resources. I …

  6. Set Mac OS X Time Zone from the Command Line

    Posted on in System Administration

    Viewing and changing the time zone in Mac OS X via the command line uses the systemsetup command:

    $ sudo systemsetup -gettimezone
    Time Zone: US/Eastern
    $ sudo systemsetup -listtimezones
    <snipped>
    $ sudo systemsetup -settimezone US/Central
    Set TimeZone: US/Central
    $ sudo systemsetup -gettimezone
    Time Zone: US/Central
    

    Set Mac OS X Time Zone from the Command LineThis command is available both …

  7. Archiving Windows Directories With 7-Zip and a FOR Loop

    Posted on in System Administration

    I recently needed to archive a bunch of old home directories on a CIFS share mounted on my Windows XP virtual machine. I wanted each home directory to be archived independently so that I would have lots of smaller zip files rather than one huge one. Additionally, maintaining the directory …

  8. Viewing NetApp A-SIS Deduplication Space Savings

    Posted on in System Administration

    Network Appliance (NetApp) advanced single-instance storage (A-SIS) deduplication is a free technology that ships with every NetApp filer. The technology works at the block level to efficiently compress volumes so that you can get more data in a limited space. All the deduplication setup and maintenance operations are controlled with …

  9. New Google Apps Sync for Outlook Improves GAL Functionality

    Posted on in Software

    Before version 1.8, Google Apps Sync for Microsoft Outlook did not support automatic updating of your domain's Global Address List (GAL). Domain administrators were forced to creating a static copy of the GAL and make that available to Outlook via a change in the desktop's registry. With the latest …

Slaptijack's Koding Kraken