{"id":2623,"date":"2021-01-04T06:00:00","date_gmt":"2021-01-04T03:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2623"},"modified":"2024-09-11T21:33:59","modified_gmt":"2024-09-11T18:33:59","slug":"pos-ftiachnoyme-mia-vasi-dedomenon-sto-az","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/","title":{"rendered":"How we create a simple database in Azure SQL Database"},"content":{"rendered":"

In previous article<\/a> we had seen what one is Azure SQL Database<\/strong> and the differences between SQL managed instances<\/strong> and SQL elastic pools<\/strong>. <\/p>\n\n\n\n

In the article we will analyze how we create one Simple Azure SQL Database<\/strong> step by step and what options we have when creating it.<\/p>\n\n\n\n

But before you continue reading the article if you are not familiar with Azure you should read first this article<\/a> which is dedicated to Azure infrastructure<\/strong>. It will be needed because it explains various concepts that we will encounter below such as Subscriptions<\/strong> and Resource Groups<\/strong>.<\/p>\n\n\n\n

The example<\/h2>\n\n\n\n

To begin with, we connect to Azure Portal<\/a> . There we choose it Menu<\/em>, SQL Databases<\/em> (from favorites) and Create<\/em>.<\/p>\n\n\n\n

Either way Menu, Create a resource, Databases, SQL database<\/em>.<\/p>\n\n\n\n

\"\"
1<\/figcaption><\/figure>\n\n\n\n

We define it Subscription <\/em>that we have the charge (in my case I had one so it put it on itself). <\/p>\n\n\n\n

The Resource Group<\/em> it's basically a bucket of our infrastructure so, we put one we already have or build a new one. For new we choose Create New<\/em> simply filling in the Data Center to which it will belong (in our case West Europe).<\/p>\n\n\n\n

We put the name we want the database to have.<\/p>\n\n\n\n

If we haven't already made one logical SQL Server <\/strong>we choose Create New<\/em>. There we should give him a unique name, him local admin<\/strong> and like Location<\/em> we will again put the Data Center we want it to belong to (ie West Europe again).<\/p>\n\n\n\n

The SQL elastic pool <\/em>we leave it No, since in this particular case we do not want it to manage many bases with shared resources.<\/p>\n\n\n\n

\"\"
2<\/figcaption><\/figure>\n\n\n\n

Time to choose the resources we want our database to have.<\/p>\n\n\n\n

Choosing Configure<\/em> in the Compute + storage <\/em>the following image will appear. There we can choose a classic billing model with DTU<\/strong> (e.g. basic for a base up to 2gb with minimum resources), Business Critical <\/strong>if we want to have a service with an infrastructure equivalent to Availability Group<\/em> or leave it General Purpose<\/strong> which is infrastructure like Failover Cluster Instance<\/em>.<\/p>\n\n\n\n

In more detail, their differences exist in the article<\/a> which we mentioned at the beginning.<\/p>\n\n\n\n

Beyond the model we will see that we can choose the size of the base and the Cores it will have. In the compute tier<\/em> a very good solution if our base will be accessed only during certain hours of the day is to choose the Serverless<\/strong> model. With this particular model if for some time there is no activity with active connections, we will not be charged<\/strong> as the base will be down*, but we will be charged by the hour (by the second to be exact) that the base is online.<\/p>\n\n\n\n

*When we try to reconnect to the base, after about 1 minute it will turn itself on.<\/em><\/p>\n\n\n\n

\"\"
3<\/figcaption><\/figure>\n\n\n\n

Then we choose how we will access the base. With the Private endpoint <\/strong>we will only have by creating a private node at the base of specific applications, VPN, etc. In our case I wanted to have access via Internet so I chose Public endpoint<\/strong>.<\/p>\n\n\n\n

By choice Add current client IP address<\/em> it basically adds the IP we are on Azure Portal<\/em> at this moment as an exception in the Firewall so that we can connect.<\/p>\n\n\n\n

\"\"
4<\/figcaption><\/figure>\n\n\n\n

In the next tab we put it collation<\/strong> that we want. In our case Greek_CI_AS<\/strong>.<\/p>\n\n\n\n

\"\"
5<\/figcaption><\/figure>\n\n\n\n

We may add tags<\/strong> so we can search if it is something for Development or is it for a production system.<\/p>\n\n\n\n

\"\"
6<\/figcaption><\/figure>\n\n\n\n

At the end it shows us one Review <\/em>with what we have selected before pressing it Create<\/em>. It also gives us the option to download it as a template so that we can upload a corresponding base any time we want in the future (DevOps).<\/p>\n\n\n\n

\"\"
7<\/figcaption><\/figure>\n\n\n\n

After the creation of the SQL Database is complete, we will be able to go to the database resource. There we can see the servername which will be the hostname <\/strong>where we will connect. Also choosing it set server firewall <\/strong>we can see where we allow access.<\/p>\n\n\n\n

\"\"
8<\/figcaption><\/figure>\n\n\n\n

There we will see that from the options we gave when we created it as we said before, the IP of the machine we were connected to was added Azure Portal<\/em>. If we would like any device to be able to connect via Internet <\/strong>directly to the base to put Start IP 0.0.0.0 <\/strong>and End IP 255.255.255.255<\/strong>.<\/p>\n\n\n\n

\"\"
9<\/figcaption><\/figure>\n\n\n\n

How do we connect to Azure SQL Database?<\/h2>\n\n\n\n

So now we can connect via SQL Server Management Studio<\/strong> the Azure Data Studio<\/strong>. To connect to the database, simply put the local admin that we created when we created the logical one SQL Server<\/em> which hosts the database (in create sql database, in figure 2).<\/p>\n\n\n\n

\"\"
10<\/figcaption><\/figure>\n\n\n\n

If we want to make one login <\/em>on the basis of which he is entitled read only<\/em> we should simply run a query based on the following:<\/p>\n\n\n\n

CREATE LOGIN [xristis] WITH PASSWORD=N'kwdikos'\nGO\nCREATE USER xristis FROM LOGIN xristis\nGO\nEXEC sp_addrolemember 'db_datareader', 'xristis';<\/pre>\n\n\n\n
We could use this login for example in an odbc connection. The connection strings<\/strong> we will see that there are ready in the tab Connection strings<\/em> of the resource. The only thing we should change is to put the corresponding username and password.<\/p>\n\n\n\n
\"\"
11<\/figcaption><\/figure>\n\n\n\n
But we can also connect with an account we have created at Azure Active Directory<\/strong>. To grant permissions (RBAC<\/strong>) in accounts we set it to Access Control (IAM)<\/strong>. But I can also set my account directly as Active Directory Admin <\/em>as we see in the image below:<\/p>\n\n\n\n
\"\"
12<\/figcaption><\/figure>\n\n\n\n
This time let's try connecting from Azure Data Studio<\/strong> (we can also with SSMS). We will choose as Authentication type<\/em> Azure Active Directory \u2013 Universal with MFA support<\/strong> and we simply log in with our account at Azure AD<\/em>.<\/p>\n\n\n\n
\"\"
13<\/figcaption><\/figure>\n\n\n\n
Finally, let's try to connect from command prompt with sqlcmd directly with the following command:<\/p>\n\n\n\n
sqlcmd -S dpgr-srv.database.windows.net -ddpgr_db -Usmatzouranis@dataplatform.gr -G<\/pre>\n\n\n\n
\"\"
14<\/figcaption><\/figure>\n\n\n\n
<\/p>\n\n\n\n
Sources:<\/h2>\n\n\n\n
What is a single database in Azure SQL Database?<\/a><\/p>","protected":false},"excerpt":{"rendered":"
In a previous article we saw what an Azure SQL Database is and the differences between SQL managed instances and SQL elastic pools. In the article we will analyze how we create a Simple Azure SQL Database step by step and what options we have when creating it. But before you continue reading the article if [\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":[135,56,46,29,30,6],"class_list":["post-2623","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-azure","category-ms-sqlserver","tag-azure","tag-azure-sql-database","tag-cloud","tag-databases","tag-rdbms","tag-sqlserver"],"yoast_head":"\n\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - 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\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03b5 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bf\u03cd\u03bc\u03b5\u03bd\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03ad\u03b9\u03c7\u03b1\u03bc\u03b5 \u03b4\u03b5\u03b9 \u03c4\u03b9 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03af\u03b1 Azure SQL Database \u03ba\u03b1\u03b9 \u03c4\u03b9\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03c4\u03b1 SQL managed instances \u03ba\u03b1\u03b9 SQL elastic pools. \u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b1\u03bd\u03b1\u03bb\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 Simple Azure SQL Database \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03bf \u03c4\u03b9 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ad\u03c2 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c4\u03b7\u03c2. \u03a0\u03c1\u03b9\u03bd \u03cc\u03bc\u03c9\u03c2 \u03c3\u03c5\u03bd\u03b5\u03c7\u03af\u03c3\u03b5\u03b9\u03c2 \u03bd\u03b1 \u03b4\u03b9\u03b1\u03b2\u03ac\u03b6\u03b5\u03b9\u03c2 \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b1\u03bd […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/\" \/>\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=\"2021-01-04T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-11T18:33:59+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=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database\",\"datePublished\":\"2021-01-04T03:00:00+00:00\",\"dateModified\":\"2024-09-11T18:33:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/\"},\"wordCount\":200,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"keywords\":[\"Azure\",\"Azure SQL Database\",\"Cloud\",\"Databases\",\"RDBMS\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft Azure\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/dp_azure.png\",\"datePublished\":\"2021-01-04T03:00:00+00:00\",\"dateModified\":\"2024-09-11T18:33:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#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\\\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\\\/#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\":\"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database\"}]},{\"@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":"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - 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\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - DataPlatform.gr","og_description":"\u03a3\u03b5 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bf\u03cd\u03bc\u03b5\u03bd\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03ad\u03b9\u03c7\u03b1\u03bc\u03b5 \u03b4\u03b5\u03b9 \u03c4\u03b9 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03af\u03b1 Azure SQL Database \u03ba\u03b1\u03b9 \u03c4\u03b9\u03c2 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03b9 \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03c4\u03b1 SQL managed instances \u03ba\u03b1\u03b9 SQL elastic pools. \u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b1\u03bd\u03b1\u03bb\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 Simple Azure SQL Database \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03bf \u03c4\u03b9 \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ad\u03c2 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c4\u03b7\u03c2. \u03a0\u03c1\u03b9\u03bd \u03cc\u03bc\u03c9\u03c2 \u03c3\u03c5\u03bd\u03b5\u03c7\u03af\u03c3\u03b5\u03b9\u03c2 \u03bd\u03b1 \u03b4\u03b9\u03b1\u03b2\u03ac\u03b6\u03b5\u03b9\u03c2 \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b1\u03bd […]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-01-04T03:00:00+00:00","article_modified_time":"2024-09-11T18:33:59+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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database","datePublished":"2021-01-04T03:00:00+00:00","dateModified":"2024-09-11T18:33:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/"},"wordCount":200,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","keywords":["Azure","Azure SQL Database","Cloud","Databases","RDBMS","SQL Server"],"articleSection":["Databases","Microsoft Azure","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/","url":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/","name":"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/01\/dp_azure.png","datePublished":"2021-01-04T03:00:00+00:00","dateModified":"2024-09-11T18:33:59+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#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\/pos-ftiachnoyme-mia-vasi-dedomenon-sto-az\/#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":"\u03a0\u03ce\u03c2 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b1\u03c0\u03bb\u03ae \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 Azure SQL Database"}]},{"@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\/2623","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=2623"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2623\/revisions"}],"predecessor-version":[{"id":5815,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2623\/revisions\/5815"}],"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=2623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=2623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=2623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}