<?xml version="1.0" encoding="utf-8"?>
<GuidebookXML>
  <guide>
    <name>SQLSaturday #151 - Orlando 2012</name>
    <startDate>9/29/2012 12:00:00 AM</startDate>
    <timezone>(GMT-05:00) Eastern Time (US and Canada)</timezone>
    <description>SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. </description>
    <twitterHashtag>#sqlsat151</twitterHashtag>
    <venue>
      <name>Seminole State College, Main Campus, 100 Weldon Boulevard Bld</name>
      <street>University Partnership Building</street>
      <city>Sanford</city>
      <state>FL</state>
      <zipcode>32773</zipcode>
    </venue>
    <guideicon>http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png</guideicon>
    <guideimage>http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png</guideimage>
    <menuitems>
      <menuitem>
        <name>Conference Information</name>
        <purpose>general</purpose>
        <active>True</active>
        <rank>1</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Maps</name>
        <purpose>maps</purpose>
        <active>False</active>
        <rank>2</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Schedule of Events</name>
        <purpose>schedule</purpose>
        <active>True</active>
        <rank>3</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Sponsors List</name>
        <purpose>sponsorslist</purpose>
        <active>True</active>
        <rank>4</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Twitter</name>
        <purpose>twitter</purpose>
        <active>True</active>
        <rank>5</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Todo List</name>
        <purpose>todo</purpose>
        <active>False</active>
        <rank>6</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>My Schedule</name>
        <purpose>myschedule</purpose>
        <active>True</active>
        <rank>7</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Feedback</name>
        <purpose>feedback</purpose>
        <active>False</active>
        <rank>8</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Key Events</name>
        <purpose>keyevents</purpose>
        <active>False</active>
        <rank>9</rank>
        <image>default</image>
      </menuitem>
      <menuitem>
        <name>Share</name>
        <purpose>share</purpose>
        <active>True</active>
        <rank>10</rank>
        <image>default</image>
      </menuitem>
    </menuitems>
  </guide>
  <sponsors>
    <sponsor>
      <importID>2549</importID>
      <name>UpSearch</name>
      <level>Platinum Sponsor</level>
      <url>http://www.upsearch.com/</url>
      <imageURL>http://www.sqlsaturday.com/files/55a668f2-9e99-4e24-bd3c-b33e94742827.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2426</importID>
      <name>Idera</name>
      <level>Gold Sponsor</level>
      <url>http://www.idera.com</url>
      <imageURL>http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2519</importID>
      <name>TekPartners</name>
      <level>Gold Sponsor</level>
      <url>http://www.tekpartners.com</url>
      <imageURL>http://www.tekpartners.com/wp-content/uploads/2012/04/TP_P2P_IT-021.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2614</importID>
      <name>Quest Software</name>
      <level>Gold Sponsor</level>
      <url>http://www.quest.com/</url>
      <imageURL>http://www.quest.com/images/common/quest_logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2703</importID>
      <name>Soaring Eagle Consulting, Inc.</name>
      <level>Gold Sponsor</level>
      <url>http://www.soaringeagle.biz</url>
      <imageURL>http://secpix.webs.com/SEC170x60.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2741</importID>
      <name>Seminole State College</name>
      <level>Gold Sponsor</level>
      <url>http://www.seminolestate.edu/</url>
      <imageURL>http://www.seminolestate.edu/media/2011/common-images/logo.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2418</importID>
      <name>Confio Software</name>
      <level>Silver Sponsor</level>
      <url>http://www.confio.com</url>
      <imageURL>http://www.confio.com/images/assets/confio_logo.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2536</importID>
      <name>Melissa Data</name>
      <level>Silver Sponsor</level>
      <url>http://www.melissadata.com</url>
      <imageURL>http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2634</importID>
      <name>SNI Technology</name>
      <level>Silver Sponsor</level>
      <url>http://www.snicompanies.com/</url>
      <imageURL>http://www.snicompanies.com/images/mastheads/sni_logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2702</importID>
      <name>ComponentOne, a division of GrapeCity</name>
      <level>Silver Sponsor</level>
      <url>http://www.componentone.com</url>
      <imageURL>http://eastiowa.sqlpass.org/Portals/252/sqlsaturday/componentone.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2275</importID>
      <name>CozyRoc</name>
      <level>Bronze Sponsor</level>
      <url>http://www.cozyroc.com</url>
      <imageURL>http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2736</importID>
      <name>McGraw Hill</name>
      <level>Bronze Sponsor</level>
      <url>http://www.mhprofessional.com/</url>
      <imageURL>http://orlando.sqlpass.org/Portals/265/Sponsor%20Images/mh_logo.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2740</importID>
      <name>OReilly</name>
      <level>Bronze Sponsor</level>
      <url>http://oreilly.com/</url>
      <imageURL>http://orlando.sqlpass.org/Portals/265/Sponsor%20Images/oreilly_logo.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2543</importID>
      <name>SQL Swampland</name>
      <level>Blog Sponsor</level>
      <url>http://sqlgator.wordpress.com</url>
      <imageURL>http://sqlgator.files.wordpress.com/2012/05/20120501-093211.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>2594</importID>
      <name>SQL Cruise</name>
      <level>Blog Sponsor</level>
      <url>http://www.sqlcruise.com</url>
      <imageURL>http://sqlcruise.com/wp-content/uploads/2012/08/sqlsat_sqlcruise_sm.png</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
  </sponsors>
  <events>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8954</importID>
      <speaker>SQLSaturday 151</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>Lunch and Networking with our SQLChefs and Sponsor</title>
      <description>BBQ and Italian (veggie option)</description>
      <startTime>9/29/2012 12:45:00 PM</startTime>
      <endTime>9/29/2012 2:00:00 PM</endTime>
    </event>
    <event>
      <importID>8955</importID>
      <speaker>Jack Corbett</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Transitioning from SQL Trace to Extended Events</title>
      <description>Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output.  Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events.  With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events.  This session will show you how to take existing Traces and convert them to Extended Event Sessions.</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>8956</importID>
      <speaker>Christopher Price</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>SSIS Moving Beyond the Script Task  Script Compon</title>
      <description>Move beyond the script task and script component and you’ll find one of the often overlooked aspects of Integration Services is the extensibility options that are available. We will dive into a world of .Net code and discover your options for extending your SSIS Packages with custom objects. We will explore both custom task and data flow components as we develop from the ground up a set of reusable SSIS components using managed code.</description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>8957</importID>
      <speaker>Christopher Price</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Introduction to Master Data Services 2012 </title>
      <description>Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>8963</importID>
      <speaker>Scott Klein</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>SQL Azure vs. Azure Tables –Clearing The Confusion</title>
      <description>The Azure platform is quickly gaining momentum and acceptance, in part due to the relational database capabilities of SQL Azure as well as the inexpensive and high-capacity storage capabilities of Azure Tables. Yet, there seems to be some confusion as to why and when you would use SQL Azure vs. Azure Tables. One is relational, and one is not, yet there has been a tendency to use Azure Storage Tables as a replacement for SQL Azure, with poor results. This session will provide a deep look at the difference between SQL Azure and Azure Storage Tables, and show the performance differences when querying each. We will look at how each stores data and the pros and cons of using each as a storage mechanism, and discuss how and why you would choose.</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>8995</importID>
      <speaker>Devin Knight</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Introduction to Power View</title>
      <description>Power View has the capability of creating eye-popping visualizations within SharePoint 2010.  It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions.  This session walks you through creating your first Power View report and shows you how to create an impressive reporting solution.</description>
      <startTime>9/29/2012 7:30:00 AM</startTime>
      <endTime>9/29/2012 8:30:00 AM</endTime>
    </event>
    <event>
      <importID>9014</importID>
      <speaker>Rob Volk</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Tame Your Unruly Data...With Constraints!</title>
      <description>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!</description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>9022</importID>
      <speaker>Jose Chinchilla</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>PowerPivot+Powerview=Self-service BI Revolution</title>
      <description>SQL Server 2012 introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot and the new ad-hoc dashboarding tool called PowerView are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves. In this session you will also understand what is the role of IT in this new self-service paradox.</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>9023</importID>
      <speaker>Jose Chinchilla</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>Real-world Fuzzy matching  with SSIS</title>
      <description>Fuzzy Lookup and Fuzzy Grouping in SSIS are two powerful transformations that allow you to match inputs by providing a similarity threshold. In this presentation you will learn how to implement Fuzzy Lookup and Fuzzy Grouping in real-world scenarios such as matching individuals by a series of attributes, creating master or header records for Master Data Management as well as implementing data cleansing for Data Quality frameworks.</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>9043</importID>
      <speaker>Anthony Sammartino</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>SSAS Tabular and Self Service BI - TheDynamDAX Duo</title>
      <description>In this session I will cover how SSAS tabular and Self Service BI compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each then will walk through how to create a SSAS tabular model, get into how to create data relationships from a regular database model with large tables, then hook it up to Excel and expose the elements for users to slice and dice data with ease and create charts. Then will demonstrate a few DAX commands that are very powerful yet very easy. </description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>9064</importID>
      <speaker>Chad Churchwell</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Designing An Efficient Replication Topology</title>
      <description>This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology.  Discussed will be design decisions for snapshot, transactional, and merge replication.  Also discussed will be agent profiles and optimizations for replication.  What type of replication to use to solve business needs will also be covered.</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>9145</importID>
      <speaker>Bradley Schacht</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>Introduction to ETL Using SSIS</title>
      <description>As we all know data is not static.  It is constantly changing, constantly moving and just moving data from one place to another is a simple enough task.  In this session Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files.  He will then discuss some of the DOs and DON’Ts of the SSIS ETL world.  We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination.  Other topics: partially blocking vs fully blocking, which transforms are right for what jobs, what to avoid.</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>9152</importID>
      <speaker>David Liebman</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>SSRS in ASP.Net Application</title>
      <description>In this session I will show you how to incorporate your SSRS reports into a ASP.Net Web Application. We will create a web page that will pass parameters to an SSRS report using the Report Server Service.</description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>9361</importID>
      <speaker>Jason Hofferle</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>PowerShell for Beginners</title>
      <description>PowerShell is Microsoft's automation engine, which includes a command-line shell and scripting language. Since its initial release in 2006, it has become an essential tool for managing Microsoft technologies and products from vendors such as VMware. This session will explain what PowerShell is, demonstrate the fundamentals, and provide some reasons why everyone working with Microsoft products should know the basics. </description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>9502</importID>
      <speaker>Jonathon Moorman</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Surviving Your Sql Developer Interview</title>
      <description>This session will describe what to expect when interviewing for a sql server developer position with tips from the 'other' side of the table.  The session will include tips to strengthen your interviewing techniques, and pitfalls to avoid. The session will explain why 'I don't know.' is a perfectly acceptable answer and when it's okay to brag.  This session will describe what's 'really' going on in the minds of the interviewer!
