Posts under SQL tag.

5 Open Source Database: Overview, Comparison and Features

Earlier we have talked about SQL Database. In this post I am going to list some of the popular open source, free database software. Before starting any service online it is much necessary to choose a database that can guarantee […]

Difference between SQL and MySQL

We have earlier seen the difference between SQL and NoSQL. Now in this post I will tell you the basic difference between SQL and MySQL. Most people find it hard to wrap their head around SQL and MySQL, and you […]

image not found

Transact-SQL : Introduction and Overview

T-SQL or Transact-SQL is a proprietary extension to SQL (Sequential Query Language). The extended features includes: Improved performance, increased functionality and enhanced globalization support. Transact-SQL is Microsoft SQL Server’s implementation of the language. It is largely SQL-92 compliant, so if […]

Difference between SQL and NoSQL: Comparision

This article on SQL and NoSQL comparison will throw light on the debate on advantages and limitations on each. Ever since the buzz of NoSQL database evolved in storing data into the NoSQL databases,  I thought of exploring both the […]

SQL Server 2012 “Denali” : New Features

Aiming to launch a technically upgraded and pumped-up-with-features Server, Microsoft is inching close to make SQL Server 2012 public. With the launch of SQL server 2012 CPT’s over the years I thought of brining you the key features of it. Well, […]

What is Microsoft codename Atlanta?

Database administrators (DBAs) have to spend a great deal of time and effort dealing with problems related to misconfiguration of Microsoft SQL Server. Microsoft codename Atlanta, a secure configuration assessment service that can reduce troubleshooting time and effort for IT […]