SQLSaturday #351 - Lima 2014
Event Date: 12/06/2014 00:00:00
Event Location:
- Microsoft Peru
- San Isidro
- Lima, Lima, Peru
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: Secure Your SQL Server Instance Without Changing Any Code
Abstract: Secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks – all without touching a single line of code! In this session you will learn about Transparent Data Encryption, IPSec, Database Firewalls, Contained Databases and many other technologies that help you lock down your systems and close attack vectors. This talk puts great emphasis on the biggest threat to your database: SQL injection, offering many remediation techniques to prevent such attacks. During the demos, you will learn techniques to deal with vendors who require SA accounts to run their applications. Protect your SQL Servers without having to wait for your Developers or Vendors to make changes!
Speaker(s):
- Argenis Fernandez
Track and Room: Oficinas Microsoft Perú, Lima - N/A
Title: Making DBCC CHECKDB Go Faster
Abstract: Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times along with its performance impact to Production systems keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like DOP, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey’s consistency checks were taken from 9 days down to 6.5 hours.
Speaker(s):
- Argenis Fernandez
Track and Room: Oficinas Microsoft Perú, Lima - N/A
Title: Backup and Restore SQL Server 2014
Abstract: En esta sesion veremos las diferentes formas de poder generar Backup y Restore a Bases de Datos Transaccionales, y almacenarlas tanto en un disco como en un Storage de Windows Azure, programando tareas y creando planes de mantenimiento.
Speaker(s):
- German Cayo
Track and Room: Oficinas Microsoft Perú, Lima - N/A
Title: Rompiendo el hielo con Code First y SQL Server 2014
Abstract: Code First es un enfoque más de Entity Framework (hay otros dos enfoques que son Database First y Model First) que plantea lo siguiente: Tú crea clases POCO con tu lenguaje favorito (C#, VB.NET, etc.) y crea relaciones entre las mismas, después despreocúpate que ya veré yo como me las gasto para persistir tu modelo en una base de datos.
Speaker(s):
- Kai Clemente
Track and Room: Oficinas Microsoft Perú, Lima - N/A
Title: Rendimiento del In-Memory OLTP Engine en SQL Server 2014
Abstract: En esta sesión veremos cómo usar In-Memory OLTP, sus beneficios en rendimiento y cómo sacarle máximo provecho. También veremos los escenarios de usos.
Speaker(s):
- Percy Reyes
Track and Room: Oficinas Microsoft Perú, Lima - N/A
Title: Practicas más dañinas en T-SQL
Abstract: En esta sesión mostraremos algunas de las prácticas comunes mas dañinas que se pueden hacer en T-SQL y que pueden convertirse en cuellos de botella afectando el rendimiento, retornando resultados incorrectos o generando efectos secundarios impredecibles en tiempo de ejecución.
Speaker(s):
- Carlos Casaverde
Track and Room: Oficinas Microsoft Perú, Lima - 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.
Percy Reyes
Twitter: - @percyreyes
LinkedIn: Percy Reyes
Contact: http://percyreyes.com/
Microsoft SQL Server MVP, Certified Sr. Database Administrator, Author at http://MSSQLTips.com | SQL PASS Peru Chapter Leader | MCITP DBA/Dev, MCTS, MCP. Bachelor in Systems Engineering and Senior Database Administrator focused on Microsoft SQL Server Internals with over 12+ years of extensive experience managing database servers. I am a frequent Speaker about SQL Server technologies for over 10 years at Local User Group Meetings, Webcasts, and National Conferences.
German Cayo
Twitter: - @ggcayo
LinkedIn: German Cayo
Contact: https://germancayom.wordpress.com/
Actualmente líder del Capítulo Pass SQL User Group Ica.Profesional, con experiencia en Infraestructura Windows, base de datos SQL Server, orientado a la implementacion de Inteligencia de Negocios. Colaborar a fin de Brindar soluciones en Infraestructura y Administracion de Base de Datos en TI, desarrollar soluciones de Inteligencia de Negocios a fin de mejorar la toma de decisiones de los diferentes niveles en la organizacion
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Kai Clemente
Twitter: - https://twitter.com/kaiclemente
LinkedIn: Kai Clemente
Contact: http://kaiclemente.wordpress.com
Consultor de sistemas con experiencia en las #225;reas de sistemas, capacitaci#243;n y docencia. S#243;lidos conocimientos en jefatura de proyectos, desarrollo de aplicaciones Windows, Web y sistemas distribuidos sobre tecnolog#237;as MICROSOFT.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Carlos Casaverde
MCSE, MCSA, MCITP, MCTS, MCP-Computer Systems Engineer,+8 years experience in Data Platform and Solutions with SQL Server. Deep experience Managing DB Servers, Upgrade, Data Migration and High Availability. Troubleshooting and Tuning. Experienced on Servers Infrastructure and Data Centers. I’ve worked in financial, construction, cement and concrete largest Peruvian companies. I’m Senior DBA in Verizon, the global leader company in Communications,IT solution,Information and Entertainment Services
Sponsors
The following is a list of sponsors that helped fund the event: