Ignorar navegação principal
Eventbrite
Pesquisar eventos
Organizar um evento
Ajuda
Iniciar sessãoRegistar
Menu
Conteúdos da página
Este evento terminou.

Painel de Ações

out 17

SQL Server Query Optimizer by Fabiano Amorim

Por Tuga Association

Quando e onde

Data e hora

sexta, 17 de outubro de 2014, 09:00 – 17:00 WEST

Localização

Instituto de Engenharia do Porto Rua Dr. António Bernardino de Almeida, 431 4200-072 Porto Portugal

Mapa e direções

Como chegar lá

Política de reembolsos

Entre em contato com o organizador para solicitar um reembolso.

Descrição

Abstract

This full day training conference aims to empower the SQL Server professional with the ability to analyze execution plans, focusing on T-SQL query optimization, by understanding how the execution plan works, how it is created and how to influence the plan as a skeleton key to optimizing T-SQL code.

After presenting the Query Optimizer, we will explore how the execution plans are executed, analyzing the characteristics of key operators, with emphasis on performance.

If you want to dive into to the world of the Query Optimizer, this is the right workshop for you! We’ll have deep dive samples and hours of fun with advanced commands.


Contents

  • Module 01 – Introduction to optimization on SQL Server
    • The process of optimization: elements, formal process
    • Query Optimizer: how it works and how to analyze execution plans
  • Module 02 – Introduction to statistics
    • Understanding how statistics work and their importance
    • How to read an histogram
    • Samples and examples
  • Module 03 – Overview of Indexes
  • Module 04 – Key operators of the execution plans
    • Index Seek
    • Key Lookup and RID Lookup
    • Improving query’s with Sort
    • Understanding the Join algorithms: Merge, Loop and Hash Join

Attendee’s pre-requisites/profile

Good knowledge on T-SQL and experience working with SQL Server 2005+. This is not a beginner training, it is required to have previous experience with SQL Server.

Aimed at Developers and DBA’s looking to better understand how their decisions about the database design and development impact the overall performance of the solution and strive to use SQL Server database resources more efficiently.

Required/Suggested Materials and Software

Laptop with SQL Server 2014 Engine and SSMS installed (preferred SQL Server 2014 developer edition), if not possible to use 2014 developer, it can be 2012 or 2014 express edition.


About Fabiano

Fabiano is fascinated by the SQL Server Query Processor and the way it works to optimize queries, procedures and functions. He graduated as a Technical Processor from Colégio Bezerra de Menezes, SP- Brazil, and has worked for several years with SQL Server, focusing in creating Data Warehouses and optimizing T-SQL codes for many companies in Brazil and Argentina. Fabiano is a SQL Server MVP, MCP for SQL Server 2000, MCTS and MCITP Data Base Developer for SQL Server 2005 and 2008. He also is actively involved in SQL Server community though forums such as MSDN and TechNet Brazil, writes articles for Simple-Talk (https://www.simple-talk.com/author/fabiano-amorim/) and SQL Server Magazine Brazil, and he also presents online Webcasts and In-Person events for Microsoft Brazil. His blog is on http://blogfabiano.com and you can also follow him on twitter at @mcflyamorim.

Etiquetas

  • Eventos em Portugal
  • Eventos em Porto
  • Coisas para fazer em Santo Ildefonso
  • Aulas em Santo Ildefonso
  • Aulas de Ciência e Tecnologia em Santo Ildefonso
Evento finalizado

SQL Server Query Optimizer by Fabiano Amorim


Siga este organizador para se manter informado sobre os próximos eventos

Tuga Association

Criador do evento

Eventos que você pode gostar

  • Roadshow Amazon Web Services - Porto

    Roadshow Amazon Web Services - Porto
    Roadshow Amazon Web Services - Porto

    Qua, fev 15, 10:30
    Palácio da Bolsa • Porto
    Gratuito
  • [Open Day] Come visit our campus in Porto

    [Open Day] Come visit our campus in Porto
    [Open Day] Come visit our campus in Porto

    Qua, fev 15, 14:00
    Le Wagon Porto Coding Bootcamp • Matosinhos
    Gratuito
  • SEI'23 - Semana da Engenharia Informática

    SEI'23 - Semana da Engenharia Informática
    SEI'23 - Semana da Engenharia Informática

    Ter, fev 14, 21:00
    Universidade do Minho • Braga
    Gratuito
  • Frontend  Conference - "Frontend Festival Porto 2023"

    Frontend Conference - "Frontend Festival Porto 2023"
    Frontend Conference - "Frontend Festival Porto 2023"

    Sáb, abr 22, 09:00
    4050-430 • Porto
    45 € - 75 €
  • Tratar o cancro por tu - Braga

    Tratar o cancro por tu - Braga
    Tratar o cancro por tu - Braga

    Qui, fev 9, 18:30
    Auditório do Centro de Juventude de Braga • Braga
    Gratuito
  • PRODEI Symposium

    PRODEI Symposium
    PRODEI Symposium

    Qua, fev 8, 09:00
    Faculty of Engineering - University of Porto • Porto
    Gratuito
  • Tomorrow Needs You  - Dias do Emprego da Escola de Engenharia UMinho 2023

    Tomorrow Needs You - Dias do Emprego da Escola de Engenharia UMinho 2023
    Tomorrow Needs You - Dias do Emprego da Escola de Engenharia UMinho 2023

    Ter, fev 28, 09:00
    Universidade do Minho • Guimarães
    Gratuito
  • HPC ADMINTECH 2O23 · Oporto

    HPC ADMINTECH 2O23 · Oporto
    HPC ADMINTECH 2O23 · Oporto

    Qua, mai 31, 11:00
    TRYP Porto Expo Hotel • Matosinhos
    Gratuito
  • Virtual Speaking Masterclass Porto

    Virtual Speaking Masterclass Porto
    Virtual Speaking Masterclass Porto

    Sáb, fev 25, 18:30
    Porto • Porto
    Gratuito
  • Startups Mentorship Program

    Startups Mentorship Program
    Startups Mentorship Program

    Sáb, fev 11, 08:00
    Porto • Porto
    32,44 £ - 80,37 £

Navegação no website

Utilizar a Eventbrite

  • Como funciona
  • Quanto Custa

Planejar eventos

  • Inscrições Online
  • Musica
  • Cursos & Workshops

Procurar eventos

  • Pesquisar eventos: Porto
  • Obter a aplicação Eventbrite

Ligue-se a nós

  • Denunciar este evento
  • Centro de Ajuda
  • Termos
  • Privacidade
  • Acessibilidade
  • Diretrizes da comunidade
Eventbrite + Ticketfly

© 2023 Eventbrite