Stories & Tips

Up to date information on Retail data, the latest in Technology and related matters to Microsoft

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 >>
2 / 22 / 2017

Power Pivot & Power BI training in Bentonville at Walmart Intl Building

Here are Harvest, we’re proud of our partnerships.  Last year we were fortunate to help Walmart International bring in Rob Collie who wrote the book on PowerPivot for training.  We’re very fortunate he’s back here this year again for private on-site training that we are making available to our readers and customers. What is Power Pivot? PowerPivot is a built-in Microsoft EXCEL Add In (2013

Read More >>
2 / 13 / 2017

DAX calculation for local time versus UTC

DAX is Microsoft’s powerful language behind Excel and Power BI.  Very few users of Excel know that you can utilize it, but it’s predominately available in one of the most underutilized features called PowerPivot.  Fortunately DAX is used also in Power BI and while creating a report for use by a customer I needed to translate log times from local time and compare it to UTC time. Probl

Read More >>
2 / 8 / 2017

Spam domains

So recently I’ve had some issues with people calling and emailing trying to get my business for outsourcing.  Looks like my information was “scraped” from LinkedIn.  In an effort to help others, here is a list of domains that I’m blocking.  I’ll keep it updated as I block them from our email server.  I’ll put the newer domains at the top. It’s important to note th

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 >>
10 / 17 / 2016

Updated Blog

It’s been a long time since our company has had a blog site.  We’ve decided to revive it including some posts we’ve made at other locations over the years that are still relevant today.  We look forward to having guest bloggers and hope to share what with the community at whole.

Read More >>