• Excel Puzzler - Problem Solved with AverageIf Function

    I could write SQL to solve this problem.. but the data was in Excel.

    I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data…

  • Can Toad Data Point help me win the lottery?

    I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'

    I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…

  • Bridging the (SQL) gap with Toad’s Query Builder

    Toad for Oracle’s Query Builder window provides a quick method for creating the framework of a SQL queries (Select, Insert, Update, or Delete statement). Additionally, one can select Tables, Views, or Synonyms, join columns, select columns, and generate…

  • Wanted: Data scientist — Will pay top dollar for the right person!

    Data scientists are in high demand. Across a range of industries, organizations are searching for highly skilled data scientists (aka data analysts) who can make sense of the rapidly rising volume, variety and velocity of data available today. Those data…

  • Fast and Furious Agile Development

    If we’ve learned anything from the cinematic achievement that is all 72 Fast and Furious films, it’s that high-stakes operations can quickly go awry with the slightest technical glitch. Staying ahead of the competition requires agility and rapid…

  • Isn’t it time to expect more from IT management?

    It's Your Time

    It’s crazy - technology and business are moving faster than ever and you’re sprinting just to keep up. Meanwhile, your workday is wasted on tons of repetitive, day-to-day tasks. That’s why we hosted a Virtual Tradeshow.

    The bad news…