Abhith Rajan

All Stories

Microsoft SQL Server Guy Trying Oracle Database

This post contains my personal experiences trying Oracle Database.

In sql-server, oracle-database, May 08, 2019 · 2 min read

Docker - SQL Error on ASP.NET Core Alpine

Having trouble to connect to a remote SQL server from an ASP.NET Core app running on top of Alpine dotnet on a linux container?

In aspnet-core, docker, sql-server, May 07, 2019 · 2 min read

Gatsby - Cookbook

This cookbook contains recipes that demonstrate how to solve common problems while working with Gatsby.

In gatsby, cookbook, react, April 26, 2019 · 2 min read

ASP.NET Core - Handling Custom Header on Request/Response

There may be situations where you want to add a custom header in your ASP.NET Core API response or you need to read a header from the request.

In aspnet-core, April 25, 2019 · 1 min read

Microsoft Orleans - Run Multiple Silos from a .NET Core Console App

If you are new to Microsoft Orleans and you are in a stage where you want to run multiple Silo from a single .NET Core console app, here is a way to achieve that.

In microsoft-orleans, dotnet-core, April 24, 2019 · 1 min read

Best Visual Studio Code Extensions

My favorite extensions for Visual Studio Code

In visual-studio-code, ide, best-series, February 12, 2019 · 3 min read

Project management - Organize issues using labels

Here I am listing the labels which I used to manage my projects in Gitlab and GitHub.

In project-management, github, gitlab, February 06, 2019 · 2 min read

GitLab - Clone a repository when 2FA enabled

You need to use a personal access token to clone your repository from GitLab when Two Factor authentication is enabled. Which explained here.

In gitlab, git, December 19, 2018 · 2 min read

Filtering, Paging and Sorting in SQL Server 2008

This article provide one solution to achieve server side paging, sorting and filtering in SQL Server 2008.

In sql-server, November 22, 2018 · 2 min read

.netstandard2.0 Project - DocFX MSBuild Error

If you are facing issues when trying to generate documentation for your .netstandard2.0 project. Try the solution mentioned in this post.

In dotnet-core, docfx, documentation, November 20, 2018 · 1 min read

Docker: Cookbook

If you are new to docker then this post might be useful. It contains solutions to common problems, regular use case commands and some additional resources.

In docker, cookbook, October 28, 2018 · 6 min read

Pad a number with leading zeros in SQL to make uniform char length

When you are in need of transforming a number to have some character to be prefixed in order to make the chars in the number a specific number long, here is one way to do it.

In sql-server, October 01, 2018 · 1 min read

The Best Extensions for Visual Studio 2010

List of extensions which improves default experience of Visual Studio 2010

In visual-studio, best-series, September 30, 2018 · 2 min read

ASP.NET Core - Starting the web server is taking longer than expected

If you are staring on a Visual Studio message saying "Starting the web server is taking longer than expected", this article might help you.

In aspnet-core, May 13, 2018 · 1 min read

Flutter Cookbook

This cookbook will help you solve common problems while writing Flutter apps.

In flutter, cookbook, dart, April 30, 2018 · 2 min read

React Native - Build APK

You can build APK (debug) from your react native project by using three commands.

In react-native, April 24, 2018 · 1 min read

IIS - OPTIONS Requests Returns 404

If OPTIONS preflight request getting 404 and URLScan enabled on your hosting machine, check out this article.

In iis, aspnet, April 19, 2018 · 2 min read

.NET Interview Questions and Answers

Here I am listing some of the interview questions I have faced when applied for .NET developer/Software engineer roles.

In interview, dotnet, aspdotnet, wcf, April 12, 2018 · 14 min read

Enable Click-Jacking Protection - Umbraco

If your site is allowed to be IFRAMEd by another site and thus would be susceptible to click-jacking. This can be prevented by setting X-Frame-Options header or CSP. Setting X-Frame-Options explained in this article.

In umbraco, web-config, website-security, asp.net, April 07, 2018 · 2 min read

Fix: Web deploy - could not verify the server certificate

Fix for "Web deployment task failed. (Connected to the remote computer ("xxx") using the specified process ("Web Management Service"), but could not verify the server’s certificate. If you trust the server, connect again and allow untrusted certificates.

In visual-studio, ide, April 06, 2018 · 1 min read

