Database Archive

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?

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 will help you to build successful carrier. What is MS SQL Server? Microsoft SQL Server or MS SQL Server or SQL Server or MSSQL is

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 to maintain the changes. It is so fast and its latency is low. This article explains how to configure Transactional Replication with Updatable Subscriptions in SQL

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 transfers the changes or updates. That’s why its latency is very low and it is faster. This article explains how to configure Transactional Replication in

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 snapshot Replication in SQL Server 2008 R2? Before start we need to learn some prerequisite knowledge about SQL server replication and snapshot replication. Some key

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 sql server? Before start we need some prerequisite knowledge about SQL Server Replication. If we have already configured the Distributor, first disable publishing and distribution

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 MS SQL Server provides a built-in mechanism,PIVOT. This article describes a simple way to use pivot in SQL query. Summary of the article: What is

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 the best solutions. That’s why different solutions have come. NoSQL is one of them. It is a database management mechanism which does not use relational

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 society. Because day by day data are becoming massive. It is really difficult to handle with the existing database management system. So need alternate way.

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 queries we can select first 1-10  records, 10-20 records, 20-30 records etc. Summery of the article: SQL ROW_NUMBER() Function Paging using Sub Queries Paging using