</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>9504</importID>
      <speaker>Stacia Misner</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>Data Visualization in Reporting Services</title>
      <description>Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you  now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>9544</importID>
      <speaker>Tom  Brenneman</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Job Common Sense - Don't be that Guy!!</title>
      <description>In this session, Tom will share stories from those in the community to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities. </description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>9613</importID>
      <speaker>Eric Wisdahl</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Free tools from the SQL Server Community</title>
      <description>No budget?  That's OK!  Need Tools?  We've get them!  Don't know where to go?  We'll show you!  The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out.  In this session we will walk through a list of twenty great tools, scripts, blogs and other resources to help you out.  Best of all, it's all free!  But wait, there's more.  Order now and we'll include an extra two tips at no additional cost!  
</description>
      <startTime>9/29/2012 7:30:00 AM</startTime>
      <endTime>9/29/2012 8:30:00 AM</endTime>
    </event>
    <event>
      <importID>9829</importID>
      <speaker>Bradley Ball</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>SQL Internals , Recovery Modes, and Backups! OH MY</title>
      <description>The more you know about SQL Server the more you understand how it works.  SQL Server is a product we use every day, and most of us know the big concepts.  At the 10,000 foot view we know what  Databases, Tables, and Columns are.   But what makes up those Databases, Tables, and Columns.  What are Records, Pages, Extents, and Allocation Units?  What are Full, Simple, and Bulk-Logged Recovery?  What are the differences between  Full, Transaction Log, Differential, or Filegroup backups?  This is an introduction to these concepts.  In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>9900</importID>
      <speaker>Richie Rump</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Introduction to Project Management</title>
      <description>The IT industry is now being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process as defined by the Project Management Institute. It will also focus on the tools that data professionals can use to deliver projects ontime and on budget.</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>10017</importID>
      <speaker>Janis Griffin</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Looney Tuner?  No, there IS a method to my madness</title>
      <description>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.</description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>10108</importID>
      <speaker>Max Trinidad</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Basic Intro to PowerShell for the DBA (1/2)</title>
      <description>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.</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>10329</importID>
      <speaker>Jose L. Rivera</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Look who's Blocking</title>
      <description>Have you ever faced the situation of trying to retrieve some data and the query keeps waiting on. Why this simple query is taking so long? There is a good chance that you are encountering locking/blocking problems. In this session, we will demonstrate how to recognize, diagnose and troubleshoot common locking and blocking scenarios. We will discuss transactions basics, lock types, escalation, and the infamous deadlock, among others.</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>10335</importID>
      <speaker>Timothy McAliley</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Running SQL Server 2012 as a Windows Azure VM</title>
      <description>This session will cover an introduction to Windows Azure Virtual Machines and then we will explore the options for planning and configuring SQL Server 2012 as a Windows Azure Virtual Machine. You will see a demonstration of configuring SQL Server 2012 as a Windows Azure Virtual Machine, and then a demonstration of post-configuration tasks such as storage provisions and resource monitoring. You will also learn the basics of what you need to obtain a Windows Azure account and the different subscription options.</description>
      <startTime>9/29/2012 2:00:00 PM</startTime>
      <endTime>9/29/2012 3:00:00 PM</endTime>
    </event>
    <event>
      <importID>10366</importID>
      <speaker>Juan Soto</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Wish you could live the glamorous consulting life?</title>
      <description>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 lean 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</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>10580</importID>
      <speaker>Kevin Kline</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>SQL Server Internals  Architecture</title>
      <description>Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - ...and much more.</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>10625</importID>
      <speaker>Craig Purnell</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>LinkedIn for SQL Server Professionals</title>
      <description>LinkedIn is more than an online resume! The platform is chock full of useful features for networking, relationship building, and job searching. Think of it as your professional online image. LinkedIn is rapidly becoming the de facto platform for business networking. There are many powerful, advanced features that most people don’t know how to use or even exist. It is also an online communication platform, professional networking portal, and contacts database. Takeaways include: how to optimize and polish your profile, how to get your profile to 100%, quality vs. quantity networking strategies, selecting of and the correct use of LinkedIn groups   