Fetch Row Count for All Tables in a SQL SERVER

Using a short query we can list all the tables in the database along with the number of records in each table.

In sql-server, March 11, 2018 · 1 min read

Download file using WCF REST Service

Download file using WCF Service

In wcf, rest, dotnet, March 07, 2018 · 2 min read

Vue.js List Rendering : Limit items in v-for

One way to limit the iteration of items in Vue v-for directive.

In vue, javascript, February 27, 2018 · 3 min read

Sitefinity Development - Problems and Solutions

During my first Sitefinity project, I encountered few problems, in which some of them are explained here.

In cookbook, sitefinity, cms, January 19, 2018 · 2 min read

ASP.NET Web Forms - Manually Trigger Client Side Validation

You can manually trigger client-side validation for ASP.NET Web Forms Server side controls. One way of doing it explained here.

In aspnet-web-forms, sharepoint, January 15, 2018 · 2 min read

Best Font for Visual Studio

Need a font family with a great monospaced variant for programmers? Find the best here.

In visual-studio, ide, best-series, January 15, 2018 · 1 min read

IP Security - Configure IP address restrictions in Web.Config on IIS

Restrict access to your website using IIS IP security

In iis, security, aspnet, January 09, 2018 · 2 min read

2017 Year In Review

Abhith Rajan's 2017 year in review.

In general, January 01, 2018 · 9 min read

Sitefinity - Caching issue for pages with NO CACHING profile

If you experiencing cache issue for pages with No Caching profile in Sitefinity, check this post.

In cache, sitefinity, cms, December 18, 2017 · 2 min read

Sitefinity - Read localized resource labels in MVC widget

Explains how to get localized labels in Sitefinity MVC widgets.

In sitefinity, cms, localization, December 07, 2017 · 1 min read

Visual Studio keeps crashing - First Aid

Things you can try to solve the random crashes of Visual Studio.

In visual-studio, ide, debug, November 20, 2017 · 3 min read

Markdown - Link within document

This is a short article on how to link within the document in a markdown (.md) file.

In markdown, gatsby, November 06, 2017 · 1 min read

JavaScript - Determine if user is on mobile device

You can use navigator.userAgent value to determine if the user is on a mobile device.

In javascript, October 25, 2017 · 1 min read

Remove specific class from all elements - jQuery

This a short article about how can we remove a specific class from all elements that do have the class easily using jQuery.

In javascript, jquery, October 23, 2017 · 1 min read

Sitefinity Rookie Guide : Get Users in a Custom Role

To get users in a custom role, make sure to use the Role manager with Default Provider in Sitefinity.

In sitefinity, cms, October 21, 2017 · 1 min read

Git branch not showing in Visual Studio Team Explorer

If you are having trouble to see the newly created (remote) git branches in the Visual Studio Team Explorer, try the workaround provided in this article.

In git, visual-studio, ide, October 11, 2017 · 1 min read

Hunting security bugs in an old web application

In this post, I am sharing one of my security bug hunting experience in an older ASP.NET web form project.

In aspnet-web-forms, security, web-config, October 09, 2017 · 4 min read

Get/Set hidden field value using jQuery

This article explains how to set and get hidden field value using jQuery.

In javascript, jquery, aspnet-web-forms, October 01, 2017 · 1 min read

Redirect HTTPS requests to HTTP using IIS Rewrite rule in Web.Config

Use the provided rewrite rule to redirect HTTPS requests to HTTP.

In iis, seo, web-config, rewrite-rule, aspnet, September 28, 2017 · 1 min read

Redirect HTTP to HTTPS using Web.Config in IIS

Use IIS Rewrite rule to redirect all HTTP request to HTTPS.

In iis, seo, web-config, rewrite-rule, aspnet, September 25, 2017 · 1 min read

Redirect WWW to Non-WWW using Web.Config in IIS

Use IIS rewrite rule to redirect (301) all www requests to non-www.

In iis, seo, web-config, rewrite-rule, aspnet, September 19, 2017 · 1 min read

Determine Total Number of Open/Active Connections in MS SQL Server

This article contains a SQL query which can be used to determine the total number of open/active connections in MS SQL Server. Also explains, how to solve the error "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

In entity-framework, sql-server, September 16, 2017 · 2 min read