Event Location:
Engine 4 Coworking Space
Complejo Onofre Carballeira Esq. PR-2 con Int. PR-5
Bayamón, PR, Puerto Rico
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,
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,
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,
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,
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,
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,
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í,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/jorgesanchezpr
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.
LinkedIn: http://www.linkedin.com/profile/view?id=189422534
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 SQL Saturday 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.
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
LinkedIn: https://www.linkedin.com/in/interactivetechnologygroup/
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.
LinkedIn: https://pr.linkedin.com/in/juan-marti-31a64564
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.
LinkedIn: http://pr.linkedin.com/in/isaiasrma
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;
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
LinkedIn: http://www.linkedin.com/profile/view?id=189422534
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 SQL Saturday 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.
N/A
LinkedIn: https://www.linkedin.com/in/nestor-figueroa-326a33/
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.
LinkedIn: https://www.linkedin.com/in/orlandomezquita/
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.
LinkedIn: http://www.linkedin.com/in/gcaicedo/
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).
The following is a list of sponsors that helped fund the event.