Category Archives: Microsoft

Intro To Kapow Katalyst

This will be the first posting of a new category on my blog regard Kapow Software. 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 what known as 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. Robots can get pretty detailed in length and if you’re reusing code across multiple robots you can insert snippets instead of rewriting the code. Check out the video below for more information regarding this product.

WHS Just Chugging Along

 

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. This was a major performance increase and adds additional room to the cabinet for more hard drives, I think like another 2 or 4 which I’m thinking of throwing all my old drives into the pool to just max out the space. Also I’m not sure what to do with the tape drive currently installed.

Below are the server specs I’m currently running on my most revision to the configuration:

  • 3.2 GHZ Pentium IV
  • 2GB RAM
  • 2 x 500GB SATA
  • External 250GB Backups
  • OS: Windows Home Server

 

 

Querying The Most Recent Records

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

FROM AdventureWorks2008R2.Production.ProductInventory AS I LEFT OUTER JOIN AdventureWorks2008R2.Production.Product AS P ON I.ProductID = P.ProductID

WHERE (I.ModifiedDate >= REPLACE(CONVERT(VARCHAR(19), DATEADD(minute,-30,GETDATE()), 120),‘-‘, ‘/’))

 

 

P.S. Before the query in the example will work on the AdventureWorks database you’ll need to update a couple of rows on the ProductInventory table.