SQLSaturday #189 - Costa Rica 2013

Event Date: 04/13/2013 00:00:00

Event Location:

  • Hotel Holiday Inn San Jose Downtown
  • Calle 5
  • San Jose, , Costa Rica

PDF of Schedule

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: Master Data Services

Abstract: Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate.

In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Speaker(s):

  • Jeff Prom

Track and Room: Track 2 - N/A


Title: Building a Windows 8 app from scratch (English)

Abstract: See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including:

  • A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls.

  • A user experience that scale

Speaker(s):

  • Russell Fustino

Track and Room: Track 4 - N/A


Title: OLTP, OLAP, las Lenguas y paradigmas en BIDS

Abstract: Con BIDS somos capaces de responder a preguntas en dos mundos contradictorios el OLTP (Procesos de Transacciones en Líneas) y el OLAP (Procesos de Análisis en Líneas) con el fin de responder a las interrogantes en estas dos configuraciones de OLAP y OLTP, BIDS incluyese tres servicios SSIS, SSRS y SSAS y una variedad de lenguajes como SQL, T-SQL, MDX, DMX, etc. Es prácticamente imposible explicar cada aspecto de cada una de las herramientas que forman parte de BIDS (Data base Tools) en una presentacion. Así que en esta presentación intentamos explicar la esencia de estos tres servicios y de las lenguas usadas en BIDS desde la perspectiva de los problemas que están tratando de resolver

Speaker(s):

  • Frank Quintana

Track and Room: Track 2 - N/A


Title: *Las mejoras + importantes en Código de SQL 2012

Abstract: En esta sesión ejecutaremos algunas funciones nuevas de SQL de gran utilidad en el día a día que disminuyen líneas de código y aceleran el proceso de desarrollo.

Speaker(s):

  • Ricardo Estrada

Track and Room: Track 2 - N/A


Title: Data Quality Services

Abstract: As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.

Speaker(s):

  • Jeff Prom

Track and Room: Track 2 - N/A


Title: SQL Server–En juego or Fuera de juego?

Abstract: Esta presentación se concentra en los pasos que se puede tomar para determinar el buen funcionamiento del SQL Server y donde debe enfocarse para optimizarlo. Revisamos las herramientas y scripts que están disponibles sin costo en la comunidad SQL para que no tenga la necesidad de comprarlas . Se da más énfasis en los índices.

Speaker(s):

  • Carlos L Chacon

Track and Room: Track 4 - N/A


Title: Security in Contained Databases in SQL-Server 2012

Abstract: Easy Administration of Security with Contained Databases in SQL-Server 2012

Speaker(s):

  • Carlos Rojas Vargas

Track and Room: Track 4 - N/A


Title: Transaction Log Deep Dive

Abstract: Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.

Speaker(s):

  • Kevin Boles

Track and Room: Track 1 - N/A


Title: Dealing With Errors in SSIS 2012

Abstract: This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.

Speaker(s):

  • David Dye

Track and Room: Track 1 - N/A


Title: Modelos de BI Tabulares

Abstract: En sesión veremos las bases de datos tabulares en SQL Server 2012, se verán las herramientas para creación de cubos tabulares tales como SQL Server Data Tools, Analisis Services, PowerPivot y PowerView. Además de cuáles son los casos en los cuales es mejor utilizar el modelo Tabular

Speaker(s):

  • Eduardo Castro

Track and Room: Track 3 - N/A


Title: Whats New in T-SQL With SQL Server 2012

Abstract: This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.

Speaker(s):

  • David Dye

Track and Room: Track 1 - N/A


Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!

Speaker(s):

  • Kevin Boles

Track and Room: Track 1 - N/A


Title: SharePoint Access Services 2013 y SQL Server 2012

Abstract: En esta sesión veremos lo nuevo de SharePoint Access Services 2013 integrado con SQL Server 2012.

Speaker(s):

  • David Sánchez Aguilar

Track and Room: Track 3 - N/A


