Introduction to Windows Azure SQL Database Services (Part 2)

In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows Azure SQL database, which is a cloud-based relational database platform that is built on SQL Server technologies. We also learned about the steps on how to provision and deploy relational database solutions to the cloud using Window Azure platform. This gives us all advantages of distributed data center such as enterprise-class availability, scalability and security as well as benefits of integrated data-protection and self-healing.

Check out the second part of this article here, in which I discussed the administration and working of Windows Azure SQL Database platform

This article is published on SSWUG.org.

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.