{"id":289,"date":"2020-01-06T22:53:41","date_gmt":"2020-01-07T01:53:41","guid":{"rendered":"https:\/\/powertuning.com.br\/?page_id=289"},"modified":"2020-01-10T18:43:06","modified_gmt":"2020-01-10T21:43:06","slug":"tuning-para-dbas-e-devs-com-casos-reais-da-sua-empresa","status":"publish","type":"page","link":"https:\/\/powertuning.com.br\/blog\/tuning-para-dbas-e-devs-com-casos-reais-da-sua-empresa\/","title":{"rendered":"Tuning para DBAs e Devs com casos reais da sua Empresa"},"content":{"rendered":"\r\n<p>A diferen\u00e7a desse Treinamento para um gen\u00e9rico com exemplos fict\u00edcios \u00e9 que em cada item do Treinamento podemos olhar o ambiente Real do cliente e discutir melhorias que v\u00e3o ajudar na pr\u00e1tica essa empresa. Inclusive, se for poss\u00edvel, vamos olhar queries reais e fazer um Tuning AO VIVO em algumas consultas do cliente.<\/p>\r\n\r\n\r\n\r\n<p>Por enquanto, ser\u00e1 um treinamento fechado apenas para empresas (In Company ou ONLINE) e ainda n\u00e3o tenho previs\u00e3o de agendar turmas abertas.<\/p>\r\n\r\n\r\n\r\n<p><strong>Dura\u00e7\u00e3o:<\/strong>\u00a0<strong>24 horas<\/strong>, mas pode ser de 16 horas (com cortes indicados pela empresa) ou de 32 horas (para dar tempo de olhar mais queries de produ\u00e7\u00e3o)<\/p>\r\n\r\n\r\n\r\n<p>Ficou interessado? Ent\u00e3o entre em contato comigo.<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>E-mail:\u00a0<strong>comercial@powertuning.com.br<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Segue o conte\u00fado do curso:<\/p>\r\n\r\n\r\n\r\n<p><strong>Parte 01: Cria\u00e7\u00e3o de Rotinas de Monitoramento de Performance<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Cria\u00e7\u00e3o da procedure WhoisActive\r\n<ul>\r\n<li>Exemplos de utiliza\u00e7\u00e3o e explica\u00e7\u00e3o dos resultados retornados por essa procedure<\/li>\r\n<li>Cria\u00e7\u00e3o de uma rotina para monitorar a cada 1 minuto<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Cria\u00e7\u00e3o de um Trace para Log das queries lentas do banco de dados\r\n<ul>\r\n<li>Como criar um Server Side Trace<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Cria\u00e7\u00e3o de uma rotina para armazenar alguns contadores do SQL Server\r\n<ul>\r\n<li>Batch Requests<\/li>\r\n<li>User Connection<\/li>\r\n<li>CPU<\/li>\r\n<li>Page Life Expectancy<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Parte 02: An\u00e1lise de Recursos do Servidor<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Waits Stats<\/li>\r\n<li>CPU est\u00e1 em 100%, o que analisar?<\/li>\r\n<li>Como validar se meu problema de performance \u00e9 falta de mem\u00f3ria?<\/li>\r\n<li>Como comprovar que estou com gargalos de disco?<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Parte 03: Configura\u00e7\u00f5es do SQL Server e dicas diversas de Performance<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Configura\u00e7\u00e3o Servidor SQL<\/li>\r\n<li>Collation faz diferen\u00e7a na Performance?<\/li>\r\n<li>Instant File Initialization (IFI)<\/li>\r\n<li>Configura\u00e7\u00e3o Error Log SQL Server<\/li>\r\n<li>Cria\u00e7\u00e3o de uma Base de Dados\r\n<ul>\r\n<li>Crescimento dos Arquivos de Log<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Cria\u00e7\u00e3o de Tabelas\r\n<ul>\r\n<li>Principais tipos de dados do SQL Server<\/li>\r\n<li>Utiliza\u00e7\u00e3o de Constraints (PK, FK, Default, Check e etc)<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Linked Server<\/li>\r\n<li>Shrink<\/li>\r\n<li>Backup com Compress\u00e3o<\/li>\r\n<li>Compress\u00e3o de Dados<\/li>\r\n<li>TEMPDB<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Parte 04: Estat\u00edsticas e \u00cdndices no SQL Server<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>An\u00e1lise das Estat\u00edsticas\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Entendendo como as estat\u00edsticas funcionam e sua import\u00e2ncia<\/li>\r\n<li>Cria\u00e7\u00e3o de uma rotina para atualiza\u00e7\u00e3o de estat\u00edsticas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>\u00cdndices\r\n<ul>\r\n<li>Como os dados s\u00e3o armazenados no SQL Server<\/li>\r\n<li>Tipos de \u00edndices (clustered e nonclustered)<\/li>\r\n<li>Fragmenta\u00e7\u00e3o\r\n<ul>\r\n<li>Rotina para armazenar o hist\u00f3rico de fragmenta\u00e7\u00e3o de \u00edndices<\/li>\r\n<li>Rotina para desfragmentar os \u00edndices das bases<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>An\u00e1lise da utiliza\u00e7\u00e3o de \u00edndices\r\n<ul>\r\n<li>Rotina para armazenar o hist\u00f3rico de utiliza\u00e7\u00e3o de \u00edndices<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Sugest\u00f5es de \u00edndices pelo SQL Server<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Parte 05: Melhorando a Performance de Consultas<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Execution Plan\r\n<ul>\r\n<li>O que \u00e9?<\/li>\r\n<li>Como analisar?<\/li>\r\n<li>Operadores mais comuns<\/li>\r\n<li>O que devo procurar primeiro?<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Como encontrar as queries mais problem\u00e1ticas para analisar (CPU, Disco, Tempo e Repeti\u00e7\u00f5es)\r\n<ul>\r\n<li>Trace de Queries Demoradas<\/li>\r\n<li>Dmvs do SQL Server<\/li>\r\n<li>Query Store<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Query Store\r\n<ul>\r\n<li>O que \u00e9?<\/li>\r\n<li>Qual o impacto?<\/li>\r\n<li>Como isso pode me ajudar no dia a dia?<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Analisando Queries Reais\r\n<ul>\r\n<li>Analisando Queries Reais \u2013 Query 1<\/li>\r\n<li>Analisando Queries Reais \u2013 Query 2<\/li>\r\n<li>Analisando Queries Reais \u2013 Query 3<\/li>\r\n<li>Analisando Queries Reais \u2013 Query 4<\/li>\r\n<li>Analisando Queries Reais do Cliente que est\u00e1 recebendo o Treinamento (Quando poss\u00edvel)<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Dicas de T-SQL\r\n<ul>\r\n<li>Posso usar cursor?<\/li>\r\n<li>NOT IN ou NOT EXISTS<\/li>\r\n<li>JOIN ou EXISTS<\/li>\r\n<li>COUNT(1) ou COUNT(*)<\/li>\r\n<li>GROUP BY ou DISTINCT<\/li>\r\n<li>UNION ou UNION ALL<\/li>\r\n<li>Outras d\u00favidas que surgirem no treinamento\u2026<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Locks e Deadlock\r\n<ul>\r\n<li>Problemas frequentes de lock que encontro em Clientes<\/li>\r\n<li>Rotina para monitorar Deadlock.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Cria\u00e7\u00e3o de Alertas\u00a0de Performance\r\n<ul>\r\n<li>TempDB<\/li>\r\n<li>Lock<\/li>\r\n<li>Consumo de CPU<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>\u00a0Conte\u00fado Extra:\u00a0<\/strong><strong>Azure SQL Database<\/strong><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Vou perder meu emprego?<\/li>\r\n<li>Meu trabalho de Tuning ainda \u00e9 importante?<\/li>\r\n<li>Quais ferramentas de Tuning tenho no SQL do Azure?<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h6 class=\"wp-block-heading\"><strong>N\u00e3o perca essa oportunidade de investir na sua empresa!<\/strong><\/h6>\r\n\r\n\r\n\r\n<p>Preencha os seus dados abaixo que entraremos em contato para conversamos melhor sobre a sua necessidade e iniciarmos uma parceria de sucesso.<br\/><\/p>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n<div data-test='contact-form'\n\t\t\tid='contact-form-289'\n\t\t\tclass='jetpack-contact-form-container '\n\t\t\tdata-wp-interactive='jetpack\/form' data-wp-context='{\"formId\":\"289\",\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\",\"showErrors\":false,\"errors\":[],\"fields\":[],\"isMultiStep\":false,\"useAjax\":true,\"submissionData\":null,\"formattedSubmissionData\":[],\"submissionSuccess\":false,\"submissionError\":null,\"elementId\":\"jp-form-8e6b4990479005e16b565dec1850635e5a876abe\",\"isSingleInputForm\":false,\"isForcedHorizontal\":false}'\n\t\t\tdata-wp-watch--scroll-to-wrapper=\"callbacks.scrollToWrapper\"\n\t\t>\n<div class=\"contact-form-submission contact-form-ajax-submission\" data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" data-wp-class--submission-success=\"context.submissionSuccess\" id=\"contact-form-success-8e6b4990479005e16b565dec1850635e5a876abe\" tabindex=\"-1\" aria-labelledby=\"contact-form-success-header-8e6b4990479005e16b565dec1850635e5a876abe\"><p class=\"go-back-message\"><a class=\"link\" role=\"button\" tabindex=\"0\" data-wp-on--click=\"actions.goBack\" href=\"\/blog\/wp-json\/wp\/v2\/pages\/289\">\u2190 Voltar<\/a><\/p><h4 data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" id=\"contact-form-success-header-8e6b4990479005e16b565dec1850635e5a876abe\">Agradecemos pela sua resposta. \u2728<\/h4>\n\n<template data-wp-each--submission=\"context.formattedSubmissionData\">\n\t\t\t\t\t<div class=\"jetpack_forms_contact-form-success-summary\">\n\t\t\t\t\t\t<div class=\"field-name-wrapper\">\n\t\t\t\t\t\t\t<div class=\"field-type-icon\" data-wp-watch=\"callbacks.watchFieldTypeIcon\"><\/div>\n\t\t\t\t\t\t\t<div class=\"field-name\" data-wp-text=\"context.submission.label\" data-wp-bind--hidden=\"!context.submission.label\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-value\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.showPlainValue\"><\/div>\n\t\t\t\t\t\t<a class=\"field-url\" data-wp-bind--href=\"context.submission.url\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.url\" target=\"_blank\" rel=\"noopener noreferrer\"><\/a>\n\t\t\t\t\t\t<div class=\"field-rating\" data-wp-bind--hidden=\"!context.submission.rating\" data-wp-watch=\"callbacks.watchRatingIcons\"><\/div>\n\t\t\t\t\t\t<div class=\"field-images\" data-wp-bind--hidden=\"!context.submission.images\">\n\t\t\t\t\t\t\t<template data-wp-each--image=\"context.submission.images\">\n\t\t\t\t\t\t\t\t<div class=\"field-image-option\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t<figure class=\"field-image-option__image\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t\t<img data-wp-bind--src=\"context.image.src\" data-wp-bind--hidden=\"!context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAAD\/ACwAAAAAAQABAAACADs=\" data-wp-bind--hidden=\"context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<div class=\"field-image-option__label-wrapper\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label-code\" data-wp-text=\"context.image.letterCode\"><\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label\" data-wp-text=\"context.image.label\" data-wp-bind--hidden=\"!context.image.label\"><\/span>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-files\" data-wp-bind--hidden=\"!context.submission.files\">\n\t\t\t\t\t\t\t<template data-wp-each--file=\"context.submission.files\">\n\t\t\t\t\t\t\t\t<div class=\"field-file\">\n\t\t\t\t\t\t\t\t\t<div class=\"field-file__thumbnail\" data-wp-style--background-image=\"context.file.previewUrl\" data-wp-style--mask-image=\"context.file.iconUrl\" data-wp-bind--hidden=\"!context.file.hasPreview\"><\/div>\n\t\t\t\t\t\t\t\t\t<svg class=\"field-file__icon\" data-wp-bind--hidden=\"context.file.hasPreview\" width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t<path d=\"M14 2H6C4.9 2 4 2.9 4 4V20C4 21.1 4.89 22 5.99 22H18C19.1 22 20 21.1 20 20V8L14 2ZM18 20H6V4H13V9H18V20Z\" fill=\"currentColor\"\/>\n\t\t\t\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__name\" data-wp-text=\"context.file.name\"><\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__size\" data-wp-text=\"context.file.size\"><\/span>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/template><\/div><form action='https:\/\/powertuning.com.br\/blog\/tuning-para-dbas-e-devs-com-casos-reais-da-sua-empresa\/'\n\t\t\t\tid='jp-form-8e6b4990479005e16b565dec1850635e5a876abe'\n\t\t\t\tmethod='post'\n\t\t\t\tclass='contact-form commentsblock jetpack-contact-form__form has-no-jetpack-form-layout' aria-label=\"Tuning para DBAs e Devs com casos reais da sua Empresa\"\n\t\t\t\tdata-wp-on--submit=\"actions.onFormSubmit\"\n\t\t\t\tdata-wp-on--reset=\"actions.onFormReset\"\n\t\t\t\tdata-wp-class--submission-success=\"context.submissionSuccess\"\n\t\t\t\tdata-wp-class--is-first-step=\"state.isFirstStep\"\n\t\t\t\tdata-wp-class--is-last-step=\"state.isLastStep\"\n\t\t\t\tdata-wp-class--is-ajax-form=\"context.useAjax\"\n\t\t\t\tnovalidate >\n<input type='hidden' name='jetpack_contact_form_jwt' value='eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbmNyeXB0ZWRfYXR0cmlidXRlcyI6InF4Qlp3QTZ5L0VpdG9SMmN2WGk4b3ZpcjBxa3VPVXF6ck1JWkxxdVdhR2tzL0w2VHlvdGFIOUdIdkd1Q3lDYUdHOTRQZlZoRGxrTmZ6MmxVZWNlNWFQRnM3Z0Vsam5GdnNIV1ZScXRheTE4N1RTNnErSFBGUnVSc1Z3bERjb0JCN2RrQjhJTG91RHVrYS9aZ09OMVEvd2d6aWU5MkJQN2lwaDVwc3FHeWN1UTMwekxvRWxYV1poOWJvZTFlN1NLWFBNS3RqS09rTVhpSkttVXp2eDFSeFc4YTlwRzdnVHF5dmIrQWR6aTFHUGtXUWRZbVhCcmVDbExLMHd0RXdMZmRYYy8vZ1J6UXJtQk5WMmZLQ3JNNTd2TE1ONUJVYnovbU5TaVNvMGcybm9obXhQcHMyWEtRa09LVndRS2dzMitDVER4WUtBUGZzQStiUk8vbkV4dWh1SFZGbzlZa0hRVWYyeGk5U2RHa2pLSzRGbml2Vkhac0toMDdiVXM2MS8rTHU0V3I5eW1oUkM5eEs0eHF6enJLT2FQam9iRkw2R0NMdlhOcFlVNWxTTHp6dGNINUJqN0poMUxrVkxzN3JSeGhWY0VzWG1hQ09uV3ZjdTBxbmFYaWQ0U0sydy9RMmc1bHc2YUxqQXFFZWgvOGFHV3Jja2hDRmRLSTlvVmJRVkE1M1BiVVJNZThVKzFRWW1oSVppb0wzN3IrYjJiemhQOU5EdGZ2YkUyWVNOWjY1VFN2UlU4TkhEcDNMNHZGSUpMc0FHcmtVVkdjYXNYanViOE5wS3lZeVRPRlRoaDAvTzMzdllKZkFuQ0htYXZkVGlKYlBNZUttUWRHTWVQcDlld0hxeElVNnArZU82V2Nkb29oWG8vNUs1NlBwNFUrTFNneG0xNllycW9ydDJndjY0S2FpV3lVaVFCTDlzVXpKZnNDME15S2hNOG1SUGJJa0h6Y084UEhIemRxRGlRalg4UG9KQnJJd2VYVld6L045bTBqdHY0N1VVaklpS3F2NUZTdlBMV3d4TXEvSHBzU3dkRWdnNXZNbk50anlCRVF1RGRPWEVweUhHMnRKam5iWmpLcG9NOFFuZkNnTkozb2ZZcTBJclNxTFNtd252Rm5UNjIzd1BzUGdXNzRXMGg0MElKOExMVjVVSmJrUlRwcHBXaS9SSGwzN0x5YUxOaGRYY1FBRHZBRXlIZURzcktZcW4zS1ZVbnpKakgzbm40U2lmNGxiNXVpRWFsTEVYWVh0MGQ3bVNUbEJrTVE2b214ZjJGNy9kUmFqNDRoU0U2VXdqYy9FVWtyZW1qU1RRNkI2U0g5TUg4ekEzUkwwdz09IiwiY29udGVudCI6Iltjb250YWN0LWZpZWxkIGxhYmVsPSdOb21lJyB0eXBlPSduYW1lJyByZXF1aXJlZD0nMScvXVtjb250YWN0LWZpZWxkIGxhYmVsPSdFbWFpbCcgdHlwZT0nZW1haWwnIHJlcXVpcmVkPScxJy9dW2NvbnRhY3QtZmllbGQgbGFiZWw9J1NpdGUnIHR5cGU9J3VybCcvXVtjb250YWN0LWZpZWxkIGxhYmVsPSdTa3lwZScgdHlwZT0ndGV4dCcvXVtjb250YWN0LWZpZWxkIGxhYmVsPSdUZWxlZm9uZScgdHlwZT0ndGV4dCcvXVtjb250YWN0LWZpZWxkIGxhYmVsPSdDb21lbnRcdTAwZTFyaW8nIHR5cGU9J3RleHRhcmVhJyByZXF1aXJlZD0nMScvXSIsImhhc2giOiI4ZTZiNDk5MDQ3OTAwNWUxNmI1NjVkZWMxODUwNjM1ZTVhODc2YWJlIiwic291cmNlIjp7ImVudHJ5X3RpdGxlIjoiVHVuaW5nIHBhcmEgREJBcyBlIERldnMgY29tIGNhc29zIHJlYWlzIGRhIHN1YSBFbXByZXNhIiwiZW50cnlfcGFnZSI6MSwic291cmNlX2lkIjoyODksInNvdXJjZV90eXBlIjoic2luZ2xlIiwicmVxdWVzdF91cmwiOiJodHRwczovL3Bvd2VydHVuaW5nLmNvbS5ici9ibG9nL3dwLWpzb24vd3AvdjIvcGFnZXMvMjg5In0sInZlcnNpb24iOjIsImNpcGhlciI6ImFlcy0yNTYtZ2NtIn0.PtYt3tH5t4GWbX3CRWci1jnk0UGl_cwTDOml8wHsKaU' \/>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-nome\",\"fieldType\":\"name\",\"fieldLabel\":\"Nome\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-name-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g289-nome' class=\"grunion-field-label name\" >Nome<span class=\"grunion-label-required\" aria-hidden=\"true\">(obrigat\u00f3rio)<\/span><\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g289-nome'\n\t\t\t\t\tid='g289-nome'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g289-nome-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='name  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g289-nome-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-nome-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-email\",\"fieldType\":\"email\",\"fieldLabel\":\"Email\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-email-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g289-email' class=\"grunion-field-label email\" >Email<span class=\"grunion-label-required\" aria-hidden=\"true\">(obrigat\u00f3rio)<\/span><\/label>\n<input\n\t\t\t\t\ttype='email'\n\t\t\t\t\tname='g289-email'\n\t\t\t\t\tid='g289-email'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g289-email-email-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='email  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g289-email-email-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-email-email-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-site\",\"fieldType\":\"url\",\"fieldLabel\":\"Site\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-url-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g289-site' class=\"grunion-field-label url\" >Site<\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g289-site'\n\t\t\t\t\tid='g289-site'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g289-site-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='url  grunion-field' \n\t\t\t\t\t \/>\n \n\t\t\t<div id=\"g289-site-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-site-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-skype\",\"fieldType\":\"text\",\"fieldLabel\":\"Skype\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-text-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g289-skype' class=\"grunion-field-label text\" >Skype<\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g289-skype'\n\t\t\t\t\tid='g289-skype'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g289-skype-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='text  grunion-field' \n\t\t\t\t\t \/>\n \n\t\t\t<div id=\"g289-skype-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-skype-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-telefone\",\"fieldType\":\"text\",\"fieldLabel\":\"Telefone\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-text-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g289-telefone' class=\"grunion-field-label text\" >Telefone<\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g289-telefone'\n\t\t\t\t\tid='g289-telefone'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g289-telefone-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='text  grunion-field' \n\t\t\t\t\t \/>\n \n\t\t\t<div id=\"g289-telefone-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-telefone-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g289-comentrio\",\"fieldType\":\"textarea\",\"fieldLabel\":\"Coment\\u00e1rio\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"8e6b4990479005e16b565dec1850635e5a876abe\"}'  class='grunion-field-textarea-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='contact-form-comment-g289-comentrio' class=\"grunion-field-label textarea\" >Coment\u00e1rio<span class=\"grunion-label-required\" aria-hidden=\"true\">(obrigat\u00f3rio)<\/span><\/label>\n<textarea\n\t\t                style=''\n\t\t                name='g289-comentrio'\n\t\t                id='contact-form-comment-g289-comentrio'\n\t\t                rows='20'\n\t\t\t\t\t\tdata-wp-text='state.getFieldValue'\n\t\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\t\t\t\t\t\taria-describedby='g289-comentrio-textarea-error-message'\n\t\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\t\tclass='textarea  grunion-field'  required aria-required='true'><\/textarea>\n \n\t\t\t<div id=\"g289-comentrio-textarea-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g289-comentrio-textarea-error-message\"><\/span>\n\t\t\t<\/div>\n\t<\/div>\n\t<p class='contact-submit'>\n<div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showFormErrors\"><span class=\"contact-form__warning-icon\" aria-hidden=\"true\"><i><\/i><\/span><span class=\"contact-form__error-message\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnValidationError\" data-wp-text=\"state.getFormErrorMessage\"><\/span><ul aria-label=\"Erros de formul\u00e1rio\">\n\t\t\t\t<template data-wp-each=\"state.getErrorList\" data-wp-key=\"context.item.id\">\n\t\t\t\t\t<li><a data-wp-bind--href=\"context.item.anchor\" data-wp-on--click=\"actions.scrollIntoView\" data-wp-text=\"context.item.label\"><\/a><\/li>\n\t\t\t\t<\/template>\n\t\t\t\t<\/ul><\/div><div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showSubmissionError\" data-wp-text=\"context.submissionError\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnSubmissionError\"><\/div>\t\t<button type='submit' class='pushbutton-wide'>Enviar mensagem de contato<\/button>\t\t<input type='hidden' name='contact-form-id' value='289' \/>\n\t\t<input type='hidden' name='action' value='grunion-contact-form' \/>\n\t\t<input type='hidden' name='contact-form-hash' value='8e6b4990479005e16b565dec1850635e5a876abe' \/>\n\t<\/p>\n<p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"ak_\"><label>&#916;<textarea name=\"ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"ak_js\" value=\"63\"\/><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\ndocument.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );\n\/* ]]> *\/\n<\/script>\n<\/p><\/form>\n<\/div>\r\n\r\n\r\n<p><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>A diferen\u00e7a desse Treinamento para um gen\u00e9rico com exemplos fict\u00edcios \u00e9 que em cada item do Treinamento podemos olhar o ambiente Real do cliente e discutir melhorias que v\u00e3o ajudar na pr\u00e1tica essa empresa. Inclusive, se for poss\u00edvel, vamos olhar queries reais e fazer um Tuning AO VIVO em algumas consultas do cliente. Por enquanto,&hellip; <br \/> <a class=\"read-more\" href=\"https:\/\/powertuning.com.br\/blog\/tuning-para-dbas-e-devs-com-casos-reais-da-sua-empresa\/\">Leia mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"content-type":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-289","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":8,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/289\/revisions"}],"predecessor-version":[{"id":462,"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/pages\/289\/revisions\/462"}],"wp:attachment":[{"href":"https:\/\/powertuning.com.br\/blog\/wp-json\/wp\/v2\/media?parent=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}