Title: Es TEMPDB, por qué es tan importante?

Abstract: TEMPDB es solo para datos temporales cierto o no? Se crea por defecto y se recrea cada vez que se reinicia SQL Server, entonces no debería ser importante, ESTO ES INCORRECTO. En esta sesión aprenderá sobre los aspectos internos de TEMPDB y por qué TEMPDB es importante. Se verán las mejores prácticas para configurar TEMPDB y cómo determina si hay centención. Si usted tiene sistemas en los cuales no se configurado TEMPDB entonces debe asistir a esta sesión.

Speaker(s):

  • Javier Loria

Track and Room: Track 1 - N/A


Title: BI en dipositivos moviles

Abstract: Todos quieren BI, todos decimos que sabemos entregar BI, pero ¿en medios móviles como lo estas entregando? Ven y aprende sobre como mostrar y como se ve tu BI en dispositivos móviles

Speaker(s):

  • Jesus Gil Velasco

Track and Room: Track 4 - N/A


Title: Creating a Custom SSIS 2012 Task

Abstract: Are you tired of copying and pasting .Net code into Script Tasks? In this presentation, Andy Leonard walks you through creating a custom SSIS task using Visual Studio. Learn how and why to build custom SSIS tasks. Discover tips and tricks for building custom tasks as Andy demonstrates common mistakes and pitfalls.

Speaker(s):

  • Andy Leonard

Track and Room: Track 1 - N/A


Title: Particionamiento y BD Parciales HA para VLDB

Abstract: Estrategia de Respaldos + Particionamiento + Arquitectura en SQL Server Enterprise Edition para obtener escenarios de alta disponibilidad en bases de datos Muy Grandes.

Speaker(s):

  • Kenneth Urena

Track and Room: Track 2 - N/A


Title: Mil maneras de morir

Abstract: ¿Cómo puedes matar a tu servidor? Malas prácticas Malas consultas Esta sesión te contará leyendas urbanas, historias reales e historias de terror No te pierdas esta oportunidad de saber ¿cómo puedes evitarlo?

Speaker(s):

  • Jesus Gil

Track and Room: Track 4 - N/A


Title: SQL Server 2012 - Data Mining

Abstract: En esta sesión se abarcarán los algoritmos y herramientas que brinda el SQL Server 2012 para la Minería de Datos.

Speaker(s):

  • César Oviedo

Track and Room: Track 3 - N/A


Title: Excel 2013 como herramienta de BI

Abstract: En esta charla se analizara el uso de excel 2013 como herramienta de analisis de infromacion. Se veran demos de powerpivot , power view y las nuevas carateristicas de accesos a cubos.

Speaker(s):

  • Juan Alvarado

Track and Room: Track 3 - N/A


Title: Data Visualization: PowerView

Abstract: La Inteligencia de Negocios es una de los áreas más importantes en las corporaciones ya que brinda soporte para la toma de decisiones, y es indispensable que los usuarios puedan sacar provecho de esta información. Power View permite la visualización rápida y fácil de sus datos, además que permite compartir y colaborar sus análisis estadísticos en un entorno familiar como lo es SharePoint y Excel.

Speaker(s):

  • César Oviedo

Track and Room: Track 3 - N/A


Title: SQL Azure para principiantes

Abstract: THis is a topci I would like to cver in order to show people who is beginning with SQl Azure what SQl Azure realy is, the power and benefits of this tool and most important in order to make people do not be afraid when they face SQl Azure

Speaker(s):

  • Salomon Henriquez

Track and Room: Track 4 - N/A


Title: Conociendo lo nuevo del Stack de BI de Microsoft

Abstract: En esta charla se analizara las diferentes opciones que Microsoft tiene para analisis de informacion y nuevas caracteristicas de SQL 2012 , Sharepoint 2013 y office 2013

Speaker(s):

  • Juan Alvarado

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.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

David Sánchez Aguilar

Twitter: - @davidsancheza

