SQLSaturday #106 - Puerto Rico 2012 5/26/2012 12:00:00 AM (GMT-04:00) Caracas, La Paz SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat106 Puerto Rico Convention Center 100 Convention Boulevard San Juan , Puerto Rico 00907 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 1742 Nagnoi, Inc Platinum Sponsor http://www.nagnoi.com http://www.sqlsaturday.com/files/a88323f6-d318-4f39-9d6c-7e24e29125e4.png 60 170 1889 Hewlett Packard Platinum Sponsor http://www.hp.com http://prpass.org.hostasp.us/wp-content/uploads/2012/02/hp-90.png 60 170 1932 Microsoft Puerto Rico Platinum Sponsor http://www.microsoft.com/es-pr/default.aspx http://i.microsoft.com/global/about/legal/en/us/PublishingImages/mslogo_black_2.gif 60 170 2071 KPG (Knowledge Power Group), Inc. Platinum Sponsor http://kpginc.net/ http://kpginc.net/wp-content/uploads/2012/03/LogoKPG_170x80.png 60 170 2230 Truenorth Corporation Platinum Sponsor http://www.truenorthcorporation.com http://truenorth.homedns.org/tn_website/images/tn_logo.jpg 60 170 2281 The Cervantes Group Gold Sponsor http://www.thecervantesgroup.com http://www.thecervantesgroup.com/images/logo%20_cervantes.JPG 60 170 1776 IAMCP Gold Sponsor http://www.iamcp.org http://prpass.org.hostasp.us/wp-content/uploads/2012/01/iamcp-logo.png 60 170 1985 INVID Silver Sponsor http://www.invidpr.com http://www.invidpr.com/pages/Portals/0/logo.png 60 170 1912 Fusionworks Silver Sponsor http://fwpr.com/ http://www.fwpr.com/images/NEWFWPRLogo.JPG 60 170 1743 Rock Solid Technologies, Inc. Silver Sponsor http://www.rocksolid.com http://prpass.org.hostasp.us/wp-content/uploads/2012/04/RockSolid_Logo.jpg 60 170 2229 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2311 Abarca Health Bronze Sponsor http://www.abarcahealth.com/ http://www.abarcahealth.com/Images/Logo.jpg 60 170 1981 Idera Bronze Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2251 Red Gate Swag Sponsor http://redg.at/IjVYva http://www.sqlsaturday.com/images/resized%20-%20redgate_logo.png 40 100 2264 SAPIEN Technologies, Inc. Swag Sponsor http://www.sapien.com http://prpass.org.hostasp.us/wp-content/uploads/2012/05/sapien_logo_n_text_300.jpg 40 100 6062 William E. Pearson III (02) - BI Room 2 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) 5/26/2012 11:15:00 AM 5/26/2012 12:30:00 PM 6218 Janis Griffin (03) - AppDev Room 3 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. 5/26/2012 4:45:00 PM 5/26/2012 6:00:00 PM 7030 Joseph Dantoni (01) - DBA Room 1 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. 5/26/2012 1:45:00 PM 5/26/2012 3:00:00 PM 7031 Joseph Dantoni (01) - DBA Room 1 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. 5/26/2012 9:45:00 AM 5/26/2012 11:00:00 AM 7054 Ramon Ponte (02) - BI Room 2 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. 5/26/2012 4:45:00 PM 5/26/2012 6:00:00 PM 7113 Jorge Sanchez (01) - DBA Room 1 (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. 5/26/2012 3:15:00 PM 5/26/2012 4:30:00 PM 7748 Max Trinidad (03) - AppDev Room 3 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. 5/26/2012 9:45:00 AM 5/26/2012 11:00:00 AM 8611 Alan Koo (02) - BI Room 2 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) 5/26/2012 1:45:00 PM 5/26/2012 3:00:00 PM 8614 Eduardo Sobrino (03) - AppDev Room 3 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. 5/26/2012 11:15:00 AM 5/26/2012 12:30:00 PM 8815 Pam Shaw (02) - BI Room 2 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. 5/26/2012 9:45:00 AM 5/26/2012 11:00:00 AM 9065 Maximo Trinidad (01) - DBA Room 1 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. 5/26/2012 4:45:00 PM 5/26/2012 6:00:00 PM 9142 Jose L. Rivera (03) - AppDev Room 3 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 5/26/2012 3:15:00 PM 5/26/2012 4:30:00 PM 9208 Maritza Córdova (03) - AppDev Room 3 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. 5/26/2012 1:45:00 PM 5/26/2012 3:00:00 PM 9295 Gualberto Huerta (01) - DBA Room 1 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. 5/26/2012 11:15:00 AM 5/26/2012 12:30:00 PM 9336 Guillermo Caicedo (02) - BI Room 2 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. 5/26/2012 3:15:00 PM 5/26/2012 4:30:00 PM 9337 Committee Members (01) - DBA Room 1 REGISTRATION 5/26/2012 7:30:00 AM 5/26/2012 8:30:00 AM 9337 Committee Members (03) - AppDev Room 3 REGISTRATION 5/26/2012 7:30:00 AM 5/26/2012 8:30:00 AM 9337 Committee Members (02) - BI Room 2 REGISTRATION 5/26/2012 7:30:00 AM 5/26/2012 8:30:00 AM 9338 Committee Members (02) - BI Room 2 Welcome Keynote 5/26/2012 8:45:00 AM 5/26/2012 9:30:00 AM 9338 Committee Members (03) - AppDev Room 3 Welcome Keynote 5/26/2012 8:45:00 AM 5/26/2012 9:30:00 AM 9338 Committee Members (01) - DBA Room 1 Welcome Keynote 5/26/2012 8:45:00 AM 5/26/2012 9:30:00 AM 9339 Committee Members (01) - DBA Room 1 LUNCH BREAK 5/26/2012 12:30:00 PM 5/26/2012 1:30:00 PM 9339 Committee Members (02) - BI Room 2 LUNCH BREAK 5/26/2012 12:30:00 PM 5/26/2012 1:30:00 PM 9339 Committee Members (03) - AppDev Room 3 LUNCH BREAK 5/26/2012 12:30:00 PM 5/26/2012 1:30:00 PM