<?xml version="1.0" encoding="utf-8"?>
<GuidebookXML>
  <guide>
    <name>SQLSaturday #77 - Pensacola 2011</name>
    <startDate>6/4/2011 12:00:00 AM</startDate>
    <timezone>
    </timezone>
    <description>SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. </description>
    <twitterHashtag>#sqlsat77</twitterHashtag>
    <venue>
      <name>
      </name>
      <street>
      </street>
      <city>Pensacola</city>
      <state>FL</state>
      <zipcode>32504</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>1139</importID>
      <name>Telerik</name>
      <level>Platinum</level>
      <url>http://www.telerik.com</url>
      <imageURL>http://www.sqlsaturday.com/files/a3fb63d6-9ff0-4953-b925-97f36eb8a9e6.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1150</importID>
      <name>Bit-Wizards</name>
      <level>Platinum</level>
      <url>http://www.bitwizards.com</url>
      <imageURL>http://www.bitwizards.com/App_themes/Bit-Wizards/images/logos/bwlogo_gradient/bwlogo_gradient-JPG.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1160</importID>
      <name>Red Gate Software</name>
      <level>Platinum</level>
      <url>http://www.red-gate.com/?utm_source=ugutm_medium=logoutm_content=sqlsaturday_columbiautm_campaign=ug</url>
      <imageURL>http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1207</importID>
      <name>Idera</name>
      <level>Platinum</level>
      <url>http://www.idera.com/</url>
      <imageURL>http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/Idera.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1100</importID>
      <name>Quest Software</name>
      <level>Gold Sponsor</level>
      <url>http://www.quest.com/sql-server/</url>
      <imageURL>http://www.quest.com/images/common/quest_logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1184</importID>
      <name>Embarcadero Technologies</name>
      <level>Gold Sponsor</level>
      <url>http://www.embarcadero.com</url>
      <imageURL>http://edn.embarcadero.com/article/images/40882/thumb02000008.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1202</importID>
      <name>Microsoft</name>
      <level>Gold Sponsor</level>
      <url>http://www.microsoft.com/windowsphone/en-us/default.aspx</url>
      <imageURL>http://i.microsoft.com/global/windowsphone/en-us/PublishingImages/windowsphone_logo.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1203</importID>
      <name>DevFish</name>
      <level>Gold Sponsor</level>
      <url>http://www.devfish.net/</url>
      <imageURL>http://www.devfish.net//images/dfbanner1.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1227</importID>
      <name>TeleVox Software Inc</name>
      <level>Gold Sponsor</level>
      <url>http://www.televox.com/company/about/</url>
      <imageURL>http://www.televox.com/graphics/televox_wtag.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1111</importID>
      <name>Overgroup Consulting, LLC</name>
      <level>Silver Sponsor</level>
      <url>http://www.overgroup.com</url>
      <imageURL>http://e.overgroup.com/images/H2O-truecolor.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1209</importID>
      <name>AppRiver</name>
      <level>Silver Sponsor</level>
      <url>http://www.appriver.com</url>
      <imageURL>http://sn143w.snt143.mail.live.com/att/GetAttachment.aspx?tnail=0messageId=9260499a-645a-11e0-a308-00237de4a318Aux=10|0|8CDC67E7CEA0B40||0|0|0|0||m</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1215</importID>
      <name>Fusion-io</name>
      <level>Silver Sponsor</level>
      <url>http://www.fusionio.com</url>
      <imageURL>http://www.fusionio.com/images/fusionio-logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1235</importID>
      <name>GrapeCity, Inc.</name>
      <level>Silver Sponsor</level>
      <url>http://www.gcpowertools.com</url>
      <imageURL>http://www.ineta.org/codechallenge/logo/GrapeCity%20PowerTools%20P%20and%20R%20200.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1236</importID>
      <name>CTS, Inc.</name>
      <level>Silver Sponsor</level>
      <url>http://www.askcts.com</url>
      <imageURL>http://sharepointsaturday.org/atlanta/SiteImages/sponsors/CTS_logo.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1102</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>1157</importID>
      <name>Confio Software</name>
      <level>Bronze Sponsor</level>
      <url>http://www.confio.com</url>
      <imageURL>http://www.confio.com/images/assets/ignite_confio_logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1189</importID>
      <name>SSWUG.ORG</name>
      <level>Bronze Sponsor</level>
      <url>http://www.sswug.org</url>
      <imageURL>http://www.sswug.org/editorial_images/SSWUG_LOGO_CLEAR.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1204</importID>
      <name>ApexSQL</name>
      <level>Bronze Sponsor</level>
      <url>http://www.apexsql.com/default.aspx</url>
      <imageURL>http://pensacola.sqlpass.org/Portals/29/ApexSQL%20Software%20Logo.gif</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1231</importID>
      <name>Perficient, Inc.</name>
      <level>Bronze Sponsor</level>
      <url>http://www.perficient.com</url>
      <imageURL>http://crossconfirm.com/images/logo-perficient.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1232</importID>
      <name>HealthWare Corporation</name>
      <level>Bronze Sponsor</level>
      <url>http://www.healthware.com</url>
      <imageURL>http://healthware.com/images/logo.png</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1234</importID>
      <name>SQL People</name>
      <level>Bronze Sponsor</level>
      <url>http://www.sqlpeople.net</url>
      <imageURL>http://mattvelic.com/wp-content/uploads/2011/05/SQLP_Logo_Sponsor.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1237</importID>
      <name>TEKsystems</name>
      <level>Bronze Sponsor</level>
      <url>http://www.teksystems.com</url>
      <imageURL>http://www.teksystems.com/images/CompTIA/sponsor-logo.jpg</imageURL>
      <imageHeight>60</imageHeight>
      <imageWidth>170</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1229</importID>
      <name>O'Reilly Publishing</name>
      <level>Book Sponsor</level>
      <url>http://oreilly.com/</url>
      <imageURL>http://cdn.oreilly.com/images/standard/oreilly-logo-footer.gif</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1255</importID>
      <name>Apress</name>
      <level>Book Sponsor</level>
      <url>http://www.apress.com</url>
      <imageURL>http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/Apress_sponsor.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1256</importID>
      <name>Wrox</name>
      <level>Book Sponsor</level>
      <url>http://www.wrox.com/WileyCDA/</url>
      <imageURL>http://media.wiley.com/assets/253/59/wrox_logo.gif</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1257</importID>
      <name>McGrawHill</name>
      <level>Book Sponsor</level>
      <url>http://www.mcgraw-hill.com/</url>
      <imageURL>http://www.mheducation.com/global_includes/images/banner_logo.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1181</importID>
      <name>Ted Krueger - LessThanDot</name>
      <level>Personal Sponsor</level>
      <url>http://lessthandot.com</url>
      <imageURL>http://blogs.lessthandot.com/media/blogs/All/LTD.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1108</importID>
      <name>Noel McKinney</name>
      <level>SQL Blogger</level>
      <url>http://noelmckinney.com/</url>
      <imageURL>http://noelmckinney.com/wp-content/uploads/2010/09/Noel-seated-compressed-NOTNULL-e1284844743579.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1114</importID>
      <name>InfoAdvisors</name>
      <level>SQL Blogger</level>
      <url>http://blog.infoadvisors.com</url>
      <imageURL>http://blog.infoadvisors.com/wordpress/wp-content/uploads/2011/03/BlogLogoBanner-small.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1134</importID>
      <name>Karla Landrum</name>
      <level>SQL Blogger</level>
      <url>http://www.karlalandrum.wordpress.com</url>
      <imageURL>http://www.gravatar.com/userimage/16784380/e57ef8681076ec40665d57ebecf2a1fc?size=20048</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1135</importID>
      <name>Rodney Landrum</name>
      <level>SQL Blogger</level>
      <url>http://www.simple-talk.com/sql/ssis/consolidating-sql-server-error-logs-from-multiple-instances-using-ssis/</url>
      <imageURL>http://www.gravatar.com/userimage/16784380/8cee550e094a6a1342f636f901112254?size=20048</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1143</importID>
      <name>Matt Velic</name>
      <level>SQL Blogger</level>
      <url>http://mattvelic.com</url>
      <imageURL>http://mattvelic.com/wp-content/uploads/2010/12/MV-SQLSat-Logo.jpg</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1205</importID>
      <name>SQLvariant</name>
      <level>SQL Blogger</level>
      <url>http://sqlvariant.com/wordpress/</url>
      <imageURL>http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
    <sponsor>
      <importID>1208</importID>
      <name>Silverwing Technologies, Inc.</name>
      <level>SQL Blogger</level>
      <url>http://www.programmersedge.com</url>
      <imageURL>http://www.programmersedge.com/images/ProgrammersEdgeLogoSmall.png</imageURL>
      <imageHeight>40</imageHeight>
      <imageWidth>100</imageWidth>
    </sponsor>
  </sponsors>
  <events>
    <event>
      <importID>3984</importID>
      <speaker>William Assaf</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>SQL Server DMV Overview</title>
      <description>What are DMV's in SQL 2005/2008, and how can you use them to improve query performance, discover indexing needs and more? Dynamic Management Views are essential tools for the SQL 2005/2008 administrator but have a wide range of applications by developers, network engineers and DBAs. Now updated with more jokes and more practical scripts!</description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
    <event>
      <importID>3987</importID>
      <speaker>Ryan Duclos</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>Introduction to SQL Azure</title>
      <description>SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer.</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>3998</importID>
      <speaker>Brad Schacht</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>Dynamic SSIS:  Configurations, Expression and Vari</title>
      <description>One of the biggest hurdles  in any organization is migrating from DEV to PROD with minimal issues.  In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier.  Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables.  After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration.  At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package!</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>4011</importID>
      <speaker>Thomas LeBlanc</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>Execution Plan Basics - Beginners</title>
      <description>This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? 


