SQL Queries Optimization Tips

Every time we writes lot of SQL queries. But most of the time we don’t consider its efficiency. Query optimization is an important factor for any database related applications. Its importance is high. It can makes any complex application simple, faster. This article describes how we can optimize SQL query? Summary of the article: What is SQL Query

Find a string inside an entire database

Some time we need to search a string inside an entire database. But we don’t know the name of the table or even the name of the column inside the table of SQL Server Database. This article discuss how to search a string inside an entire database and display the results in a table. Select

CRUD operations in AngularJS and Web API

AngularJS is one of the most popular client-side JavaScript frameworks on the web. It helps us to create Single-Page Application (SPA) using HTML, CSS, and JavaScript. It provides MVC structure for developing SPA applications. ASP.NET Web API is a good choice for providing data for these types of applications. This article explains how to perform

New Features in SQL Server 2012

Microsoft Corporation released SQL Server 2012 (codenamed “Denali”) on April 2012. Microsoft includes lot of new features and enhancements with SQL Server 2012 including a new look for SQL Server Management Studio (SSMS). The SSMS is now similar to Visual Studio with greatly improved Intelligence support. This article describes what’s new in SQL Server 2012?

What is Cloud Computing?

The cloud computing system is an important part of modern communication systems. This article explains an introduction to cloud computing system. Summary of the article: What is Cloud Computing? History of Cloud Computing Examples of Cloud Computing Types of Cloud Computing Deployment Model Advantages of Cloud Computing Disadvantages of Cloud Computing What is Cloud Computing?

What is JSON?

JSON is a text-based data exchange format that enables us to quickly and easily share information between all of our systems and devices. Like most famous XML, it is platform independent and human readable. This article explains JSON (JavaScript Object Notification), its relationship to JavaScript, and the difference between JSON and XML. This is an

Object Oriented Analysis and Design (OOAD)

Object Oriented (OO) concepts can be applied in the phases of software development life cycle (analysis, design, and implementation). It is very important to understand the OO analysis and design concepts. This article explains basic overview of object-oriented analysis and design, benefits of OOAD. Summary of the article: What is Traditional Systems Analysis and Design?

Assembly in .NET application

In the Microsoft .Net Framework, Assemblies are the compiled code. They are created as an output of a program. The CLR (Common Language Runtime) uses these assemblies and convert into machine language during the execution of that program. This article is an introduction to .NET assemblies and explain how to create .Net assemblies? Summary of

Test Driven Development (TDD)

Test driven development is an advanced technique that uses unit tests to drive the design of software. It is a technique for building software that guides software development by writing tests. This article explain an introduction to Test-driven Development. Summary of the article: What is Test Driven Development (TDD)? History of TDD TDD Life Cycle

Domain Driven Design (DDD)

Domain Driven Design or DDD is a software development technique. This article explains about the basic overview of Domain Driven Design (DDD), some key features of DDD. Summary of the article: What is Domain-Driven Design (DDD)? History of DDD How do we do DDD? What is Domain-Driven Design (DDD)? Domain Driven Design or Domain Driven Development