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.
Stored Procedure in SQL Server
In this article I am going to explain about the stored procedure in SQL Server and what is the advantages of using the procedure. I will explain how to create the procedure and how to execute them.
Triggers In SQL Server
In this Article I am going to explain triggers available in SQL server and their advantages and drawback.
Wild Card Characters in SQL Server
Wild card characters are used with like operator to search data for which we don’t know the exact match. Like operator with where condition allow to search for specific pattern with the help of wild card characters. Wild card characters allow to filter data without specifying exact match in where condition, wild card characters allow … Continue reading Wild Card Characters in SQL Server
Constraints In SQL Server
In this article, I am going to explain SQL Server constraints such as Unique key constraint Primary key and foreign key and how to implement constraints in SQL Server.
Introduction to SQL and different SQL commands
In this Article I am going to explain different type of SQL commands which are DDL, DML, DQL, DCL, TCL
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.
Visual Studio Productivity Tips
In this article I am going to share some of the very useful visual studio productivity tips.
Visual Studio Keyboard Shortcuts
In this article I am going to share visual studio keyboard shorts and some very useful productivity tips.
Git Operations With Visual Studio Part -2
In this post, I am going to explain some of the advanced Git operations using Visual Studio, like merging, resolving conflict, sync etc.
Git Operation with Visual Studio
git create repository, git create branch, git commit from visual studio.
In this post, I am going to show some Git operations using Visual Studio without using the Git command line tool.
Custom filter in Angular JS
custom filter in angular js
AngularJS from basic to expert -filters- Day – Five
This article cover filters in angular js
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 – Scope – Data binding- Day – Four
In this article I am going to write about scope and data binding in angular js
Angular JS from basic to expert – Module -Model – Controller – Day Three
This article is part of the series of angular js from basic to expert module module controller day three
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
AngulaJS basic to expert
AngulaJS basic to expert - Day One I am going to write This article series to help you to learn AngularJS 1.x.x as quickly and in simple way from basic to expert level. we … Continue reading AngulaJS basic to expert
DRY Principle
DRY PRINCIPLE: DON’T REPEAT YOURSELF In this article we will discuss: What is DRY. Why be need it. What are its benefits. How to implement it in our daily programing. DRY stand for DON’T REPEAT YOURSELF is a basic principle of software development, aimed to reducing repetition of information. The DRY principle is stated as … Continue reading DRY Principle
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.
Hello
Hi Friends after many articles posted on some other reputed blog i thought i should start my sharing here..............