Top 50 Most Asked SQL Server Interview Questions and Answers

Top 50 Most Asked SQL Server Interview Questions and Answers

This article covers most asked SQL server interview and answers. This article is useful for the software developers, SQL developers. This article is helpful for experienced as well as freshers. This article covers commonly asked SQL questions shared by many peoples including my experience as an interviewer as well as interviewee.

What is database Normalization and Denormalization.

Database is the software system which used to store the information about an organization or an enterprise or users’ activities or any other business activities information which can use letter. RDBMS RDBMS stands for relational database management system. Relational database management system is based on relational model. In database, data store in the form of tables. … Continue reading What is database Normalization and Denormalization.

Software Design Principles DRY and KISS

In this article, I am going to explore software design principles and their benefits, why design principles are useful for us, and how to implement them in our daily programming. We will explore DRY and KISS software design principles. The DRY Principle - Don’t Repeat Yourself DRY stand for "Don’t Repeat Yourself," a basic principle of … Continue reading Software Design Principles DRY and KISS

AngularJS From Basic To Expert – Day Two – Expression and Directives

Introduction In the previous article of AngularJS from basic to expert -Day one, we have learned what is AngularJS and we have seen some basics of AngularJS and used AngularJS in our demo application. In this article of AngularJS from basic to expert -Day Two, we will learn, AngularJS Expressions. Directives in AngularJS So, I … Continue reading AngularJS From Basic To Expert – Day Two – Expression and Directives

Encryption and Decryption in C#.Net AES and DES Encryption algorithms

In this Article I am going to explore about the encryption and decryption. We will see some of the encryption algorithm with C# example code. There are two type of algorithm used for encryption and decryption: Symmetric Encryption: In this type of encryption, a single key is used for encryption and decryption. It is faster … Continue reading Encryption and Decryption in C#.Net AES and DES Encryption algorithms

Dependency Injection and Inversion of control

In this article I am going to explore Dependency Injection principle in very simple way which is easy to understand and will take example from our daily programming practice. Dependency Injection is a way to resolve tight coupling and create loosely coupled classes. e.g.: public class A { public B b { get; set; } … Continue reading Dependency Injection and Inversion of control

Introduction To JSON. How to use JSON with asp.net.

In this article I am going to introduce JSON like what is JSON, what the use of JSON and creating a sample demo application and in this quick demonstration, I am going to show you how to use JSON with ASP.NET web application and how to access database using JSON. And in the demo application … Continue reading Introduction To JSON. How to use JSON with asp.net.