How to fix the When passing parameters by position, each parameter can only be referenced once Dapper error

I lately had to write some queries using Dapper which use a date, defined from the user, and check this date against two other from-to dates. In other words the query tries to find if a given date is inside the range of two other dates. When I tried to use the same date-parameter to Dapper, I was getting the following exception: When passing parameters by position, each parameter can only be referenced once.

Read the complete article

Use the ISNULL function in MSSQL to define default values in your queries

When I work with SQL-Views and create complex SELECT statements that return data from multiple tables, I like to define default values in case a row contains columns with NULL as value. To do this I use the ISNULL function.

Read the complete article

How to fix the "Unable to retrieve child resources. This request is not authorized to perform this operation" error on Azure Storage Explorer

If you use the Azure cloud for hosting your application, chances are that you are also using a Storage Account and you are accessing its content via the Azure Storage Explorer tool.

If you are all of the sudden get the Unable to retrieve child resources. This request is not authorized to perform this operation error, then a possible reason for that is that the IP you are using to connect to Azure is not yet white-listed

Read the complete article

The complete guide on how to update your Jekyll blog to the latest version on your Windows machine

I lately had to install Jekyll on my new machine for some local development and realized that I should also update the Jekyll version of my blog. With this guide I am going to show you the steps for updating your Jekyll blog and how to fix a number of possible errors, if your blog or its dependencies are outdated.

Read the complete article

Azure DevOps - Get the capacity of your team in the current sprint programmatically

Microsoft Azure DevOps provides a solid way of tracking your team-progress while using the scrum principles.

Nuget Packages with WebApi Clients are provided for accessing your team information via code. For example you can access the queries of your team, the work items of your backlog and much more!

In this article we will focus on getting the capacity of the current sprint for each member of your team. This is the code snippet that does our job:

Read the complete article