</description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4016</importID>
      <speaker>Devin Knight</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>Introduction to Data Warehousing</title>
      <description>In this session you will learn why you need a Data Warehouse, how to plan for one, and what the key steps to developing one.  You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse.  This session will focus more on the concepts of development rather than demonstrating the development itself.</description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4017</importID>
      <speaker>Devin Knight</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>Performance Tuning Analysis Services</title>
      <description>In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time.  Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>4031</importID>
      <speaker>William E Pearson III</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>Attribute Discretization in Analysis Services (BI)</title>
      <description>Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability. </description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4034</importID>
      <speaker>William E Pearson III</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>Design and Implement BI Like Edison! </title>
      <description>As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
</description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4062</importID>
      <speaker>Joe Healy</speaker>
      <track>Windows Phone Garage</track>
      <location>
        <name>Room 2175</name>
      </location>
      <title>Windows Phone Garage</title>
      <description>You're invited to spend a few hours working with 'SAMS WP7 Development in 24 Hours' book authors Kevin Wolf and Joe Healy on your Windows Phone applications.  We can play 'fix the architecture', brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications.  Every 30 minutes Joe or Kevin will supply some 'quick tips' in a lightning talk format from their book.  Bring your laptop pre-loaded with the devtools and be ready to go.</description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4063</importID>
      <speaker>Steve Jones</speaker>
      <track>MISC</track>
      <location>
        <name>Room 2176</name>
      </location>
      <title>Branding Yourself for a Dream Job - The Modern Res</title>
      <description>Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4077</importID>
      <speaker>Steve Jones</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>Preparation for Disaster</title>
      <description>This session will showcase how a DBA can be ready for any problems that might occur in their environment. Steve Jones will talk about how you can develop a well thought out backup and recovery solution for all kinds of disasters, learn about practicing restores, and the value of regularly running checks for corruption in your databases..</description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
    <event>
      <importID>4112</importID>
      <speaker>Tim Radney</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>You inherited a database, now what?</title>
      <description>You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. </description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4113</importID>
      <speaker>Michael Wells</speaker>
      <track>MISC</track>
      <location>
        <name>Room 2176</name>
      </location>
      <title>Using PowerShell to Rapidly Deploy SQL Server</title>
      <description>This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, jobs, and stored procedures.</description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4116</importID>
      <speaker>Barry Ralston</speaker>
      <track>MISC</track>
      <location>
        <name>Room 2176</name>
      </location>
      <title>PowerPivot, Idea to Solution in 60 Minutes</title>
      <description>This fast-paced session will construct a PowerPivot for SharePoint dashboard, analyzing a humorous, everyday problem-set. Beginning with installing PowerPivot for Excel and concluding with a working, interactive dashboard, this session will prepare attendees to leverage PowerPivot to load data from disparate, related sources. Limitations for creating good relationships, and the construction of good dimensions will be covered. Finally, surfacing the assembled data using slicers, charts and tables. </description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4122</importID>
      <speaker>Thomas LeBlanc</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>Transition from DBA to BI Architect </title>
      <description>Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.
