{"id":52754,"date":"2022-10-16T10:49:11","date_gmt":"2022-10-16T10:49:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=52754"},"modified":"2022-10-16T10:54:09","modified_gmt":"2022-10-16T10:54:09","slug":"sql-managed-instance-configuration","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/","title":{"rendered":"SQL Managed Instance Configuration"},"content":{"rendered":"<p>In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.<\/p>\n<p>As the first step, we learn the IP address we need to connect to the Azure Arc Featured Managed Instance, which we have installed before, with the following code block.<\/p>\n<pre class=\"lang:default decode:true \">azdata arc sql mi list\r\n\r\n<\/pre>\n<figure style=\"width: 435px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim1-2.png\" alt=\"\" width=\"435\" height=\"138\" \/><figcaption class=\"wp-caption-text\">Picture1: IP address<\/figcaption><\/figure>\n<p>We learned the IP address, we connect to the Azure SQL Managed Instance, that is, Azure Managed Instance, via SQL Server Management Studio with the username and password we gave during the installation phase in our previous article.<\/p>\n<figure style=\"width: 423px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim2-2.png\" alt=\"\" width=\"423\" height=\"250\" \/><figcaption class=\"wp-caption-text\">Picture2: We are connecting with SSMS.<\/figcaption><\/figure>\n<p>As you can see in Picture 2, the SQL Server Agent service is turned off. If you want to activate it, you need this article.<\/p>\n<p>In fact, since Azure SQL Managed Instance with Azure Arc runs on SQL Server Linux for us, if you have done the configuration operations in linux environments before, you can apply a similar one here.<\/p>\n<p>In this context, we can also answer the question of why SQL Server works on Linux. We wouldn&#8217;t be able to use these Azure Arc-Enabled data services today if they weren&#8217;t running on Linux.<\/p>\n<p>We will be using the mssql-conf utility that we use for configuring the SQL Server Linux side here as well. I know this mssql-conf file is located at \/var\/opt\/mssql location because SQL Server is obvious by Linux.<\/p>\n<p>We need to learn the name of the running Pod and container before going through the configuration processes. We can use the following code block to learn this information.<\/p>\n<pre class=\"lang:default decode:true \">Kubectl get pods -n arc\r\n\r\n<\/pre>\n<figure style=\"width: 436px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim3-2.png\" alt=\"\" width=\"436\" height=\"347\" \/><figcaption class=\"wp-caption-text\">Picture3: We find the Pod and Container name.<\/figcaption><\/figure>\n<p>What you see in Picture 3 is the Managed Instance (MI) name information that I marked with red. The 0 next to it is the number of pod information.<\/p>\n<p>Namely, if I had created more than one copy\/replica of MI, I could also see 1 or 2 values here. In fact, let me address this issue in the next article and answer the question of how we can make Azure Managed Instance High Availability.<\/p>\n<p>We learned the pod name, now let&#8217;s learn the names of the containers in this pod. I can also use the following code block for this process.<\/p>\n<pre class=\"lang:default decode:true \">kubectl get pods dmcsqlmi-0 -o jsonpath='{.spec.containers[*].name}' -n arc\r\n\r\n<\/pre>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim4-2.png\" alt=\"\" width=\"602\" height=\"85\" \/><figcaption class=\"wp-caption-text\">Picture4: Containers in pods<\/figcaption><\/figure>\n<p>As you can see, there are 3 containers available.<\/p>\n<p><strong>Fluentbit :<\/strong> A logging tool<br \/>\n<strong>collectd :<\/strong> Metric collection tool<br \/>\n<strong>arc-sqlmi :<\/strong> and the Managed Instance we created<\/p>\n<p>Since we have gained so much information, if we want to do a pod-level operation, we do our operations using dmcsqlmi-0 and if we want to do container-level operations, we use arc-sqlmi.<\/p>\n<p>So, let&#8217;s connect to the container with the code below and start our bash operations.<\/p>\n<pre class=\"lang:default decode:true \">kubectl exec -it dmcsqlmi-0 -c arc-sqlmi -n arc -- \/bin\/bash\r\n\r\n<\/pre>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim5-2.png\" alt=\"\" width=\"602\" height=\"107\" \/><figcaption class=\"wp-caption-text\">Picture5<\/figcaption><\/figure>\n<p>Now let&#8217;s switch to the folder where we will do our operations.<\/p>\n<pre class=\"lang:default decode:true \">cd \/var\/opt\/mssql\/\r\n\r\n<\/pre>\n<figure style=\"width: 434px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim6-2.png\" alt=\"\" width=\"434\" height=\"42\" \/><figcaption class=\"wp-caption-text\">Picture6<\/figcaption><\/figure>\n<p>Let&#8217;s examine the configuration file.<\/p>\n<pre class=\"lang:default decode:true \">cat mssql.conf\r\n\r\n<\/pre>\n<figure style=\"width: 433px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim7-2.png\" alt=\"\" width=\"433\" height=\"98\" \/><figcaption class=\"wp-caption-text\">Picture7<\/figcaption><\/figure>\n<p>As you can see, there is a record in our default configuration file that only shows that telemetry is turned off. I am uploading the following new configuration file via the Azure portal.<\/p>\n<pre class=\"lang:default decode:true \">[sqlagent]\r\nenabled=true\r\n\r\n<\/pre>\n<p>I am copying the file named mssql-custom.conf where the code block above is registered in the Azure portal into the container using the following line of code.<\/p>\n<pre class=\"lang:default decode:true \">kubectl cp mssql-custom.conf dmcsqlmi-0:\/var\/opt\/mssql\/mssql-custom.conf -c arc-sqlmi -n arc\r\n\r\n<\/pre>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim8-2.png\" alt=\"\" width=\"602\" height=\"547\" \/><figcaption class=\"wp-caption-text\">Picture8<\/figcaption><\/figure>\n<p>Now that the file has been moved, we can restart it for the action to be active. We will be doing this through bash.<\/p>\n<pre class=\"lang:default decode:true \">supervisorctl restart mssql-server\r\n\r\n<\/pre>\n<p>After the restart, let&#8217;s check the status of the SQL Server Agent from SQL Server Management Studio.<\/p>\n<figure style=\"width: 225px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2021\/04\/Resim9-2.png\" alt=\"\" width=\"225\" height=\"181\" \/><figcaption class=\"wp-caption-text\">Picture9<\/figcaption><\/figure>\n<p>As you can see, we ran the SQL Server Agent service by making the desired configuration on the Azure SQL Managed Instance with Azure Arc.<\/p>\n<p>You can perform many configuration operations via the mssql-custom.conf file. You can perform different configuration operations by editing this file.<\/p>\n<p>For example, you can change the locations of the database files, the information about where to take the backups you have taken, and you can change the Maximum Memory setting of SQL Server.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_52754\" class=\"pvc_stats all  \" data-element-id=\"52754\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part. As the first step, we learn the IP address we need to connect to the Azure Arc Featured Managed Instance, which we have installed before, with the following code block. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_52754\" class=\"pvc_stats all  \" data-element-id=\"52754\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1414,"featured_media":52767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[10403],"tags":[],"class_list":["post-52754","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-azure"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":85,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Managed Instance Configuration - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Managed Instance Configuration - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-16T10:49:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-16T10:54:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png\" \/>\n\t<meta property=\"og:image:width\" content=\"626\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\"},\"author\":{\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\"},\"headline\":\"SQL Managed Instance Configuration\",\"datePublished\":\"2022-10-16T10:49:11+00:00\",\"dateModified\":\"2022-10-16T10:54:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\"},\"wordCount\":704,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png\",\"articleSection\":[\"Azure\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\",\"name\":\"SQL Managed Instance Configuration - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png\",\"datePublished\":\"2022-10-16T10:49:11+00:00\",\"dateModified\":\"2022-10-16T10:54:09+00:00\",\"description\":\"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png\",\"width\":626,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Managed Instance Configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\",\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"caption\":\"\u00c7a\u011flar \u00d6zen\u00e7\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Managed Instance Configuration - Database Tutorials","description":"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.","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:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/","og_locale":"en_US","og_type":"article","og_title":"SQL Managed Instance Configuration - Database Tutorials","og_description":"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.","og_url":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/","og_site_name":"Database Tutorials","article_published_time":"2022-10-16T10:49:11+00:00","article_modified_time":"2022-10-16T10:54:09+00:00","og_image":[{"width":626,"height":360,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png","type":"image\/png"}],"author":"\u00c7a\u011flar \u00d6zen\u00e7","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u00c7a\u011flar \u00d6zen\u00e7","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/"},"author":{"name":"\u00c7a\u011flar \u00d6zen\u00e7","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab"},"headline":"SQL Managed Instance Configuration","datePublished":"2022-10-16T10:49:11+00:00","dateModified":"2022-10-16T10:54:09+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/"},"wordCount":704,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png","articleSection":["Azure"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/","url":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/","name":"SQL Managed Instance Configuration - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png","datePublished":"2022-10-16T10:49:11+00:00","dateModified":"2022-10-16T10:54:09+00:00","description":"In this article, I will be answering the question of how we can configure the Azure Managed Instance that we created in the second part.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/10\/Ekran-goruntusu-2022-10-16-135201.png","width":626,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/10\/16\/sql-managed-instance-configuration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Managed Instance Configuration"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab","name":"\u00c7a\u011flar \u00d6zen\u00e7","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","caption":"\u00c7a\u011flar \u00d6zen\u00e7"},"url":"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1414"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=52754"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52754\/revisions"}],"predecessor-version":[{"id":52765,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/52754\/revisions\/52765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/52767"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=52754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=52754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=52754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}