SQLSaturday #283 - Puerto Rico 2014

Event Date: 04/12/2014 00:00:00

Event Location:

  • Puerto Rico Convention Center
  • 100 Convention Boulevard
  • San Juan, , Puerto Rico

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).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: PowerPivot, Tabular and Multidimensional Models: Understanding Analysis Services Flavors

Abstract: The Unified Dimensional Modeling (UDM) concept was introduced in Analysis Services 2005 as the semantic layer to enable the OLAP cube development from multiple sources using an abstract layer. Analysis Services 2012 introduces the Business Intelligence Semantic Model (BISM) concept as an evolution to UDM, offering two new ‘flavors’: the Multidimensional Mode and the Tabular Mode. The BISM represents the heart of Microsoft Business Intelligence strategy for now and the upcoming years. This session will explain and clarify the basic concepts of Analysis Services 2012 and PowerPivot. We will also discuss different scenarios that will allow BI architects / developers take better decisions when building up the foundation for their companies’ Enterprise Analytics strategy.


  • Alan Koo

Track and Room: Track 1 - N/A

Title: Wish you could live the glamorous consulting life?

Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).

I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. Y


  • Juan Soto

Track and Room: Track 4 - N/A

Title: From Mess to Mastery: Managing Large Environments

Abstract: In an era of “do more with less,” IT staff are constantly being asked to manage environments without spending money. Worse yet, budgets are being cut for staff and tools.

IT veteran Mike Hillwig will show you how some of the integrated tools within SQL Server can help you manage your environment without spending a ton of money. We’ll look at the Central Management Server, Management Data Warehouse, Multi-Server Administration, and Policy Based Management. Mike will also show you his tips for building an Environment Inventory Database, a tool you can use to track your servers, instances, and login credentials.

By leveraging what you already have in SQL Server, you’ll certainly be able to do more with less.


  • Mike Hillwig

Track and Room: Track 2 - N/A

Title: Table Vars Temp Tables - What you NEED to Know!

Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”


  • Wayne Sheffield

Track and Room: Track 3 - N/A

Title: ETL Architecture Checkup: Avoiding Costly Mistakes

Abstract: In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.


  • Rafael Salas

Track and Room: Track 1 - N/A

Title: SQL Server 2014 In Memory Column Store Indexes - Haciendo un Almacén de Datos

Abstract: Las características “In Memory” es la tendencia más de perspectiva en el área de alto rendimiento. Los Índices de ColumnStore es uno de las tales características, y aún con sus limitaciones, pueden aceleran a veces sus consultas! ¿Cómo obtener más de esta característica? ¿En qué situaciones debemos usarlos? ¿Qué mecanismos internos ayudan a lograr eso? Usted puede obtener respuestas a estas y otras preguntas que se haya generado en algún momento en esta sesión.


  • Jose Gregorio Redondo Lopez

Track and Room: Track 2 - N/A

Title: Inside the Query Optimizer

Abstract: When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.


  • Bradley Ball

Track and Room: Track 2 - N/A

Title: Azure Virtual Machines: A Walk in the Cloud

Abstract: Now that Windows Azure virtual machines are generally available to the public, how does this offering affect you? In this session we’ll review this offering, walkthrough creating and deploying a virtual machine with SQL Server on it. We’ll also discuss how you can leverage this offering to your existing infrastructure!


  • Jorge Segarra

Track and Room: Track 1 - N/A

Title: Introduction to SSIS with BIML

Abstract: Do you ever find yourself repeating the same steps over and over while developing ETL packages? BIML is an XML markup language that automates your BI patterns and reduces the manual repetition that consumes most of your development time. In this session we will learn the basics of BIMLScript and show you the benefits of creating and automating an SSIS framework.


  • Guillermo Caicedo Santiago

Track and Room: Track 4 - N/A

Title: Windowing Functions in SQL Server 2012

Abstract: SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.


  • Wayne Sheffield

Track and Room: Track 4 - N/A

Title: Powershell Working with Windows Azure SQL Database Server

Abstract: In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)


  • Maximo Trinidad

Track and Room: Track 3 - N/A

Title: Tablas Particionadas: De la A a la Z

Abstract: En esta sesión discutiremos las estrategias de uso para las tablas particionadas, su impacto y cómo implementarlas, ventajas y desventajas, y como se trabaja con el mantenimiento de las ventanas corredizas. Además, compararemos las mejoras que ha tenido esta funcionalidad desde SQL Server 2008 hasta SQL Server 2014. Al final de esta sesión, tendrás toda la información necesaria para poder tomar ventaja de esta funcionalidad en tu ambiente de trabajo.


  • Jose L. Rivera

Track and Room: Track 3 - N/A

Title: Creating Reporting Services Reports to be Run in SQL Server Management Studio

Abstract: (Spanish). This session will explain and demonstrate how to create SQL Server Reporting Services to be run inside SQL Server Management Studio as custom reports. This will allow you to see SQL instance or database information that normally will require special T-SQL commands or purchasing third party products. Basic knowledge on Reporting Services and T-SQL are required.


  • Jorge Sanchez

Track and Room: Track 2 - N/A

Title: SQL Server - En juego o 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 .


  • Carlos L Chacon

Track and Room: Track 3 - N/A

Title: Location Location Location Preparing and Presenting Geographic Data

Abstract: Most all databases have some kind of geographic data and geographic reporting requirements. This session focuses on how to prepare and validate your geographic data, provide latitude and longitude, implement the GEOGRAPHY SQL data type, and finally present your data using Power Map and SSRS. An overview of each step will be given as well as in depth real life examples.


  • David Dye

