Event Location:
Puerto Rico Convention Center
100 Convention Boulevard
San Juan, , Puerto Rico
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.
Speaker(s): Alan Koo,
Abstract:
El análisis predictivo es el área dentro de Inteligencia de Negocios que busca dar conocimiento más allá de lo que ya sucedió en el pasado de su empresa o data, o incluso de lo que está pasando ahora mismo. El análisis predictivo, busca proyección en el próximo paso para influir o tener más información de lo que podrá ocurrir en el futuro cercano basado en técnicas avanzadas de minería de datos, ya sea proyectar un valor futuro para nuestras ventas en una sucursal (forecasting) o saber cuál debe ser el próximo producto que nuestro cliente estaría interesado en poner en su carrito de compras como lo hace Amazon.com. Acompáñenme durante esta sesión para contarles cómo Analysis Services nos puede ayudar (a nosotros comunes mortales de SQL), a crear ventajas competitivas para tu empresa.
Speaker(s): Alan Koo,
Abstract:
In the session we are going to take on a challenging subject that all designers face: how to deal with changing dimensions. Unlike most OLTP systems, a major objective of a data warehouse is to track history. So, accounting for change is one of the analyst’s most important responsibilities. Ralph Kimball introduced the concept of slowly changing dimension (SCD) attributes in 1996. Dimensional modelers, in conjunction with the business’s data governance representatives, must specify the data warehouse’s response to operational attribute value changes. In this session we will also explain “type numbers” assigned to several techniques that have been described in the past.
Speaker(s): Andreina Rizo,
Abstract:
SQL Server DBA's face a lot of challenges now days, from maintaining servers to putting out fires. One of them is how to properly deal with Access databases in the workplace. Quite frequently they contain mission critical data and grown to be important to your business. Upsizing them to SQL Server is just the first step, you need to change Access's forms, reports, queries and code to avoid issues with your server. In this session we will discuss strategies; from importing data to optimizing the relationship between Access and SQL. Users will leave having a much better understanding of how to incorporate Access in the workplace and safeguard their data.
Speaker(s): Juan Soto,
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,
Abstract:
This is the era of data. The Business is demanding up to day information and insight in a timelier manner. We need a solution that could enable us to satisfy those needs and be as close as real time. This session will provide insight on how to use the Change Data Capture (CDC) inside SQL Server to load your Fact and Dimension tables that will accommodate those business needs. After this session you will be able to implement the concepts in your on environments to achieve the reporting and data requirements.
Speaker(s): Jose L. Rivera,
Abstract:
Today companies are looking for options related to the deployment of their database workloads. Some database servers may need to be installed on-premise because of regulatory or performance reasons. For other scenarios, it may make more sense to deploy these databases in virtual-machines hosted in the cloud. Finally, newer applications may be better suited for Platform as a Service (PaaS) architectures. Indistinctively of which deployment model makes sense for you, it is extremely important to have a consistent user experience when managing, monitoring and developing for these databases. Learn about how you start today to take advantage of SQL Server deployment options.
Speaker(s): Ramon Ponte,
Abstract:
This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication. Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
Speaker(s): Jeffrey Garbus,
Abstract:
In this session, led by Microsoft BI Architect, SQL Server MVP, and Analysis Services Maestro Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s): William E Pearson III,
Abstract:
Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. Attend this session and you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s): Eddie Wuerch,
Abstract:
SSRS 2008 and above provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many features, such as server aggregation, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
Speaker(s): William E Pearson III,
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s): Eddie Wuerch,
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker(s): Jeffrey Garbus,
Abstract:
With the release of SQL Server 2012 Microsoft introduced a bunch of new functionalities into their product, including a whole set of tools that can make your life a whole lot easier. In this session we will go through the different scenarios where the SSDTs can be used and help you develop and/or administer your databases in a whole new way and without the need of third party tools.
Speaker(s): Guillermo Caicedo Santiago,
Abstract:
(Presented in Spanish). This session will present performance troubleshooting tips for the Database Administrator (DBA). First, will explain Windows and SQL Server installation configuration best practices, followed by TSQL scripts to detect bottlenecks (CPU, RAM, I/O, Waits, Blocking, and others), TSQL recommendations on large databases, and finally SQL performance counters.
Speaker(s): Jorge Sanchez,
Abstract:
(Spanish) This presentation explains how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server high availability and disaster recovery solutions.
Speaker(s): Jorge Sanchez,
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,
Abstract:
TSQL window functions, originally introduced in SQL Server 2005, have proven to be quite useful to solve complex ranking and aggregation scenarios. The new additions in SQL Server 2012 make them irresistible. In this session, we will discuss how to use them and highlight the new order, offset and distributions functionalities in real-world examples.
Speaker(s): Jose L. Rivera,
Abstract:
XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn: 1. How to investigate XEvents objects using the DMV's 2. How to create an XEvents Session 3. How to transition an existing Trace to an XEvents Session. What you should know coming in: 1. Basic use of SSMS 2. Familiarity with Trace/Profiler
Speaker(s): Jack Corbett,
Abstract:
Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on Power Pivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create Power View reports and an overview of the reporting enhancements in the new version of SQL Server.
Speaker(s): Guillermo Caicedo Santiago,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
LinkedIn: http://www.linkedin.com/in/jackcorbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016. Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control. Jack has presented at many user groups and SQLSaturday even
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
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).
Contact: http://www.sqlbn.com
Jose L is a SQL Server MCITP and MCT with over 10 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. He currently works as Consultant at Nagnoi, Inc. as well as College professor at University of Phoenix. In addition, he shares his knowledge and perspectives as PRPASS Vice President and Community Leader, Co-Leader for the Azure and Global Spanish virtual chapters and frequent speaker at user groups and SQLSaturday events, among others.
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
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: https://www.linkedin.com/in/alankoo
Contact: http://www.alankoo.com
Alan Koo is a 6th time Microsoft MVP in SQL Server with over 15 years of technical experience architecting and developing solutions oriented to increase businesses performance in both public and private sectors. Alan joined Nagnoi, LLC. in 2005 as the technical lead in the Performance Management amp; Business Intelligence Practice. Alan Koo is the co-founder and former President of Puerto Rico PASS. He shares his knowledge through his quot;Microsoft Business Intelligence y mas...quot; blog and the the MSDN Forums.
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
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).
Contact: http://www.sqlbn.com
Jose L is a SQL Server MCITP and MCT with over 10 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. He currently works as Consultant at Nagnoi, Inc. as well as College professor at University of Phoenix. In addition, he shares his knowledge and perspectives as PRPASS Vice President and Community Leader, Co-Leader for the Azure and Global Spanish virtual chapters and frequent speaker at user groups and SQLSaturday events, among others.
Ramon has over 19 years of experience delivering enterprise architecture and advisory services to medium and large size organizations in Puerto Rico, the Caribbean and Central America. As part of his current role, one of Ramon’s main responsibilities consists on helping customers and partners understand Microsoft's data and integration platforms.
LinkedIn: https://www.linkedin.com/in/juansoto
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.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
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: https://www.linkedin.com/in/alankoo
Contact: http://www.alankoo.com
Alan Koo is a 6th time Microsoft MVP in SQL Server with over 15 years of technical experience architecting and developing solutions oriented to increase businesses performance in both public and private sectors. Alan joined Nagnoi, LLC. in 2005 as the technical lead in the Performance Management amp; Business Intelligence Practice. Alan Koo is the co-founder and former President of Puerto Rico PASS. He shares his knowledge through his quot;Microsoft Business Intelligence y mas...quot; blog and the the MSDN Forums.
Contact: http://www.nagnoi.com
Andreina, Senior Consultant at Nagnoi has over 15 years of experience in management and business intelligence consulting providing her services to companies in Venezuela, Puerto Rico and corporations in industries such as Healthcare, Insurance, Energy, Education, Telecommunications, Pharmaceuticals, Consumer Goods, Banking and Government. She holds a PMP certification and a Master’s Degree in Business Administration/Global.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
The following is a list of sponsors that helped fund the event.