{"id":49071,"date":"2022-11-29T00:00:00","date_gmt":"2022-11-28T23:00:00","guid":{"rendered":"https:\/\/jotelulu.com\/blog\/comparacao-do-sql-server-2022-com-versoes-anteriores\/"},"modified":"2022-11-29T00:00:00","modified_gmt":"2022-11-28T23:00:00","slug":"comparacao-sql-server-2022-versoes-anteriores","status":"publish","type":"post","link":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/","title":{"rendered":"Compara\u00e7\u00e3o do SQL Server 2022 com vers\u00f5es anteriores"},"content":{"rendered":"<p>Fique a conhecer as novidades da nova vers&atilde;o e a evolu&ccedil;&atilde;o do SGBD da gigante de Redmond atrav&eacute;s desta breve review, que faz a <strong>compara&ccedil;&atilde;o do SQL Server 2022 com vers&otilde;es anteriores<\/strong>.<\/p>\n<p>No dia <strong>16 de novembro de 2022<\/strong>, a Microsoft <strong>lan&ccedil;ou a &uacute;ltima vers&atilde;o<\/strong>&nbsp;deste software e achamos que &eacute; um bom momento para analisar as reais diferen&ccedil;as desta vers&atilde;o com as vers&otilde;es anteriores. N&atilde;o nos referimos &agrave;s diferen&ccedil;as entre a vers&atilde;o final e a RC (que sem d&uacute;vida existem), mas tamb&eacute;m com vers&otilde;es anteriores.<\/p>\n<p>Para isso, iremos <strong>rever algumas funcionalidades<\/strong> e <strong>compar&aacute;-las com as vers&otilde;es 2019 e 2017<\/strong>, pois, como sabemos, s&atilde;o as vers&otilde;es anteriores e com suporte da Microsoft.<\/p>\n<p>Antes de mergulhar no assunto, devemos dizer que, como acontece sempre com as novas vers&otilde;es de produtos da Microsoft, o foco foi colocado na melhora dos recursos existentes, dando-lhes <strong>mais capacidade de trabalho<\/strong>, <strong>mais poder de computa&ccedil;&atilde;o<\/strong> e, claro, <strong>mais seguran&ccedil;a<\/strong> e maiores <strong>capacidades de utiliza&ccedil;&atilde;o no Azure<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Diferentes edi&ccedil;&otilde;es de SQL Server 2022:<\/strong><\/h2>\n<p>Para come&ccedil;ar, devemos dizer que as edi&ccedil;&otilde;es dispon&iacute;veis para esta nova vers&atilde;o s&atilde;o as mesmas que t&iacute;nhamos at&eacute; agora, sem qualquer altera&ccedil;&atilde;o.<\/p>\n<ul>\n<li><strong>Enterprise<\/strong>:&nbsp;a&nbsp;<strong>vers&atilde;o premium<\/strong> que inclui <strong>funcionalidade completa<\/strong> para o <em>data center<\/em>. N&atilde;o possui limita&ccedil;&otilde;es e apresenta desempenho profissional. Suporta uma carga de trabalho maior do que as outras edi&ccedil;&otilde;es.<\/li>\n<li><strong>Standard<\/strong>:&nbsp;vers&atilde;o <strong>menos poderosa<\/strong> que a anterior, mas ainda assim uma solu&ccedil;&atilde;o topo de gama. Ideal para <strong>pequenas organiza&ccedil;&otilde;es<\/strong>.<\/li>\n<li><strong>Express<\/strong>:&nbsp;vers&atilde;o <strong>gratuita<\/strong>, ideal para estudantes ou iniciantes. &Eacute; usado para <strong>testes<\/strong> e&nbsp;pequenas aplica&ccedil;&otilde;es de qualquer tipo, sem a necessidade de investir numa licen&ccedil;a.<\/li>\n<li><strong>Developer<\/strong>:&nbsp;vers&atilde;o que permite <strong>programar e testar<\/strong> aplica&ccedil;&otilde;es de qualquer tipo no SQL Server. Possui as mesmas funcionalidades da vers&atilde;o Enterprise, mas <strong>n&atilde;o pode ser usado em produ&ccedil;&atilde;o<\/strong>.<\/li>\n<\/ul>\n<p>Na tabela a seguir encontra-se a compara&ccedil;&atilde;o de <strong>limites para cada uma das vers&otilde;es<\/strong> do SQL Server 2022<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"124\"><\/td>\n<td width=\"111\">Enterprise<\/td>\n<td width=\"111\">Standard<\/td>\n<td width=\"111\">Express<\/td>\n<td width=\"111\">Developer<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">N&uacute;mero m&aacute;ximo de cores<\/td>\n<td width=\"111\">Limite do SO<\/td>\n<td width=\"111\">24<\/td>\n<td width=\"111\">4<\/td>\n<td width=\"111\">Limite do SO<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Mem&oacute;ria m&aacute;xima por inst&acirc;ncia<\/td>\n<td width=\"111\">Limite do SO<\/td>\n<td width=\"111\">128GB<\/td>\n<td width=\"111\">1410MB<\/td>\n<td width=\"111\">Limite do SO<\/td>\n<\/tr>\n<tr>\n<td width=\"124\">Tamanho m&aacute;ximo da base de dados<\/td>\n<td width=\"111\">10GB<\/td>\n<td width=\"111\">524PB<\/td>\n<td width=\"111\">10GB<\/td>\n<td width=\"111\">10GB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><figure id=\"attachment_16429\" aria-describedby=\"caption-attachment-16429\" style=\"width: 940px\" class=\"wp-caption alignnone\"><img decoding=\"async\" data-recalc-dims=\"1\" loading=\"lazy\" class=\"wp-image-16429 size-full\" src=\"https:\/\/i0.wp.com\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen.-Evoluciin-del-Procesamiento-de-Consultas-Inteligente-IQP.jpg?resize=800%2C378&amp;ssl=1\" alt=\"Imagem. Evolu&ccedil;&atilde;o do Processamento de Consultas Inteligente (IQP)\" width=\"800\" height=\"378\"><figcaption id=\"caption-attachment-16429\" class=\"wp-caption-text\">Imagem. Evolu&ccedil;&atilde;o do Processamento de Consultas Inteligente (IQP)<\/figcaption><\/figure>\n<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Evolu&ccedil;&atilde;o do SQL Server: <\/strong><\/h2>\n<p>Se compararmos as <strong>caracter&iacute;sticas que foram adicionadas<\/strong> ao longo das &uacute;ltimas vers&otilde;es, podemos ver como a vers&atilde;o mais recente traz um grande n&uacute;mero de melhorias &ndash; quase o dobro das que foram apresentadas pelas duas vers&otilde;es anteriores &ndash;, que tornam esta nova vers&atilde;o realmente interessante. No entanto, devemos dizer que cerca de 20% destas novas &laquo;caracter&iacute;sticas&raquo; dependem inteiramente do Microsoft Azure.<\/p>\n<p>O <strong>SQL Server 2017<\/strong> apresentou as seguintes melhoras:<\/p>\n<ul>\n<li>Compatibilidade com diferentes distribui&ccedil;&otilde;es GNU\/Linux, como SLES (SUSE Enterprise Linux), RHEL (Red Hay Enterprise Linux) ou Ubuntu Linux.<\/li>\n<li>Compatibilidade com contentores de&nbsp;GNU\/Linux e Windows.<\/li>\n<li>Grupos de disponibilidade multiplataformas.<\/li>\n<li>Processamento de consultas inteligente e adapt&aacute;vel.<\/li>\n<li>Corre&ccedil;&atilde;o autom&aacute;tica de planos para corrigir problemas de desempenho.<\/li>\n<li>Compatibilidade para modelagem de rela&ccedil;&otilde;es atrav&eacute;s de gr&aacute;ficos.<\/li>\n<li>Compatibilidade com Python.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>O <strong>SQL Server 2019<\/strong>&nbsp;apresentou as seguintes melhoras:<\/p>\n<ul>\n<li>Compatibilidade para implementa&ccedil;&atilde;o com Kubernetes.<\/li>\n<li>Compatibilidade nativa com UTF-8.<\/li>\n<li>Suporte&nbsp;Java gratuito.<\/li>\n<li>Suporte de mem&oacute;ria persistente.<\/li>\n<li>Recupera&ccedil;&atilde;o Acelerada de Bases de Dados.<\/li>\n<li>Recupera&ccedil;&atilde;o ap&oacute;s Desastre gratuita (DR) para Azure Always Encrypted com enclaves seguros.<\/li>\n<li>Avalia&ccedil;&atilde;o de vulnerabilidade.<\/li>\n<li>Classifica&ccedil;&atilde;o e auditoria de dados.<\/li>\n<li>Integra&ccedil;&atilde;o com Azure Machine Learning e Spark ML.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>E para finalizar esta revis&atilde;o de melhorias ao longo das &uacute;ltimas vers&otilde;es, o <strong>SQL Server 2022<\/strong> traz as seguintes novidades:<\/p>\n<ul>\n<li>Livro raz&atilde;o do SQL Server.<\/li>\n<li>Suporte para mais mem&oacute;ria.<\/li>\n<li>Suporte de escalabilidade simult&acirc;nea.<\/li>\n<li>Virtualiza&ccedil;&atilde;o de dados para qualquer Data Lake.<\/li>\n<li>Armazenamento de consulta padr&atilde;o e suporte de replica&ccedil;&atilde;o.<\/li>\n<li>Suporte para s&eacute;ries temporais.<\/li>\n<li>Processamento inteligente de consultas NextGen.<\/li>\n<li>Sugest&otilde;es para armazenamento de consultas.<\/li>\n<li>Novas funcionalidades Transact-SQL.<\/li>\n<li>Acelera&ccedil;&atilde;o e download integrados.<\/li>\n<li>Fun&ccedil;&otilde;es JSON.<\/li>\n<li>Extens&otilde;es para Azure.<\/li>\n<li>Azure Synapse Link para SQL.<\/li>\n<li>Pol&iacute;ticas de Microsoft Purview.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Compara&ccedil;&atilde;o de funcionalidades:<\/strong><\/h2>\n<p>A melhor forma de observar as <strong>diferen&ccedil;as entre as vers&otilde;es&nbsp;<\/strong>&eacute; expor tabelas com os diferentes elementos e ver a sua disponibilidade com base nas vers&otilde;es existentes.<\/p>\n<p>Para tornar a visualiza&ccedil;&atilde;o um pouco mais f&aacute;cil, decidimos separar os dados entre as seguintes sec&ccedil;&otilde;es:<\/p>\n<ul>\n<li>Rendimento da base de dados.<\/li>\n<li>Disponibilidade das bases de dados.<\/li>\n<li>Seguran&ccedil;a das bases de dados.<\/li>\n<li>Gest&atilde;o e programa&ccedil;&atilde;o das bases de dados.<\/li>\n<li>BI e Analytics.<\/li>\n<li>Intelig&ecirc;ncia e bases de dados.<\/li>\n<li>Funcionalidades do Azure.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Desempenho da base de dados:<\/strong>&nbsp;aqui mostramos-lhe as funcionalidade que visam melhorar a utiliza&ccedil;&atilde;o dos recursos e cargas de trabalho do SQL Server.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Base de dados na mem&oacute;ria: OLTP na mem&oacute;ria<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Base de dados na mem&oacute;ria: mem&oacute;ria persistente<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Base de dados na mem&oacute;ria: tempdb otimizada para mem&oacute;ria<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">An&aacute;lise operativa em tempo real<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Processamento inteligente de consultas<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Varredura paralela do pool buffer<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Armazenagem de consultas por defeito compat&iacute;vel com r&eacute;plicas<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Sugest&otilde;es para armazenamento de consultas<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Acelera&ccedil;&atilde;o e download integrados<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Pool buffer h&iacute;brido com escrita direta<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Extens&atilde;o AVX-512 para melhorar as opera&ccedil;&otilde;es<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Disponibilidade das bases de dados:<\/strong>&nbsp;esta sec&ccedil;&atilde;o mostra as caracter&iacute;sticas destinadas a dotar o SGBD e as bases de dados associadas com recursos de disponibilidade para permanecerem &ldquo;Always On&rdquo;.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Always on<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Recupera&ccedil;&atilde;o acelerada de bases de dados<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Ler grupos de disponibilidade de escalamento horizontal<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Mem&oacute;ria elevada e escalabilidade simult&acirc;nea<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Replica&ccedil;&atilde;o de escrita m&uacute;ltipla<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Link a Inst&acirc;ncia gerida de Azure SQL: r&eacute;plicas<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Link a Inst&acirc;ncia gerida de Azure SQL: unidirecional<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Link a Inst&acirc;ncia gerida de Azure SQL: bidirecional<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Grupo de disponibilidade contido<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Seguran&ccedil;a das bases de dados:<\/strong>&nbsp;esta sec&ccedil;&atilde;o analisa todos os recursos de seguran&ccedil;a, como criptografia, compatibilidade com AAD, logs, tecnologias antiv&iacute;rus, etc.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Sempre criptografado com enclaves seguros<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Descoberta e classifica&ccedil;&atilde;o de dados<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Criptografia de dados transparente<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Suporte para criptografia de backup<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Criptografia em repouso e em movimento<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Mascaramento din&acirc;mico de dados e seguran&ccedil;a ao n&iacute;vel de linha<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Autentica&ccedil;&atilde;o de Azure Active Directory<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Microsoft Defender para SQL<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Governo central de integra&ccedil;&atilde;o de Microsoft Purview<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Pol&iacute;ticas de propriet&aacute;rio de dados de Microsoft Purview Integration<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Livro do raz&atilde;o SQL<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade con certificados PFX e outras melhoras criptogr&aacute;ficas<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Protocolo MS-TDS 8.0 e TLS 1.3<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Gest&atilde;o e programa&ccedil;&atilde;o das bases de dados:<\/strong>&nbsp;nesta sec&ccedil;&atilde;o, acima de tudo, s&atilde;o listadas as funcionalidades de compatibilidade com linguagens de programa&ccedil;&atilde;o, manipula&ccedil;&atilde;o de dados, etc.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade GNU\/Linux<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade com contentores<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade com Kubernetes<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Tabelas tempor&aacute;rias<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade JSON<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Suporte para dados gr&aacute;ficos<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade UTF 8<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Compatibilidade Java<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Azure Data Studio para administrar SQL Server, incluindo compatibilidade com T-SQL por cadernos<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Certifica&ccedil;&atilde;o de compatibilidade de base de dados<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Fun&ccedil;&otilde;es de manipula&ccedil;&atilde;o de bits<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Suporte para s&eacute;ries tempor&aacute;rias<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>BI e Analytics:&nbsp;<\/strong>nesta parte s&atilde;o tratados todos os aspetos relacionados com Business Intelligence e an&aacute;lise de dados.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Servi&ccedil;os de integra&ccedil;&atilde;o geridos como um servidor<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Modelo sem&acirc;ntico de BI tabular<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Servi&ccedil;os de Dados Mestres<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Servi&ccedil;os de qualidade de dados<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Rela&ccedil;&otilde;es muitos-para-muitos em modelos tabulares<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">BI m&oacute;vel end-to-end em qualquer dispositivo<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Consulta direta de SQL Server Analysis Services (SSAS)<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Grupos de c&aacute;lculo em modelo tabular<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Intelig&ecirc;ncia e bases de dados:<\/strong> Inclu&iacute;dos nesta categoria est&atilde;o todos os recursos de dete&ccedil;&atilde;o autom&aacute;tica, otimiza&ccedil;&atilde;o, etc., relacionados com as consultas.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Virtualiza&ccedil;&atilde;o de dados com PolyBase<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Virtualiza&ccedil;&atilde;o de dados para qualquer Data Lake<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Backup e restauro de armazenamento de objetos<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Azure Synapse Link<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Funcionalidades do Azure:<\/strong> Tudo o que est&aacute; relacionado com a compatibilidade com Azure, uso de recursos de <em>cloud<\/em> p&uacute;blica da Microsoft, etc.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"142\">Funcionalidades<\/td>\n<td width=\"142\">SQL Server 2017<\/td>\n<td width=\"142\">SQL Server 2019<\/td>\n<td width=\"142\">SQL Server 2022<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Liga&ccedil;&atilde;o da Inst&acirc;ncia Gerida do Azure SQL &ndash; r&eacute;plicas<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Liga&ccedil;&atilde;o da Inst&acirc;ncia Gerida do Azure SQL &ndash; unidirecional<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Liga&ccedil;&atilde;o da Inst&acirc;ncia Gerida do Azure SQL &ndash; bidirecional<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Imagens de m&aacute;quina virtual (VM) otimizadas na Galeria do Azure<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Replica&ccedil;&atilde;o ass&iacute;ncrona gratuita para M&aacute;quinas Virtuais do Azure para recupera&ccedil;&atilde;o ap&oacute;s desastres<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Microsoft Defender para SQL<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Governo central de Azure Purview<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Pol&iacute;ticas de propriet&aacute;rio de dados de Azure Purview<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\">Sim<\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Autentica&ccedil;&atilde;o AAD<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<\/tr>\n<tr>\n<td width=\"142\">Azure Synapse Link para SQL<\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<td width=\"142\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><strong>Download do SQL Server 2022:<\/strong><\/h2>\n<p>Se tiver interesse em testar a nova vers&atilde;o do SGBD da Microsoft, depois de rever as novidades que esta nova vers&atilde;o traz e as diferen&ccedil;as que apresenta com as vers&otilde;es 2017 e 2019, pode fazer o download atrav&eacute;s do seguinte link:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noopener\">SQL Server Downloads | Microsoft<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" data-recalc-dims=\"1\" loading=\"lazy\" class=\"alignnone wp-image-16425 size-full\" src=\"https:\/\/i0.wp.com\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen.-Pagina-de-descargas-de-SQL-Server-2022.jpg?resize=800%2C1173&amp;ssl=1\" alt=\"Imagem. P&aacute;gina de download do SQL Server.\" width=\"800\" height=\"1173\"><\/p>\n<p>&nbsp;<\/p>\n<p>Se quiser rever um tutorial sobre a instala&ccedil;&atilde;o deste gestor de bases de dados, pode visitar <a href=\"https:\/\/jotelulu.com\/pt-pt\/suporte\/tutoriais\/how-to-install-sql-server-2019-on-your-windows-server\/\" target=\"_blank\" rel=\"noopener\">como instalar o SQL Server 2019<\/a>&nbsp;(em ingl&ecirc;s). Em breve encontrar&aacute; tamb&eacute;m um tutorial para instalar a vers&atilde;o 2022.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Conclus&otilde;es:<\/strong><\/h2>\n<p>Ap&oacute;s uma longa espera, j&aacute; temos a nova vers&atilde;o do SQL Server 2022, que substitui a vers&atilde;o 2019 que j&aacute; estava no mercado h&aacute; tr&ecirc;s anos.<\/p>\n<p>Esta nova vers&atilde;o apresenta <strong>grandes vantagens face &agrave;s suas antecessoras.<\/strong>&nbsp;Aumenta mais uma vez a seguran&ccedil;a e a continuidade do neg&oacute;cio juntamente com a performance, com uma grande melhoria na gest&atilde;o de recursos, para al&eacute;m de muitas outras melhorias.<\/p>\n<p>Como sempre, este produto demonstra a import&acirc;ncia de ter as atualiza&ccedil;&otilde;es mais recentes de um produto para ter uma plataforma est&aacute;vel, segura e otimizada para qualquer carga de trabalho.<\/p>\n<p>Em termos gerais, podemos dizer que a Microsoft continua a afirmar-se como um fornecedor s&eacute;rio de DBMS e muitos outros produtos e servi&ccedil;os.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fique a conhecer as novidades da nova vers&atilde;o e a evolu&ccedil;&atilde;o do SGBD da gigante de Redmond atrav&eacute;s desta breve review, que faz a compara&ccedil;&atilde;o do SQL Server 2022 com vers&otilde;es anteriores. No dia 16 de novembro de 2022, a Microsoft lan&ccedil;ou a &uacute;ltima vers&atilde;o&nbsp;deste software e achamos que &eacute; um bom momento para analisar [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":16427,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-49071","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-y-sistemas"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores<\/title>\n<meta name=\"description\" content=\"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores\" \/>\n<meta property=\"og:description\" content=\"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/\" \/>\n<meta property=\"og:site_name\" content=\"Jotelulu\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-28T23:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1211\" \/>\n\t<meta property=\"og:image:height\" content=\"728\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Juan Ignacio Oller Aznar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Ignacio Oller Aznar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/\"},\"author\":{\"name\":\"Juan Ignacio Oller Aznar\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/#\\\/schema\\\/person\\\/2ae97818cae086c48f108cd74234aca9\"},\"headline\":\"Compara\u00e7\u00e3o do SQL Server 2022 com vers\u00f5es anteriores\",\"datePublished\":\"2022-11-28T23:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/\"},\"wordCount\":2179,\"image\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jotelulu.com\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg\",\"articleSection\":[\"Cloud y sistemas\"],\"inLanguage\":\"pt-PT\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/\",\"url\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/\",\"name\":\"Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jotelulu.com\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg\",\"datePublished\":\"2022-11-28T23:00:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/#\\\/schema\\\/person\\\/2ae97818cae086c48f108cd74234aca9\"},\"description\":\"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#primaryimage\",\"url\":\"https:\\\/\\\/jotelulu.com\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg\",\"contentUrl\":\"https:\\\/\\\/jotelulu.com\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg\",\"width\":1211,\"height\":728,\"caption\":\"Imagen Destacada Comparativa SQL Server 2022\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/blog\\\/comparacao-sql-server-2022-versoes-anteriores\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compara\u00e7\u00e3o do SQL Server 2022 com vers\u00f5es anteriores\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/#website\",\"url\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/\",\"name\":\"Jotelulu\",\"description\":\"Cloud Paradise for Tech Companies\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/#\\\/schema\\\/person\\\/2ae97818cae086c48f108cd74234aca9\",\"name\":\"Juan Ignacio Oller Aznar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g\",\"caption\":\"Juan Ignacio Oller Aznar\"},\"url\":\"https:\\\/\\\/jotelulu.com\\\/pt-pt\\\/author\\\/juanignaciooller\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores","description":"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.","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:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/","og_locale":"pt_PT","og_type":"article","og_title":"Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores","og_description":"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.","og_url":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/","og_site_name":"Jotelulu","article_published_time":"2022-11-28T23:00:00+00:00","og_image":[{"width":1211,"height":728,"url":"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg","type":"image\/jpeg"}],"author":"Juan Ignacio Oller Aznar","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Juan Ignacio Oller Aznar","Tempo estimado de leitura":"11 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#article","isPartOf":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/"},"author":{"name":"Juan Ignacio Oller Aznar","@id":"https:\/\/jotelulu.com\/pt-pt\/#\/schema\/person\/2ae97818cae086c48f108cd74234aca9"},"headline":"Compara\u00e7\u00e3o do SQL Server 2022 com vers\u00f5es anteriores","datePublished":"2022-11-28T23:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/"},"wordCount":2179,"image":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#primaryimage"},"thumbnailUrl":"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg","articleSection":["Cloud y sistemas"],"inLanguage":"pt-PT"},{"@type":"WebPage","@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/","url":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/","name":"Compara\u00e7\u00e3o de SQL Server 2022 com vers\u00f5es anteriores","isPartOf":{"@id":"https:\/\/jotelulu.com\/pt-pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#primaryimage"},"image":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#primaryimage"},"thumbnailUrl":"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg","datePublished":"2022-11-28T23:00:00+00:00","author":{"@id":"https:\/\/jotelulu.com\/pt-pt\/#\/schema\/person\/2ae97818cae086c48f108cd74234aca9"},"description":"Conhe\u00e7a as novidades e a evolu\u00e7\u00e3o do SGBD da Microsoft atrav\u00e9s deste breve artigo de an\u00e1lise e compara\u00e7\u00e3o de SQL Server 2022.","breadcrumb":{"@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#primaryimage","url":"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg","contentUrl":"https:\/\/jotelulu.com\/wp-content\/uploads\/2022\/11\/Imagen-Destacada-Comparativa-SQL-Server-2022-1.jpg","width":1211,"height":728,"caption":"Imagen Destacada Comparativa SQL Server 2022"},{"@type":"BreadcrumbList","@id":"https:\/\/jotelulu.com\/pt-pt\/blog\/comparacao-sql-server-2022-versoes-anteriores\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/jotelulu.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Compara\u00e7\u00e3o do SQL Server 2022 com vers\u00f5es anteriores"}]},{"@type":"WebSite","@id":"https:\/\/jotelulu.com\/pt-pt\/#website","url":"https:\/\/jotelulu.com\/pt-pt\/","name":"Jotelulu","description":"Cloud Paradise for Tech Companies","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jotelulu.com\/pt-pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/jotelulu.com\/pt-pt\/#\/schema\/person\/2ae97818cae086c48f108cd74234aca9","name":"Juan Ignacio Oller Aznar","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/87efd80399b2c40a1d78dd5cee4e788d3f6c29d33e3b67bcfbc6abbf91d0fdcf?s=96&d=mm&r=g","caption":"Juan Ignacio Oller Aznar"},"url":"https:\/\/jotelulu.com\/pt-pt\/author\/juanignaciooller\/"}]}},"_links":{"self":[{"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/posts\/49071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=49071"}],"version-history":[{"count":0,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/posts\/49071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/media\/16427"}],"wp:attachment":[{"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=49071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=49071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jotelulu.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=49071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}