October 21, 2020

Index Optimization Tips

This article describes how to optimization indexes in table? Summary of the article: What is Index Optimization? Index Optimization Tips What is Index Optimization? Index Optimization is the process to …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

NoSQL

There was a time we only understood the relational database. But with relational database we did not full fill our all types of requirements. Every time relational database is not …

Read More

What is Big Data?

Big data is a general term used to describe the exponential growth and the availability of structured and unstructured data. At present big data is very important to business and …

Read More

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 …

Read More

MS SQL Server

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 …

Read More

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 …

Read More

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.  …

Read More

SQL or Structured Query Language

This article describes introduction to SQL, basic overview of SQL. Summary of the article: What is SQL? Why we should Use SQL? SQL Statements SQL Commands SQL Functions What is …

Read More