When you create a build pipeline you must sometime decide at runtime whether run some code or not. One of the options for this is output variables. It enables you to set a variable in one job and use this variable in the next job.

Last time we created a gated check-in build for .NET Core app. It works very well, but we did there one thing which is in general a bad practice in our proficiency. We duplicated build steps for building and testing .NET Core app. We can do better than that, we can use templates. Following the documentation: Templates let you define reusable content, logic, and parameters. Templates function in two ways. You can insert reusable content with a template or you can use a template to control what is allowed...

The goal of Cache@2 task is improving build performance by caching files between pipeline runs. It supports multiple types of packages likeBundler gemsnpm packagesYarn packagesNuGet packagesMaven artifactsGradle artifactsccache artifacts Further, we will focus on caching NuGet packages however in a similar manner we can configure this task for other types.Locking dependencies Before we configure cache task we need to lock dependencies to create packages.lock.json file as we need that file to set a prop...

This story has begun quite long ago. I got a chance to work on projects without the automatic deployment process. It was strange a bit because we had deployments process for both front-end and back-end projects, but not for databases. For databases, we were generating SQL scripts from Visual Studio, and then we executed them in our Test environment. This was a perfect place to save our time and FAKE did the right job here. We use Visual Studio SQL Server DB projects to handle SQL scripts. And exactly th...

FSharp helps you find duplicates in your project file 03 Jan 2017 | Category: Programming | Tag: F# On my daily work, I deal with a complex solution counting more than 100 projects. As probably like the most of you, we have branches dedicated to production, testing and development. In such environment, it is a normal thing that you have to merge your changes from one branch to another. And sometimes, not everything will go smoothly. Then, when someone overwrites merged changes, roll back becomes prob...

How to report your SQL - FSharp and XPlot make it easy 26 Dec 2016 | Category: Programming | Tag: F#, SQL It's a time to go further. Recently we modified SqlProfilerTraceAnalyzer by adding different ways of showing recorded trace. Today we'll do something even better - we'll generate an HTML page with charts showing count, the total and the average time for our SQL. After that, we'll add a table containing information about our store procedures. Last time we used F# Charting, but today we'll take a...

How to trace your SQL12 Dec 2016 | Category: Programming | Tag: F#, SQL Have you ever thought how many store procedures your code is calling? Have you tracked them to find duplicate calls? Maybe there is a place which could be optimized but going through the code without information what procedure you are looking for is difficult or at least time consuming. There is probably a many ways to do that but here you'll find a way with F#.