{"id":9778,"date":"2018-11-28T08:26:25","date_gmt":"2018-11-28T10:26:25","guid":{"rendered":"http:\/\/www.fabriciolima.net\/?p=9778"},"modified":"2018-11-28T08:26:25","modified_gmt":"2018-11-28T10:26:25","slug":"managed-instance-10-consigo-criar-linked-server","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2018\/11\/28\/managed-instance-10-consigo-criar-linked-server\/","title":{"rendered":"Managed Instance (#10) \u2013 Consigo criar Linked Server?"},"content":{"rendered":"<p>Fala Pessoal,<\/p>\n<p>Esse \u00e9 mais um post da s\u00e9rie sobre o Azure SQL Database Managed Instance. Caso ainda n\u00e3o tenha visto, seguem os posts anteriores:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/03\/17\/azure-sql-db-managed-instance-introducao\/https:\/\/www.fabriciolima.net\/blog\/2018\/11\/16\/managed-instance-criando-minha-primeira-instancia\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Azure SQL DB Managed Instance \u2013 Introdu\u00e7\u00e3o<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/16\/managed-instance-criando-minha-primeira-instancia\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance \u2013 Criando minha primeira inst\u00e2ncia<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/19\/managed-instance-como-se-conectar-direto-do-ssms-utilizando-uma-vpn\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance \u2013 Como se conectar direto do SSMS utilizando uma VPN?<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/20\/managed-instance-como-se-conectar-atraves-do-ssms-de-uma-vm-do-azure\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance \u2013 Como se conectar atrav\u00e9s do SSMS de uma VM do Azure?<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/21\/managed-instance-5-quanto-custa-tudo-isso\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance (#5) \u2013 Quanto custa tudo isso?<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/22\/managed-instance-6-consigo-fazer-um-join-entre-tabelas-de-bases-diferentes\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance (#6) \u2013 Consigo fazer um Join entre tabelas de bases diferentes?<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/23\/managed-instance-7-a-funcao-getdate-ja-retorna-a-data-da-minha-localidade\/\" target=\"_blank\" rel=\"noopener\" data-wpel-link=\"internal\">Managed Instance (#7) \u2013 A fun\u00e7\u00e3o getdate() j\u00e1 retorna a data da minha localidade?<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/26\/managed-instance-8-suporte-microsoft-em-portugues\/\" target=\"_blank\" rel=\"noopener\">Managed Instance (#8) \u2013 Suporte Microsoft em Portugu\u00eas<\/a><\/li>\n<li><a href=\"https:\/\/www.fabriciolima.net\/blog\/2018\/11\/27\/managed-instance-9-agora-consigo-mandar-e-mail-do-sql-server\/\" target=\"_blank\" rel=\"noopener\">Managed Instance (#9) \u2013 Agora consigo mandar E-mail do SQL Server?<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>No Azure SQL Database n\u00e3o era poss\u00edvel criar Linked Server e isso era um problema que algumas empresas tinha que se adaptar antes de uma migra\u00e7\u00e3o para o Azure.<\/p>\n<p>Contudo, no Managed Instance j\u00e1 conseguimos criar Linked Server conforme vamos ver nesse post.<\/p>\n<p>Nessa figura abaixo podemos ver uma instancia do MI e uma inst\u00e2ncia de uma VM que tenho na mesma rede do MI. Isso \u00e9 muito importante, pois assim como em nosso ambiente hoje, para se criar um LS os servidores devem se comunicar.<\/p>\n<p>O processo de cria\u00e7\u00e3o de um LS \u00e9 o mesmo que no seu SQL Server On Premise, ent\u00e3o\u00a0 vou pular alguns passos.<\/p>\n<p>Vou criar um Linked Server do meu MI para a minha m\u00e1quina virtual no Azure:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9786 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1.png\" alt=\"\" width=\"510\" height=\"422\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1.png 611w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1-300x248.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1-410x340.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1-100x83.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1-275x228.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_1-20x17.png 20w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/p>\n<p>Server Object-&gt; Bot\u00e3o direito em LS -&gt; New Linked Server abre a tela abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9785 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2.png\" alt=\"\" width=\"485\" height=\"443\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2.png 853w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-300x274.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-768x700.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-700x638.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-410x374.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-100x91.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-275x251.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_2-20x18.png 20w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/p>\n<p>O tipo que vou criar \u00e9 SQL Server e coloquei o IP da minha VM no Azure (157.55.192.186).<\/p>\n<p>Em seguida na aba Security devemos colocar o usu\u00e1rio que ser\u00e1 utilizado para logar na Vm e fazer os acessos via LS:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9784 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3.png\" alt=\"\" width=\"500\" height=\"451\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3.png 856w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-300x270.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-768x692.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-700x630.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-410x369.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-100x90.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-275x248.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_3-20x18.png 20w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<p>Feio isso, nosso LS j\u00e1 est\u00e1 criado conforme print abaixo:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9783 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4.png\" alt=\"\" width=\"498\" height=\"312\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4.png 615w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4-300x188.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4-410x257.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4-100x63.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4-275x172.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_4-20x13.png 20w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Vamos testar?<\/p>\n<p>Segue abaixo um select executado no meu MI acessando uma tabela da base <strong>TeamFabricioLima<\/strong> que est\u00e1 criada na minha VM.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9782 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5.png\" alt=\"\" width=\"691\" height=\"472\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5.png 954w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-300x205.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-768x525.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-700x478.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-410x280.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-100x68.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-275x188.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_5-20x14.png 20w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/p>\n<p>Pronto. LS criado e funcionando.<\/p>\n<p>Menos uma limita\u00e7\u00e3o para voc\u00ea migrar para o Managed Instance.<\/p>\n<p>E o contr\u00e1rio, funciona Fabr\u00edcio?<\/p>\n<p>R: Sim.<\/p>\n<p>E digo mais, conseguimos criar um LS at\u00e9 para fazer leitura no servidor secund\u00e1rio caso tenha contratado um MI Business Critical.<\/p>\n<p>Segue teste abaixo onde da minha VM fiz uma consulta via LS no meu MI e outra consulta para outro LS apontando para a r\u00e9plica Read only do meu MI:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9781 aligncenter\" src=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6.png\" alt=\"\" width=\"944\" height=\"562\" srcset=\"https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6.png 1094w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-300x179.png 300w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-1024x609.png 1024w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-768x457.png 768w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-700x417.png 700w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-410x244.png 410w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-100x60.png 100w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-275x164.png 275w, https:\/\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_LinkedServer_6-20x12.png 20w\" sizes=\"auto, (max-width: 944px) 100vw, 944px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>WOW!!! Quer dizer que consigo separar a carga da minha produ\u00e7\u00e3o no MI e mandar consultas para outra inst\u00e2ncia secund\u00e1ria?<\/p>\n<p>R: Sim. Mas vamos testar isso com mais detalhes em posts futuros.<\/p>\n<p>Tenho muita coisa ainda para testar e compartilhar com voc\u00eas.<\/p>\n<p><b>Gostou dessa Dica?<\/b><\/p>\n<p>Curta, comente, compartilhe\u2026<\/p>\n<p>Assine meu canal no\u00a0<a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.youtube.com\/channel\/UCeBRAO_LLrUdSrOXIywjzRA\" target=\"_blank\" rel=\"external noopener noreferrer nofollow\" data-wpel-link=\"external\">Youtube<\/a>\u00a0, curta minha p\u00e1gina no\u00a0<a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.facebook.com\/FabricioLimaSolucoesemBancodeDados\/\" target=\"_blank\" rel=\"external noopener noreferrer nofollow\" data-wpel-link=\"external\">Facebook<\/a>\u00a0 ou siga nossa p\u00e1gina no\u00a0<a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.instagram.com\/fabriciolimasolucoesembd\" target=\"_blank\" rel=\"noopener nofollow external noreferrer\" data-wpel-link=\"external\">Instagram<\/a>\u00a0para receber Dicas de Leituras, V\u00eddeos e Eventos sobre SQL Server.<\/p>\n<p>At\u00e9 o pr\u00f3ximo post.<\/p>\n<p>Abra\u00e7os,<\/p>\n<p>Fabr\u00edcio Lima<\/p>\n<p>Microsoft Data Platform MVP<\/p>\n<p>Consultor e Instrutor SQL Server<\/p>\n<p>Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fala Pessoal, Esse \u00e9 mais um post da s\u00e9rie sobre o Azure SQL Database Managed Instance. Caso ainda n\u00e3o tenha visto, seguem os posts anteriores: Azure SQL DB Managed Instance \u2013 Introdu\u00e7\u00e3o Managed Instance \u2013 Criando minha primeira inst\u00e2ncia Managed Instance \u2013 Como se conectar direto do SSMS utilizando uma VPN? Managed Instance \u2013 Como [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1616,1617,1512,280],"tags":[1641],"class_list":["post-9778","post","type-post","status-publish","format-standard","hentry","category-azure-sql-database","category-managed-instance","category-sql-azure","category-virtual-pass-br","tag-azure"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":10046,"url":"https:\/\/fabriciolima.net\/blog\/2019\/01\/21\/managed-instance-20-agora-posso-usar-o-sql-profile-no-azure\/","url_meta":{"origin":9778,"position":0},"title":"Managed Instance (#20) \u2013 Agora posso usar o SQL Profile no Azure?","author":"Fabr\u00edcio Lima","date":"21 de janeiro de 2019","format":false,"excerpt":"Fala Pessoal, Segue mais um post da s\u00e9rie sobre Managed Instance. No Azure SQL Database n\u00e3o era poss\u00edvel utilizar o nosso t\u00e3o querido Profile que era para morrer mas nunca morre. Tentando conectar no profile de uma database que tenho no Azure: \u00c9 gerado o erro abaixo: E no Managed\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2019\/01\/Managedinstance_20_1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2019\/01\/Managedinstance_20_1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2019\/01\/Managedinstance_20_1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2019\/01\/Managedinstance_20_1.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":9788,"url":"https:\/\/fabriciolima.net\/blog\/2018\/11\/29\/managed-instance-11-agora-consigo-criar-jobs-direto-no-ssms\/","url_meta":{"origin":9778,"position":1},"title":"Managed Instance (#11) \u2013 Agora consigo criar Jobs direto no SSMS?","author":"Fabr\u00edcio Lima","date":"29 de novembro de 2018","format":false,"excerpt":"Fala Pessoal, Esse \u00e9 mais um post da s\u00e9rie sobre o Azure SQL Database Managed Instance. Caso ainda n\u00e3o tenha visto, seguem os posts anteriores: Azure SQL DB Managed Instance \u2013 Introdu\u00e7\u00e3o Managed Instance \u2013 Criando minha primeira inst\u00e2ncia Managed Instance \u2013 Como se conectar direto do SSMS utilizando uma\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Jobs_1.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":9707,"url":"https:\/\/fabriciolima.net\/blog\/2018\/11\/23\/managed-instance-7-a-funcao-getdate-ja-retorna-a-data-da-minha-localidade\/","url_meta":{"origin":9778,"position":2},"title":"Managed Instance (#7) &#8211; A fun\u00e7\u00e3o getdate() j\u00e1 retorna a data da minha localidade?","author":"Fabr\u00edcio Lima","date":"23 de novembro de 2018","format":false,"excerpt":"Fala Pessoal, Esse \u00e9 mais um post da s\u00e9rie sobre o Azure SQL Database Managed Instance. Caso ainda n\u00e3o tenha visto, seguem os posts anteriores: Azure SQL DB Managed Instance \u2013 Introdu\u00e7\u00e3o Managed Instance \u2013 Criando minha primeira inst\u00e2ncia Managed Instance \u2013 Como se conectar direto do SSMS utilizando uma\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Getdate_1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Getdate_1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Getdate_1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/fabriciolima.net\/blog\/wp-content\/uploads\/2018\/11\/Managedinstance_Getdate_1.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":12222,"url":"https:\/\/fabriciolima.net\/blog\/2020\/05\/18\/managed-instance-23-video-1-criando-minha-primeira-instancia-no-portal-do-azure\/","url_meta":{"origin":9778,"position":3},"title":"Managed Instance (#23) \u2013 V\u00eddeo (#1) &#8211; Criando minha primeira inst\u00e2ncia no portal do azure","author":"Fabr\u00edcio Lima","date":"18 de maio de 2020","format":false,"excerpt":"Fala Pessoal, Recentemente foi lan\u00e7ada uma nova prova de certifica\u00e7\u00e3o ainda no modelo Beta: Exame DP-300: Administering Relational Databases on Microsoft Azure (beta) Dessa forma, acredito que agora mais pessoas v\u00e3o buscar conte\u00fado sobre o assunto e resolvi gravar alguns v\u00eddeos para ajudar. O primeiro dele j\u00e1 est\u00e1 dispon\u00edvel no\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/ESs0kaAl6R4\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":12347,"url":"https:\/\/fabriciolima.net\/blog\/2020\/05\/27\/managed-instance-24-video-2-como-faco-para-me-conectar-no-managed-instance-via-ssms\/","url_meta":{"origin":9778,"position":4},"title":"Managed Instance (#24) \u2013 V\u00eddeo (#2) \u2013 Como fa\u00e7o para me conectar no Managed Instance via SSMS?","author":"Fabr\u00edcio Lima","date":"27 de maio de 2020","format":false,"excerpt":"Fala Pessoal, No v\u00eddeo anterior, mostrei como criar um Managed Instance. Nesse de agora vou mostrar como voc\u00ea pode se conectar nele via SSMS para come\u00e7ar a fazer queries. https:\/\/www.youtube.com\/watch?v=F-PrQhC2KiE&feature=youtu.be \u00a0 Espero que possa ser \u00fatil para voc\u00eas. \u00a0 Seguem os posts anteriores sobre Managed Instance: Azure SQL DB Managed\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/F-PrQhC2KiE\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":8886,"url":"https:\/\/fabriciolima.net\/blog\/2018\/03\/17\/azure-sql-db-managed-instance-introducao\/","url_meta":{"origin":9778,"position":5},"title":"Azure SQL DB Managed Instance &#8211; Introdu\u00e7\u00e3o","author":"Fabr\u00edcio Lima","date":"17 de mar\u00e7o de 2018","format":false,"excerpt":"\u00a0 Fala Pessoal, Semana passada, enquanto estava participando do MVP Summit na sede da microsoft em Redmond-WA, eles anunciaram a libera\u00e7\u00e3o de um preview p\u00fablico de um neg\u00f3cio chamado Azure SQL Database Managed Instance. Esse an\u00fancio pode ser visto no link abaixo: https:\/\/azure.microsoft.com\/en-us\/blog\/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance\/ Conversando com alguns clientes, quase nenhum conhecia\u2026","rel":"","context":"Em &quot;Azure SQL Database&quot;","block_context":{"text":"Azure SQL Database","link":"https:\/\/fabriciolima.net\/blog\/category\/azure-sql-database\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.fabriciolima.net\/blog\/wp-content\/uploads\/2018\/03\/MI_indroducao0.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=9778"}],"version-history":[{"count":4,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9778\/revisions"}],"predecessor-version":[{"id":9808,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/9778\/revisions\/9808"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=9778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=9778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=9778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}