</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>10646</importID>
      <speaker>Luis Figueroa</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Change Tracking and Change Data Capture Deep Dive</title>
      <description>In this session Luis will cover beginning to end these two technologies key to  delivering a real time reporting. Come join him to discuss  different scenarios and some gotcha's he has learned and dealt with in real world implementations. 
</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>10669</importID>
      <speaker>Robert Biddle</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Intro to SQL Server Performance Tuning</title>
      <description>In this session we'll cover an introduction to SQL Server Performance tuning. We will go through a step-by-step process to identify causes of poor-performing systems.</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>10821</importID>
      <speaker>Andy Warren</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Building Your Professional Development Plan</title>
      <description>Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.</description>
      <startTime>9/29/2012 7:30:00 AM</startTime>
      <endTime>9/29/2012 8:30:00 AM</endTime>
    </event>
    <event>
      <importID>10828</importID>
      <speaker>Pam Shaw</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>Taking the Scary out of Monster Reports</title>
      <description>So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.  It includes grids and charts of varying sizes and complexities.  Did I mention they want it pretty as well?  In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes.  The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts.  We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.  To get the most out of this session, you should be able to build a report in SSRS.
</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>10829</importID>
      <speaker>Pam Shaw</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>Tips  Tricks for dynamic SSRS Reports</title>
      <description>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.
