SQLSaturday #62 - Tampa 2011 1/15/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat62 Tampa FL 33605 840 Kforce Platinum Sponsor http://www.kforce.com/ http://www.sqlsaturday.com/files/90b24ff0-fcf4-4c71-b140-b4057da0c290.JPG 60 170 856 Red Gate Platinum Sponsor http://www.red-gate.com http://www.sqlsaturday.com/images/resized%20-%20redgate_logo.png 60 170 861 Tavolacci and Associates, Inc. Platinum Sponsor http://tavolacci-associates.com http://tavolacci-associates.com/images/Tavolaccci-YouCanLearn.gif 60 170 890 Pragmatic Works Platinum Sponsor http://www.pragmaticworks.com http://pragmaticworks.com/images/PragmaticWorks-footer-logo.jpg 60 170 912 Soaring Eagle Consulting Gold Sponsor http://soaringeagle.biz/index-1.html http://www.tampasql.com/Assets/Images/SoaringEagleLogoHorizontal211.jpg 60 170 852 Enterprise Software Solutions Gold Sponsor http://www.entsoftsol.com http://www.sqlsaturday.com/files/b9c588ba-b5e5-42d6-bedc-d657342022c51.jpg 60 170 853 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 846 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 915 Catapult Systems Silver Sponsor http://www.catapultsystems.com http://www.sqlsaturday.com/files/ff2e90a5-25fc-4960-80e2-d83dbe49234f.jpg 60 170 900 Microsoft Silver Sponsor http://www.microsoft.com/en/us/default.aspx http://www.tampasql.com/Assets/Images/bnr-microsoft.gif 60 170 879 Melissa Data Corp Silver Sponsor http://www.Melissadata.com http://www.melissadata.com/home/new-2009/melissa-data-logo.gif 60 170 881 SQL Server Magazine Silver Sponsor http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/%7Bc4e191cc-885e-42e4-bdaa-f39a5976393e%7D_PromoInt_SQL_LOGO_BW_192x45.jpg 60 170 887 Gerasus Software Silver Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 60 170 904 SQLShare Bronze Sponsor http://www.sqlshare.com http://www.sqlshare.com/sqlshareimages/sqlshare_header_logo.jpg 60 170 933 Telerik Bronze Sponsor http://www.telerik.com http://www.sqlsaturday.com/files/cf8e7dae-e2ca-45cf-89f4-e431d98457a9.png 60 170 863 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 875 Advaiya, Inc. Bronze Sponsor http://www.advaiya.com http://www.sqlsaturday.com/files/cb1fb5aa-90b0-4cb2-87f1-0b55baa2b263.jpg 60 170 3069 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). Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. Mike is an experienced speaker and has presented at many events such as several User Groups, Code Camps, Launches, and SQL Saturdays. @http://twitter.com/sqlvariant http://www.linkedin.com/in/sqlvariant http://www.sqlvariant.com/wordpress https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 2958 Adam Jorgensen Adam Jorgensen, President – Pragmatic Works Consulting - has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups and other organizations. He regularly speaks at industry group events, Code Camps, and SQLSaturday events on strategic and technical topics. @adam_Jorgensen http://www.linkedin.com/in/wajorgensen http://bidn.com/people/AdamJorgensen https://api.twitter.com/1/users/profile_image?screen_name=@adam_Jorgensen 48 48 2989 Bill Ramos I'm currently the SQL Server Work Stream Manager for Advaiya. During my 15 years at Microsoft as a program manager, I shipped or been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Ashton-Tate/Microsoft SQL Server for OS2 (at Ashton-Tate), Excel 2003, Access 2003, Access XP, Access 2000, @billramo http://www.linkedin.com/in/billramo http://sqlblog.com/blogs/bill_ramos https://api.twitter.com/1/users/profile_image?screen_name=@billramo 48 48 2812 Brad Schacht Brad Schacht is a BI Consultant and Trainer for Pragmatic Works. His experience on the Microsoft BI platform includes DTS, SSIS, Reporting, and migrations and conversions. Brad uses this experience to make the topics real for those he’s working with and teaching. Brad also participates as a speaker at events such as SQL Saturday and Code Camp and is an active member of the Jacksonville SQL Server User Group. @bradleyschacht http://www.linkedin.com/pub/brad-schacht/17/66b/b08 http://bidn.com/blogs/bradschacht https://api.twitter.com/1/users/profile_image?screen_name=@bradleyschacht 48 48 3065 Bradley Ball Bradley Ball is a MCITP SQL 2005 MCTS 2008 Database Administrator with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on http://sqlballs.blogspot.com . @#SQLBalls http://www.linkedin.com/in/sqlballs http://sqlballs.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@#SQLBalls 48 48 2821 Brian Knight Brian K. McDonald, MCDBA, MCSD is a Business Intelligence consultant for Pragmatic Works. Brian has served in many roles over his 11+ years in the IT industry. Brian has written featured articles for industry websites and has a very active blog on SQLServerCentral and BIDN. Brian is an active member of the Jacksonville SQL Server User's Group and has presented at User groups, Code Camps and SQL Saturday events across Florida. @briankmcdonald http://www.linkedin.com/in/brianwmitchell https://api.twitter.com/1/users/profile_image?screen_name=@briankmcdonald 48 48 2988 Chad Miller Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQL Saturdays and Code Camps. @cmille19 http://www.linkedin.com/in/chadwickmiller http://sev17.com https://api.twitter.com/1/users/profile_image?screen_name=@cmille19 48 48 2829 David Dye David is an Accidental DBA/Developer for a manufacturing company in Alabama. David has three years of experience learning and administering a small SQL Server installation within the company, making use of it to make the manufacturing process more visible to management. Having earned both his MCTS and MCITP DBA certifications for SQL Server 2008, he still considers himself a beginner sharing with other beginners. @derekman1 http://www.linkedin.com/in/dyfhid http://dyfhid.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@derekman1 48 48 2899 Denny Cherry Denny Cherry has over a decade of experience managing SQL Server and is currently the Manager of Information Systems at Awareness Technologies. Denny holds several Microsoft Certifications 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 2814 Dmitri Korotkevitch Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Workforce Management solutions. Back-end database handles more than 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates. http://aboutsqlserver.com https://api.twitter.com/1/users/profile_image?screen_name= 48 48 2950 Don Stevic I have been a full time DBA for about 7 year now. Before that I was a opera singer, a high school drama teacher, and a trainer for an IT school. I moonlight as a comic book store owner, and know far too much about comics. @sql_superman http://www.linkedin.com/profile/view?id=4456558locale=en_UStrk=tab_pro http://fortressofsqltude.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@sql_superman 48 48 2980 Dr. Suresh Rajappa PhD PMP MBA Suresh leads the advanced Business Intelligence technology strategy and services for Novedea. The primary focus of Suresh and his team is to provide high-end value to our clients through the service offerings of our consulting practice. These offerings include: BI Strategy, Rapid BI solution, Data Management and Enteprise BI services. With over 19 years of experience, he provides thought leadership to the overall technology services strategy http://www.linkedin.com/SureshRajappa http://www.novedea.com/company/ 48 48 2885 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 https://api.twitter.com/1/users/profile_image?screen_name=@ScriptingGuys 48 48 2824 Eddie Wuerch Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design and manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is an MCT. @eddiew http://www.linkedin.com/in/eddiewuerch http://indydba.com https://api.twitter.com/1/users/profile_image?screen_name=@eddiew 48 48 2894 Eric Wisdahl Eric Wisdahl (MCTS - BI, Database Development, Implementation and Maintenance) is a development dba working in the e-commerce Industry. He spends what little free time he has reading technical books, playing games, perusing the MSDN SQL Forums, or spending time with his wife and dogs. In a past life he has worked as a ETL / BI Specialist in the insurance industry, a Pizza Boy, Patent Examiner, Pro-IV Code Monkey and .Net punching bag. @EricWisdahl http://www.linkedin.com/in/ericwisdahl http://ericwisdahl.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@EricWisdahl 48 48 3034 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. Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, virtualization, and database strategy implementations. @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 3032 Ira Whiteside Information Technology professional with over 30 years of industry experience , Hands on experience in using Microsoft SQL Server 2005/2008 tools, including SSIS, SSAS, SSRS (Microsoft Reporting Services) MDM (Master Data Services) and Data mining. In addition, have written and blogged several Articles for SQL Server Central and other publications. @irawhiteside http://www.linkedin.com/in/irawarrenwhiteside http://irawarrenwhiteside.com/ https://api.twitter.com/1/users/profile_image?screen_name=@irawhiteside 48 48 3061 Jack Corbett Jack has worked with SQL Server for 10 years in small to mid-sized businesses ranging from manufacturing to non-profits. Jack is the co-president of OPASS (Orlando SQL Server user group) and one of the organizers of SQLSaturday #21 and #49 in Orlando. Jack has spoken at several user groups and SQLSaturdays. When Jack is not working with SQL Server he enjoys playing, coaching, and watching sports. @unclebiguns http://www.linkedin.com/in/jackcorbett http://www.wiseman-wiseguy.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@unclebiguns 48 48 3059 James McAuliffe James McAuliffe is a Senior Lead Consultant for Catapult Systems. He has been working as a professional software developer since 1993, and has worked with clients of all sizes, from local businesses to Fortune 500 companies. James has been using SQL Server since 1999, and in the last few years with a concentration on the Business Intelligence methodologies. http://www.linkedin.com/pub/james-mcauliffe/3/b09/b 48 48 2834 Janis Griffin Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions primarily in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was also a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning. @DoBoutAnything http://www.linkedin.com/pub/janis-griffin/0/914/aba http://www.confio.com https://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything 48 48 2986 Jeffrey Garbus Jeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at a week of SQL Saturdays. http://www.linkedin.com/in/jeffgarbus 48 48 2934 John Welch John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies for 9 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), 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 2860 Jonathan Kehayias Jonathan Kehayias is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he transitioned to the role of SQL Database Administrator. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. @sqlpoolboy http://sqlblog.com/blogs/jonathan_kehayias https://api.twitter.com/1/users/profile_image?screen_name=@sqlpoolboy 48 48 2966 Jorge Segarra I’m an MCTS (SQL Server 2005) currently working as a DBA in Jacksonville, Florida. In addition to being a member of the Tampa SQL Server, Tampa SQL Server Business Intelligence, and VMware user groups I am also a Hypervisor for the PASS Virtualization Virtual Chapter and chapter leader of the PASS Professional Development Virtual Chapter. I have also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist. @sqlchicken http://linkedin.com/in/jdsegarra http://sqlchicken.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlchicken 48 48 3062 Julie Smith Julie Smith has spent the last 11 years moving data using varied tools such as MS Access, MySQL, and most importantly DTS and SSIS/SQL Server 2000-2008. She is an MCP in SQL Server 2000: Implementing Database Design. She currently works as a Business Intelligence Consultant for Key2 Consulting, LLC in Atlanta, GA, where she specializes in ETL development. She is also one half of the DataChix. @datachix1 http://www.linkedin.com/in/juliesmith0503 http://datachix.com https://api.twitter.com/1/users/profile_image?screen_name=@datachix1 48 48 3068 Kendal Van Dyke Kendal began working with SQL Server 7.0 as a VB developer 10 years ago. He has spent the last 8 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of over 40 SQL Servers. Kendal is known as @SQLDBA on Twitter and maintains a technical blog on SQL Server topics at http://www.kendalvandyke.com. @http://twitter.com/#!/sqldba http://twitter.com/SQLDBA http://www.kendalvandyke.com/ https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/#!/sqldba 48 48 3012 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 virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for over ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning. @TheSQLGuru http://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru 48 48 2994 Mark Landry Mark Landry has over thirty years of experience in software development. He has been an independent software consultant for fifteen years specializing in object-oriented design and programming, relational and multidimensional database design, and data warehousing. He is considered a regional expert in Analysis Services. Mr. Landry holds Bachelors and Masters Degrees in Computer Science. 48 48 2861 Michael Antonovich Michael Stark has been in software development for 20 years. He is certified in SQL Server and .Net. He enjoys learning new technology and sharing what he has learned with others. Michael resides in Tampa but likes to travel as much as possible. @MPAntonovich http://www.linkedin.com/in/michaelpantonovich http://micmin.org/blog.aspx https://api.twitter.com/1/users/profile_image?screen_name=@MPAntonovich 48 48 2850 Plamen Ratchev Plamen is an SQL Server MVP and founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. @PlamenRatchev http://www.linkedin.com/in/plamenratchev http://pratchev.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@PlamenRatchev 48 48 2917 Randy Knight Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for Match.com, one of the largest and most successful dot coms. @randy_knight http://www.linkedin.com/in/randyknight http://www.sqlsolutionsgroup.com https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 2833 Rodney Landrum Rodney Landrum has been architecting solutions for SQL Server for over 15 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services and published The SQL Server Tacklebox in 2009. He is a regular contributor to SQL Server magazine and simple-talk.com where he occasionally blogs, and is a SQL Server MVP. @SQLBeat http://www.linkedin.com/in/kylejdoyle http://www.simple-talk.com/author/rodney-landrum/ https://api.twitter.com/1/users/profile_image?screen_name=@SQLBeat 48 48 3043 RONALD DAMERON Ronald Dameron is a Senior Database Administrator for the largest life insurer in the United States. He is currently exploring how PowerShell can simplify his life as a DBA. He is a previous speaker at SQL Saturday Tampa, Orlando, South Florida and the Tampa SQL User group. He has published articles at www.simple-talk.com, sqlserverpedia.com and RonaldDameron.blogspot.com on his PowerShell experience. Follow him on Twitter at @RonDBA. @RonDBA http://www.linkedin.com/in/rdameron http://ronalddameron.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@RonDBA 48 48 2925 Russel Loski Russ Loski is an independent software developer and trainer based in Dallas, TX. He has worked with SQL Server since 6.5 and also develops .Net applications. He has worked with clients such as the Dallas Cowboys, T-Mobile and Rave Motion Pictures. He especially likes to work with ETL products such as SSIS. @sqlmovers http://www.linkedin.com/in/russloski https://api.twitter.com/1/users/profile_image?screen_name=@sqlmovers 48 48 2978 Sandra Mueller Sandra A. Mueller is a 16 year MCT. She started with Administration in 1997 and moved into Database Design and performance optimization. In 2004 after activation with the military focus turned to SQL Server 2005 and its Business Intelligence capabilities. She is currently working as a Senior BI Architect with SQL Server 2008R2 OLAP solutions. Sandra blogs on http://www.SandraAMueller.com and is Chapter Leader and founder of the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). @SandraAMueller http://www.linkedin.com/in/sandramueller http://www.SandraAMueller.com https://api.twitter.com/1/users/profile_image?screen_name=@SandraAMueller 48 48 2822 Scott Schledwitz Senior Consultant in BI and Data Architecture for Information Builders. * Deploy solutions to clients in the grovernment, financial services and healthcare sectors. * Developed the ARRA Fund Manager, a compliance reporting tool used by states and municipalities for federal funds reporting. * Author of 'No Nerds' and 'The Brave, New Front' - articles printed in Computerworld. * 2010 Recipient of the Business Intelligence Competency Center Visionary Award. @http://twitter.com/ecuity http://www.linkedin.com/in/schledwitz http://www.informationbuilders.om https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/ecuity 48 48 2886 Tim Radney Senior DBA in the financial sector. Former Microsoft Systems Admin turned DBA. Have been a full time DBA going on 3 years. 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 2884 Timothy McAliley Timothy is a Team Foundation Server Administrator and Database Administrator on a Business Intelligence Team at Symantec (www.symantec.com, (SYMC). His particular interests are IT operations, information security, project management, and database/application tier high availability solutions. Timothy is a PMP, a CISA, a CISM, a CISSP, and is ITIL V3 Foundations certified. Timothy also holds MCTS, MCITP certifications on Windows Server 2008, SQL Server 2005/2008, and Exchange Server 2010. @sysframeworks http://www.linkedin.com/profile/view?id=37139287trk=tab_pro http://www.sysframeworks.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@sysframeworks 48 48 2830 Troy Gallant Troy has been a SQL Server professional for over 8 years; initially as a developer, then the last 3 as DBA for several very large international organizations. When not working or traveling to various SQL Saturdays, he enjoys killing Hordies in Warcraft, listening to the Grateful Dead, and pickin' his mandolin till the sun comes up. Known on Twitter as the 'GratefulDBA' and online at http://troygallant.com @GratefulDBA http://www.linkedin.com/in/tgallant http://troygallant.com https://api.twitter.com/1/users/profile_image?screen_name=@GratefulDBA 48 48 2812 2812 Brad Schacht Track 1 Cafeteria In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demostrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS. Co-Presenter: Sherri McDonald 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2814 2814 Dmitri Korotkevitch Track 4 Room C Stored procedures are slow? SQL Server is overloaded? Maybe it's time to upgrade the server. But maybe all you need to do is the code refactoring. This session shows how to replace several common procedural style patterns in T-SQL code with set-based approaches. It demonstrates how to gain huge performance improvements using CTE, table-valued functions, TVP, MERGE operator, OUTPUT clause and other modern T-SQL constructs. No PowerPoint slides. Presentation is based on the real examples and real code. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 2821 2821 Brian Mitchell Track 3 Room B We will cover an overview of the functionality of SQL PDW. PDW is a highly scalable appliance for Enterprise data warehousing. We will discuss how PDW partitions large tables across multiple physical nodes, each having its own dedicated CPU, memory, storage, and each running its own instance of SQL Server in a parallel shared nothing design. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 2822 2822 Scott Schledwitz Track 3 Room B The capabilities of SQL are appreciated by the PASS community, but when the end users express their love for SQL, that is pretty amazing. SQL 2005 actually saved a BI deployment from becoming an utter disaster and flipped it to an enormous success. We will explore the previous data model and how the adaptability of SQL made changes to the front end (changing from standard html output to allowing RIA and Ajax design tools) and extension of user capabilities possible without degrading performance or burdening the developers. 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2824 2824 Eddie Wuerch Track 7 Room F Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing! 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2829 2829 David Taylor Track 7 Room F When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee's Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks. 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2830 2830 Troy Gallant Track 6 Conference Room SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 2833 2833 Rodney Landrum Track 4 Room C At its heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports. 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2834 2834 Janis Griffin Track 7 Room F Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2850 2850 Plamen Ratchev Track 2 Room A Hierarchical solutions used to be “reserved” for experts in the theory of trees and graphs. Not anymore! Learn how the new data type HIERARCHYID in SQL Server 2008 helps to simplify storage and manipulation of hierarchies. Practical examples and comparison with traditional methods like nested sets, adjacency list, and materialized path. 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2860 2860 Jonathan Kehayias Track 4 Room C Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 2861 2861 Michael Antonovich Track 3 Room B This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 2884 2884 Timothy McAliley Track 7 Room F Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 2885 2885 Ed Wilson Track 5 Bar Room 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 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 2886 2886 Tim Radney Track 5 Bar Room You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2894 2894 Eric Wisdahl Track 6 Conference Room An advanced session which will attempt to break down areas of the data flow buffer. In examining how the buffers are built and used, the user will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The session will further take a look at the effects of parallel package and parallel task execution. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 2899 2899 Denny Cherry Track 5 Bar Room In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 2915 2915 Brian McDonald Track 4 Room C SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this introductory session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2917 2917 Randy Knight Track 6 Conference Room In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2925 2925 Russel Loski Track 4 Room C SQL Server Integration Services (SSIS) and Reporting Services (SSRS) are two pillars of Microsoft's Business Intelligence stack: SSIS gathering the data and SSRS displaying the data. Do you know that SSRS provides a set of Web Services that SSIS can use to manage and even render SSRS reports? In this session we will develop an SSIS package that exports an SSRS report to pdf format using these Web Services. Then we will use the SSRS Web Services in a Data Flow Script Component to get data from a report. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 2934 2934 John Welch Track 1 Cafeteria The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS. 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2946 2946 Michael Stark Track 7 Room F A demonstration of SQL Geography Data Type in SQL Server 2008. We will constuct queries to easily match data by geographic location. Then we will wire this query up to an ASP.Net using Javascript and Handlers. Finally, we will wire this query up to a windows phone 7 device. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 2950 2950 Don Stevic Track 2 Room A When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2951 2951 David Dye Track 4 Room C SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2958 2958 Adam Jorgensen Track 1 Cafeteria In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Adam Jorgensen and a surprise guest GURU), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 2966 2966 Jorge Segarra Track 6 Conference Room We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers! 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2978 2978 Sandra Mueller Track 3 Room B Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2980 2980 Dr. Suresh Rajappa PhD PMP MBA Track 2 Room A Design tips and tricks on implementing enterprise datawarehose and common pitfalls to avoid. This session also provides the realworld examples 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 2986 2986 Jeffrey Garbus Track 3 Room B Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 2988 2988 Chad Miller Track 5 Bar Room In this sesssion we will look at how the CodeProject SQLPSX can be used for real world PowerShell automation. Specific topics covered include using ADO.NET, retrieving SQL Server information, SSIS administration, Policy-Based Management and SQLIse a WPF-based query tool. 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 2989 2989 Bill Ramos Track 2 Room A In this session you will learn about the SQL Server 2008 R2 data collector and management data warehouse for troubleshooting your problem situations with your SQL Server. I'll demonstrate several problem scenarios and how the MDW reports can help you identify the root cause. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 2994 2994 Mark Landry Track 6 Conference Room Intermediate MDX. Calculations, subselect, subcubes, MDX extensions. The subsequent session to 'MDX 101'. 1/15/2011 1:30:00 PM 1/15/2011 2:30:00 PM 3012 3012 Kevin Boles Track 6 Conference Room Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 3032 3032 Ira Whiteside Track 7 Room F Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 3034 3034 Geoff Hiten Track 3 Room B How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 3043 3043 RONALD DAMERON Track 5 Bar Room I will detail my reasoning why any IT Pro working in the Microsoft space would benefit from learning PowerShell. I will demonstrate how you can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage your workload. I will also share my thoughts on the best ways to learn PowerShell. 1/15/2011 8:30:00 AM 1/15/2011 9:30:00 AM 3059 3059 James McAuliffe Track 1 Cafeteria SSIS can be tricky sometimes. You've probably encountered some behaviours that make you scratch your head, throw up your hands, or even something unprintable. Well, me too!. Over the years of working with SSIS, I have acquired a collection of tips and tricks around areas like: Working with Excel, both as a source and destination, why does this package run so fast on this server and not even run on this other one? How can I compare packages? We will start the session by selecting , cafeteria style, from the topics of interest to the attendees, pick four or five, and drill down from there. Bring your questions! 1/15/2011 9:45:00 AM 1/15/2011 10:45:00 AM 3061 3061 Jack Corbett Track 2 Room A In today's environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework. Jack will share the reasons why he still believes that stored procedures are the best way to access data in SQL Server. When the session is over you will be able to discuss the issues with developers and have resources to show why you think stored procedures can improve application performance, data security, and code maintenance. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 3062 3062 Julie Smith Track 1 Cafeteria Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer new to SSIS who has mastered the dataflow, and is now looking for elegant ways to automate his/her solutions. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions. It will demonstrate short case studies of commonly encountered, real world business scenarios and solutions. 1/15/2011 11:00:00 AM 1/15/2011 12:00:00 PM 3065 3065 Bradley Ball Track 2 Room A Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 3068 3068 Kendal Van Dyke Track 5 Bar Room There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA’s) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, reasons for using each of them. 1/15/2011 4:00:00 PM 1/15/2011 5:00:00 PM 3069 3069 Aaron Nelson Track 1 Cafeteria In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You'll see a battle between two database experts (Mike Davis and Aaron Nelson), attempting to load the database in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the SQL Smackdown. 1/15/2011 2:45:00 PM 1/15/2011 3:45:00 PM 3429 3429 Brian Knight Track 2 Room A In this session, Brian Knight will show you how to accelerate your BI development lifecycle with BI xPress. You’ll see how to implement advanced SSIS frameworks, implement code reusability in SSIS and write MDX calculation code in seconds with this must have time saving application. 1/15/2011 12:15:00 PM 1/15/2011 1:15:00 PM