</description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
    <event>
      <importID>4128</importID>
      <speaker>Shawn McGehee</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>Building SMO Apps for the Non-Programmer DBA</title>
      <description>SMO gives us an exremely powerful library that can be used to perform a slew of SQL Server tasks.  Using this library we can build tools to automate daily tasks and even build apps that might not be easy to do or even possible with SSMS/TSQL.  In this session I will teach you, the non-programmer DBA, how to build an SMO application that performs some SQL Server health checks and reports back to you in a nice GUI tool.  We will go over some basic OOP information but the bulk of this session will be hands on building/demoing. No .NET experience is required. The less experience you have with .NET development the better!!</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>4142</importID>
      <speaker>Brad Schacht</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>Pulp SQL</title>
      <description>Pulp SQL: Stories, all have them. In this session Brad and Jorge will tell the tales of how SQL in shops can go horribly wrong, and how to properly go about doing it. This story will be told Tarrantino-style so prepare for some twists, characters and ninja-like tactics* to help you avoid your own SQL mistakes!*fight scenes may or may not break out</description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4146</importID>
      <speaker>Eric Wisdahl</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>Performance Tuning With Execution Plans</title>
      <description>In this session we will look at examining execution plans as a method for performance tuning. With the execution plan we can see the exact type of operation performed, and, more than that, we can look at the differences in what the optimizer thought the query would cost vs what it actually cost to perform the query. By examining the plans we have a road map for determining what type of improvements we should be striving for in order to make the particular statement more optimal.</description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4154</importID>
      <speaker>Ted Krueger</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>SSIS: The DBA multiplier </title>
      <description>Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!
