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 …
Category: Database
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 …
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 …
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 …
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 …
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 …
SQL query to convert column to row
During the creation of table maximum time we only consider the purpose and efficiency of the table. All time we don’t think about the reporting. Some times we may need …
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 …
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 …
Difference between Stored Procedure and Function
In a database system, stored procedures and functions are SQL statements that provide similar functionality. Both allow us to create bundles of SQL statements or codes that are stored on …
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 …
MySQL Interview Questions with Answers
MySQL is the most famous relational database management system. It is open source. Here is some common important question and answer in MySQL. Hope it will help you to build …
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 …