Microsoft Azure SQL Database - wikipedia Microsoft Azure SQL Database This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view. ( June 2017 ) This article may be too technical for most readers to understand. Please help improve it to make it understandable to non-experts, without removing the technical details. The talk page may contain suggestions. ( June 2017 ) Microsoft Azure SQL Database ( formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database ) is a managed cloud database ( SaaS ) provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database. Azure SQL Database is a managed database service which is different from AWS RDS which is a container service. Microsoft Azure SQL Database includes built - in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection. It was originally announced in 2009 and released in 2010. Key capabilities include : Continuous learning of your unique app patterns, adaptive performance tuning, and automatic improvements to reliability and data protection Scaling as needed, with virtually no app downtime Management and monitoring of multitenant apps with isolation benefits of one - customer - per - database Leverage open source tools like cheetah, sql - cli, VS Code and Microsoft tools like Visual Studio and SQL Server Management Studio, Azure Management Portal, PowerShell, and REST APIs Data protection with encryption, authentication, limiting user access to the appropriate subset of the data, continuous monitoring and auditing to help detect potential threats and provide a record of critical events in case of a breach Contents 1 Popular Use Cases 2 Design 3 Timeline 4 Pricing 5 See also 6 References Popular Use Cases Relational data storage for cloud based applications and web sites Business and consumer web and mobile apps Manage databases for multi-tenant apps ( software - as - a-service ) Quickly create dev and test databases to speed up development cycles Scale production business services quickly and at a known cost Containerize data in the cloud for isolation and security Outsource database management in order to focus on value - added services Design Azure SQL Database shares the SQL Server 2016 codebase. It is compatible with SQL Server 2014 and 2016 and most of the features available in SQL Server 2016 are available in Azure SQL Database. A list of incompatibilities is published by Microsoft. Timeline 2009 -- Service announced 2010 -- Service went live 2014 -- New version announced 2015 -- Elastic Pools announced Pricing Azure SQL Database is offered either as a Standalone database or Elastic database pool, and is priced in three tiers : Basic, Standard and Premium. Each tier offers different performance levels to accommodate a variety of workloads. The resources available for Standalone databases are expressed in terms of Database Transaction Units ( DTUs ) and for elastic pools in terms of elastic DTUs or eDTUs. A DTU is defined as a blended measure of CPU, memory, and data I / O and transaction log I / O in a ratio determined by an OLTP benchmark workload designed to be typical of real - world OLTP workloads. Databases are available as Standalone databases or in database pools which allow multiple databases to share storage and compute resources. Service tier Target workloads Basic Best suited for a small database, supporting typically one single active operation at a given time. Examples include databases used for development or testing, or small - scale infrequently used applications. Standard The go - to option for most cloud applications, supporting multiple concurrent queries. Examples include workgroup or web applications. Premium Designed for high transactional volume, supporting many concurrent users and requiring the highest level of business continuity capabilities. Examples are databases supporting mission critical applications. It is also available as a limited service offering with a trial Web site or Mobile service and eligible for use with an Azure trial subscription. See also Microsoft Azure SQL Server Amazon Relational Database Service Relational Database Cloud computing Software as a service References Jump up ^ `` MS Branding ''. Jump up ^ Rabeler, Carl ( October 13, 2016 ). `` Azure SQL Database Learns & Adapts ''. Retrieved 2016 - 11 - 03. Jump up ^ Rabeler, Carl ( October 13, 2016 ). `` Azure SQL Database Scales on the fly ''. Jump up ^ Rabeler, Carl ( October 13, 2016 ). `` Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency ''. Jump up ^ `` wunderlist / cheetah ''. GitHub. Retrieved 2016 - 11 - 03. Jump up ^ `` sql - cli ''. npm. Retrieved 2016 - 11 - 03. Jump up ^ `` Visual Studio Code - Code Editing. Redefined ''. code.visualstudio.com. Retrieved 2016 - 11 - 03. Jump up ^ `` Any Developer, Any App, Any Platform Visual Studio ''. www.visualstudio.com. Retrieved 2016 - 11 - 03. Jump up ^ `` Use SQL Server Management Studio ''. msdn.microsoft.com. Retrieved 2016 - 11 - 03. Jump up ^ Rabeler, Carl ( September 13, 2016 ). `` Azure SQL Database Secures and Protects ''. Jump up ^ Byham, Rick ( August 30, 2016 ). `` Azure SQL Database Transact - SQL differences ''. Jump up ^ `` SQL Data Services announces plans to accelerate core relational database features ''. azure.microsoft.com. Retrieved 2016 - 11 - 03. Jump up ^ `` SQL Azure - The Year in Review ''. azure.microsoft.com. Retrieved 2016 - 11 - 03. Jump up ^ `` Preview for greater SQL Server compatibility coming soon to Azure SQL Database ''. azure.microsoft.com. Retrieved 2016 - 11 - 03. Jump up ^ `` Azure continues to be the best place for Software as a Service ''. azure.microsoft.com. Retrieved 2016 - 11 - 03. Cloud computing Applications Box Enstratius Google G Suite Docs, Sheets and Slides HP Cloud ( closed ) Microsoft Online Rackspace Salesforce Platforms Alpha7 Amazon AppScale Box Bluemix Cloud Foundry Cocaine ( PaaS ) Engine Yard Enstratius eXo Platform Helion GE Predix Google App Engine GreenQloud Heroku Inktank Jelastic Mendix Microsoft Azure OutSystems openQRM OpenShift RightScale Force.com SAP Cloud Platform VMware vCloud Air Infrastructure Amazon Abiquo Enterprise Edition CloudStack CtrlS Cloud4c DigitalOcean EMC Atmos Enstratius Eucalyptus Fujitsu GoGrid Google Cloud Platform GreenButton GreenQloud IBM cloud computing iland Joyent Lunacloud Nimbula Nimbus OpenNebula OpenStack OrionVM Rackspace Cloud SoftLayer Zadara Storage libvirt libguestfs OVirt Virtual Machine Manager Wakame - vdc Virtual Private Cloud OnDemand Technologies Cloud database Data centers Distributed file system for cloud Hardware virtualization Internet Networking Security Structured storage Virtual appliance Web APIs Virtual private cloud Category Commons Microsoft History All topics People ( list ) Founders Bill Gates Paul Allen Board of directors John W. Thompson ( Chairman ) Satya Nadella ( CEO ) Dina Dublon Maria Klawe David Marquardt Charles Noski Helmut Panke Mason Morfit John W. Stanton Senior leadership team Satya Nadella ( CEO ) Scott Guthrie Amy Hood ( CFO ) Terry Myerson Harry Shum Corporate VPs Gabe Aul ( VP ) Joe Belfiore Richard Rashid ( SVP ) S. Somasegar ( SVP ) Divisions Engineering groups Mobile Skype unit Digital Crimes Unit Garage Press Research Studios. NET Foundation Outercurve Foundation Estates Microsoft Redmond campus Microsoft Talo Microsoft Algeria Microsoft Egypt Microsoft India Microsoft Japan Product families Operating systems Windows Software Office Servers Visual Studio Hardware HoloLens Surface Xbox Web properties Bing Channel 9 CodePlex Developer Network MSN Mixer Office.com OneDrive Outlook.com TechNet Windows Store Conferences Build MIX PDC TechEd WinHEC Inspire Criticism Bundling of Microsoft Windows Clippy iLoo Internet Explorer Microsoft Bob _NSAKEY Windows ME XP Vista 10 Litigation Alcatel - Lucent v. Microsoft Apple v. Microsoft European Union Microsoft competition case Microsoft v. Lindows Microsoft vs. MikeRoweSoft Microsoft v. Shah United States v. Microsoft Acquisitions 6Wunderkinder Altamira Software aQuantive Azyxxi The Blue Ribbon SoundWorks Beam Bungie Calista Technologies Colloquis Connectix Consumers Software Danger Farecast FASA Studio Fast Search & Transfer Firefly Forethought GIANT Company Software GreenButton Groove Networks High Heat : Major League Baseball Hotmail Jellyfish.com LinkExchange Lionhead Studios Maluuba Massive Incorporated Mobile Data Labs Mojang Nokia Devices and Services Onfolio Pando Networks Perceptive Pixel PlaceWare Powerset ProClarity Rare Revolution Analytics ScreenTonic Secure Islands Simplygon Skype Sunrise Atelier SwiftKey Winternals Software Teleo Telekinesys Research Tellme Networks Twisted Pixel Games Vermeer Technologies Visio Corporation Vivaty VoloMetrix VXtreme WebTV Networks Xamarin Yammer Yupi LinkedIn Category Portal Azure Services Platform WinFabric layer Microsoft Azure AppFabric layer Caching Service Services layer Live Services Live Mesh SQL Services. NET Services SharePoint Services Dynamics CRM Services Online applications Azure AD Connect Hohm Microsoft Dynamics CRM Online Microsoft Exchange Online Microsoft SharePoint Online Office Live Windows Live Microsoft development tools Development environments Visual Studio Code Express Lab Management Team System Profiler Test Professional Tools for Applications Tools for Office Others. NET Compiler Platform App Studio Blend Expression Web GW - BASIC Microsoft Pascal MSBuild Robotics Developer Studio SharePoint Designer FrontPage PowerShell ISE QuickBASIC QBasic QuickC Small Basic WebMatrix Windows SDK CLR Profiler ILAsm Native Image Generator XAMLPad Languages Microsoft Basic Visual Basic Visual Basic. NET Visual C++ C++ / CX C++ / CLI Managed C++ C# F# J# Visual FoxPro IronPython IronRuby JScript PowerShell TypeScript VBScript XAML Major APIs and frameworks ( See all ) Windows API Silverlight XNA DirectX Managed DirectX Xbox Development Kit Windows Installer. NET Framework ASP.NET ASP.NET Core ASP.NET AJAX ASP.NET Dynamic Data ASP.NET MVC ASP.NET Razor ADO.NET Entity Framework CardSpace Communication Foundation Identity Foundation LINQ Presentation Foundation Workflow Foundation Device drivers WDK WDF KMDF UMDF Windows Hardware Certification Kit WDM Database SQL Server Express Compact Management Studio Business Intelligence Development Studio MSDE SQL services Analysis Reporting Integration Notification Other Visual FoxPro Microsoft Access Jet Engine Extensible Storage Engine Azure DocumentDB Source control Team Foundation Server Visual SourceSafe Delivery Active Setup ClickOnce NuGet Web Platform Windows Installer WiX Windows Store Retrieved from `` https://en.wikipedia.org/w/index.php?title=Microsoft_Azure_SQL_Database&oldid=785723639 '' Categories : Microsoft cloud services Hidden categories : Articles with a promotional tone from June 2017 All articles with a promotional tone Wikipedia articles that are too technical from June 2017 All articles that are too technical Articles needing expert attention from June 2017 All articles needing expert attention Talk Contents About Wikipedia Languages עברית 日本 語 Polski Русский Українська 中文 Edit links This page was last edited on 15 June 2017, at 02 : 15. Text is available under the Creative Commons Attribution - ShareAlike License ; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia ® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization. About Wikipedia

Question: what version of sql server does azure use
Answer: 2016 codebase