Introduction to Windows Azure SQL Database (Part 1)

Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services that offers a capabilities on Microsoft SQL Server 2012 (such as Amazon S3 and Amazon Relational Database Services), as part of the Azure Services Platform. Windows Azure SQL Database uses special version of Microsoft SQL Server as its backend that provides high availability by storing multiple copies of databases i.e. flexible range and fast. Windows Azure SQL Database is hosted on Microsoft data centers on the hardware that is owned, hosted and maintained by Microsoft. Unlike other cloud-based databases, Windows Azure SQL Database allows users to write and execute queries against stored data that can either be structured or semi-structured or unstructured documents. Windows Azure SQL Database presents a subset of the full SQL Server functionality that includes specific subset of the data types (includes string, number, date and boolean), tables, primary keys, stored procedures, views and much more. Applications can use Windows Azure SQL Database in the same way they use SQL Server Database Engine because Windows Azure SQL Database use T-SQL as a query language and Tabular Data Stream (TDS) protocol for accessing services over the Internet.

Check out my article here, which presents an overview of the architecture and steps to configure and manage Microsoft Windows Azure SQL Database.

This article is published on SSWUG.org.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s