SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.


Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...