Microsoft Azure SQL Database: Difference between revisions

Revision as of 20:27, 29 June 2016

Revision as of 05:09, 1 July 2016

Line 1:

{{third-party|date=July 2013}}

'''Microsoft Azure SQL Database''' (formerly '''SQL Azure''', '''SQL Server Data Services''', '''SQL Services''', '''Windows Azure SQL Database''') is a [[cloud computing|cloud-based]] [[software as a service|service]] from [[Microsoft]] offering data-storage capabilities. (similarThe toaim [[Amazonis Relationalfor Databaseusers Service]])to asjust communicate with a partT-SQL ofendpoint therather [[Azurethan Servicesmanaging Platform]].database Unlikestorage, similarfiles, cloud-basedand high availability. In this databasesregard, SQLit Databaseis allowsa userssimilar offering to make [[relationalAmazon database|relationalRelational Database Service]]). queriesEarly againstversions storedoperated data,as whichkey-value canpair eithertables beaccessed via a [[structured data|structuredRESET]] or-based [[semi-structured data|semi-structuredAPI]], orand evenoffering [[unstructuredonly data|unstructureda document]]s.<refsubset name="faq">{{citeof webthe |data urltypes =offered http://www.microsoft.com/azure/faq.mspx#sqlby | title =the [[Microsoft SQL ServicesServer]] FAQon-premises |product. publisherUsing =these [[Microsoft]]versions |was accessdatenot =similar 2009-04-16}}</ref>to using the SQL DatabaseServer featuresdatabase queryingengine data,and search,led datato analysisrelatively andlow dataadoption synchronizationrates.<ref name="faq"/>

Current versions of Azure SQL Database share a common code base with [[Microsoft SQL Server]]. This database engine allows users to make [[relational database|relational]] queries against stored data, which can either be [[structured data|structured]] or [[semi-structured data|semi-structured]], and [[unstructured data|unstructured document]]s.<ref name="faq">{{cite web | url = http://www.microsoft.com/azure/faq.mspx#sql | title = Microsoft SQL Services FAQ | publisher = [[Microsoft]] | accessdate = 2009-04-16}}</ref> SQL Database features querying data, search, data analysis and data synchronization.<ref name="faq"/>

SQL Database shares a common code base with [[Microsoft SQL Server]]. It provides [[high availability]] by storing multiple copies of databases, [[business continuity]] and [[disaster recovery]] with backups and geo-replication, elastic scale and rapid provisioning. It has built-in data protection and security features. It exposes a subset of the full SQL Server functionality, including only a subset of the data types &mdash; including string, numeric, date and boolean.<ref name="ssds">{{cite web|url=http://blogs.msdn.com/access/archive/2008/03/06/sql-server-data-services.aspx |title=SQL Server Data Services |publisher=[[MSDN]] Blogs |author=Ryan McMinn |accessdate=2008-03-07 |deadurl=yes |archiveurl=http://web.archive.org/web/20080311003352/http://blogs.msdn.com:80/access/archive/2008/03/06/sql-server-data-services.aspx |archivedate=March 11, 2008 }}</ref> It uses an [[XML]]-based format for data transfer.<ref name="faq"/> Like [[Microsoft SQL Server]], SQL Database uses [[T-SQL]] as the query language and [[Tabular Data Stream]] (TDS) as the protocol to access the service over the Internet.<ref name="faq"/><ref>{{cite web | url = http://www.microsoft.com/azure/data.mspx | title = SQL Server Data Services | publisher = [[Microsoft]] | accessdate = 2009-04-16}}</ref> (The product does not provide a [[REST]]-based [[API]] to access the service over [[HTTP]]<ref name="faq"/> - [[Microsoft]] recommends using [[ADO.NET Data Services]] for this purpose.<ref name="faq"/>)

SQL Database shares a common code base with [[MicrosoftHigh SQL Serveravailability]]. Itis provides [[high availability]]provided by storing multiple copies of databases, [[business continuity]] and [[disaster recovery]] with backups and geo-replication, elastic scale and rapid provisioning. It has built-in data protection and security features. It exposes a subset of the full SQL Server functionality, including only a subset of the data types &mdash; including string, numeric, date and boolean.<ref name="ssds">{{cite web|url=http://blogs.msdn.com/access/archive/2008/03/06/sql-server-data-services.aspx |title=SQL Server Data Services |publisher=[[MSDN]] Blogs |author=Ryan McMinn |accessdate=2008-03-07 |deadurl=yes |archiveurl=http://web.archive.org/web/20080311003352/http://blogs.msdn.com:80/access/archive/2008/03/06/sql-server-data-services.aspx |archivedate=March 11, 2008 }}</ref> It uses an [[XML]]-based format for data transfer.<ref name="faq"/> Like [[Microsoft SQL Server]], SQL Database uses [[T-SQL]] as the query language and [[Tabular Data Stream]] (TDS) as the protocol to access the service over the Internet.<ref name="faq"/><ref>{{cite web | url = http://www.microsoft.com/azure/data.mspx | title = SQL Server Data Services | publisher = [[Microsoft]] | accessdate = 2009-04-16}}</ref> (The product doesno notlonger provideprovides a [[REST]]-based [[API]] to access the service over [[HTTP]]<ref name="faq"/> - [[Microsoft]] recommends using [[ADO.NET Data Services]] for this purpose.<ref name="faq"/>)

==Footnotes ==

Line 15 ⟶ 17:

==External links==

*[httphttps://wwwazure.microsoft.com/azureen-us/services/sql.mspx-database/ Azure SQL AzureDatabase: Windows Azure Platform]

*[http://blogs.msdn.com/ssds/default.aspx SQL Azure: Team blog (defunct) ]

*[http://www.microsoft.com/en-us/SQLAzure/datasync.aspx SQL Azure Data Sync]