Blazor: How to fix System.NullReferenceException in _Host.cshtml file

I'm currently experimenting with Blazor, a Microsoft Web Framework, and the other day I encountered a strange error that took me a while to figure out how to fix. When running the Blazor Server App, I received the System.NullReferenceException: 'Object reference not set to an instance of an object.' exception error in Visual Studio inside the generated _Host.cshtml file.

SSMS : How to fix SQL Server Management Studio not opening problem

Recently, I installed the SQL Server Management Studio 18 (SSMS) and after just one use, it didn't want to start anymore. The SQL Server Management Studio stopped loading after the splash screen showing up for a brief moment and no messages appeared to show me what was wrong, except for Windows playing the default beep sound notifying me of a problem. In this article, I will show you how I solved this issue.

Telerik-Kendo-UI : How to force exported PDF to open in a browser

Recently, I was experimenting with Telerik Kendo UI HTML Framework and in particular, I was exploring the PDF Export feature that allows you to convert HTML content into a PDF. I wanted for generated PDF to open in a new browser tab, but all the examples I found on the web worked in such a way that the file was downloaded on your computer. After a little research, I was able to find the solution that makes the PDF open in the browser in a new tab and this is the focus of this tutorial.

SQL : How to use SQL Profiler with SQL Server Express Edition

SQL Server Express is a free edition of Microsoft SQL Server family that although fully functional, it has some technical limitations like maximum database size per database. It also has some features missing from paid editions. One of those features not available with Express edition is SQL Profiler. In this post I will list the alternative tools for SQL Profiling that can be used with either SQL Server Express or can be used as the SQL Express replacement.

.NET : How to save DataTable to Database Table using C#

Recently I wanted to save DataTable data into the database. I assumed this would be easy using Entity Framework, but it turns out it is not, since DataTable consists of rows and columns while the Entity Framework deals with objects. Another way is to use ADO.NET by iterating through the rows in the DataTable and inserting each row using SqlCommand and INSERT statement, but there is an easier way to accomplish this and that is by using SqlBulkCopy class, which is the focus of this article.

ASP.NET : How to solve logging out before timeout expires problem

A while ago I had the task of setting up an old ASP.NET 3.5 application on a shared hosting server and after I was done, the application worked as it should except for one important bit. The application used a Forms Authentication to authenticate users and after users logged in they were getting logging out and redirected to the login page after a really short amount of time, usually only after a few minutes.
In this article, I will show different ways I tried to locate this problem and how I finally managed to fix this issue.

SQL : How to solve Northwind Database Install Error in SQL Server

Recently I was going through a database programming tutorial that used Northwind Database in code examples, so I thought "No problem, I'll quickly add that database to my SQL Server 2012". I assumed this would be easy but to my surprise that wasn't the case.

In this post, I will show you what problems I encountered while trying to install the Northwind database and how I finally managed to make it work.