SQLSaturday #174 - Charlotte - BI Edition 2012 10/27/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat174 Central Piedmont Community College (CPCC) 2800 Campus Ridge Road Matthews NC 28105 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 2562 Intellinet Gold Sponsor http://www.intellinet.com/ http://www.sqlsaturday.com/files/664ffcf1-25d1-4f88-b2d3-42b24fb76ca2.jpg 60 170 2585 Mariner Gold Sponsor http://mariner-usa.com http://www.sqlsaturday.com/files/920106d8-a494-4724-a7d6-2d58de209d1e.png 60 170 2643 TekPartners BI Solutions Gold Sponsor http://www.tekpartnersbi.com http://www.sqlsaturday.com/files/1fe694d5-5770-47c6-b293-e88108a255c1.jpg 60 170 2675 SQL Sentry Gold Sponsor http://www.sqlsentry.com/ http://www.sqlsaturday.com/files/c1823b6b-e23a-4be8-a8cb-4cfea1a193eb.png 60 170 2728 Cardinal Solutions Gold Sponsor http://www.cardinalsolutions.com http://www.sqlsaturday.com/files/5ca56613-1329-4fc6-b40f-24becd5ac7ec.png 60 170 2734 Enterprise Software Solutions Gold Sponsor http://www.entsoftsol.com http://www.entsoftsol.com/logo170x60.png 60 170 2653 CapTech Consulting Silver Sponsor https://www.captechconsulting.com http://www.sqlsaturday.com/files/dfadf904-ac0f-4668-a7af-d199fa2da204.jpg 60 170 2669 Varigence Silver Sponsor http://www.varigence.com http://www.sqlsaturday.com/files/c5e56b32-0f75-42a1-81b2-733577adeffa.png 60 170 2673 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2679 COZYROC Silver Sponsor http://www.cozyroc.com http://www.sqlsaturday.com/files/781fbe77-f6d2-41b3-8e26-b9686169e215.png 60 170 2773 GridIron Systems Silver Sponsor http://www.gridironsystems.com http://www.sqlsaturday.com/files/d1aff1e0-dffd-46cd-b76c-f44f281ec341.jpg 60 170 2778 New Horizons Computer Learning Center of Charlotte Silver Sponsor http://www.nhcharlotte.com http://www.sqlsaturday.com/files/c8ac0a95-aace-463c-9f6c-87efa143a876.gif 60 170 2790 Fusion-io Silver Sponsor http://www.fusionio.com http://www.sqlsaturday.com/files/298dd9dd-32b9-4081-b020-527624c25dec.png 60 170 2710 Blue Granite Bronze Sponsor http://www.blue-granite.com/site/Home/tabid/36/Default.aspx http://melissacoates.squarespace.com/storage/BlueGranite_170x60.png 60 170 2605 McGraw-Hill Professional Swag Sponsor http://www.mhprofessional.com/ http://melissacoates.squarespace.com/storage/Swag_McGrawHill_100x40.gif 40 100 2606 Red Gate Software Swag Sponsor http://www.red-gate.com/ http://melissacoates.squarespace.com/storage/Swag_RedGateLogo_100x40.png 40 100 2607 O'Reilly Media, Inc. Swag Sponsor http://oreilly.com/ http://melissacoates.squarespace.com/storage/Swag_OReillyLogo_100x40.gif 40 100 2608 SAPIEN Technologies, Inc. Swag Sponsor http://www.sapien.com/software/primalscript http://melissacoates.squarespace.com/storage/Swag_SapienLogo_100x40.png 40 100 2637 Wrox Swag Sponsor http://www.wrox.com/WileyCDA/ http://melissacoates.squarespace.com/storage/Swag_Wrox_100x40.gif 40 100 2697 Kimball Group Swag Sponsor http://www.kimballgroup.com/ http://melissacoates.squarespace.com/storage/Swag_KimballGroup_100x40.png 40 100 2780 TechSmith Swag Sponsor http://www.techsmith.com/ http://www.sqlsaturday.com/files/34f87c66-5e73-4871-a86d-882fadd4d4b1.png 40 100 2698 APress Swag Sponsor http://www.apress.com/ http://melissacoates.squarespace.com/storage/Swag_APress_100x40.jpg 40 100 2699 Prologika Swag Sponsor http://www.prologika.com/ http://melissacoates.squarespace.com/storage/Swag_Prologika_100x40.png 40 100 2700 Mr. Excel Swag Sponsor http://www.mrexcel.com/ http://melissacoates.squarespace.com/storage/Swag_MrExcel_100x40.png 40 100 2701 Que Publishing Swag Sponsor http://www.quepublishing.com/ http://melissacoates.squarespace.com/storage/Swag_Que_100x40.png 40 100 2726 Pluralsight Swag Sponsor http://www.pluralsight.com/training http://melissacoates.squarespace.com/storage/Swag_Pluralsight_100x40.png 40 100 2732 Packt Publishing Swag Sponsor http://www.packtpub.com/ http://melissacoates.squarespace.com/storage/Swag_Packt_100x40.png 40 100 2563 SQL Chick Blog Sponsor http://www.sqlchick.com http://melissacoates.squarespace.com/storage/SQLChick_Logo_100x40.png 40 100 2574 Some Random Thoughts Blog Sponsor http://road-blogs.blogspot.com https://xmp7ua.bay.livefilestore.com/y1pgMJIQLI5I7eTQiU9RbpQ8Eyu3GXt5jhk211KxpOxpxCClvTgKG2qGOJClvk8lUpaZiH57ym5jXXPqtgNwu_ZSKUSoQ1A9RK6/TitlImg.jpg 40 100 2582 Javier Guillen Blog Sponsor http://javierguillen.files.wordpress.com http://javierguillen.files.wordpress.com/2012/08/javilogo-e1344616159627.jpg 40 100 2687 Rafael Salas Blog Sponsor http://www.rafael-salas.com http://www.sqlsaturday.com/files/d4e6e71c-6cc2-4dce-a746-e298c1a3f0ec.png 40 100 11104 David Eichner 6 1319 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy! 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11106 Luis Figueroa 3 1304 Every second counts when you are trying to achieve real time reporting. In this session Luis will demonstrate how to use Change Tracking and Change Data Capture to very quickly update data warehouse dimensions. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11107 William E Pearson III 7 1315 A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11110 William E Pearson III 5 1408 Once the enterprise implements SSAS, immediate reporting benefits appear as the power of OLAP is unleashed in the speed of aggregations, the support of organization-wide ad hoc analysis and reporting, and myriad other advantages. A common need that then often arises is the capability to perform extra-hierarchy groupings. In this session, BI Architect and MVP Bill Pearson presents an approach to accomplishing external grouping with PowerPivot. We examine ways to accomplish a stated, example business need for such grouping via the addition of PowerPivot to an integrated Microsoft BI solution. Moreover, we discuss ways to design a scalable solution with PowerPivot that we can then entrain into the base warehouse / mart / cube structure. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11160 James Herring 2 1317 This session is designed to introduce the audience to Microsoft Parallel Data Warehouse (PDW) and how an MPP Architecture can be useful to them in their current BI Environment. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11175 Steven Wright 5 1408 This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it's performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We'll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server's performance. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11207 Anthony Sammartino 6 1319 In this session I will go over how to separate your systems for transactional databases, and for reporting. I will lightly cover how this can be done with mirroring, replication, which one is right for your situation. Then deep dive into replication, the agents it creates and their purpose, provide tips, best practices, and dispel any fears you may have heard or validate them. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11242 Kevin Goode 8 1307 Being a DBA is not all smiles and sunshine; sometimes you have to deal with the tedious topic of licensing. As a DBA, developer, or consultant, you are responsible for ensuring that your company or client is in compliance and can pass software audits. As with any Microsoft product license, there are complicated nuances of the SQL Server licensing program with many new twists added in 2012. This session will help you understand what you can and cannot do with various license types, and, how you could save your company some serious money. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11244 Kevin Goode 4 1303 Have you ever wondered how Microsoft and Unisys loaded 1TB of data in 30 minutes? They used as many parallel processes as possible. This session will walk through a solution that makes heavy use of parallel processing. We will look at the use of scope to isolate threads and script tasks to determine and spread the workload across multiple threads. Additionally, we will look at how to determine how many parallel processes should be run on a single server and techniques to spread loads over multiple servers. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11256 Paul Waters 3 1304 SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, there are some painful shortcomings that make it difficult to automate package creation, easily reuse patterns and templates, and create packages directly from schema information and other metadata. The free and open source BIDS Helper Add-In offers support for automatically generating SSIS packages using the Business Intelligence Markup Language (Biml). In this session we will start by showing the power of Biml. We will then step back, and start from the beginning of using BimlScript. Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11268 Kevin Boles 2 1317 Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11269 Kevin Boles 1 1410 SQL Server Partitioning from A to Z We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11278 Russell Christopher 8 1307 Tableau is the Swiss Army Knife for analytics professionals and compliments SQL Server relational, SSAS, SSAS Tabular, and PowerPivot. It is quickly becoming a 'must have' data tool. In this session, you'll learn about Tableau Desktop and see it in action against a variety of Microsoft data sources. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11283 Mark Hudson 6 1319 Columbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server 2008 supports geospatial data. SQL Server 2008 R2 provides the United States map gallery. Come see how Reporting Services leverages those knowns to present our data in a geographical way. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11288 Ira Whiteside 4 1303 Implement an SSIS Framework to track the progress of SSIS production packages similar to how you can in the BIDS Designer, and explore your package withs windows explorer like capability.Utilizing the “out of the box” SSIS Logging with no changes required to the existing logic or packages. The new framework will also use SSIS to scan existing packages and automatically discover Master / Child package relationships and providing a capability for package restartability. This design pattern can be use to replace earlier “Stored Proc” version of SSIS Framework greatly reducing the code required. This functionality is complementary to the 2012 Package Tracking capability. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11294 Rick Heiges 8 1307 Ever thought to yourself, 'I could do a better job at this than the consultant we hired'? Or, 'I could make so much more money if I were a consultant'? A career in consulting can be alluring. In this interactive session, we'll discuss strategies for how to become a consultant, as well as the pros and cons of the lifestyle. We'll also talk about the different legal and tax-related issues and costs/benefits of being a consultant, as well as details such as how to determine a rate and how to market your services. Join the discussion on these factors and more to help you figure out if you're cut out to be a consultant. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11300 Jason Howell 3 1304 If you haven't seen it yet, SQL Server 2012 introduces a new feature called Data Quality Services (DQS for short). Its easy and quick to learn in an hour. DQS is useful for data stewards and IT professionals who seek to improve the quality of their business data. In this intro session, we describe the concept and main principles behind Data Quality Services and demo the main capabilities of the product, such as knowledge management, cleansing, matching, profiling, and the Azure Datamarket Reference Data Services. Most any business user will quickly see the value of DQS and walk away feeling ready to show off their new found smarts to the rest of their team. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11315 Paul Rizza 4 1303 As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort! 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11321 Evan Basalik 6 1319 Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11325 Jesse Kraut 4 1303 This session will dive into the the SSIS toolkit by creating SSIS Custom Components in SQL Server 2008 and 2012. Discuss how to register the custom components and add to the SSIS Toolbox. Demonstrate a method to open an SSIS package with a C# script and read or make changes to the package design. The start of data driven design and programmatically creating packages, scan an entire BIDS Solution all cubes, dimensions, and connections in SSAS using Analysis Management Objects (AMO) with C#. This allows us to create a metadata mart and full documentation of our SSAS cubes. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11334 Chris Skorlinski 1 1410 This sessions provides insight into the high availability (HA) features planned for SQL Server. I’ll provide a brief look at current HA options, Clustering, Replication, Mirroring, Log Shipping then explore how these were all combined into new AlwaysOn HA feature for SQL 2012. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11337 Katherine Fraser 5 1408 Originally called the Vertipaq engine, SQL Server 2012 uses in-memory column-oriented storage and compression to be able to process millions of rows with sub-second response time on desktop hardware. In this session we'll talk about how xVelocity is used inside PowerPivot and Analysis Services Tabular models to give performance improvements to data warehousing and business intelligence. We'll look at the columnstore index and SSAS/PowerPivot implementations and what the memory limitations are. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11338 William Carroll 1 1410 Introduction to the service broker feature and what is new for service broker in SQL Server 2012 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11339 Chris Skorlinski 8 1307 Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. In this personal development session I'll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11349 Christopher Price 3 1304 With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11372 Matthew Duffield 8 1307 Need to have some dashboard reports that support cross-platform devices? Ever wanted to build your dashboard and see it on the iPad or Android, or Windows 8 Surface? With this session, we will take a look at what it takes to provide simple dashboards using goodness of HTML5. We will look at using client-side JavaScript to provide our data using Web API and JSON. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11381 Julie Smith 3 1304 Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create Data Cleansing Knowledge Bases to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Knowledge Bases can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11395 Jose L. Rivera 5 1408 The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11399 Mike Oryszak 7 1315 The Business Connectivity Services (BCS) offered in SharePoint provides a robust way to integrate and display your Line of Business Data. We will provide a full overview of the feature, show how it can be used to connect to different data sources, and then demonstrate the other advantages of using External Content Types instead of a custom developed report including lookup columns and search. With this session, you will have the information needed to quickly and securely access your Line of Business data in SharePoint. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11400 Geoff Hiten 1 1410 Good Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11401 Geoff Hiten 2 1317 Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving where you live or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using examples focused on SharePoint workloads. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11403 Rob Volk 2 1317 Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page! 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11418 Ben Adams 7 1315 The backbone for SharePoint is a strong SQL Server to support the environment. Let's review how SharePoint Databases behave and how to care and maintain them. What is the proper setup for a SQL Server that is supporting SharePoint? What are some pitfalls to watch out for? We will also review some tools that can help make your life easier in monitoring your SQL Server when it comes to SharePoint Databases. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11509 Fendy Huang 3 1304 What is the Integration Services Catalog? If you plan to use SQL 2012 SSIS for your next project, you need to know the free, new features of logging, tracing, and statistics data provided by the Integration Services Catalogs. In this session we will walk through the steps to configure the catalogs, explore the database objects inside the catalogs, manage the catalogs, and create/deploy custom report to be used in the catalogs. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11511 Rob Kerr 7 1315 This session provides a technical overview of Hadoop targeted for Microsoft DW/BI professionals. Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11516 Dave Turpin 1 1410 As a database developer, BI specialist or just getting started DBA... How many times have you simply run out of space in your database? How much better would your life be if you were able to assess your database available space, recognize space problems BEFORE they occur, and make recommendations to your DBA proactively before you hit the ugly 'can't auto-grow' error on Friday at 4:30? This session will leap frog your understanding of database physical files. You will be given the tools and knowledge to monitor and assess your physical space so you can recommend corrective steps BEFORE they happen. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11541 Paul Wood 8 1307 With the SharePoint 2010 and Visio 2010 releases, the ability to quickly create and share powerful, intuitive, automatically-refreshing dashboard visualizations of both your critical IT and business data has never been easier to accomplish. We will cover a quick overview of SharePoint Visio Services, Visio 2010 tips and tricks, and connecting Visio diagrams to data in varios common data sources like Excel, SharePoint and SQL Server. Several demos of how to do this will enable you to leave this session with the knowledge needed to immediately start using Visio Services to make your existing data tell a real story in your organization. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11550 David Botzenhart 6 1319 There are a multitude of data visualization options in a Microsoft environment, Reporting Services, Excel Services, Performance Point, Power View, 3rd party tools...each of these are specialized tools to fill a specialized need. In this session we will walk through each of these tools. Focusing on the most popular tool Excel, we will see how we can take this already excellent tool and extend its capabilities further At the end of the session the attendee will understand the range of data visualization options and how they can use Excel to design reports for both multidimensional, tabular, and relational models for an enhanced user experience on the PC, Web, and Mobile devices. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11558 Joe Dib 7 1315 You have heard the news. You could not escape the buzz. It is coming. It is coming. SQL Server 2012 (denali) is here! What is in it? This session will survey SQL Server 2012 at a high level focusing on BI components. This session is perfect for managers or anyone who is looking into SQL Server 2012 for the first time. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11561 Leo Furlong 7 1315 MDM isn't just about technology implementation, but about going through the real pain, trials, and tribulations of addressing core issues the company has in the areas of Organization, Process, Data Management/Data Governance, and Technology. Join John Head and Leo Furlong as they discuss the process of trying to discover a company’s operational MDM issues, set up a program for addressing the real problems, and trying to make real organization change to not only clean up the data, but prevent it from getting dirty in the first place. http://www.youtube.com/watch?v=s4sQI8Evfhcfeature=fvst 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11562 Cathy Miller 4 1303 The newest version of SQL Server 2012 introduces many new BI features. This session will help DBAs and ETL Developers ramp up by demonstrating the major changes in SSIS 2012! 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11569 Wayne Snyder 5 1408 You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propogate is necessary requisite. We will use a 'W' diagram to understand how this occurs in tabular models. Then will will learn how to force filter propogation called cross-filtering. The we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production. 10/27/2012 8:30:00 AM 10/27/2012 9:30:00 AM 11570 Audrey Hammonds 2 1317 So you've got your data in the database? That's great! Now... how about getting it back out? Sometimes complex reports call for complex queries, and this session is all about that. Want to pivot your rows into columns? Sure. Want to format that self-referencing hierarchy? Got it. Ranking? Windowing? No problem. In this session we'll cover some common data formatting issues and the T-SQL solutions that make them a little less scary. 10/27/2012 2:45:00 PM 10/27/2012 3:45:00 PM 11571 Audrey Hammonds 1 1410 So many names! Data warehouse, data mart, star-schema, snowflake schema, dimensional model, Type 1, Type 2, Type 3... What does it all mean? Whether you're a data consumer, ETL specialist, or database designer, it pays to understand the vocabulary and design concepts of dimensional models. In this session, we'll cover the basics of dimensional modeling, including dimensions, facts, and the ways they all come together. We'll talk about why denormlization isn't necessarily a dirty word, some common design challenges, and a few ETL considerations. By the end of the hour, you'll be ready to impress your friends and confound your frenemies with your mad dimensional modeling knowledge! 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM 11572 Jessica Moss Phil Noakes 5 1408 Once you’ve loaded your data into a star schema and built an Analysis Services 2008 R2 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports, to change your cube design based on your choice of reporting outlet, and determine any additional special considerations. This session will answer these questions and explore the different reporting options, such as Reporting Services and PerformancePoint Services, when deriving business intelligence from an Analysis Services cube. 10/27/2012 9:45:00 AM 10/27/2012 10:45:00 AM 11573 Jessica Moss 6 1319 Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one. 10/27/2012 1:30:00 PM 10/27/2012 2:30:00 PM 11643 SQLSat 174 6 1319 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 5 1408 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 7 1315 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 8 1307 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 1 1410 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 2 1317 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 4 1303 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 3 1304 Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11643 SQLSat 174 Common Area A Breakfast Check-In 10/27/2012 7:30:00 AM 10/27/2012 8:00:00 AM 11644 SQLSat 174 Common Area A Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 3 1304 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 4 1303 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 2 1317 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 1 1410 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 8 1307 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 7 1315 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 5 1408 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11644 SQLSat 174 6 1319 Opening Remarks 10/27/2012 8:00:00 AM 10/27/2012 8:30:00 AM 11645 SQLSat 174 6 1319 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 5 1408 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 7 1315 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 8 1307 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 1 1410 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 2 1317 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 4 1303 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 3 1304 Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11645 SQLSat 174 Common Area A Closing Remarks 10/27/2012 5:00:00 PM 10/27/2012 5:15:00 PM 11646 SQLSat 174 Common Area A Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 3 1304 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 4 1303 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 2 1317 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 1 1410 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 8 1307 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 7 1315 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 5 1408 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11646 SQLSat 174 6 1319 Lunch Sponsor Sessions 10/27/2012 12:00:00 PM 10/27/2012 1:30:00 PM 11647 SQLSat 174 6 1319 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 6 1319 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 6 1319 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 6 1319 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 5 1408 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 5 1408 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 5 1408 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 5 1408 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 7 1315 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 7 1315 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 7 1315 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 7 1315 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 8 1307 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 8 1307 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 8 1307 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 8 1307 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 1 1410 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 1 1410 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 1 1410 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 1 1410 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 2 1317 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 2 1317 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 2 1317 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 2 1317 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 4 1303 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 4 1303 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 4 1303 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 4 1303 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 3 1304 Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 3 1304 Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 3 1304 Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 3 1304 Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11647 SQLSat 174 Common Area A Break 10/27/2012 9:30:00 AM 10/27/2012 9:45:00 AM 11647 SQLSat 174 Common Area A Break 10/27/2012 10:45:00 AM 10/27/2012 11:00:00 AM 11647 SQLSat 174 Common Area A Break 10/27/2012 2:30:00 PM 10/27/2012 2:45:00 PM 11647 SQLSat 174 Common Area A Break 10/27/2012 3:45:00 PM 10/27/2012 4:00:00 PM 11856 Rafael Salas 4 1303 Dealing with bad data is a painful and expensive experience.  In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with  SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals.  You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component. 10/27/2012 4:00:00 PM 10/27/2012 5:00:00 PM 11880 Javier Guillen 2 1317 Although the Tabular framework is based on simple one-to-many relationships, there are important rules to follow when modeling business scenarios: DAX direction of context propagation, Lookup vs Base tables, disconnected tables and calculated aggregate tables are some of the things to consider when delivering real life Analysis Services models. This session reviews some of the most important 'gotchas' encountered when doing developing SSAS models. 10/27/2012 11:00:00 AM 10/27/2012 12:00:00 PM