SQLSaturday #641 - Puerto Rico 2017
Event Date: 06/17/2017 00:00:00
Event Location:
- Engine 4 Coworking Space
- Complejo Onofre Carballeira Esq. PR-2 con Int. PR-5
- Bayamón, PR, Puerto Rico
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: Gestión de Backups y recuperación en bases de datos SQL Server
Abstract: Alguna vez ha tenido que recuperar una base de datos SQL Server, para restaurar una tabla? Le han solicitado archivos de backups encriptados para cumplir con estándares de seguridad? Los respaldos de SQL Server utilizan al máximo los recursos de hardware disponible? Durante esta sesión veremos cómo recuperar un objeto de la base de datos sin tener que recuperar la BD completa, vea cómo podemos recuperar registros modificados directamente de los archivos de log y conozca los nuevos algoritmos para realizar backups de SQL Server hasta con un 90% de compresión.
Speaker(s):
- German Ordonez
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Disaster Recovery, de dificil a muy facil.
Abstract: Contar con un “Disaster Recovery”, es una de las preocupaciones de muchos CIO, debido a la cantidad de diferentes sistemas, la complejidad de los mismos, el costo en dinero y operaciones de mantener un sitio alterno de recuperación, y no se hable de las pruebas, entre otras cosas más, hace que este sea un objetivo difícil de alcanzar. En esta sesión cubriremos las bases de “Site Recovery”, un muy poderoso servicio de Microsoft Azure, que nos permitirá implementar un “Disater Recovery”, para la mayoría de nuestras plataformas sean Windows o Linux, Hyper-V o VMWare.
Speaker(s):
- Isaias Martinez
Track and Room: Strategy and Architecture - Room 3
Title: Microsoft SQL Server Certification and Career Roadmap
Abstract: Microsoft is streamlining its expert-level technical certifications. The new Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Solutions Expert (MCSE) Data Management and Analytics Certification paths is aligning to industry-recognized areas of competence while providing flexibility to showcase your specific skills on Microsoft products and services.
Speaker(s):
- Kahlil Mendez
Track and Room: Other - Room 3
Title: Monitoreo y diagnostico de bases de datos SQL Server
Abstract: Conozca como las soluciones de Quest permiten monitorear un ambiente de bases de datos SQL Server, identificar problemas de espacio, identificar bloqueos en tiempo real, hacer diagnóstico histórico del comportamiento de la base de datos, generar alertas o notificaciones sobre los problemas en la base de datos, vea como rápidamente se puede hacer afinamiento a consultas SQL problemáticas, durante la sesión presentaremos los tips para identificar problemas en la base de datos y encontrar rápidamente las soluciones.
Speaker(s):
- German Ordonez
Track and Room: Enterprise Database Administration Deployment - Room 3
Title: Azure SQL Data Warehouse Loading Strategies
Abstract: Any data warehousing project has to include a data loading strategy during the development and operational phases. As the industry is moving to more modern and scalable alternatives in the cloud, it is important to understand what are our options and best practices to design the best strategy for our scenario. In this session we will go through some Polybase basics and various Azure SQL Data Warehouse loading best practices.
Speaker(s):
- Guillermo Caicedo Santiago
Track and Room: BI Platform Architecture, Development Administration - Room 2
Title: SQL Server on Linux
Abstract: The era of Windows only SQL Server is over. In this session, we will explore the capabilities that brings SQL Server 2017 on a Linux environment and its integration with the rest of the ecosystem.
Speaker(s):
- Jose L. Rivera
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Using Azure Machine Learning Power In Xamarin
Abstract: Microsoft, Google and even Apple are pushing the power of machine learning as the future of technology. This is the greatest moment of starting to make your application intelligent, predictive and using the power of machine learning. In this talk you will be able to use the power of Azure and combine it with Xamarin.
Speaker(s):
- Juan Martí
Track and Room: Software Development - Room 1
Title: Creating a Server Antivirus/Antimalware Definitions Update Scanning Status Report
Abstract: (In Spanish) Are you wonder how to know if your servers are up to date in their antivirus/antimalware? In this session I’ll explain and demonstrate how to create a custom solution for a server antivirus/antimalware definitions update scanning status report. The technologies used on the solution are: SQL Server (Database Reporting Services), Microsoft Endpoint Protection 2012, PowerShell Scripts (.ps1), Command files (.cmd), Windows Scheduled Tasks, and Active Directory Group Policy.
Speaker(s):
- Jorge Sanchez
Track and Room: Other - Room 3
Title: Better Together: Power BI, Office 365 and Azure
Abstract: Power BI when combined with Office 365 and Azure opens up many new enterprise wide and self service scenarios. Learn how you can leverage other tools, which integrate natively with Power BI, to enable actionable, collaborative and process driven BI.
Speaker(s):
- Ramon Ponte
Track and Room: Data Science - Room 1
Title: “The Statistical Sommelier”, A Practical Intro to R!
Abstract: In this session, attendees will learn basic data exploration using R, and will be able to run an entire prediction case using Linear Regression, to predict quality of wine based on a real life case, but also stressing the importance for Data Scientists in the interpretation of the results.
Speaker(s):
- Nestor Figueroa
Track and Room: Data Science - Room 2
Title: Introduction to Data Visualization with R: ggplot2 more
Abstract: ggplot2 is the most popular R package for data visualization. This incredibly versatile and powerful package allows you to create complex visualizations with simple code. In this session, we will cover the basics of ggplot2 and show you how to extend its capabilities with other packages. We will also provide some tips to consider when creating graphs.
Speaker(s):
- Orlando Mezquita
Track and Room: Data Science - Room 1
Title: SQL Server Machine Learning Services in a nutshell
Abstract: With the evolution of SQL Server R Services into Machine Learning Services in SQL Server 2017 expanding scalable R in-database analytics by adding scalable Python machine learning providing enterprise-scale data science within SQL Server’s database engine. In this session, we will demonstrate how to create, deploy and consume machine learning models within SQL Server 2017.
Speaker(s):
- Jose L. Rivera
Track and Room: Advanced Analytics - Room 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Jorge Sanchez
LinkedIn: Jorge Sanchez
Mr. Jorge S#225;nchez brings +27 years of experience in the IT industry, currently working for Rock Solid Technologies as IT Manager. Previously, Mr. Sanchez worked 8 years in Microsoft Puerto Rico as SQL Server Regional Specialist for Caribbean and Central America with direct focus in Puerto Rico, Costa Rica, Dominican Republic, and Trinidad. Before that, he worked 14 years as Senior Consultant, Developer, and SQL Server Certified Instructor within the Microsoft Partners Ecosystem.
Jose L. Rivera
Twitter: - SQLConqueror
LinkedIn: Jose L. Rivera
Contact: http://sqlconqueror.com
Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.
German Ordonez
Strategic Solutions Consultant – Latinoamerica y Caribe Ingeniero de Sistemas de la Universidad Nacional de Colombia, Especialista en Gerencia de Proyectos de la Universidad del Rosario, con mas de 14 anos de experiencia en Administracion de bases de datos Oracle. Consultor de las soluciones para bases de datos en desarrollo, administracion y alta disponibilidad dentro de Quest, gestor en la region de Latinoamerica de las iniciativas de mejoramiento para la familia de productos de TOAD en Oracle y SQL Server
Kahlil Mendez
LinkedIn: Kahlil Mendez
Contact: https://www.itg.online/
For the last 6 years, Kahlil Mendez has developed and managed “Interactive Technology Group”, a Microsoft Learning Partner in San Juan, Puerto Rico with an entrepreneurial and dynamic vision for IT professional development and Learning as a Service Solutions. His current objective is to improve the technical occupational skills challenges through innovative training services for a positive effect in the IT labor marketplace.
Juan Martí
Twitter: - @jmarti326
LinkedIn: Juan Martí
Contact: http://polybits.io
Passionate Software Developer in mobile and web technologies. Leader of the Google Developers Group Puerto Rico Chapter and collaborator of various other developers communities in the US and Puerto Rico.
Isaias Martinez
LinkedIn: Isaias Martinez
Contact: http://www.isaiasmartinez.com
Awarded as MVP C# for 7 consecutive years. Over 20 years of extensive experience in management, design and implementation of information technology projects aimed to automate processes to minimize time, save resources and improve operational efficiency. This to enhance the vision and mission of the organizations. The experience has been gathered in projects performed in various countries such as: Venezuela, Bolivia, Panama, Colombia, and Puerto Rico. In the last 6 years, I have specialized as Cloud Architect, leading the implementation of Microsoft Azure Solutions in Puerto Rico. My certifications include Microsoft MCP, MCSD, MCSE, MCT, MCDBA.#160;
German Ordonez
Strategic Solutions Consultant – Latinoamerica y Caribe Ingeniero de Sistemas de la Universidad Nacional de Colombia, Especialista en Gerencia de Proyectos de la Universidad del Rosario, con mas de 14 anos de experiencia en Administracion de bases de datos Oracle. Consultor de las soluciones para bases de datos en desarrollo, administracion y alta disponibilidad dentro de Quest, gestor en la region de Latinoamerica de las iniciativas de mejoramiento para la familia de productos de TOAD en Oracle y SQL Server
Jose L. Rivera
Twitter: - SQLConqueror
LinkedIn: Jose L. Rivera
Contact: http://sqlconqueror.com
Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.
Ramon Ponte
N/A
Nestor Figueroa
LinkedIn: Nestor Figueroa
Over 20 years of experience in management consulting to companies in Puerto Rico and Fortune 500 corporations in industries such as Healthcare, Insurance, Education, and Government. In 1995, he started his consulting career with international firm PricewaterhouseCoopers in New York. At PwC, Nestor led large implementations of Integrated Analytics and Data Warehousing. In 2002, Mr. Figueroa co-founded Nagnoi. Today, Nagnoi is a leading healthcare Big Data analytics software company with customers in PR and the US.
Nestor holds a Bachelor’s Degree in Industrial Engineering from Penn State University and MBA from the Massachusetts Institute of Technology (MIT) Sloan School of Management.
Orlando Mezquita
Twitter: - orlandomezquita
LinkedIn: Orlando Mezquita
Contact: http://www.MasterDataAnalysis.com
Orlando is principal consultant and trainer at Master Data Analysis. He is a passionate analytics professional who shares his knowledge through MasterDataAnalysis.com. Orlando provides analytics training and consulting services with Power BI, Excel, R, and Minitab.
Guillermo Caicedo Santiago
Twitter: - @sqltitan
LinkedIn: Guillermo Caicedo Santiago
Contact: http://www.sqltitan.com
Guillermo Caicedo es un profesional de bases de datos y tecnolog#237;a trabajando como Consultor en Nagnoi, LLC. Ha ayudado a numerosas empresas a obtener conocimiento sobre sus datos por desarrollar e implementar soluciones de inteligencia empresarial en sus organizaciones. El Sr. Caicedo tambi#233;n tiene una amplia experiencia desarrollando aplicaciones web y m#243;viles. Guillermo es un Data Platform MVP y l#237;der del Cap#237;tulo PASS para Puerto Rico (PRPASS).
Sponsors
The following is a list of sponsors that helped fund the event: