{"id":1139,"date":"2020-12-18T07:00:00","date_gmt":"2020-12-18T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=1139"},"modified":"2024-09-11T21:33:41","modified_gmt":"2024-09-11T18:33:41","slug":"sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/","title":{"rendered":"SQL Server in the Cloud Era. Time for Azure SQL Databases?"},"content":{"rendered":"<p>Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. <\/p>\n\n\n\n<p>With the services of SQL Server in Virtual Machine (IaaS) and managed instance (PaaS) it showed its understanding of Hybrid Cloud uses with a very short adaptation time since in these cases and SQL Server Agent we also have DB mail and Change Data Capture and many other functions that we are used to working with.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"387\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-aq.png\" alt=\"\" class=\"wp-image-1149\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-aq.png 582w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-aq-300x199.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Our options per case<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DTU model<\/strong>, is a unit of measurement between CPU, memory and disk speed:\n<ul class=\"wp-block-list\">\n<li><strong>Basic<\/strong> (up to 2GB at a cost of ~4 euros per month)<\/li>\n\n\n\n<li><strong>Standard<\/strong><\/li>\n\n\n\n<li><strong>Premium<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>vCore model, <\/strong>Cores and Storage are measured in units:\n<ul class=\"wp-block-list\">\n<li><strong>General purpose<\/strong>: The most common model has the possibility to choose <strong>serverless<\/strong> compute so that you are charged only for the resources you use (even if the server stops completely).<\/li>\n\n\n\n<li><strong>Business<\/strong> <strong>Critical<\/strong>: The high availability model that offers many replicas.<\/li>\n\n\n\n<li><strong>Hyperscale<\/strong>: Has the maximum scaling of resources. Backups are taken via snapshots.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What&#039;s Beyond Microsoft SQL Server in a Virtual Machine on Azure?<\/h3>\n\n\n\n<p>Azure SQL Databases are divided into three different categories depending on our needs. Let&#039;s see them in detail...<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"490\" height=\"210\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-aq.png\" alt=\"\" class=\"wp-image-1150\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-aq.png 490w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-aq-300x129.png 300w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/figure>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"223\" height=\"220\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/3-aq.png\" alt=\"\" class=\"wp-image-1141\"\/><\/figure>\n<\/div>\n\n\n<p>Let&#039;s go <strong>SQL databases<\/strong>. Although setting up a new one is no more than 5 minutes of installation and yet it changes everything we knew\u2026<\/p>\n\n\n\n<p>We don&#039;t take the backups, it doesn&#039;t have a sql server agent for jobs, it doesn&#039;t play change data capture, mirroring, db mail, DTC, Linked Servers, restores and many more.<\/p>\n\n\n\n<p>The solutions for <strong>migration <\/strong>in SQL database is with the <strong>Data Migration Service,<\/strong> <strong>Transactional Replication<\/strong>, <strong>BACPAC <\/strong>and <strong>BCP<\/strong>.<\/p>\n\n\n\n<p>The good thing is that Microsoft undertakes to always have the latest version with the latest patch of SQL Server, as well as through automated tuning it can create indexes and force plans by itself.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"199\" height=\"207\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/4-aq.png\" alt=\"\" class=\"wp-image-1142\"\/><\/figure>\n<\/div>\n\n\n<p>The <strong>SQL elastic pools<\/strong> it is the same case with SQL databases with the difference that we do not make a whole server dedicated to the database, but we have a group of databases on the same server sharing resources.<\/p>\n\n\n\n<p>Thus, in bases that do not have high usage, we reduce costs and make their management easier.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"249\" height=\"209\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/5-aq.png\" alt=\"\" class=\"wp-image-1143\"\/><\/figure>\n<\/div>\n\n\n<p>The <strong>SQL managed instance<\/strong>s is an intermediate solution. We don&#039;t have access to any VM that is the instance but by logging into the instance we see that we knew most of the SQL Server functions from on-premise are working.<\/p>\n\n\n\n<p>It has a sql server agent, we can backup\/restore in the classic way, db mail and much more.<\/p>\n\n\n\n<p>In the case of migration, the same applies to SQL Databases plus transfer and restore of the classic .bak file.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-vivid-cyan-blue-color has-text-color\">And since in the cases of Azure SQL Database \/ elastic pools we do not get the backup, how does it get?<\/h4>\n\n\n\n<p>He takes himself by dividing them into two categories:<\/p>\n\n\n\n<p><strong>Long<\/strong><strong>-term<\/strong><strong> backups<\/strong><strong>: <\/strong>Full backups once a week with the possibility to keep up to 10 years.<\/p>\n\n\n\n<p><strong>Default<\/strong><strong> Backups<\/strong><strong>: <\/strong>Differential backups every 12 hours and transaction log backups every 5 minutes which are kept for 7-35 days.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"552\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-aq-1024x552.png\" alt=\"\" class=\"wp-image-1144\" style=\"width:512px;height:276px\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-aq-1024x552.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-aq-300x162.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-aq-768x414.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-aq.png 1079w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>These backups are easily restored at a point in time or can be used to create a new database.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"174\" height=\"222\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/7-aq.png\" alt=\"\" class=\"wp-image-1145\"\/><\/figure>\n<\/div>\n\n\n<p>The <strong>Elastic Jobs<\/strong> are the corresponding jobs that can be created for the Azure SQL Database\/elastic pools of one and there is no sql server agent service. It is a bit more time consuming process to set them up so far.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Azure Data Sync<\/strong><\/h4>\n\n\n\n<p>Azure data sync is Microsoft&#039;s first attempt at an active\/active replication solution.<\/p>\n\n\n\n<p>It enables us to be able to have synchronized bases even on another continent. What you write on one, write on the other bi-directional or one way depending on what we want. We can define in case of conflict which data prevails. It also works with on-premise bases (requires to download a tool).<\/p>\n\n\n\n<p>But it comes with a few thorns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It is not modern<\/li>\n\n\n\n<li>It is at least 5 minutes late.<\/li>\n\n\n\n<li>It has quite a performance impact<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"308\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-aq.png\" alt=\"\" class=\"wp-image-1146\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-aq.png 624w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-aq-300x148.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Active geo-replication \/ Auto-failover groups<\/strong><\/h4>\n\n\n\n<p>Similar high availability services that create a readable secondary base in the same or another geographical area. In the case that we have a SQL Database or elastic pool, we go to the geo-replication solution and in the case that we have multiple databases or managed instances in an auto-failover group at the server level.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"739\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-aq-1024x739.png\" alt=\"\" class=\"wp-image-1147\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-aq-1024x739.png 1024w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-aq-300x217.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-aq-768x554.png 768w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-aq.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"271\" height=\"153\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/10-aq.png\" alt=\"\" class=\"wp-image-1148\" style=\"width:190px;height:107px\"\/><\/figure>\n<\/div>\n\n\n<p>Let&#039;s mention at the end the <strong>Azure Synapse Analytics<\/strong> which is the equivalent of OLAP SQL Data Warehouse.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-vivid-cyan-blue-color has-text-color\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/sql-database-paas-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Azure SQL Database<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/auto-failover-group-overview?tabs=azure-powershell\" target=\"_blank\">Azure failover groups<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. With its SQL Server in Virtual Machine (IaaS) and managed instance (PaaS) services, it demonstrated its understanding of Hybrid Cloud uses with much [\u2026]<\/p>","protected":false},"author":1,"featured_media":2837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,36,15],"tags":[56,55,46,29,23,6],"class_list":["post-1139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-azure","category-ms-sqlserver","tag-azure-sql-database","tag-azure-synapse","tag-cloud","tag-databases","tag-microsoft","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"H Microsoft \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud \u03bc\u03b5 \u03c4\u03bf Azure \u03b1\u03c0\u03bf\u03c6\u03ac\u03c3\u03b9\u03c3\u03b5 \u03bd\u03b1 \u03b4\u03ce\u03c3\u03b5\u03b9 \u03cc\u03c3\u03bf \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ad\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03c3\u03b5 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03cc\u03bb\u03bf\u03b9 \u03b9\u03ba\u03b1\u03bd\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03bf\u03b9. \u0395\u03af\u03c4\u03b5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03bb\u03ac\u03c4\u03c1\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 on-premise \u03b5\u03af\u03c4\u03b5 \u03c4\u03bf\u03c5 hybrid cloud. \u039c\u03b5 \u03c4\u03b9\u03c2 \u03c5\u03c0\u03b7\u03c1\u03b5\u03c3\u03af\u03b5\u03c2 \u03c4\u03bf\u03c5 SQL Server in Virtual Machine (IaaS) \u03ba\u03b1\u03b9 \u03c4\u03bf\u03c5 managed instance (PaaS) \u03ad\u03b4\u03b5\u03b9\u03be\u03b5 \u03c4\u03b7 \u03ba\u03b1\u03c4\u03b1\u03bd\u03cc\u03b7\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03b3\u03b9\u03b1 \u03c7\u03c1\u03ae\u03c3\u03b5\u03b9\u03c2 Hybrid Cloud \u03bc\u03b5 \u03c0\u03bf\u03bb\u03cd [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-18T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-11T18:33:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases;\",\"datePublished\":\"2020-12-18T04:00:00+00:00\",\"dateModified\":\"2024-09-11T18:33:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/\"},\"wordCount\":225,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"keywords\":[\"Azure SQL Database\",\"Azure Synapse\",\"Cloud\",\"Databases\",\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft Azure\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/\",\"name\":\"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"datePublished\":\"2020-12-18T04:00:00+00:00\",\"dateModified\":\"2024-09-11T18:33:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Azure\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/azure\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dataplatform.gr\/en\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr","og_description":"H Microsoft \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud \u03bc\u03b5 \u03c4\u03bf Azure \u03b1\u03c0\u03bf\u03c6\u03ac\u03c3\u03b9\u03c3\u03b5 \u03bd\u03b1 \u03b4\u03ce\u03c3\u03b5\u03b9 \u03cc\u03c3\u03bf \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ad\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03c3\u03b5 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03cc\u03bb\u03bf\u03b9 \u03b9\u03ba\u03b1\u03bd\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03bf\u03b9. \u0395\u03af\u03c4\u03b5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03bb\u03ac\u03c4\u03c1\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 on-premise \u03b5\u03af\u03c4\u03b5 \u03c4\u03bf\u03c5 hybrid cloud. \u039c\u03b5 \u03c4\u03b9\u03c2 \u03c5\u03c0\u03b7\u03c1\u03b5\u03c3\u03af\u03b5\u03c2 \u03c4\u03bf\u03c5 SQL Server in Virtual Machine (IaaS) \u03ba\u03b1\u03b9 \u03c4\u03bf\u03c5 managed instance (PaaS) \u03ad\u03b4\u03b5\u03b9\u03be\u03b5 \u03c4\u03b7 \u03ba\u03b1\u03c4\u03b1\u03bd\u03cc\u03b7\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03b3\u03b9\u03b1 \u03c7\u03c1\u03ae\u03c3\u03b5\u03b9\u03c2 Hybrid Cloud \u03bc\u03b5 \u03c0\u03bf\u03bb\u03cd [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2020-12-18T04:00:00+00:00","article_modified_time":"2024-09-11T18:33:41+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases;","datePublished":"2020-12-18T04:00:00+00:00","dateModified":"2024-09-11T18:33:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/"},"wordCount":225,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","keywords":["Azure SQL Database","Azure Synapse","Cloud","Databases","Microsoft","SQL Server"],"articleSection":["Databases","Microsoft Azure","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/","url":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/","name":"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases; - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","datePublished":"2020-12-18T04:00:00+00:00","dateModified":"2024-09-11T18:33:41+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/sql-server-stin-epochi-toy-cloud-ora-azure-sql-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Microsoft Azure","item":"https:\/\/www.dataplatform.gr\/category\/azure\/"},{"@type":"ListItem","position":3,"name":"SQL Server \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03bf\u03c7\u03ae \u03c4\u03bf\u03c5 Cloud. \u038f\u03c1\u03b1 \u03b3\u03b9\u03b1 Azure SQL Databases;"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=1139"}],"version-history":[{"count":3,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1139\/revisions"}],"predecessor-version":[{"id":5812,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1139\/revisions\/5812"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/2837"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=1139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=1139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=1139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}