I’ve been using Microsoft Access since Access 97 it’s a very powerful tool is you use it right. You can use it for everything from personal Baseball card inventory control to managing home inventories; even fortune 500 companies use it to manage million dollar systems. As I said if you use it right it can be quite a powerful tool built on some amazing framework. Recently a friend who’s getting into access asked me if I could provide him some resources so that he can get better familiar with the tool.

This will be the first posting of a new category on my blog regard Kapow Software a Robotic Process Automation (RPA) tool. Before I begin to discuss my usage experiences and technical information regarding Kapow Katalyst, I figure it would be good to give a little background about it. Kapow Katalyst is a Web Data Aggregation Tool; these tools are used to capture data from websites for analytic’s purposes. Where Kapow excels is it allows you to complete your ETL process from a single execution aka a Robot.

When I interviewed with Coyote a discussion came up of passion and I said my passion at work was turning data into insight for my coworkers. During my presentation about myself to our Executive team and my coworkers I realized what my true passion is… it’s to help people. Every job I’ve had involved helping people and at Coyote it’s no different I’m just using my technical skills to help our coworkers and our customers; outside work I love to volunteer with the Jaycees because we help people and make an impact with the work we do around the world.

It’s true when they say no news is good news, my Windows Home Server has been just chugging along currently were approaching 180 days without rebooting, which is quite impressive to even to me. Actually now that think about it I made a major change to my setup back in March. I purchased a Dell PowerEdge 700 for 25 dollars on eBay which a real server instead of an old desktop I had lying around.

Here’s another fun solution for you business intelligence people out there. Suppose you wanted to pull data that was updated in the last 15mins based on when a row was last. I’m sure there are many ways to accomplish this but I like to use the DATEADD() function in Microsoft SQL Server 2008. Below is the query using the AdventureWorks2008R2 database enjoy. SELECT I.ProductID, I.LocationID, I.Bin, I.Shelf, I.Quantity, P.ProductNumber, P.Name, I.

On September 8th my campaign to serve the Illinois Jaycees members as their 2013 Membership Development Vice President came to end with me being elected. It’s true competing for the time of our members has gotten tougher each year our chapter, region, and state boards have gotten stretched too thin, burned out quickly, not adequately trained and weaker. As a result our members have suffered. Next year I want to focus on shaping the future of our organization.