</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4184</importID>
      <speaker>Kevin Boles</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>SQL Server Partitioning from A to Z</title>
      <description>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.</description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4185</importID>
      <speaker>Kevin Boles</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>SQL Server Memory Deep Dive</title>
      <description>Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance.</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4224</importID>
      <speaker>Wayne Sheffield</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>Table Vars and Temp Tables: What you NEED to know!</title>
      <description>Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, ''When do I use one or the other and what are the various impacts of doing so?'</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4238</importID>
      <speaker>Rodney Landrum</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>T-SQL Alphabet Soup</title>
      <description>Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.  </description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
    <event>
      <importID>4239</importID>
      <speaker>Kevin  Grohoske</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>Building Occasionally Connected Apps Using SQL Azu</title>
      <description>In this presentation we will walk though utilizing Microsoft SQL Azure, a scalable cloud database service built on SQL Server technologies, and the Microsoft Sync Framework, a comprehensive synchronization platform, to build a highly available and scalable collaboration business application. Along the way we will discuss the capabilities and challenges of building such an application using the current frameworks.</description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4241</importID>
      <speaker>Troy Ketsdever</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>Predictive Analytics - You Can, Too!</title>
      <description>Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…</description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4256</importID>
      <speaker>Bryan Soltis</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>Deploying Kentico CMS Applcaition to Windows Azure</title>
      <description>In this session, Bryan Soltis will demonstrate deploying a Kentico CMS application to Windows Azure. Topics covered will include converting a Kentico CMS site to a web application, adding and configuring a Windows Azure web role, implementation and configuration of Windows Azure storage accounts, deployment of a Kentico CMS database to SQL Azure, and deploying the application to Windows Azure. Bryan will demonstrate several code examples, real world applications, and best practices in developing Kentico CMS in the cloud.</description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4262</importID>
      <speaker>Rob Volk</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>Revenge: The SQL!</title>
      <description>Have you been wronged, cheated, lied to, lied about, or deceived by a coworker?  Feel like your DBA position offers no opportunity for revenge?  WRONG!

This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them.  (But they deserved it!)  Learn how to:  create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL.  You may never get to use these techniques…but you'll ache for the chance!</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4264</importID>
      <speaker>Audrey Hammonds</speaker>
      <track>DBA and TSQL</track>
      <location>
        <name>Room 1780</name>
      </location>
      <title>T-SQL Awesomeness: 3 Ways to Write Cool SQL</title>
      <description>There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. 

Come learn three new-school ways to expand your T-SQL repertoire with: • Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY 