LinkedIn: David Sánchez Aguilar

Contact: http://davidsanchezaguilar.wordpress.com

David S#225;nchez Aguilar, especializado en Tecnolog#237;as Microsoft. Cuenta con el reconocimiento de Microsoft Most Valuable Professional y con varias certificaciones como MCP, MCTS, MCITP, MCSD, Microsoft Specialist y Microsoft Certified Trainer. Es graduado de la carrera de Ingenier#237;a en Sistemas Computacionales y actualmente cursa una Maestr#237;a en Administraci#243;n de Tecnolog#237;as de la Informaci#243;n. Cuenta con m#225;s de siete a#241;os de experiencia trabajando con diferentes plataformas Microsoft.

Kenneth Urena

Twitter: - @sqlcr

LinkedIn: Kenneth Urena

Contact: http://www.sqlcr.com

Kenneth Ureña is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016.

Kenneth has performed the role of Database Developer, Database Architect and Database Administrator, always relying on his disaster recovery and performance tuning skills.

He co-leads the Global Spanish Virtual chapter of PASS. PASS LatAm Regional Mentor, he speaks at multiple SQL Server events in both Spanish and English. Kenneth holds multiple SQL server certifications.

Ricardo Estrada

Twitter: - pricardo03@hotmail.com

Contact: http://SeHablaSQL

Soy Ricardo Estrada consultor y conferencista en temas relacionados con SQL, resido en Costa Rica, curioso por la tecnología y apasionado por las bases de datos y sistemas de BI, gusta de compartir conocimiento, buscar soluciones a problemas cotidianos y construir aplicaciones que faciliten las operaciones y decisiones a nivel empresarial, es orgullosamente speaker de los SQLSaturdays de Centroamérica desde el año 2014, además de participar como expositor en los Summit para España y Panamá. Mi primer contacto con SQL Server fue con la versión 2000 y no ha dejado de aprender trucos, metodologías, técnicas y estrategias nuevas… y desde entonces… las he compartido en diferentes posts, principalmente la página de fb: SeHablaSQL

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Juan Alvarado

Contact: http://www.youtube.com/juanbizzz

MVP SQL SERVER desde 2005, especialista en inteligencia de negocios en las areas de diseños de data marts, datawarehouse, SSAS, reporting services, powerpivot, excel , bases de datos tabulares y Sharepoint. Consultor en varias implementaciones de tecnologias de Microsoft, Oracle y SAP. Experto certificado en SQL SERVER, Project Server , Sharepoint. Certificado en tencologias de SAP y Oracle.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori

Juan Alvarado

Contact: http://www.youtube.com/juanbizzz

MVP SQL SERVER desde 2005, especialista en inteligencia de negocios en las areas de diseños de data marts, datawarehouse, SSAS, reporting services, powerpivot, excel , bases de datos tabulares y Sharepoint. Consultor en varias implementaciones de tecnologias de Microsoft, Oracle y SAP. Experto certificado en SQL SERVER, Project Server , Sharepoint. Certificado en tencologias de SAP y Oracle.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

Salomon Henriquez

Salomon Henriquez GSpeaker at comunidad AlejandriaSpeaking about Microsoft products like Azure, Windows Server, Exchange Server, SQL Server, Hyper V, Sharepoint Server and others. Currently performing at Microsoft as ARR engineer.

Jeff Prom

LinkedIn: Jeff Prom

Contact: http://jeffprom.com/

Jeff Prom is a Data and BI Developer with over 15 years experience. From a wide variety of industries, he has worked at corportations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect in Minnesota.

Russell Fustino

Contact: http://www.clubfarpoint.com/Forums/blogs/russells_blog/

Russ Fustino heads up Developer Evangelism at ComponentOne as a Senior Developer Evangelist. He is also a highly experienced Windows Phone 7 software developer with a passion for conveying relevant, current, and future software development technologies and tools through live seminars, teaching, and internet video productions. Russ has a new innovative blog and interview video series with influentials, about current technology, ComponentOne products and developer community called ‘Russ Cam’!

