Microsoft Azure SQL Database

Azure SQL Database
Developer(s)Microsoft
Initial release2010; 14 years ago (2010)
Available inEnglish
TypeManaged cloud database
Websiteazure.microsoft.com/en-us/products/azure-sql/database/

Microsoft Azure SQL Database (formerly known as SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database (PaaS) cloud-based Microsoft SQL Servers, provided as part of Microsoft Azure services. The service handles database management functions for cloud based Microsoft SQL Servers including upgrading, patching, backups, and monitoring without user involvement.[1]

Overview

Azure SQL Database supports multi-modal storage of structured, semi-structured, and non-relational data.[2]

Azure SQL Database includes built-in intelligence that learns app patterns and adapts them to maximize performance, reliability, and data protection.

Key capabilities include:

  • Relational data storage for cloud-based applications and websites
  • 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
  • Reduce database administration overhead through increased automation

Design

Azure SQL Database is built on the foundation of the SQL server database and therefore, kept in sync with the latest version[2] of it by using the common code base. Since the cloud version of the database technology strives to decouple it from the underlying computing infrastructure, it doesn't support some of the context specific T-SQL features[13] available in the traditional SQL server. However, the rest of the features are the same with incompatibilities spelled out by Microsoft.[14] Azure SQL Database is also similar to Microsoft's SQL Managed instance offering, with some differences.[15]

Timeline

  • 2009 – Service announced[16]
  • 2010 – Service went live[17]
  • 2014 – New version announced and rebranded from Windows Azure to Microsoft Azure[18]
  • 2015 – Major Architectural Revision
  • 2016 – Elastic Pools Introduced[19]
  • 2017 - Azure SQL Database Managed Instance launched
  • 2019 - Introduced Azure SQL Database Hyperscale, Serverless, and Instance Pools[20]

Deployment Models

Azure SQL Database is offered in two deployment models, as a Standalone database or an Elastic database pool (with shared storage and compute resources).

See also

References

  1. ^ WilliamDAssafMSFT. "What is the Azure SQL Database service? - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  2. ^ a b WilliamDAssafMSFT. "What is the Azure SQL Database service? - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  3. ^ Rabeler, Carl (March 3, 2023). "Azure SQL Database Learns & Adapts". Microsoft Azure. Retrieved 2016-11-03.
  4. ^ Rabeler, Carl (March 3, 2023). "Azure SQL Database Scales on the fly". Microsoft Azure.
  5. ^ Rabeler, Carl (October 13, 2016). "Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency". Microsoft.
  6. ^ "wunderlist/cheetah". GitHub. Retrieved 2016-11-03.
  7. ^ "sql-cli". npm. Retrieved 2016-11-03.
  8. ^ "Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance". Microsoft. Retrieved 2023-03-29.
  9. ^ "Add a connection to Azure SQL Database - Visual Studio (Windows)". Microsoft. 2022-09-27. Retrieved 2023-03-29.
  10. ^ "Use SQL Server Management Studio". Microsoft. 2023-03-03. Retrieved 2016-11-03.
  11. ^ Rabeler, Carl (March 3, 2023). "Azure SQL Database Secures and Protects". Microsoft.
  12. ^ Slater, Phil. "Maximizing Security and Flexibility: Azure SQL Server Authentication Methods". heliumit.uk. Retrieved 2023-09-05.
  13. ^ croblesm. "Resolving T-SQL differences-migration - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  14. ^ Byham, Rick (2022-12-16). "Azure SQL Database Transact-SQL differences". Microsoft Azure.
  15. ^ danimir. "Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance". learn.microsoft.com. Retrieved 2023-04-07.
  16. ^ "SQL Data Services announces plans to accelerate core relational database features". Microsoft Azure. March 10, 2009. Retrieved 2016-11-03.
  17. ^ "SQL Azure - The Year in Review". Microsoft Azure. January 4, 2011. Retrieved 2016-11-03.
  18. ^ Kelly, Eron (November 5, 2014). "Preview for greater SQL Server compatibility coming soon to Azure SQL Database". Microsoft Azure. Retrieved 2016-11-03.
  19. ^ Wissner, Tiffany (May 11, 2016). "Azure continues to be the best place for Software as a Service". Microsoft Azure. Retrieved 2016-11-03.
  20. ^ markdefalco. "History of Azure SQL (2 of 61)". learn.microsoft.com. Retrieved 2023-04-07.

Read other articles:

Santo Croix

Saint CroixJulukan: Kota kembarGeografiLokasiLaut KaribiaKoordinat17°44′23″N 64°44′20″W / 17.73972°N 64.73889°W / 17.73972; -64.73889Koordinat: 17°44′23″N 64°44′20″W / 17.73972°N 64.73889°W / 17.73972; -64.73889KepulauanKepulauan Virgin, Kepulauan LeewardPanjang35,4 kmLebar11,3 kmTitik tertinggi355 mPemerintahanNegara Amerika SerikatKependudukanDemonimOrang CroixPenduduk50.601 jiwa jiwaKepada...

 

 

Papua Nugini

Negara Merdeka Papua NuginiInggris:Independent State of Papua New GuineaTok Pisin:Independen Stet bilong Papua NiuginiHiri Motu:Independen Stet bilong Papua Niu Gini Bendera Lambang Semboyan: Unity in diversity (Persatuan dalam Keragaman) [1]Lagu kebangsaan:  O Arise, All You Sons (O Bangunlah, Semua Kalian Putera!)[2] Lagu kerajaan:  God Save the King (Tuhan Menjaga sang Raja) Perlihatkan BumiPerlihatkan peta BenderaLokasi Papua Nugini Ibu kota(dan kota terbesa...

 

 

Four Seasons Hotel Atlanta

Hotel in Georgia, United States This article relies excessively on references to primary sources. Please improve this article by adding secondary or tertiary sources. Find sources: Four Seasons Hotel Atlanta – news · newspapers · books · scholar · JSTOR (August 2009) (Learn how and when to remove this template message) Four Seasons Hotel AtlantaFour Seasons Hotel AtlantaGeneral informationLocation75 14th St NE, Atlanta, GA 30309Coordinates33°47′10�...

Egeløkke

EgeløkkeGeneral informationLocationEgeløkkevej 3, 5953 Tranekær 4490 Jerslev SjællandCountryDenmarkCoordinates55°2′39″N 10°51′39″E / 55.04417°N 10.86083°E / 55.04417; 10.86083Construction started1845ClientC. A. Fonnesbech Broløkke is a manor house and estate on Langeland, Denmark. The present main building was constructed in 1845–46 to a Neoclassical designs by Gustav Friedrich Hetsch, but was heightened with one storey in 1890. It was listed on the ...

 

 

Tobirama Senju

Artikel ini kemungkinan ditulis dari sudut pandang penggemar dan bukan sudut pandang netral. Mohon rapikan untuk menghasilkan standar kualitas yang lebih tinggi dan untuk membuat pemakaian nada yang netral. (Maret 2022) (Pelajari cara dan kapan saatnya untuk menghapus pesan templat ini) Karakter dalam seri NarutoTobirama Senju千手扉間Penampilan perdanaMangaBab 118AnimeNaruto episode 69Tampil diAnime, manga, OVA, dan permainanPengisi suaraInggrisPeter LurieJepangKen'yū Horiuchi Informasi ...

 

 

English art

Overview of the art of England Folio 27r from the 8th-century Lindisfarne Gospels contains the incipit from the Gospel of Matthew. Culture of England History People Languages Traditions Country clothing Fête Morris Dancing Pub Mythology and Folklore Cuisine Festivals Saint George's Day Commonwealth Day Guy Fawkes Night Harvest Festival Lady Day May Day Plough Monday Plough Sunday Whitsun Religion Art Literature Music and Performing arts Abbots Bromley Horn Dance Country dance English folk mu...

الانتقائية في العمارة

تعدّ كنيسة ساغرادا فاميليا في برشلونة التي صممها المعماريّ الكبير أنطوني غاودي مثالًا على الانتقائيَّة حيث دُمج فيها عناصر من العمارة القوطيَّة مع أشكال وزخارف مشرقيَّة مستوحاة من العالم الطبيعي مما ينتج عنه صرحًا معماريًا أصيلًا ومتفردًا من نوعه.[1] وهذا رغمًا عن تص�...

 

 

August Kubizek

Childhood friend of Adolf Hitler This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: August Kubizek – news · newspapers · books · scholar · JSTOR (June 2021) (Learn how and when to remove this message) August KubizekAugust Kubizek in his youthBorn(1888-08-03)3 August 1888Linz, Austria-Hungary (now Austria)Died23...

 

 

艾哈迈德·哈桑·贝克尔

此條目可参照英語維基百科相應條目来扩充。 (2022年1月31日)若您熟悉来源语言和主题，请协助参考外语维基百科扩充条目。请勿直接提交机械翻译，也不要翻译不可靠、低品质内容。依版权协议，译文需在编辑摘要注明来源，或于讨论页顶部标记{{Translated page}}标签。 艾哈迈德·哈桑·贝克尔أحمد حسن البكر第4任伊拉克总统任期1968年7月17日—1979年7月16日副总统萨达姆·侯...

Park Hae-jin

Ini adalah nama Korea; marganya adalah Park. Park Hae-jinPark Hae-jin pada tahun 2018LahirPark Hae-jin (박해진)1 Mei 1983 (umur 41)Busan, Korea SelatanPekerjaanAktormodelTahun aktif2006-sekarangAgenMountain Movement[1]Nama KoreaHangul박해진 Hanja朴海鎭 Alih AksaraBak Hae-jinMcCune–ReischauerPak Haejin Situs webCLUB Jin’s Park Hae-jin (Hangul: 박해진, lahir 1 Mei 1983) adalah seorang aktor dan model asal Korea Selatan. Ia dikenal sebagai peran pendukung dalam ...

 

 

Eleutherodactylus ruthae

Species of frog Eleutherodactylus ruthae Conservation status Endangered  (IUCN 3.1)[1] Scientific classification Domain: Eukaryota Kingdom: Animalia Phylum: Chordata Class: Amphibia Order: Anura Family: Eleutherodactylidae Genus: Eleutherodactylus Species: E. ruthae Binomial name Eleutherodactylus ruthaeNoble, 1923 Eleutherodactylus ruthae (common name: Ruth's robber frog) is a species of frog in the family Eleutherodactylidae. It is endemic to Hispaniola and known from scat...

 

 

حزب التقدم والاشتراكية

حزب التقدم والاشتراكية البلد المغرب  التأسيس التأسيس 1943 تحت اسم الحزب الشيوعي المغربي (الاعتراف الرسمي أغسطس 1974 بالاسم الحالي). تاريخ التأسيس 23 أغسطس 1974  المؤسسون علي يعتة  الحزب الشيوعي المغربي،  وحزب التحرر والاشتراكية    الشخصيات قائد الحزب محمد نبيل بنع...

Member states of the Council of Europe

Council of Europe member states as of 16 March 2022.   Founding member states  Subsequent member states  Former member states The Council of Europe was founded on 5 May 1949 by ten western and northern European states,[1] with Greece[2][3] joining three months later, and Iceland,[4][5] Turkey[6][7] and West Germany[8][9] joining the next year. It now has 46 member states, with Montenegro bei...

 

 

Concord, New Hampshire

Capital city of New Hampshire, United States State capital city in New Hampshire, United StatesConcord, New HampshireState capital cityNew Hampshire State HouseMain Street in Downtown ConcordView from Eagle SquareNew Hampshire State LibraryCity HallOld Post OfficeSt. Paul's School chapel FlagSealLogoLocation in Merrimack County, New HampshireConcordShow map of New HampshireConcordShow map of the United StatesConcordShow map of North AmericaCoordinates: 43°12′24″N 71°32′17″W...

 

 

Olympiska vinterspelen 2010

Olympiska vinterspelen 2010 Grenar86 grenar i 15 sporterDeltagareNationer82Aktiva2626[1]Män1 215Kvinnor522VärdskapLand KanadaOrtVancouverArenaBC PlaceInvigning12 februari 2010Spelen öppnades avMichaëlle Jean(Generalguvernör)Läste deltagarnas edHayley WickenheiserLäste funktionärernas edMichel VerraultElden tändes avCatriona LeMay-Doan, Steve Nash, Nancy Greene, Wayne GretzkyAvslutning28 februari 2010← Turin 2006 Sotji 2014 → Olympiska vinterspelen 2010, de tjugo...

جغرافيا الصحراء الغربية

جغرافيا الصحراء الغربيةمعلومات عامةالقارة إفريقيا الساحل المحيط الأطلسي الحدود موريتانياالجزائرالمغرب الإحداثيات 20°N 10°W / 20°N 10°W / 20; -10 الأرض والتضاريسالمساحة 266٬000 كم² تعديل - تعديل مصدري - تعديل ويكي بيانات خريطة طوبوغرافية للصحراء الغربية تقع الصحراء الغر...

 

 

History and traditions of Harvard commencements

Meryl Streep, Hon. D.A. 2010[1] (l-r) US Navy Secretary (and Har­vard Over­seer) George Meyer; Prof. Frank W. Taussig; Pres. Eliot (who dis­dained aca­dem­ic regal­ia);[2] Bishop (and Over­seer) William Lawrence (1911) What was originally called Harvard Colledge[3] (around which Harvard University eventually grew)[4] held its first Commence­ment in September 1642, when nine degrees were conferred.[5] Today some 1...

 

 

Taishi Takizawa

Questa voce o sezione sull'argomento wrestler giapponesi non cita le fonti necessarie o quelle presenti sono insufficienti. Puoi migliorare questa voce aggiungendo citazioni da fonti attendibili secondo le linee guida sull'uso delle fonti. Taishi TakizawaNazionalità Giappone Luogo nascitaYokosuka2 settembre 1985 Ring nameTaishi TakizawaHiroshi TakizawaTakizawaJiro AllenatoreTaka MichinokuFCW Debutto19 novembre 2006 FederazioneKENTAI DOJO Progetto Wrestling Manuale Taishi Takizawa ...

松下元

松下元 松下 元（まつした はじめ、1884年〈明治17年〉8月10日 - 1953年〈昭和28年〉12月1日）は、日本の海軍軍人。最終階級は海軍中将。「五省」の考案者。 経歴 福岡県出身。松下丈吉の長男として生れる。中学明善校を経て、1903年12月、海軍兵学校（31期）を卒業し、翌年9月、海軍少尉任官。日露戦争では「松島」乗組として出征し、日本海海戦では「八雲」乗組であっ...

 

 

Disturbo depressivo

Le informazioni riportate non sono consigli medici e potrebbero non essere accurate. I contenuti hanno solo fine illustrativo e non sostituiscono il parere medico: leggi le avvertenze. Disturbo depressivoVincent van Gogh: Sulla soglia dell'eternità; Museo Kröller-Müller, Otterlo, Paesi Bassi.Specialitàpsichiatria Eziologiagenetica e fattori ambientali Classificazione e risorse esterne (EN)OMIM608520 e 608691 MeSHD003865 MedlinePlus003213 eMedicine286759 SinonimiDepressione clinicaDepress...