Track and Room: Track 1 - N/A

Title: Business Insight through Cloud Based Data Models

Abstract: It is common for power users and data scientists to start mocking up their analysis in Excel. As their reporting grows in sophistication, however, it is important to understand the options available to enable increasingly robust analytical capabilities without incurring high infrastructure costs during experimentation phases.

This session will explore promotion paths for PowerPivot models that mature to demand robust data transformations, as well as cleansing and master data procedures. You will learn the pros and cons of using cloud-based PowerPivot environments, as well as the recommended architectures for model growth.


  • Javier Guillen

Track and Room: Track 1 - N/A

Title: PowerPivot + Powerview + PowerMap = Self-service BI Revolution

Abstract: Microsoft introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot, PowerView and PowerMap are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves right form Excel 2013. In this session you will also understand what is the role of IT in this new self-service paradox.


  • Jose Chinchilla

Track and Room: Track 2 - N/A

Title: Como lograr tu certificación de SQL Server 2012

Abstract: En esta sesión se ofrecerá un resumen del fenómeno de las certificaciones en la industria de las bases de datos SQL Server, los cursos de entrenamiento del fabricante, beneficios y ventajas de las certificaciones y el RoadMap de certificación para SQL Server 2012.


  • Rogger Rodriguez

Track and Room: Track 4 - N/A

Title: Understanding Power BI by Example

Abstract: In this session you will learn through a demonstration what is Power BI. We will show how all of the technologies included in this new offering can help customers quickly build end-to-end self-service analytic solutions leveraging the power of the cloud. The scenario we will be showcasing focuses on helping governments maximize their Open Data initiatives by providing government officials with the insight they need to make more informed decisions.


  • Ramon Ponte

Track and Room: Track 3 - N/A

Title: MsAccess and SQLServer in the Cloud Integration

Abstract: Users will be able to create a small access database, connect to the cloud and see their access working in the cloud.


  • Edwin Blancovitch

Track and Room: Track 4 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Alan Koo

Contact: http://www.alankoo.com

Alan Koo is a former Microsoft MVP with over 11 years of technical experience architecting and developing solutions oriented to increase businesses performance in both public and private sectors. Alan joined Nagnoi, Inc. in 2005 as the lead technical architect for the Performance Management Business Intelligence Practice and in 2007 became Nagnoi’s first Senior Consultant. Alan is the co-founder and current President of PRPASS and maintains his “Microsoft Business Intelligence y mas…” blog.

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

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

Contact: http://www.sqlballs.com

Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

Ramon Ponte

Ramon Ponte has over eighteen years of experience delivering enterprise architecture and advisory services to medium and large size organizations in Puerto Rico, the Caribbean and Central America. Industries of expertise include government, education, financial services, insurance, and the telecommunication sector. Ramon’s technical areas of expertise include development, system integration and business intelligence.

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.

Rogger Rodriguez

Ingeniero de Sistemas de la fundación Universitaria Politécnico Gran colombiano, con más de 20 años de experiencia, Técnico en Electrónica Digital Industrial del Centro Don Bosco, Técnico en Sistemas de la Universidad Abierta y a Distancia. Diplomando en Gerencia de Proyectos Educativos, Diplomando en Administradores de contenidos para plataformas Virtuales. Certificaciones: MCT, MCSE, MCSA ITIl, COBIT.

Javier Guillen

Twitter: - @javiguillen

LinkedIn: Javier Guillen

Contact: http://javierguillen.wordpress.com/

Javier Guillen is a Solutions Architect for BlueGranite.

An active blogger, speaker, and Microsoft community contributor, Javier has more than 10 years developing SQL Server solutions and is very interested in SQL Server Analysis Services and the practical application of MDX and DAX patterns.

Javier is also a Power BI Workshop instructor, delivering classes in private and public settings, an adjunct BI instructor for Central Piedmont Community College in Charlotte, NC and an adjunct lecturer for the City University of New York (CUNY) School of Professional Studies undergraduate and bridge graduate courses in Business Analytics. He is also the co-founder and co-organizer of the Charlotte Business Intelligence User Group (CBIG).

Jorge Segarra

Twitter: - @sqlchicken

LinkedIn: Jorge Segarra

Contact: http://sqlchicken.com

Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including “SQL 2008 Pro Policy-Based Management” and “SQL Server 2012 Bible” .

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

Contact: http://www.sqljoe.com

Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.

Juan Soto

Twitter: - jsoto22

LinkedIn: Juan Soto

Contact: https://accessexperts.com/blog/

I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.

Edwin Blancovitch

Contact: http://www.easypayroll.net

Graduated from the Interamerican University in PR, after working a few years administrating the largest food chain in the island and after looking at the needs of local business for software solutions, decided to create his own business Advanced Developers.Net www.advdev.net . After some year’s easy payroll is being used by some of the top 500 business in the island, with more than 500 users handles over than 100 million in payroll every year.

Jose Gregorio Redondo Lopez

Contact: http://redondoj.wordpress.com/

Consultor y Arquitecto de Sistemas de Información con 19 años de experiencia en SQL Server, Oracle, DB2, Informix y SyBase; así como en Access, FoxPro, DBase, 4D, Interbase, FileMaker entre otros. Ha aplicado sus conocimientos en diversas compañías de sectores como Gobierno, Petroleras, Cultura, Educación, Salud, Manufacturero, Ventas/Retail y Financieras; ejecutando proyectos en dichas áreas. Es miembro fundador de “SQL PASS Venezuela - Caracas Chapter” y es el Líder de dicho capítulo.

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.

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).


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

Back to the SQLSaturday Event List

Back to the home page