code-adda Microsoft excel shortcuts

All the Useful Microsoft Excel Keyboard Shortcuts

August 26, 2019 Ravi Ranjan Kumar 0

There are many keyword shortcuts available for Microsoft Excel. Here we’ve tried to gather all the useful keywords and managed to display category wise, so you can find as per your interest. And, Don’t worry! almost all of mentioned excel shortcuts have been around for a long time, so they […]

Code-Adda.com Change SQL Server Password Thumbnail

How to change or reset SQL Server Password

June 28, 2019 Ravi Ranjan Kumar 0

It might be possible that you forgot the password of SQL Server for SA login and you want to get it back anyhow. This can be happen because of not using SQL server for while and maybe password was too complex so it was not easy to remember. Whatever There […]

SQL Server : Missing Index

SQL SERVER – How to find missing Index

April 13, 2019 Ravi Ranjan Kumar 0

Introduction If you are looking for a solution to find the missing index in your SQL Server database, I can assume you already know the impact of the missing index on your applications. Well organized Index strategy plays a vital role in your application performance. If your application interacts a […]

No Image

SQL SERVER – How to Fix Error : ‘System.OutOfMemoryException’ was thrown. (mscorlib) while executing script

March 9, 2019 Ravi Ranjan Kumar 0

In this article, we will learn how to solve System.OutOfMemoryException error while executing scripts in SQL Server Management Studio. Issue : It is ok to execute average size of the script using SQL Server Management Studio but If you want to execute a large SQL script in SQL Server Management […]

SQL SERVER – How to Fix Error : Database diagram support objects cannot be installed

February 21, 2019 Ravi Ranjan Kumar 1

What is a Database Diagram Support in SQL SERVER SQL Server management studio(Any versions) allows you to create Database Diagrams to use graphically and show the complete structure of the database. Additionally, you can create and modify tables, columns, relationships, Indexes and constraints there. Error: Database diagram support objects cannot be […]

How to solve SSL/TLS validation error while making connection in C#

February 17, 2019 Ravi Ranjan Kumar 0

In this article, you will learn how to deal with SSL/TLS validation error using C#. If you are trying to establish a connection with a web server using c# and getting an exception as given below : SocketException: An existing connection was forcibly closed by the remote host IOException: Unable […]

RabbitMQ with C#

January 27, 2019 Ravi Ranjan Kumar 0

In this article, you will learn how to write a basic program using RabbitMQ and C# like how to create connections, how to publish a message in the queue and how to receive that message from a queue. Before writing code, I assume you have already had some idea about […]

JWT Authentication with ASP.NET WEB API

January 20, 2019 Ravi Ranjan Kumar 9

In this article, we will learn how to authenticate ASP.NET WEB API using JSON Web Token(JWT). If you are new to JWT then I would like to request you to please go through with our article which briefly explains A Basic Introduction to JSON Web Token(JWT). You can also read […]

A Basic Introduction to JSON Web Token(JWT)

January 13, 2019 Ravi Ranjan Kumar 1

In this article, you will learn the basic fundamental of JWT like how it works, what is JWT, what is the structure of JWT. If you would like to implement JWT based authentication in your API, you can either use one of the existing open source libraries JWT.io available for […]

No Image

How to use FileUpload control inside ASP.Net AJAX Update Panel

January 9, 2019 Ravi Ranjan Kumar 0

There are plenty of questions asked by developers around the globe that they are not able to use FileUpload asp.net control inside ASP.Net Ajax update panel. Their issues are FileUpload control inside Asp.Net Ajax update panel doesn’t hold any file and also return false for HasFile property whenever they upload […]