SQLSaturday #896 - Puerto Rico 2019
Event Date: 10/12/2019 00:00:00
Event Location:
- Engine 4
- Complejo Onofre Carballeira Esq. PR-2 con Int. PR-5
- Bayamon, Bayamon, 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: Active Directory and Azure Active Directory: Authentication in a Cloudy World
Abstract: If you’re planning on deploying Office 365 or Azure, whether you know it or not, you will be using Azure Active Directory (AAD). But, you’ve already got on-prem Active Directory. How do these two products work together? Are they the same thing? SHOULD they work together? In this session I’ll answer these questions, compare and contrast AD and AAD usage in Azure and hybrid scenarios, discuss costs, and some best practices. This is a beginner session, but there will be some networking involved, in addition to “legacy” AD functionality and settings.
Speaker(s):
- Kerry Tyler
Track and Room: Cloud Application Development Deployment - Room2
Title: Azure Databricks: A Brief Introduction
Abstract: Designed in collaboration with Microsoft and the creators of Apache Spark, Azure Databricks combines the best of Databricks and Azure to help customers accelerate innovation with one-click set up. Get started at: https://databricks.com/product/azure.
Speaker(s):
- Philip Austin
Track and Room: BI Platform Architecture, Development Administration - Room 1
Title: Introduction To Data Governance
Abstract: Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.
Speaker(s):
- Warren Sifre
Track and Room: Other - Room 1
Title: Typescript and beyond…
Abstract: Session about what is Typescript, the benefits of writing code in Typescript, why is so important and a small demo of a Typescript app in Azure cloud services
Speaker(s):
- Edwin Martinez
Track and Room: Application Database Development - Room2
Title: Azure Machine Learning Overview
Abstract: Join us for a session that will give you a thorough overview of what machine learning tools are available in Azure, and how to get started on your first machine learning project regardless of your skill level.
Speaker(s):
- Guillermo Caicedo
Track and Room: Advanced Analysis Techniques - Room2
Title: How do you Azure?
Abstract: Most are talking about it, some have migrated to it and others are just overwhelmed. If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you.
Join me for a fun journey to learn the very basics of Azure. Some how-tos, some whys, and some demos.
This is a level 0 session, #N00b, #Imabeginner
Speaker(s):
- Tamera Clark
Track and Room: Cloud Application Development Deployment - Room 1
Title: What’s new in SQL Server 2019
Abstract: In this session we will have an overview of the top features that are included in the new SQL Server 2019.
Speaker(s):
- Jose L. Rivera
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: Data Integration at Scale with Azure Data Factory
Abstract: Azure Data Factory provides a “code free” visual interface to orchestrate data integrations at scale in the cloud. In this session we will deep dive on the newly added Mapping Data Flows capabilities which combines a visual designer with the full power of Spark to deliver a robust and hugely scalable data flow pipeline.
Speaker(s):
- Guillermo Caicedo
Track and Room: BI Information Delivery - Room 1
Title: Introduction to BI Architecture
Abstract: There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We will go over an ideal architecture design and explain the various elements and tools that make up this architecture. We will use the Microsoft BI Stack as a perspective, but architecture can be replicated with various vendor tools.
Speaker(s):
- Warren Sifre
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: Women in IT. A survival guide.
Abstract: How to stay relevant if a tsunami of technology changes? what are the tools needed to survive and thrive as a woman in IT?
Speaker(s):
- Gilda Alvarez
Track and Room: Professional Development - Room2
Title: Heredé una base de datos, y ahora que hago?
Abstract: Si estas o reciente mente has estado en esta situaci#243;n en la que has heredado la base de datos o simplemente cambiaste de trabajo, y llegaste cuando la base de datos ya estaba creada, y se te hace familiar la frase de “Y ahora que hago?”, en esta sencion te dare ciertos guias que te puede ayudar a comenzar a levantar el desempe#241;o de tu base de dfatos actual y verificar el estado de tus erstrategia de recuperaci#243;n de desastres.
Speaker(s):
- Kenneth Urena
Track and Room: Enterprise Database Administration Deployment - Room2
Title: 45 Minutes to Your First Tabular Model
Abstract: Have you been watching SSAS Tabular develop? What about the Azure Analysis Services product? Power BI’s data modeling? These technologies are all effectively the same, but live in different places and can serve different roles. Now’s the time to dive in and figure all of this out. In this session, we will talk about what Tabular is and what it does, in addition to the various “flavors” it comes in. We’ll explore development processes and will wind up with a model ready for ad-hoc querying through Excel or Power BI.
Speaker(s):
- Kerry Tyler
Track and Room: BI Platform Architecture, Development Administration - Room 1
Title: Data visualization tips for Power BI
Abstract: In this session we will cover multiple data visualization tips to create more interactive Power BI reports and dashboards. Some of the Power BI features we will cover are report pages tooltips, drillthrough filters, better use of bookmarks, SVG Measures, and many more.
Speaker(s):
- Orlando Mezquita
Track and Room: Analytics and Visualization - Room 1
Title: Introduction To Data Lakes
Abstract: What is a Data Lake and can I swim in it??? Can I truly emerse myself in data? How difficult is it to create a lake? When is a lake part of the data strategy? Can data lakes evaporate? These questions and more will be answered in the wake of this session.
Speaker(s):
- Warren Sifre
Track and Room: BI Platform Architecture, Development Administration - Room 1
Title: Chatbot, 0 to 100 with L.U.I.S.
Abstract: A chatbot is a next level on application response interactively, make more humans the use of an app, in this session we go to learn how to use LUIS to create an app with Natural Language.
Speaker(s):
- Isaias Martinez
Track and Room: Advanced Analysis Techniques - Room2
Title: Let’s make your apps, “smart” apps!
Abstract: Let’s make your apps, “smart” apps!
In a world were smartphones get “smarter” have higher bells and whistles; they no longer need just apps; they need “smart” apps. In this talk, I will teach you how to improve your app using the power of Azure, and it’s services.
Speaker(s):
- Juan Martí
Track and Room: Application Database Development - Room 1
Title: SQL Server 2019: Big Data Clusters
Abstract: In this session we will have an overview of one of the most interesting features of SQL Server 2019 called Big Data Clusters.
Speaker(s):
- Jose L. Rivera
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: SQL Server 2019: Estrategias de Indexación para alto desempeño
Abstract: Multiples estrategias de indexacion para obtener los mejores resultados sobre SQL Server, se coveran temas como:
- Noncluster Coverage
- Culstered Page Split
- Heaps
- Indices Filtrados
Speaker(s):
- Kenneth Urena
Track and Room: Application Database Development - 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.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
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.
Guillermo Caicedo
Twitter: - https://twitter.com/sqltitan
LinkedIn: Guillermo Caicedo
Contact: https://sqltitan.wordpress.com/
Guillermo currently works as an Azure Data AI Specialist @ Microsoft, former Data Platform MVP. He is an active member of the Puerto Rico PASS Chapter. Enjoys sharing his experiences by participating as a speaker in technical community events.
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.
Philip Austin
LinkedIn: Philip Austin
Philip Austin comes to Databricks as SLED Solution Director. Philip comes to us after an 8-year run at Teradata covering organizations of all size in the southeastern US. He is a seasoned data professional with respected leadership skills, proven hands-on technical expertise, and a demonstrated ability to understand and improve processes within an organization. Philip demonstrates and encourages that entrepreneurial creative spirit needed to grow the SLED business, improving service, and implement Databrick’s solutions.
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.
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;
Edwin Martinez
Twitter: - dev_ejmartinez
LinkedIn: Edwin Martinez
Hello, I’m Edwin. I’m a web developer with 4 years in the field. I live in Puerto Rico. Passionate in technology, I love to explore new techniques and tools to make my work efficient as possible and with a lot of love.
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.
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.
Gilda Alvarez
Twitter: - @Latina_DBA
She graduated from the University of Central Florida with MIS and Computer science degrees. She has over a decade of experience in Enterprise Information Technology solutions for several Fortune 500 companies. In depth and applied knowledge of database administration with emphasis on high availability and disaster recovery solutions, security audits, database health checks, capacity planning, resource utilization analysis and enterprise database migrations. She is a big advocate of technical and leadership education in her community. She loves to spend time with her family, friends and dance Latin music.
Guillermo Caicedo
Twitter: - https://twitter.com/sqltitan
LinkedIn: Guillermo Caicedo
Contact: https://sqltitan.wordpress.com/
Guillermo currently works as an Azure Data AI Specialist @ Microsoft, former Data Platform MVP. He is an active member of the Puerto Rico PASS Chapter. Enjoys sharing his experiences by participating as a speaker in technical community events.
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.
Sponsors
The following is a list of sponsors that helped fund the event: