MS SQL Server

Standard Naming Conventions for SQL Database Design

Naming Conventions is an important factors for any type of database design. It’s benefits are high. It makes a simple database generic for others. This article describes what standard should …

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 …

SQL Server Interview Questions and Answers

MS SQL Server is a computer programs that is primarily used to store and retrieve information. This article describes some important questions with answers in MS SQL Server. Hope it …

Transactional Replication with Updatable Subscriptions

It is similar to the Transactional Replication that works with every transaction. It has some extra features. Here, both Publisher and Subscribers can update the existing data. It uses MSDTC …

Transactional Replication in SQL Server

Transactional Replication works with every transaction. When any changes made at the Publisher end, it’s delivered it to the Subscriber almost in the real time. Except first snapshot, it only …

Snapshot Replication in SQL Server

The simplest type of replication is snapshot replication. In snapshot the entire copy of the publisher is copied from the Publisher to the Subscriber’s. This article explains how to configure …

Configuring Distributor

Distributor is the servers that manage the whole replication system. It act like a middle man for publisher and subscriber. This article explains how to setup a distribution in ms …

Cross Tab Queries using PIVOT in SQL

Some times we need to convert row to column in SQL. We can do that by using basic SQL query. But most of the time it may complex. For that …

How to use Paging in SQL Queries?

Paging is one of the most important tasks when developers developed applications. This article describes how to use paging in SQL queries or How to select 5-10 records?. In SQL …

MS SQL Server is a computer application that is primarily used to store and retrieve data. This program is developed by Microsoft Corporation. At present most of the developing applications …

Difference Between Primary Key and Unique Key

In relational database system primary key and unique key are two important concepts. Both are used to uniquely identify a row in a table. Though both can identify a row …

How to make a Great Primary Key?

The primary key is in important factor for any relational database. It plays a vital role. It has numerous functionalities. On a table we can create a primary key in …

SQL Server Agent

SQL Server Agent or SQL Agent is a Microsoft Windows service that executes scheduled automated tasks. In SQL Server this task is called jobs. This article explains SQL Server Agent. …

How to Check the Status of SQL Server Agent?

SQL Server Agent is very important to perform automated tasks. If the agent goes stop, no automated task will be executed. This article explains how to check SQL Server Agent …

Error Handling or Exception Handling in SQL Server

Error handling or exception handling is the most vital part of any software development. Generally we are not interested to show any type of application error to end user. Error …

Data Types in SQL Server

The data type is an attribute that defines the type of data that the object can hold. During table creation we have to decide what types of data will be …

SQL Views

In SQL, a View is a virtual table that is generated based on a SQL statement. It has no own data, but it returns data from others table. This article …

What are the Difference between SQL Server Replication and Mirroring?

SQL server replication and database mirroring is used copy data into different server or location. Anybody can confused with them. Both have some difference. This article describes some difference between …

Bulk Data Insertion from CSV to SQL Server

Bulk Insertion is a process to insert massive data into database. There are several ways to insert bulk data from CSV files into database. This article explains how to insert …

Difference between Join and Union

In relational database, the basic functionality of Join and Union is to combined two ore more tables. Everyone follow their own mechanism. This article describes a comparison between Join and …

Data Model or Database Model

The database model is the internal structure of a database system. This describes the internal functionality of the database. Every database system follow at list one data model. This article …