Event Location:
Microsoft Peru
San Isidro
Lima, Lima, Peru
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/percyreyes
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.
LinkedIn: https://www.linkedin.com/in/ggcayo/
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
LinkedIn: http://www.linkedin.com/in/argenis
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.
LinkedIn: https://pe.linkedin.com/in/kaiclemente
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.
LinkedIn: http://www.linkedin.com/in/argenis
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.
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