SQLSaturday #111 - Atlanta 2012 4/14/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat111 Georgia State University - Alpharetta 3775 Brookside Pkwy Alpharetta GA 30022 1681 Idera Platinum Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1859 Red Gate Software Ltd Platinum Sponsor http://www.red-gate.com/ http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1861 Enterprise Software Solutions Gold Sponsor http://www.entsoftsol.com http://www.codegumbo.com/images/entsoftsol.png 60 170 1938 SQL Sentry Gold Sponsor http://sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1945 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2104 MDI Group Gold Sponsor http://www.mdigroup.com/ http://www.mdigroup.com/logos/MDI-Logo_4c-tag_letterhead.jpg 60 170 1725 Intellinet Gold Sponsor http://www.intellinet.com http://www.intellinet.com/media/79328/intellinet_color_horiz_tag_170x60.png 60 170 2108 WhipTail Gold Sponsor http://www.whiptail.com http://whiptail.com/wp-content/uploads/2012/03/WhipTail-100x40.jpg 60 170 2139 EMC Gold Sponsor http://www.emc.com http://www.codegumbo.com/images/EMC_notag_BK.jpg 60 170 2136 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1812 Perpetual Technologies, Inc. Silver Sponsor http://pti.net/ http://pti.net/logo/logo.png 60 170 1666 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1907 Linchpin People LLC Bronze Sponsor https://www.linchpinpeople.com http://linchpinpeople.com/wp-content/uploads/2012/02/linchpin_logo_trans.png 60 170 2105 Morgan Kaufmann Bronze Sponsor http://www.mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 1850 Pragmatic Works Bronze Sponsor http://www.pragmaticworks.com http://pragmaticworks.com/images/pw_logo.jpg 60 170 2066 LeanKit Bronze Sponsor http://blog.leankitkanban.com/landing/smpl http://leankitblog.com/wp/wp-content/uploads/2012/03/LeanKit_Logo_small.png 60 170 2143 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 1857 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1837 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 1746 codegumbo Blog Sponsor http://www.codegumbo.com http://www.codegumbo.com/images/codegumbo_small.png 40 100 1774 SQLChick Blog Sponsor http://www.sqlchick.com http://melissacoates.squarespace.com/storage/SQLChick_Logo_100x40.png 40 100 1699 StrateSQL Blog Sponsor http://www.jasonstrate.com/ http://www.jasonstrate.com/images/StrateSQLProfile.jpg 40 100 1718 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2054 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 1879 InfoAdvisors Blog Sponsor http://blog.infoadvisors.com http://blog.infoadvisors.com/loveyourdata100x40.jpg 40 100 7776 Aaron Nelson Aaron Nelson is a Senior SQL Server Architect with over 10 years of experience in SQL Server. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). @http://twitter.com/sqlvariant http://www.linkedin.com/in/sqlvariant http://sqlvariant.com/wordpress/ https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 7751 Adam Machanic Adam Machanic doesn't like web sites that only let him put in 500 characters for a bio. If you want to know who he is, visit this link: https://mvp.support.microsoft.com/profile/adam @AdamMachanic http://www.linkedin.com/in/adammachanic http://dataeducation.com https://api.twitter.com/1/users/profile_image?screen_name=@AdamMachanic 48 48 7553 Allen White Allen is a Practice Manager for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last five years. He's President of the Ohio North SQL Server User's Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx. @SQLRunr http://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_pro http://www.upsearch.com/sql https://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr 48 48 6875 Andy Leonard Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer and Consultant and developer, SQL Server database and data warehouse developer, community mentor, SQLBlog.com blogger, and 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, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 200 @AndyLeonard http://www.linkedin.com/in/andyleonard http://linchpinpeople.com https://api.twitter.com/1/users/profile_image?screen_name=@AndyLeonard 48 48 6302 Bob Langley Bob Langley, MCDBA, has been in IT for 23+ years in the financial services industry and local government. Starting out in programming, then moving to Business Systems Analysis, Systems Administration, and finally Database Administration and Development, administering and developing databases for many departments for a local county government. 48 48 7331 Brian Kelley Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as a database administrator/ architect but has also worked as a infrastructure and security architect and incident response team lead. @kbriankelley http://www.linkedin.com/in/kbriankelley https://api.twitter.com/1/users/profile_image?screen_name=@kbriankelley 48 48 6260 Christina Leo Christina Leo works as a database developer for ProfitStars, a Jack Henry Company. She supports three development teams that create software for the banking industry. She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group, volunteers with the PASS - Women in Technology Virtual Chapter, and holds an MCITP for SQL Server 2005 in Development and Administration. @christinaleo http://www.linkedin.com/pub/christina-leo/a/839/9aa http://christinaleo.net https://api.twitter.com/1/users/profile_image?screen_name=@christinaleo 48 48 6429 Denny Cherry Denny Cherry is an independent consultant with over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP. @mrdenny http://www.linkedin.com/in/mrdenny http://www.mrdenny.com https://api.twitter.com/1/users/profile_image?screen_name=@mrdenny 48 48 6891 Ed Wilson Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog,. He has also spoken at TechEd and at the Microsoft internal TechReady conferences. He is a Microsoft-certified trainer who has delivered a popular Windows PowerShell workshop to Microsoft Premier Customers worldwide. He has written 9 books including 6 on Windows scripting that were published by Microsoft Press. He has also contributed to nearly a dozen other books. @ScriptingGuys http://www.linkedin.com/in/mredwilson http://www.scriptingguys.com/blog https://api.twitter.com/1/users/profile_image?screen_name=@ScriptingGuys 48 48 7639 Eric Melcher Eric Melcher brings over 10 years of technology and consulting experience delivering data management and business intelligence solutions across a variety of industry verticals, with focuses on manufacturing, logistics, energy, services, and insurance. At Profisee, Eric leads the Master Data Management practice, guiding Profisee’s customers in the development of Master Data http://www.linkedin.com/profile/view?id=5020968trk=tab_pro http://www.profisee.com 48 48 7698 Erika Bakse Erika Bakse began her business intelligence career three 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 @BakseDoesBI http://www.linkedin.com/pub/erika-bakse/20/5bb/146 http://erikasblog.datainspirations.com https://api.twitter.com/1/users/profile_image?screen_name=@BakseDoesBI 48 48 7060 Geoff Hiten Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in high-availability and high-performance SQL systems. Geoff was appointed to fill an interim Director position at the National PASS organization for 2011. @sqlcaftsman http://www.linkedin.com/profile/view?id=5834715trk=tab_pro http://weblogs.sqlteam.com/geoffh/default.aspx https://api.twitter.com/1/users/profile_image?screen_name=@sqlcaftsman 48 48 7642 Glen Gordon Glen is a Developer Evangelist with Microsoft. He works with communities of developers in the southeast, bringing them the resources they need to be successful using Microsoft technologies. Prior to joining Microsoft in 2003, Glen worked as an enterprise consultant, and prior to that, as a software trainer. Glen’s current passion is helping people build the next big thing in the Windows Phone space. @glengordon http://blogs.msdn.com/glengordon https://api.twitter.com/1/users/profile_image?screen_name=@glengordon 48 48 6856 Grant Fritchey Grant Fritchey is a SQL Server MVP with over 20 years of experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0, back in 1995. He has developed in VB, VB.NET, C# and Java. He has authored books for Apress and Simple-Talk and joined Red Gate Software as a Product Evangelist in January 2011. @gfritchey http://www.linkedin.com/in/scarydba http://www.scarydba.com https://api.twitter.com/1/users/profile_image?screen_name=@gfritchey 48 48 6880 Hal Rottenberg Hal Rottenberg is a system engineer, Microsoft PowerShell MVP, and VMware vExpert living in Woodstock, Georgia. He has over thirteen years of experience in IT while working for such large enterprises as Hewlett-Packard, IBM, and The Home Depot. When it comes to IT, Hal’s passions are automation and virtualization. He is well-known in sysadmin circles for co-hosting the PowerScripting Podcast, and authoring a book titled “Managing VMware Infrastructure with PowerShell: TFM ”. @halr9000 http://www.linkedin.com/in/halrottenberg http://halr9000.com https://api.twitter.com/1/users/profile_image?screen_name=@halr9000 48 48 7492 Hope Foley Hope has over 12 years experience in the IT world, she has worked across many industries including small business enterprises, start ups, and Fortune 500 companies, and has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and then took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers. @hope_foley http://www.linkedin.com/pub/hope-foley/6/79b/5a9 http://www.hopefoley.com https://api.twitter.com/1/users/profile_image?screen_name=@hope_foley 48 48 6883 Jason Strate Jason Strate, Digineer Inc, is a database consultant with over fifteen years of experience. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. He is a recipient of the Microsoft Most Valuable Professional (MVP) award for SQL Server since July, 2009. @stratesql http://www.linkedin.com/in/jasonstrate http://www.jasonstrate.com https://api.twitter.com/1/users/profile_image?screen_name=@stratesql 48 48 6873 Jen Underwood Jen is a Microsoft Southeast Region Data Platform Technology Specialist. She has 16 years of experience in business intelligence, data warehousing, reporting and analytics. Jen is active in the SQL Server community, presents at SQL Server Worldwide User Group, PASS SQL Saturday events and at local user group meetings. She graduated from the University of Wisconsin, Milwaukee and has a post graduate certificate in Computer Science - Data Mining from the University of California, San Diego. @idigdata http://www.linkedin.com/in/jenunderwood http://www.jenunderwood.com https://api.twitter.com/1/users/profile_image?screen_name=@idigdata 48 48 6878 Jennifer McCown Jen McCown is a Microsoft SQL Server MVP, developer, DBA and presenterfor the Texas-based toy company, KidKraft. She is Senior Editor at 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. @MidnightDBA http://www.linkedin.com/in/jennifermccown http://www.MidnightDBA.com/Jen https://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA 48 48 7752 Jeremy Carroll Senior Consultant at Intellinet MCTS, MCITP SQL Server 2008 DBA MCTS, MCITP SQL Server 2008 Developer @thinkinsql http://www.linkedin.com/in/jeremycarrollatlanta http://thinkinsql.com https://api.twitter.com/1/users/profile_image?screen_name=@thinkinsql 48 48 7163 Jessica Moss Jessica M. Moss is a well-known architect at CapTech Consulting, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in many industries and has authored technical content for multiple magazines, websites, and the book 'Microsoft SQL Server 2008 Integration Services Problem-Design-Solution'. Jessica enjoys working with the Virginia community and speaks regularly at user groups, code camps, and conferences @jessicammoss http://www.jessicammoss.com https://api.twitter.com/1/users/profile_image?screen_name=@jessicammoss 48 48 7542 Jim Christopher By date, Jim Wooley is a consultant for Slalom Consulting, In his free time, Jim is a frequent speaker, INETA Regional Speaker, MVP, and author of 'LINQ in Action'. He is always striving to stay at the forefront of technology and enjoys the thrill of a new challenge. He has been active evangelizing LINQ since it's announcement in 2005. Jim is a freqent speaker at regional and national events including DevLink, DevWeek, CodeMash, CodeStock, VS Live, and MIX. @beefarino http://www.linkedin.com/profile/edit?trk=hb_tab_pro_top http://www.beefycode.com https://api.twitter.com/1/users/profile_image?screen_name=@beefarino 48 48 7764 John Welch John Welch has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an SSAS Maestro, and a frequent presenter on SQL Server BI topics. @john_welch http://www.linkedin.com/in/johncwelch http://agilebi.com/jwelch https://api.twitter.com/1/users/profile_image?screen_name=@john_welch 48 48 6166 Jonathan Boulineau Jon Boulineau is an 11 year it veteran currently working as a DBA for a Fortune 500 company. In addition to his work as a DBA he has survived phases as a network engineer, systems administrator, and developer in his career. He resides in Columbus, GA with his wife and four children. @jboulineau http://www.newsqlblog.com https://api.twitter.com/1/users/profile_image?screen_name=@jboulineau 48 48 7677 Julie Smith Julie Smith has spent the last 10 years moving data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is an MCTS in SQL Server 2008 BI. She recently joined ista NA as a SQL Developer. Prior to ista, she worked as a database developer at Key2 Consulting and the Network Inc. She is very simple woman with warm fuzzy secret heart. @datachix1 http://www.linkedin.com/in/juliesmith0503 http://datachix.com https://api.twitter.com/1/users/profile_image?screen_name=@datachix1 48 48 6515 Karen Lopez Karen López is Sr. Project Manager and Architect at InfoAdvisors. As a Microsoft MVP, Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. She specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. Karen wants you to Love Your Data. @datachick http://linkedin.com/in/karenlopez http://blog.infoadvisors.com https://api.twitter.com/1/users/profile_image?screen_name=@datachick 48 48 7705 Kevin Boles Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds many SQL Server related certifications and is also an MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for almost years. He is also a Mentor with SolidQ, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially scalability, performance analysis and tuning. @TheSQLGuru http://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru 48 48 6659 Mark Tabladillo Mark Tabladillo (MVP, SAS Expert) has been an information technology professional since 1998, and has a primary career consulting with companies across the United States and around the world. Mark's business mission is to empower and inspire executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark shares his thoughts on his professional blog at http://marktab.net @marktabnet http://www.linkedin.com/company/marktab-consulting http://www.marktab.net https://api.twitter.com/1/users/profile_image?screen_name=@marktabnet 48 48 7065 Matt Masson Matt Masson is a Software Development Engineer working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product including upgrade, performance, and overall user experience. He is a frequent presenter at Microsoft conferences, and maintains the SSIS Team blog. Prior to joining Microsoft in 2006, Matt was a developer on a number of BI Reporting and Analytical products @mattmasson http://www.linkedin.com/in/mmasson http://www.mattmasson.com https://api.twitter.com/1/users/profile_image?screen_name=@mattmasson 48 48 6922 Melissa Coates Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As a Senior Consultant with Intellinet, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at www.sqlchick.com. @sqlchick http://www.linkedin.com/in/melissacoatesprofile http://www.sqlchick.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlchick 48 48 7490 Pam Shaw Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa. @http://www.linkedin.com/in/pshaw1129 http://www.linkedin.com/in/pshaw1129 http://sqlpam.wordpress.com/ https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw1129 48 48 7699 Phil Pledger Phil Pledger is a SQL Server consultant in Atlanta, GA and has spent almost 20 years working with SQL Server starting with version 4.2 on NT 3.1 and has worked with every version since. His focus is on schema design and performance tuning. He has a BS and MS in Computer Science from the University of Alabama. @philpledger http://www.linkedin.com/pub/phil-pledger/15/1a4/480 http://www.SqlServerAssociates.com https://api.twitter.com/1/users/profile_image?screen_name=@philpledger 48 48 6905 Rafael Salas Rafael Salas is a MCITP with a Bachelors degree in Computer Engineering and a Masters in Information Technology . Currently, he is a Manager of Professional Services Consulting at Quaero, CSG International. Rafael is a SQL Server MVP with more than 12 years of experience in data warehousing and BI. He is a blog and article author, and is very active in some SQL Server community forums. You can find more about Rafael on his blog: www.rafael-salas.com @RafSalas http://www.linkedin.com/in/rafaelsalas http://www.rafael-salas.com/ https://api.twitter.com/1/users/profile_image?screen_name=@RafSalas 48 48 6413 Rob Volk Rob Volk does deranged things with SQL Server, so you don't have to. A DBA in the Metro Atlanta area for the past 10 years, he has also abused other database and programming platforms elsewhere and elsewhen. In his spare time he accomplishes more than he does on the job, just don't tell his boss. @sql_r http://www.linkedin.com/pub/rob-volk/1/ba8/134 http://weblogs.sqlteam.com/robv/ https://api.twitter.com/1/users/profile_image?screen_name=@sql_r 48 48 7412 Robert Cain Robert C. Cain (http://arcanecode.com) is a Microsoft MVP SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, co-author of Volumes 1 and 2 of 'SQL Server MVP Deep Dives', as well as the upcoming 'Professional SQL Server 2012 Administration'. A popular speaker, Robert has presented at events such as TechEd, SQL Rally, and numerous SQL Saturdays. @arcanecode http://www.linkedin.com/in/arcanecode http://arcanecode.com https://api.twitter.com/1/users/profile_image?screen_name=@arcanecode 48 48 7365 Stacia Misner Stacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She is a SQL Server MVP, MCITP, MCTS, and has authored or co-authored multiple books about Microsoft business intelligence technologies. @StaciaMisner http://www.linkedin.com/in/staciamisner http://blog.datainspirations.com https://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner 48 48 6254 Stuart Ainsworth Stuart R Ainsworth, MA, MEd is a Database Architect working in Financial Information Security; he's worked as a Research Analyst, a report writer, a DBA, a programmer, and a public speaking professor. In his current role, he's responsible for a data analysis operation that processes several hundred million rows per day. He's one of the chapter leaders for AtlantaMDF. A master of air guitar, he has yet to understand the point of Rock Band ('You push buttons? What's that all about?'). @codegumbo http://www.linkedin.com/in/stuartainsworth http://www.codegumbo.com https://api.twitter.com/1/users/profile_image?screen_name=@codegumbo 48 48 6836 Sven Aelterman Sven Aelterman is a lecturer in Information Systems at Troy University in Troy, Alabama. He teaches undergraduate courses in database design, data warehousing and network infrastructure and security. He is also the technology specialist for the Sorrell College of Business at TROY and performs a variety of technology roles with a global scope. He continues consulting work through Adduxis, where he assists customers with software development projects using the Microsoft .NET Framework. @svenaelterman http://linkd.in/svena http://svenaelterman.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@svenaelterman 48 48 7643 Teo Lachev Teo Lachev (MVP, MCSD, MCT, MCITP) is a consultant, author, and mentor, with a focus on Microsoft Business Intelligence. His Atlanta-based company “Prologika” helps organizations make sense of data by effectively applying Microsoft Business Intelligence technologies. Teo has authored and co-authored several SQL Server Business Intelligence books and he has been leading the Atlanta Business Intelligence group. @tlachev http://www.linkedin.com/in/tlachev http://www.prologika.com https://api.twitter.com/1/users/profile_image?screen_name=@tlachev 48 48 6249 Tim Radney Lead System DBA for a top 40 US held bank. Chapter leader for the Columbus GA SQL Users Group, PASS Regional Mentor for Greater South East US. I am a Microsoft Systems Admin turned DBA. Prior to becoming a full time DBA I spent 10 years supporting Citrix, Novell, Windows, IIS, and MSSQL. @http://www.twitter.com/tradney http://linkedin.com/in/tradney http://www.timradney.com https://api.twitter.com/1/users/profile_image?screen_name=@http://www.twitter.com/tradney 48 48 6168 Vicky Harp With 10 years of professional software development experience, Vicky is always interested in learning new ways to improve performance and maintainability of database code. She is a senior developer with Idera, where she is presently lead developer for SQL diagnostic manager. @vickyharp http://www.linkedin.com/in/vickyharp https://api.twitter.com/1/users/profile_image?screen_name=@vickyharp 48 48 6809 Wayne Sheffield Wayne Sheffield is a Sr. SQL Server DBA, currently working with General Electric Healthcare in Richmond, Va. With twenty years in the IT industry, he has spent the last 12 working with SQL Server database systems (starting from version 6.5). He is the author of several articles at www.sqlservercentral.com, where he also is active on the forums assisting the community. @DBAWayne http://www.linkedin.com/in/waynesheffield http://blog.waynesheffield.com/wayne https://api.twitter.com/1/users/profile_image?screen_name=@DBAWayne 48 48 6565 Wesley Brown Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Database Administrator Consultant for Dell. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays. @SQLServerIO http://www.linkedin.com/in/sqlserverio http://www.sqlserverio.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLServerIO 48 48 6190 William E. Pearson III Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution. @Bill_Pearson http://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85e https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson 48 48 6166 6166 Jonathan Boulineau POW Room 1 Moore's law is not dead; it lives on as CPU manufacturers add more and more CPU cores to the same chip real estate. In this session, we will look at the ways in which you can leverage concurrent processing in your PowerShell code to dramatically increase the efficiency of your code. Speed up those ETL processes, execute code on multiple servers at the same time, and complete your maintenance tasks much faster using the techniques you will learn. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6168 6168 Vicky Harp DBA\DEV Room 10 Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6190 6190 William E. Pearson III DBA\DEV Room 6 Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6249 6249 Tim Radney DBA\DEV Room 7 TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6254 6254 Stuart Ainsworth DBA\DEV Room 8 Most database professionals know (from firsthand experience) that there continues to be a 'data explosion', and there's been a lot of focus lately on 'big data'. But what do you do when your data's just kind of 'biggish'? You're managing Terabytes, not Petabytes, and you're trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of 'larger-than-average' databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6260 6260 Christina Leo DBA\DEV Room 8 You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you. First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 6302 6302 Bob Langley DBA\DEV Room 6 With the new data security standards and legislation, encryption has become a necessity in today’s business world. This session will introduce SQL Server column-level encryption and show how it can easily be implemented as part of a comprehensive security initiative (even in SQL Server Express Edition!). The session will include slides and discussions to introduce concepts and will also have a live demo of a simple implementation of column-level encryption. This is intended for anyone who is interested in SQL Server encryption, or those who need to implement column-level security in their databases as part of their overall database information security strategy. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6413 6413 Rob Volk DBA\DEV Room 9 In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6429 6429 Denny Cherry DBA\DEV Room 7 During this session we will be digging into the internals of SQL Server indexes. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6432 6432 Denny Cherry DBA\DEV Room 7 In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6515 6515 Karen Lopez DBA\DEV Room 8 A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6565 6565 Wesley Brown DBA\DEV Room 6 Benchmarking, Baselines and Monitoring Storage There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. We will cover: SQLIO, a specific SQL Server benchmarking tool. Iometer, a general IO benchmarking tool and simulator. SQLIOSim a specific SQL Server base lining tool and simulator. TPC style testing focused on TPC-C, TPC-E and TPC-H. Monitoring your system using WMI and virtual file stats. Finally, what it all really means, how to read these results and compare them with each other. With these tools you can plan, deploy and manage your storage for years to come! 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6659 6659 Mark Tabladillo SSAS\IS\RS Room 5 SQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6809 6809 Wayne Sheffield DBA\DEV Room 10 Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?' 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 6836 6836 Sven Aelterman DBA\DEV Room 9 SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read 'folders'). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs. It may be valuable to attend the Introduction to FILESTREAM session also. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6856 6856 Grant Fritchey BEG Room 2 SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6873 6873 Jen Underwood DBA\DEV Room 10 Get mobilized! Mobile business intelligence and mobile applications are hot in 2012. Learn how to leverage Microsoft Business Intelligence and SQL Server data platform technologies with a variety of mobile devices. The session will cover several options, tips, tricks, best practices and field lessons learned. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6875 6875 Andy Leonard SSAS\IS\RS Room 4 In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6878 6878 Jennifer McCown BEG Room 2 If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance! 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6879 6879 Jennifer McCown DBA\DEV Room 10 You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and 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. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6880 6880 Hal Rottenberg POW Room 1 Do you listen to podcasts? It's like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We'll come prepared to hit most any general PowerShell topic you want, and we'll probably sneak some SQL + PowerShell experts on stage to help out. This won't be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED! 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 6883 6883 Jason Strate DBA\DEV Room 8 There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6891 6891 Ed Wilson POW Room 1 Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 6905 6905 Rafael Salas SSAS\IS\RS Room 5 SSIS in SQL Server 2012 is getting major face lift and comes loaded with a great deal of enhancements and new features. In this session we explore the new the new project deployment model, design and runtime features along with deployment and management considerations using the also brand new SSIS catalog. This session provides you with valuable to get you going in your next SSIS 2012 project. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 6922 6922 Melissa Coates SSAS\IS\RS Room 3 You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft's vision of delivering 'BI for the Masses.' In this session we will dismiss the hype examine how this new world of 'Managed Self-Service BI' complements Corporate BI in SQL Server 2012 and SharePoint 2010. Goals: (1) Overview of each Self-Service component. (2) Introduce Codename 'Data Explorer' and Data As A Service. (3) Techniques to monitor, manage, secure the Self-Service BI environment. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 6962 6962 Grant Fritchey DBA\DEV Room 6 It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7060 7060 Geoff Hiten SSAS\IS\RS Room 3 Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving where you live or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using examples focused on SharePoint workloads. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7065 7065 Matt Masson SSAS\IS\RS Room 4 Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7163 7163 Jessica Moss SSAS\IS\RS Room 4 Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using 'report parts'. Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7331 7331 Brian Kelley DBA\DEV Room 7 In this session, we’ll take a look at Windows operating system internals, including kernel architecture, threads and processes, memory usage, and I/O, and how they affect how SQL Server performs and acts. By having a good understanding of how the operating system works under the covers and how it interacts with the SQL OS, you will gain a deeper knowledge of what’s going on with your SQL Servers and where performance issues may be on your systems. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7334 7334 Brian Kelley BEG Room 2 Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, 'Jack of all trades, master of none.' The full saying is, 'Jack of all trades, master of none, though often times better than master of one.' 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7365 7365 Stacia Misner SSAS\IS\RS Room 3 Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View . 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7412 7412 Robert Cain SSAS\IS\RS Room 3 Reporting Services can be one of the easier tools to configure, once you understand how to use the configuration manager. In this session you'll explore the configuration settings available through the exploration of the Reporting Services Configuration Manager. You'll learn the different accounts Reporting Services will need in order to run, how to access Reporting Services via URLs, and the importance of encryption keys. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7413 7413 Robert Cain BEG Room 2 Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7490 7490 Pam Shaw SSAS\IS\RS Room 4 So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7492 7492 Hope Foley SSAS\IS\RS Room 5 Importing data is as common to SQL Server as bacon is to a savory breakfast sandwich. As most of us love to eat those breakfast sandwiches, SQL Server Integration Services (SSIS) loves to eat data in an Import/Export kind of way. Although a green chain of boxes in SSIS can be the ruling “Happy Dance” of any DBA or SQL Developer, we must still consider the performance of those tasks. In this session, we will go through performance tuning in SSIS 2012 after a successful SSIS package has been developed. When we are finished with this session, not only will you still have the mystic of green colors of successful execution of your SSIS import and export tasks, but the turbo boosters will be turned on as well. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7542 7542 Jim Wooley DBA\DEV Room 8 As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio to help manage these changes better. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7552 7552 Jim Christopher POW Room 1 You know that problem you're working on? Chances are someone has already solved it, and has packaged their solution up in a nice pretty PowerShell module for you to use. Come learn about PowerShell modules - what they are, how you use them, where you can find them. And let's explore some of these modules and see what problems they can solve for us. 4/14/2012 10:15:00 AM 4/14/2012 11:30:00 AM 7553 7553 Allen White POW Room 1 Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7639 7639 Eric Melcher SSAS\IS\RS Room 5 Recent changes in Business Intelligence have placed greater emphasis on on enabling end-user analytics. While compelling in theory, in practice there are many challenges when creating a foundation that supports end-users analytics. Many of these challenges revolve around making consistent reference (i.e. dimensional) data available to end users. This can be addressed using a Master Data Management solution. This session session will explore ways that Master Data Services 2012 can be used to support the definition and management of master data used to support analytics (BI) solutions. It will start with a high level overview of MDM and MDS 2012, and finish with a demo of an analytical MDM solution. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7642 7642 Glen Gordon DBA\DEV Room 9 Learn about the various options for managing data in a Windows Phone application, including local storage, accessing data feeds, synchronization, and more. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7643 7643 Teo Lachev SSAS\IS\RS Room 4 Confused about the BI alphabetical soup? Not sure which one makes sense for your organization? Join this session to learn you can use the Microsoft BI platform to address various analytical needs. Discover how to implement the Personal-Team-Organizational continuum on a single platform. I'll also discuss how Tabular and Multidimensional compare. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7677 7677 Julie Smith BEG Room 2 You’ve finally gotten your first job working with SQL Server (SS) as the junior DBA at company XYZ. All the studying, the classes, the pricey SS certification exams, the User Group attendance has paid off. Your first day at the job your boss walks you through some new job duties. He wants you to remote out to the server to look at the file directory where the FTP process writes the encrypted files make sure the file share didn’t disappear when the cluster failed over. You slip away to the bathroom, lock yourself in a stall, have a seat and rock side to side muttering -What is he talking about?I thought there would be tables. If this sounds familiar this session is for you. Learn about the SS ecosystem how to navigate it as a new 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7698 7698 Erika Bakse SSAS\IS\RS Room 3 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 that starts with your data query. In this session, we'll think outside the group! Learn about how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts. 4/14/2012 2:30:00 PM 4/14/2012 3:30:00 PM 7699 7699 Phil Pledger DBA\DEV Room 10 Over the years, I have seen NULL abused in many ways, often to the detriment of the application. This session will help you gain a deeper appreciation for what seems, on the surface, to be a simple topic. We will dig into how NULLs impact schema semantics, storage internals, and query performance. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7705 7705 Kevin Boles DBA\DEV Room 6 This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used. 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7751 7751 Adam Machanic DBA\DEV Room 9 In today's multi-core-driven world, query performance is very much determined by how well you're taking advantage of the processing power at your disposal. In this session you will learn how to take full advantage of parallelism, from a developer's point of view. After a quick terminology review and technology refresher the session will go deep, covering T-SQL patterns that allow certain queries to scale almost linearly across your multi-core CPUs. Not all T-SQL queries can go parallel, so you'll also learn to watch for those things that can restrict the query optimizer's decisions. Along the way you'll learn to manipulate costs and row goals, challenge generally accepted tuning practices, and take complete control of your parallel queries. 4/14/2012 1:00:00 PM 4/14/2012 2:15:00 PM 7752 7752 Jeremy Carroll DBA\DEV Room 7 In this session we will review the growing parts of rows and how to keep them as lean as possible. The following topics will be studied: • Row structure with a concentration on the parts that grow • Row and page compression and their effect on row structure • Prefix and Dictionary compression and their effect on row structure • The CPU cost of running queries against compressed data • Some strategies for compressing various data • Leave the attendees with additional demos and scripts for studying compression and testing it on your own machine 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM 7764 7764 John Welch SSAS\IS\RS Room 5 You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube. 4/14/2012 3:45:00 PM 4/14/2012 4:45:00 PM 7776 7776 Aaron Nelson DBA\DEV Room 9 SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff! 4/14/2012 9:00:00 AM 4/14/2012 10:00:00 AM