</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>10860</importID>
      <speaker>Norm Bowen</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>Data Conversions - Steps, Best Practices  More</title>
      <description>This session will cover the stages and steps of a data conversion project, some best practices and other considerations. The session includes information that could be useful to someone involved in planning, managing or developing a data conversion project.</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>10893</importID>
      <speaker>Eddie Wuerch</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Partitioning for Perf  Management of Large Tables</title>
      <description>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 seamlessly 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.</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>10898</importID>
      <speaker>Allen White</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Manage SQL Server 2012 on Server Core w/PowerShell</title>
      <description>Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>10907</importID>
      <speaker>Mike Davis</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Complex DAX Functions</title>
      <description>PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.</description>
      <startTime>9/29/2012 4:30:00 PM</startTime>
      <endTime>9/29/2012 5:30:00 PM</endTime>
    </event>
    <event>
      <importID>10909</importID>
      <speaker>Arvin Meyer</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Database Creation Process</title>
      <description>A beginning to intermediate look at Requirements Analysis, Needs Assessment, and Software Satisfaction followup</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>10927</importID>
      <speaker>Dmitri Korotkevitch</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Database Backend - Between Ground and Clouds</title>
      <description>The choice of the database backend is one of the most important tasks during system design stage. This session compares various options available to users, such as on-premises SQL Server installation; Windows Azure SQL Database; Amazon Elastic Compute Cloud (EC2) and Amazon Relation Database Service (RDS). It analyzes pros, cons and platform limitations for different types of the systems, architecture and design requirements for each platform and discusses conversion of the systems from one platform to another. </description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>10940</importID>
      <speaker>Michael Antonovich</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>BI for the Masses Deux, PowerPivot 2012</title>
      <description>The latest version of PowerPivot brings even more BI power to the masses the addition of defined hierarchies, KPI’s, perspectives, formatted measures, and more.  This session focuses on showing how to use some of the latest features of PowerPivot to give your power users the tools they need to perform their own analysis of their business data.  In fact, when your users begin to use Office Excel 2013, PowerPivot is already built-in and does not require a separate download.  Stay ahead of the curve and attend this session so you can help your users effectively use this tool.</description>
      <startTime>9/29/2012 9:00:00 AM</startTime>
      <endTime>9/29/2012 10:00:00 AM</endTime>
    </event>
    <event>
      <importID>10965</importID>
      <speaker>Ed Watson</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Best Practices Are Not Just Hypothetical</title>
      <description>Ever had a discussion where someone said well X is best practices but that is impossible to implement?  This session is a step by step installation guide to best practices for SQL Server.  When you install with best practices in mind, maintaining them is much simpler.</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>10984</importID>
      <speaker>Robert Hatton</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>The server side of Reporting Services</title>
      <description>This session will cover important information about how to set up Reporting Services. We'll go beyond the simple installation and configuration issues. Covered topics will include shared data sources, managing the folder structure, using linked reports, and the management user interfaces. We'll also cover the database that Reporting Services uses to house report definitions.</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>11019</importID>
      <speaker>Guillermo Caicedo</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>SQL Server Data Tools, What can you do for me?</title>
      <description>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.  </description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>11613</importID>
      <speaker>Rodney Landrum</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>DBA Repository Update Using SSIS and SSRS</title>
      <description>At its heart, the DBA Repository solution employs SSIS and SSRS to centralize important SQL Server information for the DBA to analyze with ad hoc queries or reports. It was recently updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine and his book SQL Server Tacklebox, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS. Rodney will also show you how to use the fundamental package contructs so that you can easily expand the freely available project in your own environment. Two additional packages will be demonstrated, Error Log gathering and SSRS audit logs.</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>11614</importID>
      <speaker>Jeff Garbus</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Rewriting Bad Code </title>
      <description>This session consists of real-life examples of poorly performing t-sql code and what was done to improve performance by several orders of magnitude. Jeff will cover a variety of performance topics from misuse of tempdb, to excessive io, to taking advantage of new t-sql features. These examples are also featured in his most recent (and well-reviewed) book, 'Microsoft Transact - SQL, The Definitive Guide'.</description>
      <startTime>9/29/2012 3:15:00 PM</startTime>
      <endTime>9/29/2012 4:15:00 PM</endTime>
    </event>
    <event>
      <importID>11617</importID>
      <speaker>Ryan Adams</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>How Active Directory Affects SQL Server</title>
      <description>There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers.  Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent.  We'll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.  This includes the biggest perpetrator, Group Policy Objects.</description>
      <startTime>9/29/2012 11:30:00 AM</startTime>
      <endTime>9/29/2012 12:30:00 PM</endTime>
    </event>
    <event>
      <importID>11618</importID>
      <speaker>Todd Phillipe</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Object Level Recovery Made Easy</title>
      <description>Learn how to recover database objects quickly and efficiently without having to do a full database restore.</description>
      <startTime>9/29/2012 10:15:00 AM</startTime>
      <endTime>9/29/2012 11:15:00 AM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>BI</track>
      <location>
        <name>Room 3103</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>Admin</track>
      <location>
        <name>Room 4103</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>Reporting</track>
      <location>
        <name>Room 4106</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>SSIS</track>
      <location>
        <name>Room 4102</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>Perf Tuning</track>
      <location>
        <name>Room 4105</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>Cloud</track>
      <location>
        <name>Room 3205</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
    <event>
      <importID>11669</importID>
      <speaker>Raffle  Drawing</speaker>
      <track>Career Skills</track>
      <location>
        <name>Room 3206</name>
      </location>
      <title>Raffle Drawing</title>
      <description>Raffle Drawing</description>
      <startTime>9/29/2012 5:45:00 PM</startTime>
      <endTime>9/29/2012 6:15:00 PM</endTime>
    </event>
  </events>
</GuidebookXML>