About
Harvest Data Corp specializes in automating Retailer data including Walmart's Retail Link data.
More >>Category: Software Development
4 / 26 / 2017
VSTS with code signed PFX certificates
While using VSTS, one of the most common questions is how to code sign your application. It's extremely problematic, because there's no easy way to import a PFX with a password. Step 1: Add a PowerShell Script and put the following as inline code. String $(CertPassword) -AsPlainText -Force Write-Output ("$(System.DefaultWorkingDirectory)" + "\Resources\Harvest.pfx") Import-PfxCertificate -Fi
Read More >>
3 / 14 / 2017
Performance Tuning in Azure SQL Data Warehouse
(This was originally posted on 01/09/2016 on another site and has been moved here) Yesterday I spent over an hour with John Huang (Azure SQL Data Warehouse team) and Martin Lee (MCS – Microsoft Consulting Services). They were extremely graceful in helping me try to performance tune a very difficult query. Since SQLDW is so new, they are looking to see how to help the community as a whole in
Read More >>12 / 19 / 2016
Use VS Code to create PowerShell scripts to move files into folders by date
Recently while cleaning up a bunch of old hard drives and getting ready to sell / give them away, I found a ton of old photos. Unfortunately I found that many of them had the same file names and weren’t sorted at all. In fact, I had no way of filtering them in any way meaningful. I resigned myself to manually create folders by day and throw them into the folders. That las
Read More >>
12 / 2 / 2016
Continuous Integration with VSTS – Tips #1
Now that the blog is officially announced and released, I thought I’d show you a quick tip in how we were able to update our main website through continuous integration and continuous deployment. Since this particular website is used just for our marketing purposes, we currently aren’t using deployment slots, so this helps us out a great deal. All of our code is in GitHub, which I’ll bl
Read More >>