SQLSaturday #329 - Rio de Janeiro 2014
Event Date: 10/25/2014 00:00:00
Event Location:
- Rua Ibituruna, 108, Tijuca
- Rio de Janeiro, Brazil
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Buffer Pool Extension (BPE) - How it works?
Abstract: A new feature of SQL Server 2014, Buffer Pool Extension (BPE) promises improvement on OLTP workload like systems, taking advantage of fast persistent disks. On this session we will enter in some theoretical details regarding this new technology, as well as some demos.
Speaker(s):
- Murilo Miranda
Track and Room: Track 1 - N/A
Title: Carreira - Dicas para fazer um milhão com MSSQL
Abstract: Carreira com banco de dados SQL Server. Nesta sessão pretendo fugir um pouco do tecniqueis para bater um papo sobre o que esperar do mercado de SQL Server, e dar uma série de dicas que acho extremamente importantes pra todo profissional que deseja ter sucesso profissional (que é totalmente relativo). Também veremos algumas boas práticas para desenvolvedores e administradores de bancos de dados, bem como dicas em relação a temidas perguntas de entrevistas de emprego relacionadas a SQL Server.
Speaker(s):
- Fabiano Amorim
Track and Room: Track 3 - N/A
Title: In-Memory OLAP a.k.a ColumnStore Index
Abstract: Nessa sessão será abordado os seguintes tópicos: Introdução, Internals, Transactional Isolation, Clustered Vs Non-Clustered ColumnStore Index, Batch Mode, TempDB e Data Loading
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: Track 2 - N/A
Title: Minimizando o downtime de Migrações com o Database Mirroring
Abstract: Database Mirroring é uma das funcionalidades do SQL Server que lhe permite “espelhar” um ou mais bancos de dados entre instâncias SQL Server. Nesta sessão Nilton Pinheiro mostrará como ele utiliza o Database Mirroring para minimizar o downtime de migrações em ambientes SQL Server de alta criticidade.
Speaker(s):
- Nilton Pinheiro
Track and Room: Track 3 - N/A
Title: Durability 101
Abstract: In this session we will explain how and what features SQL Server has in place to ensure data durability, that is, how can this RDBMS ensure that no data is lost even in case of crash failure
We will cover, in a simple language, subjects like:
- Transaction Log
- Recovery Models
- Database Recover
- Delayed Durability
- Durability drawbacks
This session is targeted for people that are new to the SQL server world and want to understand the SQL server inner workings and by that ensure that they make the better choice for each scenario. More experienced user will also benefit from the teachings in this session when we’ll touch more advanced topics that will support their decisions to fine tune their servers
Speaker(s):
- Pedro Correia
Track and Room: Track 1 - N/A
Title: Melhores Práticas para Utilizar as Polices no SQL Server 2014
Abstract: Nessa palestra iremos abordar as melhores práticas de como utilizar as Polices no SQL Server 2014. Os conceitos básicos, os modos de execução, e o que monitorar.
Speaker(s):
- Sulamita Dantas
Track and Room: Track 4 - N/A
Title: Tudo que você precisa para um BI de ponta!
Abstract: Qualidade de dados, enriquecimento da informação, visualizações ricas e mobilidade. Veja como tudo isso faz diferença na construção do Business Intelligence corporativo.
Speaker(s):
- Erika Madeira
Track and Room: Track 3 - N/A
Title: Collecting and analyzing SQL Server performance da
Abstract: Are you familiar with SQL Server Dynamic Management Objects (DMOs)? Do you know what kind of data you can collect from them? Are you aware of the standard tools available to analyze data from them? In this session you will learn how to use some of the SQL Server Dynamic Management Objects to collect performance data. The session will have some demos on how to collect and analyze SQL Server Performance information with DMOs. By the end of the session you will know how to collect and analyze SQL Server performance data using data gathered with DMOs.
Speaker(s):
- Ignacio Salom Rangel
Track and Room: Track 1 - N/A
Title: Trocando o Profiler pelos Extended Events
Abstract: Você irá descobrir as vantagens do uso dos Extended Events sobre o Profiler e descobrirá como os extended events podem solucionar muitos problemas, tal como deadlocks
Speaker(s):
- Dennes Torres
Track and Room: Track 2 - N/A
Title: Database Administration Strategies
Abstract: It’s 3 AM and your pager beeps. Oh no!! The slowness is hitting me again!! There are so many things that we can do to minimise the possibility of a problem and make your lives easier as a DBA, mainly when we are oncall :) Organize the house, and making our bed everyday will assure that the DBA can relax and focus in other kind of work. On this session, we will talk about few basic strategies to avoid common problems that DBAs experience in their environments, such as choose the right storage layout, accomodate the database’s files properly and configure the TempDB.
Speaker(s):
- Murilo Miranda
Track and Room: Track 1 - N/A
Title: Melhorias na interface do Management Studio
Abstract: O Management Studio é a principal ferramenta utilizada por quem trabalha com o SQL Server. Apesar de possuir ótimos recursos, esta ferramenta ainda deixa a desejar em vários aspectos de usabilidade. Esta palestra mostrará diversas dicas, recomendações e sugestões de melhorias no Management Studio que podem facilitar o dia a dia de quem trabalha com o SQL Server ganhando tempo e aumentando a produtividade.
Speaker(s):
- Mauro Pichiliani
Track and Room: Track 4 - N/A
Title: Entendendo o Clusterlog
Abstract: Quando trabalhamos com projetos de missões críticas implementamos a solução de cluster e finalizamos o projeto e caso de troubleshooting nos sentimos limitados com o Event Viewer. Nesta sessão você conhecerá como “Debugar” o clusterlog, que é um excelente recurso e quando sabemos utilizá-lo nos poupa várias horas de troubleshooting durante a madrugada.
Speaker(s):
- Marcelo Fernandes
Track and Room: Track 2 - N/A
Title: Otimizando seus planos de execução com o SQL Server 2014 Cardinality Estimator
Abstract: O SQL Server 2014 apresenta a primeira grande reformulação do processo de estimativa de cardinalidade desde o SQL Server 7.0. A principal meta para a reformulação do estimador de cardinalidade é melhorar a precisão e a consistência do processo de estimativa de cardinalidade, afetando diretamente a qualidade dos planos de execução criados pelo otimizador de consultas do SQL Server. Esta apresentação fornecerá uma visão geral das principais alterações realizadas no estimador de cardinalidade.
Speaker(s):
- Vitor Fava
Track and Room: Track 4 - N/A
Title: Best Practices TempDB
Abstract: Teremos um overview desse database tão importante para o funcionamento do SQL Server.
° Iremos falar sobre boas práticas, bem como separação de seus arquivos em discos separados com relação aos demais bancos ° Contenção na alocação das páginas de dados ° Tipos de espera, PAGELATCH ou PAGEIOLATCH ? ° Trace Flags 1117 e 1118, devo sempre utilizar ? porque ? ° Mitos e verdades sobre Arquivos de dados X CPU ° Entendendo ALLOW_SNAPSHOT_ISOLATION
Cuide de sua Tempdb, ela é única.
Speaker(s):
- Lucas Souza
Track and Room: Track 2 - N/A
Title: Transaction Log - Entendendo as melhores práticas
Abstract: Entenda o funcionamento do Transaction Log para então perceber como é importante gerenciar o tamanho, além de aprender como lidar quando o TLog cresce mais do que deveria ou até mesmo fica cheio. Veja dicas de como ganhar performance significativamente e casos onde apenas gerenciando o TLog foi possível obter até 3x mais performance.
Speaker(s):
- Luiz Mercante
Track and Room: Track 3 - N/A
Title: Computação em Nuvem e SQL Azure
Abstract: Nesta seção irá aprender tudo sobre Computação em Nuvem, funcionalidades, vantagens, desvantagens, estruturas, arquiteturas, tipos de contrato. Após Cloud Computing abordaremos o SQL Azure, todas as características dele, configurações, segurança, funcionamento pelo SSMS e pelo browser.
Speaker(s):
- Ozimar Souza
Track and Room: Track 3 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Dennes Torres
Twitter: - Dennes
LinkedIn: Dennes Torres
Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/
Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.
Mauro Pichiliani
Contact: http://pichiliani.com.br
Mauro Pichilian é bacharel em Ciência da Computação, mestre e doutorando pelo ITA (Instituto Tecnológico de Aeronáutica) e MCP, MCDBA e MCTS. Trabalha há mais de 14 anos utilizando diversos bancos de dados SQL e NoSQL. É escritor da revista SQL Magazine, colunista de do iMasters e co-produtor do DatabaseCast, o podcast brasileiro sobre banco de dados.
Erika Madeira
Erika Madeira é graduada em Engenharia da Computação e atuou na área de tecnologia da informação por mais de 3 anos como Administradora de Bando de Dados (DBA). Atualmente, especialista do time de SQL Server da Microsoft, atua com foco na comunidade técnica. Mantêm o blog http://blogs.technet.com/b/sqlserverbrasil/ com artigos relacionados a banco de dados em toda sua abrangência.
Nilton Pinheiro
Twitter: - nilton_pinheiro
LinkedIn: Nilton Pinheiro
Contact: http://www.mcdbabrasil.com.br
Nilton has 18+ years of SQL Server experience and is the co-author of the book “SQL Server 2014: High Availability in Practice with AlwaysOn Failover Cluster Instances”. He worked as a SQL Server Specialist at Itaú Bank (Brazil) for 11 years working on design and coordination of large database infrastructure projects involving deployment and migration of mission-critical servers. Nilton worked at IBM for 4 years as a SQL Server SME and also at Microsoft as a Sr. Support Engineer in the Microsoft CSS SQL team. Speaker at events like SQLSaturday, TechEd, MS Tech Summit and others, he was Microsoft MVP for 11 years and holds SQL Server MCSA\MCSE certifications. Currently he is a Sr. Database Consultant at AGAP2 IT, working in Brussels.
Luiz Mercante
Luiz Mercante (@sqldicas) é analista sênior em um dos maiores Data Centers do Brasil, MCTS em Windows, MTA em Databases, MCITP em SQL Server, moderador no Fórum
Murilo Miranda
Twitter: - murilocmiranda
LinkedIn: Murilo Miranda
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
Sulamita Dantas
Twitter: - @suladantas
LinkedIn: Sulamita Dantas
Contact: http://www.sulamitadantas.com.br
Sulamita Dantas é formada em Ciência da Computação pelo Centro Universitário Unibh.
Possui experiência como DBA SQL Server, Analista Protheus e Analista BI.
Atualmente é MVP Data Plataform (Microsoft Most Valuable Professional),
Lider do Local Group SQL BH,
Co-Organizadora do Grupo Random Hacks
Conselheira Fiscal da ONG MTAC.
Apaixonada por Ciclismo!
Ignacio Salom Rangel
Twitter: - @iasalom
LinkedIn: Ignacio Salom Rangel
Contact: http://ignaciosalom.com/
Ignacio Salom is a Senior SQL Server DBA and the CEO of Cenlinea Online Education He has over 15 years of experience in IT and in 2006 he turned his focus to SQL Server. Ignacio holds MCITP Database Administrator certifications for SQL Server 2005 and SQL Server 2008. His online presence includes:
- Writing for Confio Software’s LogicalRead
- His blog
- The SQL Server Central forums
- MSDN forums
- Twitter(@iasalom)
Lucas Souza
Twitter: - https://twitter.com/LucasJ_DBA
LinkedIn: Lucas Souza
Contact: http://www.lucasdba.com.br
Lucas Jos#233; dos Reis Souza, Formado em Sistemas da informa#231;#227;o pela universidade Anhembi Morumbi. Atua como Administrador de banco de dados na plataforma SQL Server há mais de 6 anos com #234;nfase em administra#231;#227;o e tunning. Lecionou treinamentos e Atuou em grandes empresas bem como, Santander, Saraiva e Grupo B2W com grandes projetos de implanta#231;#227;o, migra#231;#245;es de vers#245;es (2000 gt; 2008r2 / 2008r2 gt; 2012). Possui os t#237;tulos de MCTS, MCITP, MCSA e MCT em SQL Server 2008/2012.
Murilo Miranda
Twitter: - murilocmiranda
LinkedIn: Murilo Miranda
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Fabiano Amorim
Twitter: - mcflyamorim
LinkedIn: Fabiano Amorim
Contact: http:\blogfabiano.com
Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.
Vitor Fava
Twitter: - sqlservermaniacs
LinkedIn: Vitor Fava
Contact: https://www.vitorfava.com
I’m a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I’m a speaker at various technology events such as SQLSaturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I’m the Chapter Leader of SQLManiacs PASS chapter.
Ozimar Souza
Contact: http://ozimar.com.br
Graduado em Ci#234;ncia da Computa#231;#227;o, P#243;s gradua#231;#227;o em Business Intelligence, Trabalha com SQL Server desde 1998. Membro do grupo Microsoft MTAC.
Pedro Correia
Twitter: - pjcorreiasql
LinkedIn: Pedro Correia
Contact: http://sql.pt
Pedro Correia was born in 1976 on the 265th day of that year. He has been working with SQL Server for over 12 years, since the days of SQL Server 7.0, and his specialties are security and performance tuning. He is also a SQL Server trainer and teaching is one of his passions. 2012 was a year focused on the certification of competences and skills gained over the years, namely becoming one of the few Microsoft Certified Master - SQL Server 2008 (llt;100 worldwide).
Sponsors
The following is a list of sponsors that helped fund the event: