{"id":6756,"date":"2018-06-24T10:17:36","date_gmt":"2018-06-24T13:17:36","guid":{"rendered":"http:\/\/www.fabriciolima.net\/?p=6756"},"modified":"2018-06-24T10:17:36","modified_gmt":"2018-06-24T13:17:36","slug":"50-dicas-e-atalhos-sql-server-management-studio-ssms","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/","title":{"rendered":"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)"},"content":{"rendered":"<p>Ol\u00e1 pessoal,<\/p>\n<p>H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos.<\/p>\n<p>Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada aqui sem ajudar ningu\u00e9m.<\/p>\n<p>Problema resolvido!<\/p>\n<p>Segue abaixo o link para baixar esse conte\u00fado (Power Point + Scripts de testes):<\/p>\n<p><a href=\"https:\/\/github.com\/FabricioLimaSolucoesEmBD\/Materiais\/tree\/master\/Post-50-Atalhos-SSMS\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/FabricioLimaSolucoesEmBD\/Materiais\/tree\/master\/Post-50-Atalhos-SSMS<\/a><\/p>\n<p>Espero que gostem e que algo seja \u00fatil para o seu dia a dia.<\/p>\n<p><b>Links utilizados como Refer\u00eancia:<\/b><\/p>\n<p><a href=\"https:\/\/msdn.microsoft.com\/pt-br\/library\/ms174205.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Atalhos de teclado do SQL Server Management Studio<\/a><\/p>\n<p><a href=\"http:\/\/www.tech-recipes.com\/rx\/47195\/11-keyboard-shortcuts-every-sql-server-geek-should-know\/\" target=\"_blank\" rel=\"noopener noreferrer\">11 Keyboard Shortcuts Every SQL Server Geek Should Know<\/a><\/p>\n<p><a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/2413\/sql-server-management-studio-keyboard-shortcuts-part-1-of-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Management Studio keyboard shortcuts (Part 1 of 2)<\/a><\/p>\n<p><a href=\"https:\/\/www.mssqltips.com\/sqlservertip\/2415\/ssms-keyboard-shortcuts-part-2-of-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Management Studio keyboard shortcuts (Part 2 of 2)<\/a><\/p>\n<p><b>OBS:<\/b> Algumas Dicas e Atalhos <strong>podem<\/strong> <strong>n\u00e3o funcionar em algumas vers\u00f5es<\/strong> <strong>do SQL Server Management Studio<\/strong>. Caso tenha algum problema, deixe um feedback nos coment\u00e1rios para poder agregar ainda mais informa\u00e7\u00e3o ao post. Deixe tamb\u00e9m alguma sugest\u00e3o para utiliza\u00e7\u00e3o das dicas que voc\u00ea j\u00e1 tenha usado em algum contexto e ache interessante compartilhar.<\/p>\n<p>Se for poss\u00edvel, utilize a \u00faltima vers\u00e3o do SSMS. Segue abaixo o link para fazer o <strong>Download<\/strong>:<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\">https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms<\/a><\/p>\n<p><b>Gostou dessas Dicas?<\/b><\/p>\n<p>Curta, comente, compartilhe com os coleguinhas\u2026<\/p>\n<p>Assine meu canal no <a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.youtube.com\/channel\/UCeBRAO_LLrUdSrOXIywjzRA\" target=\"_blank\" rel=\"external nofollow noopener noreferrer\" data-wpel-link=\"external\">Youtube<\/a> e curta minha <a class=\"external-link wpel-icon-left\" href=\"https:\/\/www.facebook.com\/FabricioLimaSolucoesemBancodeDados\/\" target=\"_blank\" rel=\"external nofollow noopener noreferrer\" data-wpel-link=\"external\">P\u00e1gina no Facebook<\/a> para receber Dicas de Leituras e Eventos sobre SQL Server.<\/p>\n<p>At\u00e9 a pr\u00f3xima.<\/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>Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1248,33],"tags":[1382,1381,1385,33,1384,1383],"class_list":["post-6756","post","type-post","status-publish","format-standard","hentry","category-queries-do-dia-a-dia","category-sql-server","tag-atalhos","tag-dicas","tag-management-studio","tag-sql-server","tag-sql-server-management-studio","tag-ssms"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Fabr\u00edcio Lima\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta property=\"og:description\" content=\"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-06-24T13:17:36+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-06-24T13:17:36+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#blogposting\",\"name\":\"50 Dicas e Atalhos \\u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"headline\":\"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)\",\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"},\"datePublished\":\"2018-06-24T10:17:36-03:00\",\"dateModified\":\"2018-06-24T10:17:36-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#webpage\"},\"articleSection\":\"Queries do Dia a Dia, SQL Server, atalhos, dicas, management studio, SQL Server, sql server management studio, ssms\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/queries-do-dia-a-dia\\\/#listItem\",\"name\":\"Queries do Dia a Dia\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/queries-do-dia-a-dia\\\/#listItem\",\"position\":3,\"name\":\"Queries do Dia a Dia\",\"item\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/queries-do-dia-a-dia\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#listItem\",\"name\":\"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#listItem\",\"position\":4,\"name\":\"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/category\\\/sql-server\\\/queries-do-dia-a-dia\\\/#listItem\",\"name\":\"Queries do Dia a Dia\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/\",\"name\":\"Fabr\\u00edcio Lima\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Fabr\\u00edcio Lima\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#webpage\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/\",\"name\":\"50 Dicas e Atalhos \\u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Ol\\u00e1 pessoal, H\\u00e1 alguns meses juntamos v\\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\\u00e7\\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\\u00e7\\u00e3o de atalhos que fizemos estava parada\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/2018\\\/06\\\/24\\\/50-dicas-e-atalhos-sql-server-management-studio-ssms\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/author\\\/fabricio\\\/#author\"},\"datePublished\":\"2018-06-24T10:17:36-03:00\",\"dateModified\":\"2018-06-24T10:17:36-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/\",\"name\":\"Fabricio Lima | Neg\\u00f3cios, Dados e IA\",\"description\":\"Insights pr\\u00e1ticos sobre neg\\u00f3cios, dados e intelig\\u00eancia artificial.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/fabriciolima.net\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada","canonical_url":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#blogposting","name":"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA","headline":"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)","author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"},"datePublished":"2018-06-24T10:17:36-03:00","dateModified":"2018-06-24T10:17:36-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#webpage"},"isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#webpage"},"articleSection":"Queries do Dia a Dia, SQL Server, atalhos, dicas, management studio, SQL Server, sql server management studio, ssms"},{"@type":"BreadcrumbList","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/fabriciolima.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/#listItem","name":"Queries do Dia a Dia"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/#listItem","position":3,"name":"Queries do Dia a Dia","item":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/","nextItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#listItem","name":"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#listItem","position":4,"name":"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)","previousItem":{"@type":"ListItem","@id":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/#listItem","name":"Queries do Dia a Dia"}}]},{"@type":"Organization","@id":"https:\/\/fabriciolima.net\/blog\/#organization","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","url":"https:\/\/fabriciolima.net\/blog\/"},{"@type":"Person","@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author","url":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/","name":"Fabr\u00edcio Lima","image":{"@type":"ImageObject","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/bf37320f6a46a98e189640eb70a8304c0ab624d1d7508cea5e99f626f4d56829?s=96&d=mm&r=g","width":96,"height":96,"caption":"Fabr\u00edcio Lima"}},{"@type":"WebPage","@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#webpage","url":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/","name":"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/fabriciolima.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/#breadcrumblist"},"author":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"creator":{"@id":"https:\/\/fabriciolima.net\/blog\/author\/fabricio\/#author"},"datePublished":"2018-06-24T10:17:36-03:00","dateModified":"2018-06-24T10:17:36-03:00"},{"@type":"WebSite","@id":"https:\/\/fabriciolima.net\/blog\/#website","url":"https:\/\/fabriciolima.net\/blog\/","name":"Fabricio Lima | Neg\u00f3cios, Dados e IA","description":"Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/fabriciolima.net\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"Fabricio Lima | Neg\u00f3cios, Dados e IA - Insights pr\u00e1ticos sobre neg\u00f3cios, dados e intelig\u00eancia artificial.","og:type":"article","og:title":"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA","og:description":"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada","og:url":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/","article:published_time":"2018-06-24T13:17:36+00:00","article:modified_time":"2018-06-24T13:17:36+00:00","twitter:card":"summary_large_image","twitter:title":"50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS) - Fabricio Lima | Neg\u00f3cios, Dados e IA","twitter:description":"Ol\u00e1 pessoal, H\u00e1 alguns meses juntamos v\u00e1rias dicas de atalhos do SSMS em um Power Point para incluir no material de nossos Treinamentos. Contudo, acabou que ficamos de realizar algumas valida\u00e7\u00f5es no material e com a grande demanda que tivemos isso ficou em segundo plano. Ou seja, essa compila\u00e7\u00e3o de atalhos que fizemos estava parada"},"aioseo_meta_data":{"post_id":"6756","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-07-04 23:53:16","updated":"2026-07-04 23:53:16"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/\" title=\"Queries do Dia a Dia\">Queries do Dia a Dia<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t50 Dicas e Atalhos \u2013 SQL Server Management Studio (SSMS)\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/fabriciolima.net\/blog"},{"label":"SQL Server","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/"},{"label":"Queries do Dia a Dia","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/queries-do-dia-a-dia\/"},{"label":"50 Dicas e Atalhos &#8211; SQL Server Management Studio (SSMS)","link":"https:\/\/fabriciolima.net\/blog\/2018\/06\/24\/50-dicas-e-atalhos-sql-server-management-studio-ssms\/"}],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":9978,"url":"https:\/\/fabriciolima.net\/blog\/2018\/12\/27\/managed-instance-18-sql-agent-offline-ao-logar-no-mi\/","url_meta":{"origin":6756,"position":0},"title":"Managed Instance (#18) \u2013 SQL Agent Offline ao logar no MI","author":"Fabr\u00edcio Lima","date":"27 de dezembro de 2018","format":false,"excerpt":"Fala Pessoal, Esse \u00e9 um post r\u00e1pido com uma dica sobre um caso que aconteceu comigo no Ignite. Chego eu para montar minha demo que estava fazendo para o pessoal que vinha com d\u00favidas e quando ia falar que o MI tinha o SQL Agent dispon\u00edvel, ele aparece Offline conforme\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\/12\/Managedinstance_18_1.png?resize=350%2C200&ssl=1","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":6756,"position":1},"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":12898,"url":"https:\/\/fabriciolima.net\/blog\/2020\/07\/28\/managed-instance-25-video-3-conectando-na-replica-read-only-e-fazendo-consultas\/","url_meta":{"origin":6756,"position":2},"title":"Managed Instance (#25) \u2013 V\u00eddeo (#3) \u2013 Conectando na replica read only e fazendo consultas","author":"Fabr\u00edcio Lima","date":"28 de julho de 2020","format":false,"excerpt":"Fala Pessoal, No v\u00eddeo anterior, mostrei como se conectar no Managed instance atrav\u00e9s do SSMS. Agora vamos ver como se conectar na r\u00e9plica read only e executar algumas consultas nela. https:\/\/www.youtube.com\/watch?v=nnE8VWD8Djc&t=3s \u00a0 Espero que possa ser \u00fatil para voc\u00eas. \u00a0 Seguem os posts anteriores sobre Managed Instance: Azure SQL DB\u2026","rel":"","context":"Em &quot;Administra\u00e7\u00e3o de Banco de Dados&quot;","block_context":{"text":"Administra\u00e7\u00e3o de Banco de Dados","link":"https:\/\/fabriciolima.net\/blog\/category\/sql-server\/administracao-de-bd\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/nnE8VWD8Djc\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":9788,"url":"https:\/\/fabriciolima.net\/blog\/2018\/11\/29\/managed-instance-11-agora-consigo-criar-jobs-direto-no-ssms\/","url_meta":{"origin":6756,"position":3},"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":18550,"url":"https:\/\/fabriciolima.net\/blog\/2023\/01\/24\/managed-instance-26-maintenance-window\/","url_meta":{"origin":6756,"position":4},"title":"Managed Instance (#26) \u2013 Maintenance Window","author":"Fabr\u00edcio Lima","date":"24 de janeiro de 2023","format":false,"excerpt":"Fala Pessoal, Ap\u00f3s um longo inverno voltei a criar uma inst\u00e2ncia gerenciada no azure (managed Instance) e vi uma op\u00e7\u00e3o que ainda n\u00e3o tinha documentado aqui no Blog, a Maintenance Window: Quando fiz esse post em 2018 n\u00e3o era poss\u00edvel escolher a collation da inst\u00e2ncia: Collation Managed Instance Devo ter\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\/2023\/01\/Managed_instance_timezone-e-maintenance-window-297x300.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"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":6756,"position":5},"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":[]}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/6756","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=6756"}],"version-history":[{"count":3,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/6756\/revisions"}],"predecessor-version":[{"id":9090,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/6756\/revisions\/9090"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=6756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=6756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=6756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}