Posts under SQL tag.

firebird-database

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 [...]

RECOMMENDED: Click here to scan for Invalid Registry Entries & Make Windows Run Faster
How to move a SQL Database to another drive partition-image6

How to move a SQL Database to another drive partition

Information is stored somewhere. Sometimes it’s not suited for its original location. If you’re running low on disk space, added a new drive array, or just curious; this is a simple procedure to move a database(s) in Microsoft SQL Server [...]

MySQL-and-SQL-Server

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 [...]

SQL

Difference between SQL and NoSQL : Comparision

Ever since the buzz of NoSQL database evolved in storing data into the NoSQL databases,  I thought of exploring both the concepts to reach out to its depth. And it took me some time to figure out things that actually [...]

sql-server-2012

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, [...]

microsoft-atlanta

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 [...]