We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills. </description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4268</importID>
      <speaker>Julie Smith</speaker>
      <track>SSIS and BI</track>
      <location>
        <name>Room 1776</name>
      </location>
      <title>Up and Running with SSIS in 5,4,3,2, (Datachix)1 !</title>
      <description>This presentation is for those familiar with SQL Server, but absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour, stepping through a classic 'old pro' DBA forced into Beginner ETL Developer scenario. We'll quickly cover not just developing the package, but also ways to deploy and execute.  </description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4269</importID>
      <speaker>Aaron Nelson</speaker>
      <track>MISC</track>
      <location>
        <name>Room 2176</name>
      </location>
      <title>Loading Data with PowerShell</title>
      <description>In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table.  We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell.  Finally we'll re-use our newly found XML scills to modify an SSIS package before we run it.</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>4275</importID>
      <speaker>Vincent Mayfield</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>Windows Azure Overview</title>
      <description>Should you be be looking to the Cloud? Your path to blue skies might be through Windows Azure Platform.Windows Azure is just one element of Microsoft's Cloud Computing Strategy. There are a wide variety of Cloud Services and Cloud Technology offerings from Microsoft. This session will focus on Windows Azure and the Microsoft offerings under this umbrella. It will provide developers and business people an overview of Windows Azure.</description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
    <event>
      <importID>4285</importID>
      <speaker>Aaron Nelson</speaker>
      <track>Performance</track>
      <location>
        <name>Room 2171</name>
      </location>
      <title>Quickly Gather Performance Data with PowerShell</title>
      <description>Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment.  Having quick access to what’s happening right now is equally important.  In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info.  We’ll also take a look at how to Visualize the data using charts.  </description>
      <startTime>6/4/2011 3:00:00 PM</startTime>
      <endTime>6/4/2011 4:00:00 PM</endTime>
    </event>
    <event>
      <importID>4289</importID>
      <speaker>Mike Huguet</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>The Power of ASP.NET 4.0 Dynamic Data</title>
      <description>ASP.NET Dynamic Data is now a matured offering of the .NET framework.  In this session we will take a feature tour demonstrating its power and flexibility.  We’ll discuss practical usages and customizations.  </description>
      <startTime>6/4/2011 8:30:00 AM</startTime>
      <endTime>6/4/2011 9:30:00 AM</endTime>
    </event>
    <event>
      <importID>4290</importID>
      <speaker>Mike Huguet</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>Leveraging Open XML to Create More Dynamic Docs</title>
      <description>Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions.  We’ll also discuss the role of some of the SharePoint Office Services.</description>
      <startTime>6/4/2011 11:00:00 AM</startTime>
      <endTime>6/4/2011 12:00:00 PM</endTime>
    </event>
    <event>
      <importID>4314</importID>
      <speaker>Joe Healy</speaker>
      <track>Windows Phone Garage</track>
      <location>
        <name>Room 2175</name>
      </location>
      <title>Windows Phone Garage (Continued)</title>
      <description>You're invited to spend a few hours working with 'SAMS WP7 Development in 24 Hours' book authors Kevin Wolf and Joe Healy on your Windows Phone applications. We can play 'fix the architecture', brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications. Every 30 minutes Joe or Kevin will supply some 'quick tips' in a lightning talk format from their book. Bring your laptop pre-loaded with the devtools and be ready to go.</description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4315</importID>
      <speaker>Steve Jones</speaker>
      <track>DBA</track>
      <location>
        <name>Room 1775</name>
      </location>
      <title>RedGate Tools Demonstration</title>
      <description>TBA</description>
      <startTime>6/4/2011 12:45:00 PM</startTime>
      <endTime>6/4/2011 1:30:00 PM</endTime>
    </event>
    <event>
      <importID>4486</importID>
      <speaker>Sven Aelterman</speaker>
      <track>MISC</track>
      <location>
        <name>Room 2176</name>
      </location>
      <title>Entity Framework v4.1: What's New in 2011</title>
      <description>Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a 'code only' approach, which has many benefits, including for testability and long-term evolution of your code.</description>
      <startTime>6/4/2011 4:15:00 PM</startTime>
      <endTime>6/4/2011 5:15:00 PM</endTime>
    </event>
    <event>
      <importID>4487</importID>
      <speaker>Sven Aelterman</speaker>
      <track>DEV</track>
      <location>
        <name>Room 2172</name>
      </location>
      <title>Entity Framework Quick Introduction</title>
      <description>For those attendees who want to attend the Entity Framework version 4.1 session, but aren’t quite sure what Entity Framework is, and how to get started with the basics, this talk with some background info and basic demos will get you up to speed. This will use the traditional EF approach of creating a model using a designer based on an existing or new database.</description>
      <startTime>6/4/2011 9:45:00 AM</startTime>
      <endTime>6/4/2011 10:45:00 AM</endTime>
    </event>
    <event>
      <importID>4534</importID>
      <speaker>Russ Fustino</speaker>
      <track>Windows Phone Garage</track>
      <location>
        <name>Room 2175</name>
      </location>
      <title>How to Make (more) Money with WP7</title>
      <description>When you get your app running… and even more so when published… you are most likely feeling pretty good and on cloud 9. It feels great, doesn’t it? Here are a few suggestions in this chapter to make you feel even better. Of course, more work is needed. Getting your app noticed in marketplace will not happen automatically or optimally by publishing alone. There specific suggestions I will offer up to help the cause. So, grab a deep breath and get ready to settle in and focus on making more money. Make all the time you have invested so far, well worth it. Many of the suggestions are common sense when you think them through, but are a few I found out the hard way and hopefully will save you some pain.  Topics include: Marketing Basics,  Gettin</description>
      <startTime>6/4/2011 1:45:00 PM</startTime>
      <endTime>6/4/2011 2:45:00 PM</endTime>
    </event>
  </events>
</GuidebookXML>