Jeff Prom

LinkedIn: Jeff Prom

Contact: http://jeffprom.com/

Jeff Prom is a Data and BI Developer with over 15 years experience. From a wide variety of industries, he has worked at corportations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect in Minnesota.

Eduardo Castro

Twitter: - edocastro

LinkedIn: Eduardo Castro

Contact: http://ecastrom.blogspot.com

Eduardo Castro, Microsoft Data Platform MVP and PASS Board of Advisor for LATAM, is well known LATAM SQL Server Expert and focuses on architecture, Business Intelligence and Data Analytics, Eduardo has an specialization and master degree in Data Analysis and Big Data. I have been speaker at PASS Summit delivering session about R and Data Science.

Eduardo Castro has presented in United States, Costa Rica, Colombia, Guatemala, Mexico, Panama, El Salvador and South Korea.

Jesus Gil Velasco

Twitter: - @jesus_gilv

Jesus Gil (Dr. Rudo SQL) es un experto en SQL con mas de 10 años de experiencia y un speaker habitual de los SQL-Saturday en Latinoamérica. Es el primer MVP de SQL Server para México, reconocimiento que ha ganado desde el año 2010. Es co-autor de la Guia Oficial de Microsoft Corp. para la Migración de SQL Server 2012 y es colaborador de revistas, tanto nacionales como internacionales. Para Microsoft México genero el contenido del diplomado técnico y de Negocios sobre BI con SQL2012.

Jesus Gil

Twitter: - @jesus_gilv

LinkedIn: Jesus Gil

Contact: https://jesusgilv.wordpress.com/

Jesus Gil is a professional working with SQL Server since 6.5 version to SQL Server 2017 I’m an Microsoft Data Platform MVP since 2010 and was coauthor of official WhitePapers: SQL Server 2014 Upgrade Technical Guide and SQL Server 2012 Upgrade Technical Guide Author several technical articles, course, workshops, etc.

Javier Loria

Contact: http://www.solidq.com/

Javier Loria es un experimentadoArquitecto de Software yArquitecto de Inteligencia de negocios, desarrollador líder con un historial de ingeniera de redes. Javier tiene más de 12 años de experiencia como Instructor Técnico, casi 20 años como desarrollador; 8 años como arquitecto de software y de inteligencia de negocios.

César Oviedo

Contact: http://businessintelligencelatam.com/

MCITP: Business Intelligence, Database Administrator, Database Developer. Arquitecto de Inteligencia de Negocios y Application Life Management. Administrador Comunidad Business Intelligence LATAM.

Carlos Rojas Vargas

Contact: http://sqlugcr.net

Carlos Rojas Vargas es Microsoft MVP en SQL-Server desde el año 2001 con 16 años consecutivos de obtener este reconocimiento, trabaja con SQL-Server desde el año 1995. A partir de 1999 se certifica como MCT y comienza a impartir Capacitación certificada Microsoft, actualmente trabaja como Consultor en SQL-Server, Windows Server, Virtualización con Hyper-V, Alta Disponibilidad y Soluciones de Colaboración con Sharepoint en Grupo CMA. En este momento cuenta con las certificaciones MCSA(SQL-Server 2012/2014), MCSA(SQL-Server 2008), MCITPro (Database Adm SQL-Server 2008), MCTS(Sharepoint 2010), MCTS(SQL-Server 2008), MCTS(Windows Server 2008 App Infrastructure), MTA, MCDBA, MCSD.NET, MCAD, MCSE, A+, N+. Fundador del Grupo de Usuarios de SQL CR.

César Oviedo

Contact: http://businessintelligencelatam.com/

MCITP: Business Intelligence, Database Administrator, Database Developer. Arquitecto de Inteligencia de Negocios y Application Life Management. Administrador Comunidad Business Intelligence LATAM.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page