SQLSaturday #106 - Puerto Rico 2012
Event Date: 05/26/2012 00:00:00
Event Location:
- Puerto Rico Convention Center
- 100 Convention Boulevard
- San Juan, 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: Tasting the Flavors of Analysis Services 2012
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. Now, 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 2.0 and discuss different scenarios that will allow BI architects / developers to take better decisions when developing OLAP solutions with SSAS. (Spanish)
Speaker(s):
- Alan Koo
Track and Room: (02) - BI - N/A
Title: You got XML !!!
Abstract: The use of XML based content in SQL Server has become very popular over time. In this session, we will show you how to use the XML data type (FOR XML, Schemas, Namespaces), perform basic operations on XML data (XML DML), and discuss the performance consideration (storage, XML indexes) associated to these features.In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All
Speaker(s):
- Jose L. Rivera
Track and Room: (03) - AppDev - N/A
Title: Cleansing Your Data with Data Quality Services.
Abstract: SQL Server Data Quality Services (DQS) is a Knowledge-Driven Data Quality product aimed at the data stewards and IT professionals who seek to improve the quality of their business data. In this session, Ramon will describe the concept and main principles behind SQL Server 2012 Data Quality Services. The main capabilities of the product, such as knowledge management, cleansing, matching and profiling.In Spanish.
Speaker(s):
- Ramon Ponte
Track and Room: (02) - BI - N/A
Title: Basic Intro to PowerShell for the DBA
Abstract: Description:This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and testing PowerShell working with both SMO and SQLPS module to build SQL PowerShell scripts. This is not a language intro but it will get you started to learn PowerShell. Covering PowerShell V2/V3 and SQL Server tools.
Speaker(s):
- Maximo Trinidad
Track and Room: (01) - DBA - N/A
Title: Tips Tricks for dynamic SSRS Reports
Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create. Presented in English.
Speaker(s):
- Pam Shaw
Track and Room: (02) - BI - N/A
Title: SAN Basics for DBAs
Abstract: Curious as to what a LUN is? Or what RAID level you should use for you database files? This session will cover the basics of what a SAN is, how it works, and how to talk to your SAN Admins. We will also discuss various ways to configure SQL Server for optimal I/O. Presented in English.
Speaker(s):
- Joseph D’Antoni
Track and Room: (01) - DBA - N/A
Title: Managing Blobs and Geo-Location Data
Abstract: Working with “very large objects” (“Binary Large Objects”) including images, binary data, xml documents, or geo-location related data sets is a challenge. Once the object is registered then how you manage or query data within. What about performance? This session will present to you various issues related to managing large objects and strategies / code alternatives for its storage, retrieval and querying. Presented in Spanish.
Speaker(s):
- Eduardo Sobrino
Track and Room: (03) - AppDev - N/A
Title: Looney Tuner? No, there IS a method to my madness
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.This session will be presented in English.
Speaker(s):
- Janis Griffin
Track and Room: (03) - AppDev - N/A
Title: Power View Reporting Enhancements in SQL Server
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 PowerPivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create PowerView reports and an overview of the reporting enhancements in SQL Server 2012. Presented in Spanish.
Speaker(s):
- Guillermo Caicedo
Track and Room: (02) - BI - N/A
Title: SQL Server Performance Troubleshooting for the DBA
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
Track and Room: (01) - DBA - N/A
Title: PowerPivot for Excel: For Those Unacquainted …
Abstract: Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. (ENGLISH)
Speaker(s):
- William E Pearson III
Track and Room: (02) - BI - N/A
Title: PowerShell Query for the T-SQL Developer.
Abstract: This session will show the side-by-side similarity in building a PowerShell query vs T-SQL. I will demo some scripting techiniques in buidling a PowerShell query, building Hash table objects, ways to read and display the information. If the person knows how-to write T-SQL script, then it makes it easy to understand How-To write a PowerShell query. Presented in English.
Speaker(s):
- Maximo Trinidad
Track and Room: (03) - AppDev - N/A
Title: SQL 2012 – All About HA and DR
Abstract: Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don’t know where to start. In this presentation you’ll learn all about the new DR features in SQL Server 2012 and see them in practice. Presented in English.
Speaker(s):
- Joseph D’Antoni
Track and Room: (01) - DBA - N/A
Title: A Lap Around SQL Server Integration Services 2012
Abstract: This session will cover a featured enterprise-level extract, transform and load (ETL) tools like SSIS platform. Features and architecture of the new toolset of MSSSIS 2012 as we learn how you can be using SSIS for your projects. This session will be presented in Spanish.
Speaker(s):
- Maritza Córdova
Track and Room: (03) - AppDev - N/A
Title: HP Data Management Solutions.
Abstract: The HP and Microsoft global strategic alliance is one of the longest standing alliances of its kind in the industry; this session presents the solution portfolio for Database management and consolidation using the HP Converged Infrastructure portfolio and Microsoft technologies. Presented in Spanish.
Speaker(s):
- Gualberto Huerta
Track and Room: (01) - DBA - N/A
Speakers
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.
Maritza Córdova
Maritza Córdova is a Business Intelligence Consultant at Nagnoi, Inc. Maritza has 9 year of industry experience and more than 6 years working on Data Warehouse projects and Business Intelligence, including deep experience on Extraction, Transformation and Loading (ETL) components using SSIS, OLAP, Data Mining and Enterprise Reporting.
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.
Jose L. Rivera
Contact: http://www.jlrivmir.com
Jose Luis has over 9 years of experience developing Data Analytics, Data Warehousing and Business Intelligence solutions using SQL Server technologies, among others. In addition, he shares his knowledge and perspectives on database technologies as PRPASS Community Leader and college professor. He holds the MCTIP in Database Administration, Database Development and Business Intelligence for SQL Server 2008.
Ramon Ponte
Ramon Ponte 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. Industries of expertise include government, education, financial services, insurance, and the telecommunication sector. Ramon#39;s area of specialization is Enterprise Application Platforms. This includes SOA, BI, BPM, ALM, Data Management and Enterprise Architecture.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
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.
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.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Gualberto Huerta
Gualberto Huerta is a Regional Solution Architect in the servers organization at Hewlett-Packard (HP) based in Houston, Texas, a consultant expert on the HP Business Enterprise Solutions portfolio; these includes, Virtualization, HP Converged Infrastructure, and CloudSystem. Also he has published several technical white papers that solve customer problems using HP products and services and Microsoft technologies.
Eduardo Sobrino
Contact: esobrino.wordpress.com
Contributor for the Developers Community. Software Architect and Team-Leader for the past 20 years.
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.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
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
Sponsors
The following is a list of sponsors that helped fund the event: