Showing posts from April, 2018

Programmatically add Other Search Engines to Google Chrome for VSTS Shortcuts

When I'm working with a new repo/project in VSTS , I like to set up shortcuts in Google Chrome to be able to quickly jump to a specific Work Item, PR, Build, or Release based on the ID. To do this, I take advantage of Chrome's " other search engines " settings. You can manually add these by specifying a Short Name, a Keyword, and the URL to navigate to when that keyword is typed into the browser's address bar. Until now, I would manually add these URLs one at a time, but being a lazy developer, I wanted a way to automate this process. I discovered that Chrome uses a SQLite database to store these values, and you can side-load new entries by simply performing a SQL Insert into the `keywords` table of that SQLite database! You can use the following SQL Script to insert the default set of shortcuts I usually add for each new VSTS project/repo: Steps to Add:  1. Ensure all instan

Location of SqlPackage.exe on VSTS and Azure

If you're looking to deploy a Visual Studio Database Project  via VSTS to Azure, you can use the Azure SQL Database Deployment  Release Task to include the deployment in your CI/CD process. When a .dbproj builds, it creates a .dacpac file that contains the database definition/schema. The DB Deployment Release Task uses the SqlPackage.exe executable to deploy/sync the target database with the definitions in the dacpac file. SqlPackage.exe can do more than just `publish`. However, at this time, the publish action is the only action supported by that release task. If you'd like to perform other actions (e.g. `DeployReport` or `Script`), you can call the SqlPackage.exe directly using a PowerShell Script Release Task. However, to do that, you'll need to know the location of the SqlPackage.exe on the VSTS host, because it is not available in the PATH by default. To find the location of SqlPackage.exe, the Azure SQL DB Deploy task uses this utility script:  https://git

Sync Github Gists with Git Repo

I needed an easy way to sync  github gists  to my local machines and I couldn't find anything provided by gist, or any other open source projects out there so I put this little node app together quick. Simply clone this repo and update the `users.json` file to sync all the associated public gists to your local machine. The node app uses the gists api  and `git clone`s each gist into a folder with the same name as it's id: Hope this helps! Aaron