﻿<?xml version="1.0" encoding="utf-8"?>
<Collection xmlns:p="http://schemas.microsoft.com/livelabs/pivot/collection/2009" SchemaVersion="1.0" Name="24hrs of PASS Events - hosted by LobsterPot Solutions" p:BrandImage="http://pivot.lobsterpot.com.au/favicon_LP.png" xmlns="http://schemas.microsoft.com/collection/metadata/2009">
  <FacetCategories>
    <FacetCategory Name="Event" Type="String" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Track" Type="String" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Date" Type="DateTime" p:IsFilterVisible="true" p:IsWordWheelVisible="false" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Time" Type="String" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Speaker Name" Type="LongString" p:IsFilterVisible="false" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Session Description" Type="LongString" p:IsFilterVisible="false" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Speaker Description" Type="Link" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Spreaker Company" Type="String" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Live Meeting Presentation" Type="Link" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
    <FacetCategory Name="Live Meeting Replay" Type="Link" p:IsFilterVisible="true" p:IsWordWheelVisible="true" p:IsMetaDataVisible="true" />
  </FacetCategories>
  <Items ImgBase="24hrsOfPASSEvents_files\lcvnoqmt.uiz.xml">
    <Item Id="0" Img="#0" Name="Zero to Cube: Fast Track to Analysis Services Development" Href="http://www.sqlpass.org/24hours/fall2010/Home/ZerotoCubeFastTracktoAnalysisServicesDeve.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="21:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Adam Jorgensen" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="This session is a SQLSaturday legend! Have you wanted to start using Analysis Services to deliver self-service BI to your end users? Have you started a cube project but have trouble using additional functionality such as Actions and KPIs? This session is a great all-hands-on experience where we build a fully functional cube in one hour with all the bells and whistles. This session is all demo and very interactive to make sure everyone gets the information and has a good time. Even experienced SSAS developers will learn something!" />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Adam Jorgensen is the President of Pragmatic Works Consulting, a global Business Intelligence software and solutions firm based in Jacksonville, FL. He has been delivering SQL Server solutions for over a decade, and his passion is finding avenues for clients and the community to embrace BI and lower barriers to implementation.&#xA; &#xA;Adam, an MBA and MCITP: BI, is a co-founder of BIDN.com and the co-host of SQLLunch.com, a weekly, live, virtual event. Adam is a regular contributor to the PASS BI Virtual Chapter and speaks often at industry events, conferences, Code Camps, and SQLSaturdays on strategic and technical topics." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Pragmatic Works Consulting" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-21PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-21PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-21PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-21PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="1" Img="#1" Name="What's Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects" Href="http://www.sqlpass.org/24hours/2010/Sessions/WhatsReallyHappeningonYourServer.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="17:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Adam Machanic" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="There are two kinds of DBAs in this world: Those who scratch their heads, unsure of how to find answers, and those who demand real-time, comprehensive insight. This session is for the latter type—the Type A DBAs who are serious about managing their servers as efficiently as possible.&#xA;&#xA;Dynamic Management Objects, a set of views and functions that first shipped with SQL Server 2005, are a window into the inner workings of your SQL Server instance. Locked within the objects is the information you need to help you solve virtually any performance problem, quickly debug issues as they're occurring, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions—information gleaned from heavy use of the objects in a number of environments over the past 5 years. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. No longer will you need to scratch your head, wondering what is slowing down your queries: You will be the master of your SQL Server instance." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Adam Machanic is a Boston-based independent database consultant, writer, and speaker. Adam has written for numerous Web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including &quot;SQL Server 2008 Internals&quot; (Microsoft Press, 2009) and &quot;Expert SQL Server 2005 Development&quot; (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and Microsoft .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Database Consultant" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_05PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_05PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_05PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_05PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="2" Img="#2" Name="SQLBI Methodology" Href="http://www.sqlpass.org/24hours/fall2010/Home/SQLBIMethodology.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="14:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Alberto Ferrari and Marco Russo" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="When it comes to implementing a data warehouse using the SQL Server suite, you have to make several SQL Server-specific decisions about technology and implementation that could mean the difference between the success or failure of your data warehouse project. This session will introduce you to the SQLBI Methodology—an approach has been developed over the years to account for all the architectural and technological decisions that you have to make when implementing a complete Business Intelligence solution using SQL Server, Integration Services, and Analysis Services. This methodology is focused on medium to large data warehouses, but with a reduced overhead compared to the classic Kimball methodology, you can use it for small data warehouses too. The big advantage of the SQLBI Methodology is flexibility in terms of design and maintenance. You can download SQLBI Methodology draft papers at http://www.sqlbi.com/sqlbimethodology." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Marco Russo is a Business Intelligence and software development consultant and trainer. He has particular competence and experience with BI solutions in financial services (including complex OLAP designs in the banking industry), manufacturing, and commercial distribution sectors. Marco wrote the paper “The Many-to-Many Revolution” about multidimensional modeling and is a co-author of the “SQLBI Methodology” and of the books Microsoft PowerPivot for Excel 2010: Give Your Data Meaning, Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, and Programming Microsoft LINQ. He has spoken at previous PASS Summits and at the Microsoft BI Conference.&#xA;&#xA;Alberto Ferrari is a BI development consultant and trainer in Italy. His main interest is in the methodical approaches to BI development, which he and Marco Russo lay out in SQLBI Methodology. He spent several years working with SSIS and SSAS for the banking and manufacturing industries and typically works as a consultant for software developers interested in building complex BI solutions." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="SQLBI" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-14PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-14PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-14PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-14PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="3" Img="#3" Name="Gather SQL Server Performance Data with PowerShell" Href="http://www.sqlpass.org/24hours/fall2010/Home/GatherSQLServerPerformanceDatawithPowerShell.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="13:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Allen White" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="We all know how important it is to keep a baseline of performance metrics that let us know when something is wrong and help us track down and fix the problem. However, we don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts that you can schedule against SQL Server (2008, 2005, 2000) to capture the most important data and will then show you how to build reports that use that data to keep your server running smoothly." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. With over 35 years of experience in IT, he has been using SQL Server since 1992 and is certified MCITP in SQL Server and an MCT. Allen has been named a Microsoft MVP for the past four years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell. You can read his blog atsqlblog.com/blogs/allen_white/." Href="http://sqlblog.com/blogs/allen_white/default.aspx" />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Upsearch Technology Services" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-13PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-13PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-13PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-13PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="4" Img="#4" Name="Database Development Patterns" Href="http://www.sqlpass.org/24hours/2010/Sessions/DatabaseDevelopmentPatterns.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="13:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Andy Leonard" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Designed for software developers tasked with database development, this practical session features:&#xA;&#xA;Patterns and anti-patterns of database development&#xA;One way to build re-executable T-SQL deployment scripts&#xA;A method for using SqlCmd to deploy re-executable T-SQL deployment scripts&#xA;Fodder for a lively discussion about NULLs" />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP and PASS Regional Mentor Andy Leonard is an architect with Unisys Corporation, a SQL Server database and Integration Services developer, and an engineer. His background includes Web application architecture and development, Visual Basic, ASP, SQL Server Integration Services, and data warehouse development using SQL Server 2000, 2005 and 2008. He is a coauthor of Professional SQL Server 2005 Integration Services (Wrox) and SQL Server MVP Deep Dives (Manning Publications) and blogs for SQLBlog.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Unisys Corporation" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_01PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_01PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_01PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_01PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="5" Img="#5" Name="Managing Teams" Href="http://www.sqlpass.org/24hours/fall2010/Home/ManagingTeams.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="PD" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="16:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Andy Leonard" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you! Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Andy Leonard is an Architect with Molina Medicaid Solutions, a SQL Server database and Integration Services developer, a SQL Server MVP, a PASS Regional Mentor, and an engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes Web application architecture and development, VB, ASP, SQL Server Integration Services (SSIS), and data warehouse development using SQL Server 2008, 2005, and 2000. Andy blogs at sqlblog.com/blogs/andy_leonard/, and you can follow him on Twitter at @AndyLeonard." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Molina Medicaid Solutions" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-16PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-16PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-16PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-16PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="6" Img="#6" Name="Manage Your DBA Career, Don’t Let it Manage You " Href="http://www.sqlpass.org/24hours/2010/Sessions/ManageYourDBACareerDontLetItManageYou.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="PD" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="00:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Brad McGehee" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Many people tend to &quot;fall into&quot; their career instead of making a conscious decision as to what their career should be. Because of this, many people wander about in their career, not particularly satisfied with how it is going. Instead of letting your career manage you, all DBAs can learn to manage their own career by consciously taking control of it. By doing so, not only will you have a financially rewarding career, but one that gets you excited about life and your contribution to it.&#xA;&#xA;In this session, you will learn specific steps to follow to take control of your career, including:&#xA;&#xA;Defining your career path&#xA;Deciding if you want to be an average or exceptional DBA&#xA;Selecting a career specialty&#xA;Determining how to match your career with your personal goals&#xA;Developing the appropriate skill sets&#xA;Managing your brand&#xA;Whether you are successful in your career or not boils down to the following: deciding what you want out of your career; developing specific goals; and taking action. This session is targeted at DBAs who are tired of letting their career just happen and want to take control of it." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Brad M. McGehee, Director of DBA Education for Red Gate Software, is a SQL Server MVP with over 15 years’ SQL Server experience and over 6 years’ training experience. He has been involved in the industry since 1982 and is a MCSE+I, MCSD, and former MCT with a bachelors’ degree in economics and an MBA.&#xA;&#xA;Brad is a frequent speaker at PASS Summit, PASS European Conference, SQL Connections, SQLTeach, devLINK, SQLBits, SQLSaturday, TechFests, Code Camps, SQL Server user groups, and other industry seminars. Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans. These books are available for free in PDF format at http://www.sqlservercentral.com/Books/." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Red Gate Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_00AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_00AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_00AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_00AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="7" Img="#7" Name="Automate Your Database Maintenance Using Ola Hallengren’s Free Script" Href="http://www.sqlpass.org/24hours/fall2010/Home/AutomateYourDatabaseMaintenanceUsingOlaHalle.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="19:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Brad McGehee" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="One of the common ways that DBAs (especially novice DBAs) create database maintenance plans is to use the Maintenance Plan Wizard. But the wizard isn’t very flexible, and if it isn’t properly used, it can result in poor database maintenance plans. More experienced DBAs often use T-SQL or PowerShell scripts to create custom database maintenance plans.&#xA; &#xA;However, a lot of experienced DBAs lack the time to create their own scripts, and many novice DBAs don’t have the knowledge to create custom scripts. If you can’t create your own custom scripts, is your only option to use the Maintenance Plan Wizard?&#xA; &#xA;Fortunately, there are many generic database maintenance scripts that are much more flexible and powerful than those created by the Maintenance Plan Wizard. In this session, we look at a T-SQL database maintenance script written by Ola Hallengren, which not only offers great flexibility but is easy to implement, even by inexperienced DBAs." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Brad M McGehee is a SQL Server MVP and the Director of DBA Education for Red Gate Software. He is a frequent speaker at PASS Summit, PASS European Conference, SQL Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, TechFests, Code Camps, and SQL Server user groups.&#xA; &#xA;A well-respected name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans. He blogs at www.bradmcgehee.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Red Gate Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-19PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-19PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-19PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-19PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="8" Img="#8" Name="BLITZ! 60 Minute Server Takeovers " Href="http://www.sqlpass.org/24hours/2010/Sessions/BLITZ60MinuteServerTakeovers.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="11:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Brent Ozar" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="You’re minding your own business in your corner office—well, since you’re a DBA, it’s just your cubicle—when somebody asks, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this all-demo session, you’ll see how to take over a SQL Server and:&#xA;&#xA;Quickly assess a server’s health using a set of scripts&#xA;Catch dangerous development issues that will haunt you later&#xA;Quickly put some basic measures into place to minimize your risk" />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Brent Ozar—a SQL Server Domain Expert with Quest Software and a SQL Server MVP—has a decade of broad IT experience in SQL Server database administration; systems, SAN, and virtualization administration; and project management. In his current role, Brent specializes in performance tuning, virtual and cloud-based database servers, and disaster recovery. Previously, he spent 2 years at Southern Wine &amp; Spirits, a Miami-based wine and spirits distributor. Brent conducts training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He coauthored Professional SQL Server 2008 Internals and Troubleshooting (Wrox)." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Quest Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_11AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_11AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_11AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_11AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="9" Img="#9" Name="Introduction to PowerPivot " Href="http://www.sqlpass.org/24hours/2010/Sessions/IntroductiontoPowerPivot.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="12:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Brian Knight" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this level -200 session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. See how Office 2010 and SQL Server 2008 R2 can help your users answer their own questions and bring together datasets that may be heterogeneous, such as a SQL Server table and data feed from a Web site. Then see how to take that data and create a striking report for your end users as well as collaborate with the data in SharePoint. Key takeaways include how to use PowerPivot to create a culture of self-service BI and how to use SharePoint to share that business intelligence with others." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP Brian Knight, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He works as an independent consultant for Pragmatic Works and has written nine books on SQL Server over his 10-year database career." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Pragmatic Works" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_12PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_12PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_12PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_12PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="10" Img="#10" Name="Upgrading DTS Packages to SSIS" Href="http://www.sqlpass.org/24hours/fall2010/Home/UpgradingDTSPackagestoSSIS.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="12:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Brian Knight" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this level-200 session, learn options for converting your Data Transformation Services packages to SQL Server Integration Services. The Microsoft “End of Life” policy for SQL Server 2000 has encouraged many organizations to seriously look at migrating their SQL Server 2000 servers to SQL Server 2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue.&#xA; &#xA;To gain the performance benefits and a supported path forward for the functionality in DTS, these DTS packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join us for this session and learn:&#xA;Why you should upgrade from DTS to SSIS&#xA;The advantages of SSIS over DTS&#xA;Options for converting DTS packages to native SSIS&#xA;How to add value to packages during the conversion process&#xA;How to assess the scope of a DTS conversion project (time, costs)&#xA;&#xA;You’ll also see a demonstration of DTS xChange, a tool for converting DTS packages." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Brian Knight—SQL Server MVP, MCITP, MCSE, and MCDBA—is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. Brian, a contributing columnist at several technical magazines, does regular webcasts at Jumpstart TV and is the author of a dozen SQL Server books. He runs the local SQL Server users group in Jacksonville, FL (JSSUG) and is a regular speaker at PASS Summit, SQL Connections, Microsoft Tech Ed, and Code Camps. You can read his blog at www.bidn.com/blogs/BrianKnight." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Pragmatic Works" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-12PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-12PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-12PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-12PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="11" Img="#11" Name="Preparing For Your Next Job" Href="http://www.sqlpass.org/24hours/fall2010/Home/PreparingforYourNextJob.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="PD" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="15:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Chris Shaw" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="People make mistakes day in and day out. But the time you don’t want to make a mistake is during an interview. In this session, we will review a number of interviews that I have conducted and the mistakes that were made that inspired me to continue looking for the right candidate. The goal of this session is to learn from the mistakes of others so that we can put our best foot forward." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Chris Shaw started his database career while in the Marine Corps working with Lotus Ami Pro databases in 1993. From there, he went on to companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. and later consulted with insurance companies, including Anthem Blue Shield. Chris has enjoyed writing and speaking about SQL Server over the past 10 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences, where Chris was the conference chair. Chris received the Microsoft MVP award. He is the founding member of the Colorado Springs SQL Server User Group and is currently blogging on chrisshaw.wordpress.com and sswug.org and writing his book, How to Find Your Next DBA Job." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="SQLShaw" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-15PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-15PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-15PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-15PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="12" Img="#12" Name="Multi-Server Management With UCP, MDW and PBM" Href="http://www.sqlpass.org/24hours/2010/Sessions/MultiServerManagementwithUCPMDWandPBM.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="06:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Chuck Heinzelman" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Many of us are managing multiple servers, with multiple instances and many databases. SQL Server provides some great tools for dealing with your installations, but much of the data that is generated is still distributed across your servers. If you have problems getting a comprehensive snapshot of your environment, this session is for you. Come see how to use system data collectors and user-defined data collectors to centralize all of that data onto your Utility Control Point and use that data to build dashboards." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Chuck Heinzelman is a Senior Database Administrator with Big Hammer Data, a division of Edgenet, Inc. At Big Hammer, Chuck’s primary role is database design and development, with the occasional sidestep into server configuration and administration. He holds a BS degree in Management Computer Systems from the University of Wisconsin – Whitewater and is currently working on his MBA from the University of Wisconsin – Milwaukee. He has been working with SQL Server since 1998 and also has experience developing Windows and Web applications using Visual Basic and C#.&#xA;&#xA;Chuck has been involved with PASS since 2000, serving in many capacities, including author, editor, and past member of the Board of Directors. He is a SQL Server MVP and a charter member of the Wisconsin SQL Server User Group." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Big Hammer Data" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_06AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_06AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_06AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_06AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="13" Img="#13" Name="Why Data Warehousing Projects Fail (And What You Can Do About It)" Href="http://www.sqlpass.org/24hours/fall2010/Home/WhyDataWarehousingProjectsFailandWhatYouC.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="14:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Craig Utley" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Craig Utley is a Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft's first data warehousing course. Since then, he has consulted at a variety of businesses worldwide on their BI solutions as an independent consultant, a ProClarity consultant, and a member of SQLCAT. Craig is a former MVP in SQL Server and C#." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-14PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-14PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-14PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-14PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="14" Img="#14" Name="SQL Tuning - Get it Right the First Time " Href="http://www.sqlpass.org/24hours/2010/Sessions/SQLTuningGetItRighttheFirstTime.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="04:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Dean Richards" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Whether you are a developer or DBA, you can determine the best execution plan for a query every time by using the SQL diagramming techniques outlined in this session. Regardless of the complexity of the statement or database platform you’re using (this method works on all), this quick and 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 in tuning SQL." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Dean Richards has over 20 years of performance tuning, implementation, and strategic database architecting experience. Before coming to Confio, Dean was a technical director for Oracle Corporation, managing and performing consulting work at several key accounts. Dean has focused his entire career on performance tuning of Oracle and SQL Server environments." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Confio Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_04AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_04AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_04AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_04AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="15" Img="#15" Name="Storage for the DBA" Href="http://www.sqlpass.org/24hours/fall2010/Home/StoragefortheDBA.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="16:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Denny Cherry" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="One of the biggest issues in database performance centers around storage. Storage is also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. This session covers storage from both the database and storage perspectives. We’ll dig into LUNs, HBAs, and the fabric, as well as RAID groups. In addition to theory, we’ll look at an actual EMC SAN so that you can translate what you see in the storage array with what you see on the actual server." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Denny Cherry has over a decade of experience managing SQL Server, including some of the largest installations in the world. His areas of technical expertise include system architecture, performance tuning, replication, and troubleshooting. He uses these skills on a regular basis in his current role as the Manager of Information Systems at Awareness Technologies.&#xA; &#xA;Denny, a Microsoft MVP, currently holds many of the Microsoft certifications related to SQL Server for versions 2000 through 2008. He is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written many technical articles on SQL Server management and how SQL Server integrates with enterprise storage." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Awareness Technologies" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-16PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-16PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-16PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-16PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="16" Img="#16" Name="TempDB Configuration and Management" Href="http://www.sqlpass.org/24hours/fall2010/Home/TempDBConfigurationandManagement.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="01:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Dipti Sangani" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="TempDB  is a critical shared resource on a SQL Server installation. Understanding and planning your TempDB very carefully can greatly impact the performance of your workload on the system.  In this session you will learn about TempDB, common TempDB related bottlenecks. You will also learn about various tools available to you  to understand these bottlenecks and recommendations/best practices around avoiding these issues." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Dipti Sangani started hercareer as a Support Engineer supporting SQL Server for enterprise customers. After getting some hands-on experience in the field and working with customers, she moved to the SQL Server development team as a Program Manager for the SQL Server core engine team. Dipti has over 10 years of experience working with SQL Server in various capacities starting with Support engineer to QFE/Release manager and she is now a feature Program Manager on the engine team." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="17" Img="#17" Name="Exploring SQL Server Security " Href="http://www.sqlpass.org/24hours/2010/Sessions/ExploringSQLServer2005and2008Security.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="20:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Don Kiely" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="There are few corporate assets as valuable in the information age as data. Enterprises spend billions to collect and generate it, slice and dice it in every conceivable way to mine marketplace intelligence from it, and replicate and back it up using elaborate, redundant schemes. Yet it is all too common to slack on security. Sure, SQL Server 2005 and 2008 are designed to be “secure by default,” but once you add databases and start letting users and their applications access the server, you’ve already poked holes in the security. SQL Server comes with plenty of features that let you secure data, but it can be hard to get a handle on the right ones to use in your environment. This session explores the myriad security features in SQL Server and how to put them to use in applications." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP Don Kiely, MCSD, is a technology consultant who develops secure Web applications using SQL Server, VB, C#, AJAX, and ASP.NET. He writes regularly for such industry journals as Visual Studio Magazine, MSDN Magazine, CoDe Magazine, SQL Server Magazine, and asp.netPRO. Don trains developers and speaks regularly at industry conferences, including TechEd, PASS Summit, DevConnections, and DevTeach. He is a member of the INETA and MSDN Canada speaker bureaus and writes courseware and records videos for AppDev.&#xA;&#xA;In his other life, Don roams the Alaska wilderness by foot, dog sled, skis, and kayak. Contact him at donkiely@computer.org." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="AppDev" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_08PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_08PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_08PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_08PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="18" Img="#18" Name="Filtered Indexes, Sparse Columns: Together, Separately " Href="http://www.sqlpass.org/24hours/2010/Sessions/FilteredIndexesSparseColumns.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="18:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Don Vilen" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server 2008 introduced Filtered Indexes and Sparse Columns. Although they are perhaps especially powerful when used together, they also can be used independently. This session covers the basics and then dives into the areas where they work well—and not so well—both together and separately." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Don Vilen is Chief Scientist at Buysight in Palo Alto, gaining insight into data to better serve our customers. For the previous 3 years Don was Principal Architect at Scalability Experts, working with SQL Server customers around the world, guiding them through performance, upgrade, migration, and consolidation projects. Prior to November 2007, Don was on the SQL Server team in Redmond, with 13 years of SQL Server experience at Microsoft. For 6 years Don was a Program Manager on the Storage Engine component of SQL Server, focusing on HA and the storage of large objects. For the preceding 4 years Don created and delivered training for Microsoft's SQL Server support engineers worldwide. Prior to joining Microsoft, Don was on the computer science faculty at a California university and was also the VP of Software Dev for a software company." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Buysight" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_06PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_06PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_06PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_06PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="19" Img="#19" Name="Solving common business problems with Microsoft PowerPivot " Href="http://www.sqlpass.org/24hours/2010/Sessions/SolvingCommonBusinessProblemswithMicrosoftPo.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="19:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Donald Farmer" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="You may have already seen PowerPivot in action at various PASS keynotes and sessions. If so, you’ll know about the exciting power of this new product, but have you considered its practical business application? In this session, we look at some common business scenarios where PowerPivot is uniquely placed to help. In particular, we delve into some sales analytics, some inventory management, and how to calculate key business metrics. Along the way, we’ll learn more about PowerPivot and its unique approach to analytics." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Donald Farmer has served on the Microsoft Business Intelligence team for 9 years, working on several teams and technologies in that time. A popular speaker at international events for both business and technical audiences, he has a wide range of interests, including data integration, information quality, metadata intelligence, master data management, and predictive analytics. He is a Guest Professor at the College of Software and Information Science, Southwestern University at Chongqing, China, and is the author of a number of books and articles. Before joining Microsoft, Donald worked not only in Business Intelligence but in fields as varied as medieval archaeology and fish farming" />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="20" Img="#20" Name="How to Rock Your Presentations" Href="http://www.sqlpass.org/24hours/fall2010/Home/HowtoRockYourPresentations.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="PD" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="21:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Douglas McDowell" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Just because you’re a technical rock star doesn’t mean your technical presentation is going to rock. And even if you own the room for technical presentations, you may find that your business presentations often fall short. This session is for veteran presenters as well as first-timers, offering prescriptive guidance and best practices for structuring, building, and delivering a compelling presentation every time—whether technical or non-technical. Effective and persuasive presentation skills are critical for survival and success in the workplace—this is a session worth checking out." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Douglas McDowell is the CEO, North America, for Solid Quality Mentors. He is a SQL Server MVP, has lots of certifications, serves as the Director of Technology &amp; Chapters on the PASS Board of Directors, and is an author and contributing editor for SQL Server Magazine. Douglas completed his MBA at Penn State’s Smeal College of Business and also holds a Masters of Information Technology and a degree in Culinary Arts. Douglas is a passionate speaker about the value of Business Intelligence realized through successful architectures and implementations." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-21PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-21PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-21PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-21PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="21" Img="#21" Name="SQL Server R2 Utility" Href="http://www.sqlpass.org/24hours/fall2010/Home/SQLServerR2Utility.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-17T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="00:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Eddie Fong" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server 2008 R2 introduces the Utility Control Point (UCP) for multi-server management. The UCP provides a central point of reasoning for analyzing resource utilization and configuration information across a distributed deployment containing large numbers of SQL Server instances and database applications.  This session will review the user experience for multi-server management using the UCP.  You will see how the UCP is created and SQL Server instances become managed, and how resource health policy provided by the UCP can be used to perform capacity management.  This session will also look under the covers at the design of the UCP and managed instances including their key components and workflows." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Eddie Fong has been working with SQL Server since 2002 working on WinFS and SQL Server 2008 in a release management capacity. He recently joined the SQL Server Manageability team as a Lead Program Manager responsible for PBM, UCP, Config Manager/WMI and a soon to be released Project Houston." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-00AM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-00AM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-00AM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-00AM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="22" Img="#22" Name="Getting Started with SQL Server Utility in SQL Server 2008 R2 " Href="http://www.sqlpass.org/24hours/2010/Sessions/GettingStartedwithSQLServerUtilityinSQLSer.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="15:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Glenn Berry" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server 2008 R2 introduces the new SQL Server Utility, which lets you manage and monitor up to 25 instances of SQL Server 2008 R2 from a single Utility Control Point (UCP). SQL Server Utility lets you automatically gather and store historical data on CPU and disk space usage for these managed instances, and you can set policies to notify you about over-utilization of these resources by instance. This session shows you how to create a UCP, enroll managed instances for monitoring, and set policies to improve your management capabilities with SQL Server Utility." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS—which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in SQL Server MVP Deep Divesand blogs regularly at glennberrysqlperformance.spaces.live.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="NewsGator Technologies" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_03PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_03PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_03PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_03PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="23" Img="#23" Name="Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance" Href="http://www.sqlpass.org/24hours/fall2010/Home/Hardware201SelectingandSizingDatabaseHardwa.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="15:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Glenn Berry" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage, have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS—which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University - University College. He is the author of two chapters in SQL Server MVP Deep Divesand blogs regularly at glennberrysqlperformance.spaces.live.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="NewsGator Technologies" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-15PM-downloadHFP/ReplayMeeting.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-15PM-downloadHFP/ReplayMeeting.htm" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="24" Img="#24" Name="Identifying Costly Queries" Href="http://www.sqlpass.org/24hours/fall2010/Home/IdentifyingCostlyQueries.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="20:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Grant Fritchey" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="My Spotlight session at PASS Summit will show you how to use execution plans to identify problems in your queries, ways to fix those problems, and what the execution plan will look like after you’re through. But before you dive into the execution plans, you need to identify the queries and procedures that are causing your system the most pain. This introductory-level session will explain several useful ways to gather metrics on query performance. You will learn what a server-side trace is, how to set one up, and why you would want to. You’ll learn mechanisms for identifying costly queries by using the information from inside the server’s memory. You’ll also see several ways that SQL Server Management Studio can help you gather performance metrics. With the information and skills you’ll gain in this session, you can begin to systematically identify the queries that are hurting performance in your system, and you’ll be able to get that information right away." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Grant Fritchey works as a database administrator for FM Global, an engineering and insurance company. Grant has 20+ years of experience in IT, including time spent in support and development. He has been working with SQL Server since version 6.0 in 1995. He has experience developing in VB, VB.NET, C#, and Java. Grant volunteers with PASS and currently serves as president of the Southern New England SQL Server Users Group (SNESSUG). He has written two books, SQL Server 2008 Query Performance Tuning Distilled and SQL Server Execution Plans, and was awarded SQL Server MVP status in 2009 and 2010." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="FM Global" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-20PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-20PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-20PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-20PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="25" Img="#25" Name="Reporting Services Enhancements in SQL Server 2008 R2" Href="http://www.sqlpass.org/24hours/2010/Sessions/ReportingServicesEnhancementsinSQLServer2008.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="03:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Greg Low" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Gain a good understanding of the enhancements to SQL Server Reporting Services shipping as part of SQL Server 2008 R2. This session digs into Report Builder changes, using reports as data sources, the incorporation of map data, and a number of general reporting enhancements." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP and Microsoft Regional Director Greg Low is a well-known international SQL Server consultant and trainer. The country lead for Solid Quality Mentors in Australia (SolidQ Australia), Greg is a PASS Regional Mentor and regularly presents at Microsoft and PASS events around the world." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_03AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_03AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_03AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_03AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="26" Img="#26" Name="SQL Server Security Tips &amp; Tricks" Href="http://www.sqlpass.org/24hours/fall2010/Home/SQLServerSecurityTipsTricks.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-17T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="01:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Il-Sung Lee" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server 2008 provides a wealth of security features to help satisfy business as well as compliance goals. While you've probably used some of the features, there are probably some new things you can learn. For example, do you how to periodically rotate the database encryption key automatically? Or how to detect whenever an Audit in any of your instances is disabled or modified? Come to this session to learn the answer to these questions as well as a few other tips and tricks." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Il-Sung Lee is a Senior Program Manager for the Engine team in the SQL Server product group and is the PM owner for SQL Server Engine Security component.  Il-Sung has over twelve years of experience in the database industry as a developer and a program manager focusing on database security and database communications. His current focus is to advance the capabilities of SQL Server in areas such as authentication, authorization, cryptography, audit, and data leak prevention. He is a regular presenter at TechEd and SQLPASS and has spoken at numerous other domestic and international conferences over the past several years. Il-Sung graduated with an M.Eng degree from McGill University and subsequently worked for several years at IBM in their Information Management group prior to joining Microsoft, initially with the SQL Server Protocols team before moving to the Core Security Infrastructure area." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-01AM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-17-2010-01AM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-01AM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="27" Img="#27" Name="Data Tier Applications (DACPAC)" Href="http://www.sqlpass.org/24hours/2010/Sessions/DataTierApplications.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="16:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jacob Sebastian" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Focusing on the new Data Tier Application (DAC) support in the SQL Server 2008 R2 November CTP, this session looks into the challenges that DBAs and application developers face in making, reviewing, validating, managing, and deploying database changes. Through the experiences of two fictitious characters (Sumit - a DBA; and Leena - an application developer), the session dives into the details of the DAC support in SQL Server Management Studio 2008 R2 Nov CTP and Visual Studio 2010 Beta 2." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jacob Sebastian is a SQL Server MVP, MSDN Moderator, PASS Chapter Leader, and Regional Mentor for PASS Asia. With more than 10 years of experience with SQL Server, Jacob wrote The Art of XSD - SQL Server XML Schema Collections (Red Gate Books) and the XML chapter in Microsoft SQL Server 2008 Bible (Wiley). He is currently writing a book on FILESTREAM and is a regular columnist with SQLServerCentral.com and simple-talk.com. Jacob has presented at SQL Server events in India and the US, including PASS Summit 2009 and SQLSaturday. He runs the SQL Server Web site http://beyondrelational.com and the TSQL Challenges series of SQL Server puzzles at http://tsqlchallenges.com." />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_04PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_04PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_04PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_04PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="28" Img="#28" Name="Peer-to-Peer Transactional Replication" Href="http://www.sqlpass.org/24hours/fall2010/Home/PeertoPeerTransactionalReplication.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="00:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jean-Yves Devant" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Learn how to design, deploy and maintain Peer-to-Peer Transactional Replication as a High-Availability solution.  Session topics include Replication Monitor, TableDiff utility, performance considerations and backup/restore guidelines." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jean-Yves is Program Manager in the SQL Server dev team where he is now in charge of Replication, Change Tracking, Change Data Capture.&#xA;&#xA;&#xA;Prior to that, Jean-Yves spent more than 12 years in Microsoft in EMEA in CSS as one of the few worldwide escalation engineers in charge of replication, SQL Server Compact, CDC, CT, etc. Jean-Yves has had extensive exposure to customers scenarios/topologies/architectures and was very much involved in solving critical issues with MCS, Presales, and US Mobility Architects to help devise architectures best suited for customers’ scenarios and drive POCs." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="29" Img="#29" Name="T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code" Href="http://www.sqlpass.org/24hours/fall2010/Home/TSQLBrushupTheBestThingsYouForgotYouKne.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="18:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jen McCown" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="You're a good database professional—you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes, just sometimes, some piece of T-SQL slips by you unnoticed or falls out of memory. Come and revisit old favorites and brush up on new T-SQL features and enhancements such as MERGE, OVER, and PARTITION BY. This session is chock-full of code examples, including before-and-after demos and how-to illustrations." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jen McCown is a 10-year SQL Server developer and DBA, currently serving as the lead DBA at a state trade association in Texas. She is co-author and co-owner of MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She presented at SQLSaturday #41 in Atlanta and SQLSaturday #35 in Dallas and is on staff at the SQL University. She is scheduled to present at PASS Summit 2010 in November." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="MidnightDBA" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-18PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-18PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-18PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-18PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="30" Img="#30" Name="Easier than Ever Report Authoring in SSRS 2008 R2 " Href="http://www.sqlpass.org/24hours/2010/Sessions/EasierthanEverReportAuthoringinSSRS2008R2.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="22:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jessica Moss" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server 2008 R2 includes many new business intelligence features, especially in Reporting Services. SSRS 2008 R2 contains better report collaboration, new report items, enhanced visualizations, and additional management and deployment functionality. This session highlights new authoring features and how they can help you design and develop better reports. Plus learn how to display map data, create a dashboard, and reuse report items in your new SSRS 2008 R2 reports." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jessica M. Moss, a SQL Server MVP and architect with Ironworks Consulting, is a well-known practitioner, author, and speaker on SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, Internet, health services, finance, and energy industries. She has written technical content for many magazines and Web sites and is the coauthor of Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution (Wrox). Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read about her work on her blog at http://www.jessicammoss.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Ironworks Consulting" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_10PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_10PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_10PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_10PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="31" Img="#31" Name="Isolation vs Concurrency: What are the Choices?" Href="http://www.sqlpass.org/24hours/fall2010/Home/IsolationvsConcurrencyWhatAretheChoices.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="19:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kalen Delaney" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="What does it mean to have data isolation? In this presentation, we’ll look at the four different ANSI isolation levels and the new one, Snapshot Isolation, added in SQL Server 2005 to see how much isolation each provides and what behaviors—such as Dirty Reads, Nonrepeatable reads, and Phantoms—are possible in each level. We’ll discuss what consistency might mean to your applications and what the trade-offs are as you choose a higher isolation level to enable greater isolation and consistency. We’ll also discuss the difference between the optimistic and pessimistic concurrency models and look at the relationship between isolation level and concurrency models to see how the various isolation levels work in either an optimistic or a pessimistic manner." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kalen Delaney has been working with SQL Server for almost 23 years and provides advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long.&#xA; &#xA;Kalen has spoken at dozens of technical conferences, including every PASS conference in the US, since the organization’s founding in 1999. She is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at sqlblog.com, and her personal website and schedule can be found at www.SQLServerInternals.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="SQLearning" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-19PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-19PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-19PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-19PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="32" Img="#32" Name="Enforcing Compliance with Policy Based Management" Href="http://www.sqlpass.org/24hours/fall2010/Home/EnforcingCompliancewithPolicyBasedManagement.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="17:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Ken Simmons" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="As the demand for data keeps growing and security and compliance keep tightening, the role of the DBA has become an increasingly critical part of maintaining compliance within the organization. This session will cover real-world examples you can use with Policy-Based Management to ensure that you have the proper server configuration and security settings in place, along with the appropriate encryption and auditing options for your environment." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Ken Simmons is a database administrator, developer, and Microsoft SQL Server MVP. He is the author of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, MCTS for SQL Server 2005, and MCITP for SQL Server 2008." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Data Software Services" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-17PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-17PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-17PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-17PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="33" Img="#33" Name="What exactly is in SQL 2008 R2?  " Href="http://www.sqlpass.org/24hours/2010/Sessions/WhatExactlyIsinSQLServer2008R2.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="14:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kevin Cox" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Take a walk through all the major enhancements in the new release of SQL Server, including PowerPivot, Multi-Server Management, StreamInsight, Parallel Data Warehouse, and Master Data Management. This session will give you a good, high-level overview as well as general usage scenarios where the new features could fit in your organization." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kevin Cox has been working in the database field for over 30 years and with Microsoft SQL Server since 1987 (version 1.0 from Sybase). He is on the Microsoft SQL Server Customer Advisory Team and feels lucky to be working on the largest SQL Server projects in the world." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_02PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_02PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_02PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_02PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="34" Img="#34" Name="Statistics: How to prove everything but the truth" Href="http://www.sqlpass.org/24hours/fall2010/Home/StatisticsHowtoProveEverythingbuttheTruth.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="13:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kevin Goode" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="“Like other occult techniques of divination, the statistical method has a private jargon deliberately contrived to obscure its methods from non-practitioners.” Ashley-Perry Statistical Axioms&#xA;&#xA;&#xA;Statistics are the lifeblood of a cost-based optimizer such as SQL Server’s and are a key component of performance tuning. This session will attempt to demystify statistics in regard to the SQL Server query optimizer. The internals of statistics will be examined and explained so that you will understand what statistics are available, how the optimizer uses those statistics, what causes statistics to be recomputed, and when it happens." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kevin Goode has 15 years of IT experience, 12 years of which have been focused on SQL Server, starting with version 6.5. He has worked in many industries, including manufacturing, distribution and logistics, financial services, and IT outsourcing, and has worked for several Fortune 500 companies. His specialties include SQL Server development, performance tuning, Business Intelligence, and ETL." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Inmar Inc." />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-13PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-13PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-13PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-13PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="35" Img="#35" Name="Top 10 Mistakes on SQL Server " Href="http://www.sqlpass.org/24hours/2010/Sessions/Top10MistakesonSQLServer.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="01:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kevin Kline" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server encompasses a wide variety of domains—administrative, development, and design. But despite years of experience with relational databases, SQL Server practitioners often make the same mistakes over and over again. Wouldn’t you like to learn about those mistakes so you can avoid them? This session will answer questions like:&#xA;&#xA;What’s the most common T-SQL programming mistake, and how do I fix it?&#xA;How do database designers cause problems for future generations of application developers and database administrators?&#xA;Why do inexperienced database administrators make their own job more difficult and less efficient?&#xA;The session covers a short list of mistakes that, if you know about them in advance, will make your life much easier. These mistakes are the “low-hanging fruit” of application design, development, and administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than ever before." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books such as SQL in a Nutshell (O’Reilly &amp; Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Quest Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_01AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_01AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_01AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_01AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="36" Img="#36" Name="Relational Database Design for Utter Newbies" Href="http://www.sqlpass.org/24hours/fall2010/Home/RelationalDatabaseDesignforUtterNewbies.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="20:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kevin Kline" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Designing a database isn’t hard work. But investing a little time and effort early will yield big benefits by providing a database that is self-documenting, that is easy to maintain and alter, and that provides high-quality data to its users. This level-100 session will use extensive examples and a real-world use case to teach you:&#xA;&#xA;• How to approach a new database design project&#xA;• How to normalize a relational database up to Third Normal Form (3NF)&#xA;• How to read an Entity-Relationship Diagram (ERD) or create your own&#xA;• How to transform a design into a real database&#xA;&#xA; &#xA;&#xA;This is a great session for developers who’ve never undertaken a database design project themselves, administrators who focus on operations, and for other IT professionals who are interested in databases." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kevin Kline is the Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and former president of PASS and the author of popular IT books such as SQL in a Nutshell (O’Reilly &amp; Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Quest Software" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-20PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-20PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-20PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-20PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="37" Img="#37" Name="SQL Server 2008 R2 StreamInsight" Href="http://www.sqlpass.org/24hours/fall2010/Home/SQLServer2008R2StreamInsight.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="17:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Klaus Aschenbrenner" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Microsoft StreamInsight is a new platform inside SQL Server 2008 R2 that you can use to analyze data streams from external sources in real-time. StreamInsight is based on the concept of Complex Event Processing (CEP). Typical data streams for CEP are found in many industries, including financial applications, Web analytic tools, and industrial environments where events are produced for monitoring big hardware devices. In this session, you will learn how to use StreamInsight in your own applications, how to develop with StreamInsight, and how to extend StreamInsight-based applications with your own adapters." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Klaus Aschenbrenner works as a Software Architect for HP in Vienna, Austria, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, Klaus received the Microsoft MVP award for his support in the .NET community. He is author of Pro SQL Server 2008 Service Broker, and you can find more information about him on his website at http://www.csharp.at." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="HP" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-17PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-17PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-17PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-17PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="38" Img="#38" Name="Database Design Fundamentals " Href="http://www.sqlpass.org/24hours/2010/Sessions/DatabaseDesignFundamentals.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="10:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Louis Davidson" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming &quot;difficulties&quot; are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently)." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Louis Davidson has been in the IT industry for 16 years as a corporate database developer and architect. He has been a Microsoft MVP for 6 years and has written four books on database design and coauthored another on dynamic management views. Currently, he is the Data Architect/DBA for the Christian Broadcasting Network, supporting offices in Virginia Beach, VA, and Nashville, TN. He has a bachelor's degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. For more information, visit drsql.org." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="CBN" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_10AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_10AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_10AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_10AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="39" Img="#39" Name="Top Ten Design Mistakes" Href="http://www.sqlpass.org/24hours/fall2010/Home/Top10DesignMistakes.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="22:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Louis Davidson" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="People do a lot of really stupid things at times in the name of &quot;getting it done&quot; (I’m not immune myself). The list I’ll present in this session is simply the 10 most heinous things that come up over and over in the real world. Study the basics of database design, and you’ll find that it’s not exactly rocket science. Normalization is as straightforward a principle to apply as gravity. So why do so many people make so many mistakes? The answer is generally pretty close to the same reason that people fail when baking a cake from a recipe. The cook gets in a hurry, skips steps, and omits the important powder that is the key ingredient—either by mistake or on purpose. The end product in either case is less than adequate results. Knowing what you are doing wrong is the first step to at least knowing how to predict the outcome." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Louis Davidson has been in the IT industry for 16 years as a corporate database developer and architect. He has been a Microsoft MVP for 6 years and has written four books on database design and coauthored another on dynamic management views. Currently, he is the Data Architect/DBA for the Christian Broadcasting Network, supporting offices in Virginia Beach, VA, and Nashville, TN. He has a bachelor's degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. For more information, visit drsql.org." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="CBN" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-22PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-22PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-22PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-22PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="40" Img="#40" Name="Using Data Compression with SQL Server 2008 R2 " Href="http://www.sqlpass.org/24hours/2010/Sessions/UsingDataCompressionwithSQLServer2008and20.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="21:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Maciej Pilecki" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="When used properly, data compression can be a killer feature. It lets you store more data using less disk and memory space, improving cacheability of your data and limiting the number of I/O operations performed. This session looks into the details of data compression and backup compression as available in SQL Server 2008 as well as the Unicode compression available in SQL Server 2008 R2." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Maciej Pilecki is a SQL Server MVP, MCT, and consultant with Project Botticelli. With many years of international experience in SQL Server database development, optimization, and troubleshooting, he spends most of his time traveling around the world advising customers on how to improve performance and reliability of their databases and sharing lessons learned with conference and user group audiences. His favorite topic are SQL Server database engine internals, including SQLOS, storage engine, and query optimizer, but he also ventures into business intelligence, especially data warehousing and data mining.&#xA;&#xA;Maciej likes skiing with his son and trekking in the mountains in his spare time. He has recently climbed Lobuche East – a 21,000 foot mountain in Everest region of the Himalayas." />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_09PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_09PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_09PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_09PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="41" Img="#41" Name="eXtreame Database Design" Href="http://www.sqlpass.org/24hours/fall2010/Home/eXtreameDatabaseDesign.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="22:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Paul Nielsen" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="This session pushes the data modeling envelope with research in applying object-oriented design to SQL Server, including class inheritance, domain classes with integrity, decorator classes for additional attributes, and transparent data overlays for data that changes from perspective to perspective. Also learn how to tackle another difficult database design involving temporal data—data that changes depending on the effective date of the query. This session assumes that you design SQL databases and that you want to see patterns that go beyond the traditional one-to-many relational database, but that you still value data integrity and normal SQL querying." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Paul Nielsen, author of the SQL Server Bible series, believes SQL is the romance language of data. A data modeler and database developer, he’s worked with databases since 1981 and has been a Microsoft SQL Server MVP since 2004. As a consultant, Paul specializes in complex database designs (object-oriented, temporal, and abstract) and has worked in the financial, airline, manufacturing, insurance, non-profit, and research industries. Involved in the SQL Server community, Paul has several projects in www.CodePlex.com, including autoaudit, regularly presents at most SQL Server conferences, and was the lead editor ofSQL Server MVP Deep Dives, in which 53 SQL Server MVPs contributed chapters with all author proceeds going to War Child International. You can read more at his website, www.SQLServerBible.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="www.SQLServerBible.com" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-22PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-22PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-22PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-22PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="42" Img="#42" Name="Producing Dashboards with PerformancePoint Services" Href="http://www.sqlpass.org/24hours/2010/Sessions/ProducingDashboardswithPerformancePointService.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="02:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Peter Myers" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="PerformancePoint Services (PPS) 2010 is the next-generation performance management application from Microsoft. Delivered as a SharePoint 2010 service application, it is primarily designed to define rich Key Performance Indicators (KPIs) and scorecards that provide monitoring capabilities. To complement the monitoring capabilities, a comprehensive suite of report types let you define interactive reports to deliver analytic capabilities. You can then assemble the monitoring and analytic capabilities to produce dashboards. In this session, see how to define data sources, KPIs, scorecards, reports, and filters to produce an interactive PerfomancePoint dashboard." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP Peter Myers of Solid Quality Mentors has 12 years of experience in OLTP database design and development, DBA support, and data warehousing/business intelligence with SQL Server. Specializing in developing custom, data-focused applications and reporting solutions, he provides architecting, development, implementation, and support services at all tiers of a multi-tier application.&#xA;&#xA;Peter has a broad business background supported by a bachelor’s degree in applied economics, and he extends this with MCITP, MCSD, MCDBA, MCSE, and MCT certifications. He provides mentoring and technical training internationally and shares his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including PASS Summit, TechEd (US and Australia), and VSLive." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_02AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_02AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_02AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_02AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="43" Img="#43" Name="Delivering KPIs with Analysis Services" Href="http://www.sqlpass.org/24hours/fall2010/Home/DeliveringKPIswithAnalysisServices.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="23:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Peter Myers" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Key Performance Indicators (KPIs) are important measurements that allow organizations to evaluate whether they are meeting targets for specific objectives. This session will begin by introducing how KPIs are defined in Analysis Services cubes and made available for consistent reporting through Excel, Reporting Services, and PerformancePoint Services. Next, we’ll look at where the KPI sources its target data and explore additional capabilities of Analysis Services to collect planning data, specifically by using cube write-back and data mining to seed planning values. Then we’ll see how you can use the new Excel 2010 What-If Analysis feature to support the collection of planning data from users." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Peter Myers, a Mentor with Solid Quality Mentors, has 13 years of experience working in OLTP database design and development, DBA support, and data warehousing/Business Intelligence with SQL Server. Specializing in Microsoft BI, he provides mentoring, technical training, and course content authoring for SQL Server and Office, working with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot, and PerformancePoint Services.&#xA; &#xA;Peter has a broad business background supported by a bachelor’s degree in applied economics, and he extends this with current MCITP and MCT certifications. A Microsoft MVP since 2006, he is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events, and conferences." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-23PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-23PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-23PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-23PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="44" Img="#44" Name="I Am a DBA - Why Should I Care About SQL Server 2008 R2?" Href="http://www.sqlpass.org/24hours/fall2010/Home/IAmaDBAWhyShouldICareaboutSQLServer20.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="12:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Peter Ward" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Most presentations about SQL Server 2008 R2 focus on features such as Reporting Services now being able to use maps, sparklines, data bars, and indicators to depict data—or how PowerPivot can be used to assemble and create relationships in large amounts of data from different sources. In this session, we won’t even mention Business Intelligence. This session is designed to show DBAs why SQL Server 2008 R2 is in no way a minor release for the Database Engine. We’ll look at a number of new features introduced in R2 for the DBA, including improvements in locking and merging partitions as well as the new Unicode compression. If lifting the hood on the Database Engine is your thing, this is the session for you." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Peter Ward is Chief Technical Architect for WARDY IT Solutions, a company he founded in 2005. His credentials and achievements include being a highly regarded speaker at SQL Server events and a sought after SQL Server consultant and trainer providing solutions for some of the largest SQL Server sites in Australia. Peter has been recognized as a Microsoft MVP for his commitment to the SQL Server community." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="WARDY IT Solutions" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-12PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-12PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-12PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-12PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="45" Img="#45" Name="Advanced T-SQL Query Tuning Techniques" Href="http://www.sqlpass.org/LearningCenter/24Hours.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="07:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Rob Farley" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Applying a variety of advanced T-SQL techniques to tune a query, showing how different constructs get reflected in execution plans. Rob Farley is a SQL MVP in Adelaide, Australia, where he runs both a consultancy (doing SQL &amp; BI) and the local SQL User Group. He is a regular presenter at conferences, and always gets &quot;good&quot; feedback on his &quot;jokes&quot;." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Rob Farley runs LobsterPot Solutions, a Gold Partner SQL Server &amp; BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia and SQLBits (UK), heads up the Adelaide SQL Server User Group, sits on the South Australian committee of the Australian Computer Society, and has held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD, and MCITP). Rob is an MCT and has been a SQL Server MVP since 2006. He has helped create several of the MCP exams, wrote two chapters for SQL Server MVP Deep Dives, and created the PASS chapter map that can be found on the PASS website." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="LobsterPot Solutions" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_07AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_07AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_07AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_07AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="46" Img="#46" Name="Understanding SARGability to Make Your Queries Run Faster" Href="http://www.sqlpass.org/24hours/fall2010/Home/UnderstandingSARGabilitytoMakeYourQueriesRun.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="23:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Rob Farley" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="There’s so much more to SARGability than people think, and you can miss out on some significant performance benefits by not fully appreciating it. SARGable means Search-ARGument-able and relates to the ability to search through an index for a value. Unfortunately, many database professionals don’t really understand it—especially in regard to joins—leading to queries that don’t run as well as they should. This session involves lots of demos, showing plenty of queries and execution plans." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Rob Farley runs LobsterPot Solutions, a Gold Partner SQL Server &amp; BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia and SQLBits (UK), heads up the Adelaide SQL Server User Group, sits on the South Australian committee of the Australian Computer Society, and has held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD, and MCITP). Rob is an MCT and has been a SQL Server MVP since 2006. He has helped create several of the MCP exams, wrote two chapters for SQL Server MVP Deep Dives, and created the PASS chapter map that can be found on the PASS website." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="LobsterPot Solutions" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-23PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-23PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-23PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-16-2010-23PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="47" Img="#47" Name="Implementing MDM Using SQL Server 2008 R2 Master Data Services" Href="http://www.sqlpass.org/24hours/2010/Sessions/ImplementingMDMUsingSQLServer2008R2MasterD.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="08:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Rushabh Mehta" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Master Data Management (MDM) addresses the critical IT function of centrally managing an organization’s essential data assets. SQL Server 2008 R2 Master Data Services enables IT organization to manage these critical data assets across diverse systems, enable more people to securely manage master data, and ensure the integrity of information over time, resulting in better data governance.&#xA;&#xA;In this session, we briefly review Master Data Services, which is shipping as part of SQL Server 2008 R2, look at the service’s features, and explore some of the tool’s important capabilities, including hierarchy and version management. Attendees will walk away with a good understanding of Master Data Services, usage scenarios, and capabilities available for managing master data." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="SQL Server MVP Rushabh Mehta is President of PASS, a BI Mentor with Solid Quality Mentors, and a business owner. He has been architecting and developing Decision Support Systems for more than a decade. Over the years, he has developed best practices and frameworks in the areas of Data Warehousing and ETL processes and implementation and was recently a contributing author for SQL Server Integration Services: Problem, Design, Solutions.&#xA;&#xA;Rushabh has implemented large-scale BI solutions for clients around the world, including organizations such as Raymond James Financials, Jackson Hewitt, Microsoft, Veteran Health Administration, US Department of Defense, Progressive Insurance, Tysons, and many others. Rushabh has developed a number of courses on BI technologies, which he regularly teaches in cities around the world, and he frequently speaks at user groups and conferences." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Solid Quality Mentors" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_08AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_08AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_08AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_08AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="48" Img="#48" Name="Managing SSIS Package Deployments with Powershell " Href="http://www.sqlpass.org/24hours/2010/Sessions/ManagingSSISPackageDeploymentswithPowerShell.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="05:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Sean McCown" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="This exciting session shows you how to manage SSIS package deployments in PowerShell and the real power it brings to the table. You’ll learn how to change package configurations, enforce standards, deploy to multiple locations, and more. After this session, you’ll walk away doing things you’ve never been able to before, making your SSIS package deployments soar." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Sean McCown , a SQL Server MVP, has been involved with SQL Server since 1995, working with multi-terabyte, high-transaction databases since before they were popular. He’s a Contributing Editor and the sole database expert for InfoWorld Magazine, which means he also touches DB2, Oracle, Sybase, and any other database out there. Sean has also written for SQL Server Magazine, SQL Server Standard, SSWUG, and SQLServerCentral.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="InfoWorld Magazine" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_05AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_05AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_05AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_05AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="49" Img="#49" Name="High Performance functions " Href="http://www.sqlpass.org/24hours/2010/Sessions/HighPerformanceFunctions.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-19T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="23:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Simon Sabin" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Functions, which you use to encapsulate common code, are a valuable development tool. This session looks at how you can write functions in SQL Server and then explores the performance differences of using functions. After this session, you will understand how you can increase your query performance 100 fold just by employing some simple best practices." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Simon Sabin is the principal consultant for SQLKnowHow, a company specializing in SQL Server consulting and training. He has worked with SQL Server since 1998, focusing on reliable, high-performance systems, and has particular expertise in search, distributed architectures, business intelligence, application development, and making Web sites and applications run faster through scale-out technologies and database performance tuning. Simon, who was named a SQL Server MVP in 2006, runs user groups in London and Cambridge (http://www.SQLSocial.com) and in 2007 founded the SQL Bits (Sqlbits.com) SQL Server conference in Europe. He is a regular speaker at SQL Server events and blogs at http://sqlblogcasts.com/blogs/simons." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="SQLKnowHow" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_11PM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_11PM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_11PM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_19_2010_11PM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="50" Img="#50" Name="Intro to MDX">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Summit Preview" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-09-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="18:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Stacia Misner" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="“Everyone” says MDX is hard—so what’s the point of learning it? Quite simply, some answers are easier to get from your data by using multidimensional queries instead of relational queries. Sure, it’s possible to write pages of T-SQL code to do things like period-over-period analysis, cumulative results such as month-to-date and year-to-date comparisons, or trending calculations for Key Performance Indicators. But in this session, you’ll learn how much easier you can perform these calculations by using MDX (after you put your data into a cube, of course!), not to mention how much faster MDX queries execute compared to their relational counterparts.&#xA; &#xA;To help you get started with MDX, I’ll explain how to think about multidimensional space, how to create basic queries, which functions to learn first, and how to construct simple, but useful, calculations. In my PASS Summit 2010 session, “Demystifying MDX in Reporting Services,” I’ll then show you how to apply these concepts to queries in Reporting Services and how to adapt queries that return multidimensional results to the two-dimensional dataset structure required by Reporting Services." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT, she is the author or co-author of eight books about BI. Her most recent books include Microsoft SQL Server 2008 Reporting Services Step by Step andIntroducing SQL Server 2008 R2. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI atblog.datainspirations.com, and tweets as @StaciaMisner." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Data Inspirations" />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-18PM-downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-18PM-downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-18PM-downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24HoursFall/09-15-2010-18PM-downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="51" Img="#51" Name="SQL 2008 R2 how to manage CPU’s, Cores and CPU Groups " Href="http://www.sqlpass.org/24hours/2010/Sessions/SQLServer2008R2HowtoManageCPUsCoresand.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating SQL Server R2" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2010-05-20T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="09:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Thomas Grohser" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="To leverage the increasing number of cores in modern server hardware, SQL Server 2008 R2 supports up to 256 logical cores. In this session, you’ll learn how to use R2 to manage CPU resources and make workloads—especially on systems that host multiple databases—run faster. We’ll talk about CPU Affinity, Hardware NUMA, Software NUMA, and how, when used properly, these features can boost the performance of your workloads." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Thomas Grosher has spent the last 15 of his 20 years as an IT pro exploring the inner workings of SQL Server while working for leading companies in the entertainment and pharmaceutical industries. His main focus is to architect, plan, and provide a reliable, highly available, secure, and scalable SQL Server infrastructure, including hardware, network, storage systems, operating systems, SQL Server configuration, and application data access.&#xA;&#xA;Grosher currently works with one of the largest SQL Server installations in the world, processing hundreds of millions of transactions daily while moving peta bytes of data in a 24x7 environment. He speaks regularly at conferences and events in North America and Europe and works closely with the Microsoft SQLCAT group to share his knowledge." />
        </Facet>
        <Facet Name="Live Meeting Presentation">
          <Link Name="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_09AM_downloadHFP/Start.htm" Href="http://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_09AM_downloadHFP/Start.htm" />
        </Facet>
        <Facet Name="Live Meeting Replay">
          <Link Name="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_09AM_downloadLMM/livemeeting.wmv" Href="mms://passfiles.sqlpass.org/uploads/24Hours/05_20_2010_09AM_downloadLMM/livemeeting.wmv" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="52" Img="#52" Name="Dashboards Design and Practice using SSRS" Href="http://www.sqlpass.org/24hours/spring2011/Home/DashboardsDesignandPracticeusingSSRS.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="13:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jen Stirrup" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="How is it possible to create dashboards that are in line with data visualisation principles? Using SSRS, dashboard design, function and creation will be explored in this session. In order to underline the data 'stories' of the overall message, we will look at ways of designing the internal dashboard elements that are in line with current data visualisation practices, whilst maintaining overall consistency between the dashboard elements.&#xA;The dashboard design theory is translated into practical demonstrations using SQL Server Reporting Services 2008 R2." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jen Stirrup has been delivering end-to-end Microsoft SQL Server Business Intelligence solutions for over a decade. Jen has previously presented at SQLBits in the UK, and also helps to run the UK Tableau User Group. Whilst Jennifer has played a key role in delivering projects with a technical focus, she has strived to ensure business users are heard by finding the best solution for the business problem. Jennifer enjoys digging around data to find answers, and sharing the (sometimes surprising) business answers with others via reports, data visualizations, and dashboards. Jen also actively blogs, and was delighted to be nominated for a SQLServerPedia “Best Blogger of the Year” award for the “Business Intelligence” stream in 2010." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="53" Img="#53" Name="Cool Tricks to Pull From Your SSIS Hat" Href="http://www.sqlpass.org/24hours/spring2011/Home/CoolTrickstoPullFromYourSSISHat.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="16:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Julie Smith" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="SQL Server Integration Services-Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer who is relatively new to SSIS, has mastered the basics of the dataflow, and is now looking for elegant ways to automate his/her solutions. It introduces essential components to sophisticated ETL design. The presentation demonstrates several uses of variables, types of variables (including the SSIS workhorse ado.net object), and various ways to populate them. The session will also cover the basics of the SSIS Expression language. This session is demo intensive, using case studies of real business problems." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Julie Smith has spent the last 11 years moving data using varied tools such as MS Access, MySQL, and most importantly SQL Server 2000-2008. She is an MCP in SQL Server 2000: Implementing Database Design. She has worked for a major law firm and a major compliance reporting company.  She currently works as a Business Intelligence Consultant for Key2 Consulting, LLC in Atlanta, GA." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Key2 Consulting" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="54" Img="#54" Name="Multidimensional Thinking" Href="http://www.sqlpass.org/24hours/spring2011/Home/MultidimensionalThinking.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="20:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Stacia Misner" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Whether you're developing Analysis Services cubes or creating PowerPivot workbooks, you need to get into a multidimensional frame of mind to produce a model that best enables users to answer their business questions on their own. Many database professionals struggle initially with multidimensional models because the data modeling process is much different than the one they use to produce traditional, third normal form databases. In this session, I'll introduce you to the terminology of multidimensional modeling and step through the process of translating business requirements into a viable model." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT she is the author or co-author of eight books about BI. Her most recent books include Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 and Office 2010 and Introducing SQL Server 2008 R2. Stacia provides consulting and custom education services through Data Inspirations and writes about her experiences with BI at blog.datainspirations.com, as well as tweets as @StaciaMisner." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Data Inspirations" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="55" Img="#55" Name="Many-to-Many Dimensions – ETL to Cube" Href="http://www.sqlpass.org/24hours/spring2011/Home/ManytoManyDimensionsETLtoCube.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="23:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Lisa J Phillip" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="A few years ago, while re-architecting our Data Warehouse we found that, in many circumstances, performance of reports based on cubes was far superior to those based on tables.  80% of our reports now run off Analysis Services (2008) cubes.  This meant ensuring complex relationships with fact tables were handled well at the cube as well as the database level.  Using the example of a sale that can be attributed to many departments, I plan to show our best practices for handling some of these complex relationships:&#xA;1. Using the Group dimension table design strategy, I have found to be the best way to model these relationships&#xA;2. One strategy is to have the group dimension acts as a “fact” in order to build out measure groups in your cube design, and relate any dimension in other measure groups to it.  This allows you to filter by Sales where the Sales department AND the Marketing department contributed.  This strategy comes with its own performance issues.&#xA;3. Another strategy allows you to filter where Sales OR Marketing contributed.  To accomplish this I had to utilize not only the group bridge, but pivoting as well as finding a way to add attributes within a dimension without having to reprocess the entire cube.  An “OR” filter is rarely ever achieved while browsing an Analysis Services cube." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Lisa Phillip is currently a Senior Data Warehouse Engineer with Quicken Loans.  She has been involved in building out and maintaining very large Data Warehouses for the past 12 years.   Within a year of starting at Quicken Loans she was charged with leading the re-architecture of the Data Warehouse.  Her current responsibilities include everything from administration and maintenance, performance tuning, cube and dashboard building in a SQL Server 2008 environment. She also has experience leading a project to architect and rollout a massive Disaster Recovery strategy.  In part thanks to these efforts, she attended The Data Warehouse Institute summit in San Diego (2010), where she and her Director of Business Intelligence accepted the Best Practices Award for Operational BI." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Quicken Loans" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="56" Img="#56" Name="Reporting Services 201: The Next Level" Href="http://www.sqlpass.org/24hours/spring2011/Home/ReportingServices201TheNextLevel.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="12:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jes Borland" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from meh to wow using features such as tablix, lists, images, and charts." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jes Borland is a Database Administrator with Kimberly Clark and has over five years’ experience in SQL Server. She is an active member of the Wisconsin SQL Server user group, PASS Women in Technology Virtual Chapter, blogger, and tweeter." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Kimberly Clark" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="57" Img="#57" Name="Tips &amp; Tricks for Dynamic Reporting Services Reports" Href="http://www.sqlpass.org/24hours/spring2011/Home/TipsTricksforDynamicReportingServicesReports.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="16:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Pam Shaw" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this session we will explore the multitude of ways you can make your reports adapt to the needs of your users. This includes defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered, and will demonstrate how to create a parameter-driven data source. We will examine 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." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Pam Shaw has been in IT for almost 30 years and is currently an independent contractor.  Since 2001, Pam has been working with SQL Server; first 2000, then 2005 and now 2008.  She is also the Chapter Leader of the Tampa Bay SQL Users Group, a local chapter of PASS and organizer of SQL Saturday Tampa." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="OmniVue Business Solutions" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="58" Img="#58" Name="Intelligent ETL with SQL Server" Href="http://www.sqlpass.org/24hours/spring2011/Home/IntelligentETLwithSQLServer.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="18:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jyoti Gupta" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Many developers are tasked with moving and transforming data stored in SQL Server tables. In this hour-long seminar, developers will explore techniques for building intelligent ETL applications for SQL Server that maximize their productivity and accuracy. We will focus on reusability via bottom-up development of ETL applications. We will start with understanding how to introduce reusability into the ETL design process and then study reusable design components, such as metadata structures and connectivity information. Finally, we'll build a small application that takes advantage of reusable design sub-components. A brief Q/A session will end the seminar." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jyoti Gupta is a senior field engineer for expressor, a software company that provides free ETL software for extracting and loading SQL Server data. She has 10 years of experience in Data Integration/ETL, starting as a field engineer for Torrent Systems, where the current parallel ETL engine from DataStage originated. Since Torrent Jyoti has worked in a variety of vertical markets, implementing data warehouses and data-driven technology systems. Prior to joining expressor, Jyoti was a technical trainer for IBM, specializing in the InfoSphere product suite." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="expressor" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="59" Img="#59" Name="Clever Queries: Crafting MDX Queries to get the Most out of SSRS" Href="http://www.sqlpass.org/24hours/spring2011/Home/CleverQueries.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="19:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Erika Bakse" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Reporting Services is a powerful tool that can make designing reports a snap...most of the time. But every once in a while you have to format a report very specifically, and the data just isn't available in the form you need it to do that.  Enter Clever Queries!  Learn about how to use named sets, dummy members, and other MDX tricks to craft your data query in a way that allows you to conquer the trickiest report layouts." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Erika Bakse began her business intelligence career two years ago when she joined the Data Inspirations team. She has helped develop training curricula for use of the various SQL Server business intelligence technologies and is a contributing author of Microsoft SQL Server 2008 Reporting Services Step by Step (Microsoft Press, 2006).  Her blog is available at erikasblog.datainspirations.com, and she tweets as @BakseDoesBI" />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Data Inspirations" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="60" Img="#60" Name="What You Don't Know about SSRS 2008R2" Href="http://www.sqlpass.org/24hours/spring2011/Home/WhatYouDontKnowaboutSSRS2008R2.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="BI" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="21:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kathi Kellenberger" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="You have seen the maps and the sparklines but have you heard about all the other cool features such as enhanced page numbers, improved Report Builder and more? View this session and learn about all the little things that make SQL Server Reporting Services 2008R2 great!" />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kathi Kellenberger is a Data Technology Specialist for Microsoft in St. Louis, MO. Before joining Microsoft, she was a database administrator for an international law firm and an MVP.  Kathi has been involved with the SQL Server community for several years as a PASS volunteer, author and speaker. She is the author of “Beginning T-SQL 2008” (Apress) and co-author of “SQL Server MVP Deep Dives” (Manning) and “Professional SQL Server 2005 Integration Services” (Wrox)." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="61" Img="#61" Name="SQL Server AlwaysOn: the Next Generation High Availability Solution" Href="http://www.sqlpass.org/24hours/spring2011/Home/SQLServerAlwaysOntheNextGenerationHigh.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="12:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Lara Rubbelke" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this session we will talk about the new high availability solution that is being introduced in SQL Server code named Denali. The session provides an overview of AlwaysOn and using a lot of demos explains how you can build a high availability solution using the new features and capabilities. The session will focus on describing how to deploy an AlwaysOn solution, utilize your secondary hardware for better return of investment, how the new solution simplifies deployment, management of high availability in your environment." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Lara Rubbelke brings her passion for architecting, implementing and improving SQL Server solutions to the community as a Data Platform Technology Specialist for Microsoft. Her expertise involves both OLTP and OLAP systems, data management, performance tuning, encryption, ETL, and the Business Intelligence lifecycle.  She regularly delivers technical presentations at local, regional and national conferences, user groups and webcasts.  Notably, Lara has presented at Tech Ed, PASS Summit, Minneapolis SQL Server Launch, and delivered numerous webcasts on MSDN and TechNet.   " />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="62" Img="#62" Name="SQL Server Performance Tools" Href="http://www.sqlpass.org/24hours/spring2011/Home/SQLServerPerformanceTools.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="15:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Cindy Gross" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Troubleshooting performance issues with SQL Server can be confusing and time consuming. I want to make sure you are familiar with some of the common tools used to help troubleshoot performance issues and when to use each. I will provide best practices around troubleshooting methodology, SQLDiag, PSSDiag, SQL Nexus, Profiler / SQL Trace, and PerfMon. After this presentation you will be better able to narrow down a performance problem and focus in on where to spend your time and effort." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="I started my SQL Server life as a DBA with a hospital and health plan company in 1993 and moved to Microsoft in 2000 where I have worked ever since. For that entire 18 years I have worked with SQL Server, from version 1.11 to 2008 R2 and beyond. My roles at Microsoft have included PSS Product Support Engineer, SQL Content Lead, Yukon Readiness Lead, and most recently Dedicated Support Engineer (DSE) in the Premier Field Engineering (PFE) organization. I have delivered SQL Server training throughout the United States as well as in Europe and India, including presentations at SQL PASS. My technical writing includes Microsoft KB articles, my MSDN blog, and chapters in two books: Professional SQL Server 2008 Internals and Troubleshooting (Chapter 8: Defining Your Approach to Troubleshooting) and SQL Server 2005 Practical Troubleshooting: The Database Engine (Chapter 10: Clustering). I live and work in Boise, ID where I'm near fun things like hiking trails, bike paths, the Boise River, downtown Boise and the Idaho State Capitol building. " />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="63" Img="#63" Name="SQL Server Performance" Href="http://www.sqlpass.org/24hours/spring2011/Home/SQLServerPerformance.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="18:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Isabel de la Barra" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="What we all want from our databases is how to get the maximum potential and best response time for users and administration tasks.  These kinds of optimizations can be performed at the Operating System level with tools and options which SQL Server provides for.  Attend this session and learn more about SQL Server performance." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Isabel de la Barra is an Infrastructure Engineer with more than 18 years of experience in different platform and database systems.  She has worked with SQL Server since 6.0 to the newest version. She has been Microsoft Certified since 2002 and has been a technical specialist for SQL Server since 2008. As a Microsoft Certified Trainer, she has given classes on SQL Server versions 2002 to 2008." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="64" Img="#64" Name="Bad Plan! Sit!" Href="http://www.sqlpass.org/24hours/spring2011/Home/BadPlanSit.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="21:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Gail Shaw" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad execution plan? How do you identify one in your system and, once identified, how do you go about fixing it?&#xA;In this session we’ll look at some things that make a plan “bad”, how you might detect such plans as well as various methods of fixing the problem, both immediately and long-term." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Gail is a database consultant from Johannesburg, South Africa, specializing in performance tuning and database optimization. Before moving to consulting she worked at a large South African investment bank and was responsible for the performance of the major systems there. Gail is a frequent poster on the SQLServerCentral forums and writes for the same site. She has presented at TechEd Africa and the PASS Community Summit. She was awarded MVP for SQL Server in July 2008." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="65" Img="#65" Name="Indexes and Execution Plans" Href="http://www.sqlpass.org/24hours/spring2011/Home/IndexesandExecutionPlans.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="22:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kim Tessereau" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="This session will offer examples of B-Tree indexes, as well as offer an introduction to the query optimizer. It will cover obtaining execution plan information, queries that use join operations and lastly, myths about optimizing and indexes." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kim Tessereau MCDBA &amp; former MCT: has 28 years of IT experience with 15 years of experience with databases and 7 years of teaching. She has worked as a Sybase, Oracle and SQL Server DBA and developer. She currently works at Scottrade as a Senior Database Developer and spends time mentoring junior members of the group. Kim also works as an instructor at Washington University in St. Louis - CAIT teaching Business Intelligence and Database Administration courses. " />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Scottrade" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="66" Img="#66" Name="Replication, Log Shipping and Mirroring: Oh My!" Href="http://www.sqlpass.org/24hours/spring2011/Home/ReplicationLogShippingandMirroringOhMy.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="13:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Wendy Pastrick" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="With so many different high availability options available, how do you know which one is right for you? How do you know which technology will meet your requirements? In this session we will take a tour of each option to highlight what makes them different. Attend and you will understand what problem each technology solves and how to make a good choice when needing to select one to best suit your needs." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Wendy Pastrick has been a SQL Server DBA for 10+ years working with versions 6.5 thru 2008 R2. She works closelywith development teams to see application development through the entire lifecyle and also has experience with Transactional and Merge Replication along with High Availability and Disaster Recovery planning and implementation.  Previously, Wendy worked for a Technical Training company, and has comfortably taken the podium at local User Group meetings, SQL Saturday events and the SQL PASS Summit to educate audiences on both SQL Server technologies as well as Women In Technology issues." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="67" Img="#67" Name="All about SQL Server Memory Settings for DBAs " Href="http://www.sqlpass.org/24hours/spring2011/Home/AllaboutSQLServerMemorySettingsforDBAs.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="15:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Vyshnavi Thota" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="This session will cover memory setting basics required for MS SQL Server to perform optimally, consisting of parameter setting and metric details to check for memory issues as well as thumb rules for memory settings." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Vyshnavi Thota is a Sr. SQL Server Database Administrator with 11 years of experience, currently working at DELL in Austin, Texas.&#xA;She completed Bachelor of Engineering from Bangalore University, holds a post-graduate diploma in computer science along with a Master in Information Technology from AAIDU." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="DELL" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="68" Img="#68" Name="Index Internals for Mere Mortals" Href="http://www.sqlpass.org/24hours/spring2011/Home/IndexInternalsforMereMortals.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="22:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Michelle Ufford" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Most DBAs have heard of indexes but not everyone understands how they work.  In this in-depth session, Michelle will cover the internals of indexes including index filtering and partitioning.  She'll compare the B-trees of different index types, explain fragmentation, and use undocumented commands to show you what an actual index page looks like.  Attendees will walk away with a better understanding of indexes, which is helpful when designing and tuning databases.  If you've ever wondered just *what* goes on in an index, this is the session for you!" />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Michelle Ufford is a Senior SQL Server Developer at GoDaddy.com, the world's largest domain name registrar and web hosting company. She specializes in designing and tuning high-volume, multi-terabyte databases. She's perhaps best known for her index defrag script and for tuning a VLDB to support 27k transactions per second. Michelle is also a frequent speaker, published author, and award-winning blogger at http://sqlfool.com. She can be found on Twitter at @sqlfool." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="GoDaddy.com" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="69" Img="#69" Name="TwitterData on Azure (end-to-end demo) – How We Did It" Href="http://www.sqlpass.org/24hours/spring2011/Home/TwitterDataonAzureendtoenddemoHowWeDi.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DBA" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="23:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Lynn Langit" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="In this all session, Lynn will show an end-to-end solution using the Windows Azure platform for parsing, filtering, sorting and displaying Twitter data.  She uses many parts and pieces of the Azure platform, Web Roles, Worker Roles, Azure storage, SQL Azure storage and SQL Azure Reporting.  Lynn will show customization of the Report Viewer control embedded in various applications, such as WinForms, WebForms, WinMobile etc... See and understand how it all works together, all sample code available too." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="A self-described language geek, Lynn Langit is fascinated by languages and semantics. She understands that life rarely travels in a straight line and her own career reflects this winding path. Lynn moved from a degree in linguistics to become a business executive, and then launched her own software development, training and consulting company. She’s done production work with all versions of .NET, BizTalk, K2.Net, SharePoint, SQL Server, Analysis Services, InfoPath, MOM, and Active Directory, and holds an array of certifications, including MCT, MCSD, MCITP, MCSE, MCDBA and MSF. &#xA;She is the author of Smart Business Intelligence Solutions with SQL Server 2008 (MSPress) and Foundations of SQL Server 2005 Business Intelligence (APress).  In her spare time, Lynn gives back to the community by supporting children’s education. Her current projects include work with the 'Teaching Kids Programming' group (www.TeachingKidsProgramming.org), the Mona Foundation (Redmond, Washington) and SmartCare (Lusaka, Zambia)." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="70" Img="#70" Name="Spatial Data: Cooler Than You’d Think" Href="http://www.sqlpass.org/24hours/spring2011/Home/SpatialDataCoolerThanYoudThink.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="14:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Hope Foley" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistently pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built-in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data so that you can become the spatial data pro in your organization." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Hope Foley has over 10 years experience in the IT world and has worked across many industries with small business enterprises, start ups, and Fortune 500 companies. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst and last year took over as Principal Microsoft Consultant, where she now leads a team of expert Database Administrators and Developers. More recently, Hope has added presenter to her resume, and presents for both PTI and various user groups around the country. She has obtained the certification of MCITP: Database Administration (2005/2008).  " />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Microsoft" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="71" Img="#71" Name="No More Bad Dates: Using Temporal Data Wisely" Href="http://www.sqlpass.org/24hours/spring2011/Home/NoMoreBadDatesUsingTemporalDataWisely.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="17:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Kendra Little" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="Temporal data can be confusing in SQL Server. It's no wonder: there are six data types for storing these values. In this session we'll discuss dates, times, and how they are stored internally in SQL Server. We'll talk about how to select a temporal data type, common issues with some types, and compare performance of different methods for computing temporal values. We'll also take a look at gotchas in features of SQL Server for which date and time data type choices can be critical. Choose wisely: the correct type and high performing data access logic will help your applications scale and save development and administrative time." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Kendra Little is a Senior Database Administrator at WildTangent Games who has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="WildTangent Games" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="72" Img="#72" Name="T-SQL Code Sins: The Worst Things We Do to Code and Why" Href="http://www.sqlpass.org/24hours/spring2011/Home/TSQLCodeSins.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-15T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="19:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Jennifer McCown" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="It's impossible to follow every best practice all the time. Code sins are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Jen McCown is a SQL Server developer and DBA currently serving as the lead DBA at a state trade association in Texas. She is co-author and co-owner of MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple SQL Saturdays, and at the PASS Summit 2010.  " />
        </Facet>
      </Facets>
    </Item>
    <Item Id="73" Img="#73" Name="Entity Framework: Not as Evil as You May Think" Href="http://www.sqlpass.org/24hours/spring2011/Home/EntityFrameworkNotasEvilasYouMayThink.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="14:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Julie Lerman" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="“It’s going to write and execute its own TSQL? I have to give it access to my tables? What, are you kidding me? I am not letting that performance and security sopping hunk-a-goo near my database!” Okay, okay, we hear you! Before you database gurus get your knickers in a twist about Entity Framework, the model driven ORM that is now part of ADO.NET, don’t believe everything you hear. The default functionality of Entity Framework can definitely be scary to someone who really knows their way around a database. But there is a lot to love if you look a little further. For example, did you know that an Entity Data Model can be built from *only* views and stored procedures? Have you seen the great improvements to the query builders in EF4? Did you know that EF uses parameterized queries? In this session, Entity Framework expert (and eager-to-learn DB luddite), Julie Lerman, will share some features of Entity Framework that should give database owners the info they need to make balanced and educated assessments of Entity Framework." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Julie Lerman is a Microsoft MVP, .NET mentor and consultant who lives in the hills of Vermont. You can find Julie presenting on data access and other Microsoft .NET topics at user groups and conferences around the world. Julie blogs at thedatafarm.com/blog, is the author of the highly acclaimed Programming Entity Framework (with a second edition released in August 2010) and authors the MSDN Magazine “Data Points” column. Follow Julie on twitter at julielerman." />
        </Facet>
      </Facets>
    </Item>
    <Item Id="74" Img="#74" Name="T-SQL Awesomeness: 3 Ways to Write Cool SQL" Href="http://www.sqlpass.org/24hours/spring2011/Home/TSQLAwesomeness3WaystoWriteCoolSQL.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="17:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Audrey Hammonds" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="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: &#xA;• Recursive Common Table Expressions (CTE)&#xA;• EXCEPT and INTERSECT&#xA;• CROSS APPLY and OUTER APPLY&#xA;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." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Audrey Hammonds is a BI Consultant for Key2 Consulting in Atlanta, GA, and one half of the Datachix (www.datachix.com). She holds MCTS certifications in SQL Server 2008 Database Development and SQL Server 2008 Business Intelligence. Fourteen years ago, she volunteered for database training to escape the clutches of COBOL, and has never looked back.  A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="Key2 Consulting" />
        </Facet>
      </Facets>
    </Item>
    <Item Id="75" Img="#75" Name="Five Physical Database Design Blunders and How to Avoid Them" Href="http://www.sqlpass.org/24hours/spring2011/Home/FivePhysicalDatabaseDesignBlundersandHowto.aspx">
      <Facets>
        <Facet Name="Event">
          <String Value="24 Hours of PASS: Celebrating Women in Technology" />
        </Facet>
        <Facet Name="Track">
          <String Value="DEV" />
        </Facet>
        <Facet Name="Date">
          <DateTime Value="2011-03-16T00:00:00" />
        </Facet>
        <Facet Name="Time">
          <String Value="20:00" />
        </Facet>
        <Facet Name="Speaker Name">
          <LongString Value="Karen Lopez" />
        </Facet>
        <Facet Name="Session Description">
          <LongString Value="What’s going on in your physical data model? How many people can or will update it to match the reality of what’s going on in your databases? Who actually decides what goes into the database design?  How do you choose your primary keys? How do you implement them? Are your datatypes the right ones for the data?&#xA;In this presentation we discuss five physical data modeling mistakes that cost you dearly: performance snags, development delays, bugs, and professional respect. Data Architects are often tasked to prepare first cut physical data models, yet these skills usually overlap those of DBAs and Developers and this overlap can lead to contention, confusion, and complacency. In this presentation, you’ll learn about the five blunders, how to find them as well as many tips on how to avoid them." />
        </Facet>
        <Facet Name="Speaker Description">
          <Link Name="Karen Lopez is a principal consultant at InfoAdvisors. She specializes in the practical application of data management principles and is an active blogger, speaker and social networker. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com, dm-discuss, and other online communities." />
        </Facet>
        <Facet Name="Spreaker Company">
          <String Value="InfoAdvisors" />
        </Facet>
      </Facets>
    </Item>
  </Items>
  <Extension>
    <p:Copyright Name="LobsterPot Solutions 2010" />
  </Extension>
</Collection>
