Data Replication with SQL Server 2012

Replication is the process of copying and maintaining database objects in multiple databases that make up a distributed database system. ...

Consume Service References Using Windows Strore Apps

Please note that this is not database related post. I'm recently working on windows store app development. In one scenario I have been p...

READTEXT in T-SQL (SS2012)

This statement use to read text, ntext, or image values from a text, ntext, or image column, starting from a specified offset and reading th...

Document Oriented Database

        Designed for storing, retrieving, and managing document-oriented, or semi structured data , information. Document-oriented databases...

Create Database Snapshot

CREATE DATABASE statement can also be used to create database snapshots of existing databases. Database snapshot is a read only static view ...

Create Database in SQL Server 2012

  This example query create table named as db_name  in this case I omitted PRIMARY option and the first file is assumed as a primary file.T...

Policies Management In SQL Server

New SQL Server versions upgrade with new Declarative Management Framework ( DMF ) which policy based system managing one or more server ins...

Introdiuction to Query Optimizer

     In Practical case most of the DBE's can not find the query that optimized execution process of the query.           The question th...

Requirements for Database Security

Ever since, men had learned and concentrated on ways on how they could protect their files and documents even before computers ever existed...