Here, I would like to demonstrate how to find memory leaks in .NET application. To analyze memory leaks, first, you […]

How to resolve disk IO performance problems that are a very important point for SQL Server troubleshooting. Find Average read […]

Tempdb is a system database inside SQL Server, used primarily for internal and temporary operations. In the case of troubleshooting […]

Here are the scripts for find missing index in SQL Server database: SELECT s.last_user_seek, d.object_id, d.equality_columns, d.included_columns, d.statement, s.avg_user_impact FROM […]

To get the current location of device, you have to add reference to System.Device DLL. GeoCoordinateWatcher class supplies location data […]

Problem: Encrypting & Decrypting a String in C# Decrypting PKCS#7 encrypted data in C# Encrypt string with Bouncy Castle AES/CBC/PKCS7 […]

Frequently asked C# interview questions and answers for Experienced. 1. What is the difference between strong typing and weak typing […]

How to Export and Download Excel files with .NET Core? First, add the EPPlus into your project: dotnet add package […]

Here is the simple script to backup SQL Server database: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — […]

Let’s learn how to shrink database in SQL Server Step 1 : Right click on database => properties => options […]