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

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

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

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