SQLSaturday #61 - DC 2010 12/4/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat61 Reston VA 20190 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 825 Microsoft Gold Sponsor http://www.microsoft.com http://techtickerblog.com/wp-content/uploads/2009/06/microsoft-logo.jpg 40 100 830 The FUZION Agency Gold Sponsor http://www.FUZIONAgency.com http://www.FUZIONAgency.com/themes/FUZION/images/logoFUZION.jpg 40 100 838 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 40 100 839 idera Gold Sponsor http://www.idera.com/Content/Home.aspx http://www.idera.com/images/Logo.jpg 40 100 843 redgate Gold Sponsor http://www.red-gate.com/?utm_source=SQLsaturday61utm_medium=bannerutm_campaign=sqlmonitor http://www.sqlsaturday.com/images/resized%20-%20redgate_logo.png 40 100 844 CapTech Gold Sponsor http://www.captechconsulting.com/ http://sphotos.ak.fbcdn.net/hphotos-ak-snc4/hs977.snc4/77047_457363549340_237246899340_5222566_5493063_n.jpg 40 100 847 Fusion-io Gold Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 40 100 794 Quest Software Silver Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 826 Wrox Silver Sponsor http://www.wrox.com http://www.mikewach.com/adobe/wrox.gif 60 170 857 SQL Server Magazine Silver Sponsor http://www.sqlmag.com/ http://img.en25.com/eloquaimages/clients/PentonMediaInc/{c4e191cc-885e-42e4-bdaa-f39a5976393e}_PromoInt_SQL_LOGO_BW_192x45.jpg 60 170 779 Edgewood Solutions Bronze Sponsor http://www.mssqltips.com/ http://www.mssqltips.com/images/mssqllogo.gif 60 170 842 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 849 telerik Bronze Sponsor http://www.telerik.com/ http://www.telerik.com/Libraries/Company/TelerikLogoPreview.sflb 60 170 2631 Michael Coles DBA/DEV Advanced Room 2 SQL Server 2008 introduced support for new spatial data features -- providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data. 12/4/2010 2:15:00 PM 12/4/2010 3:15:00 PM 2651 Andy Leonard Professional Development Room 5 Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams. 12/4/2010 8:30:00 AM 12/4/2010 9:30:00 AM 2654 Andy Leonard Database Development Room 3 This session if for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS. 12/4/2010 2:15:00 PM 12/4/2010 3:15:00 PM 2656 Joseph Dantoni Database Development Room 3 Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample. 12/4/2010 1:00:00 PM 12/4/2010 2:00:00 PM 2660 Steve Radich Professional Development Room 5 How do you verify your daily backup can be restored? What if you need to restore a backup from several days ago instead of the latest? How many backups should you keep? I've adopted a Tower of Hanoi tape rotation schedule to meet our disk-to-disk backup needs, at first that sounds simple but it's actually MUCH more complex than it sounds - Learn about the strategy I use, the scripts we use to backup (with reports of success/failure and automatic retries for any failure), how we validate backups, and how we decide which backups to keep and which we erase to free up disk space. 12/4/2010 9:45:00 AM 12/4/2010 10:45:00 AM 2662 Kevin Goff BI Room 4 Learning the basics of MDX is one thing - learning how to incorporate MDX into custom OLAP applications is sometimes more difficult. In this session, I'll show different examples on using MDX inside SSRS reports, PerformancePoint Services dashboards, and even inside Excel. 12/4/2010 3:30:00 PM 12/4/2010 4:30:00 PM 2665 Kevin Goff BI Room 4 Are you trying to get a handle on what PowerPivot can do? Are you also interested in knowing PowerPivot's limitations? Would you like to know how to integrate PowerPivot with Sharepoint 2010? Are you a little confused about where PowerPivot 'fits' in the Microsoft BI stack? Are you unsure about how DAX formulas work? This intro session is almost like a 'PowerPivot for Mere Mortals', where I'll take same data from 2 sources and showcase several of PowerPivot's capabilities. 12/4/2010 11:00:00 AM 12/4/2010 12:00:00 PM 2670 William Pearson BI Room 4 As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions. 12/4/2010 1:00:00 PM 12/4/2010 2:00:00 PM 2696 Matt Van Horn BI Room 4 I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports. 12/4/2010 9:45:00 AM 12/4/2010 10:45:00 AM 2703 Sandra Mueller DBA Room 1 Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't files be auto-shrunk? Why keep that free space in the files? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators! 12/4/2010 9:45:00 AM 12/4/2010 10:45:00 AM 2707 Michael Coles Professional Development Room 5 In today's economy job seekers need to take advantage of every opportunity. In this session attendees will learn how to take advantage of unprecedented opportunities to market themselves to potential employers (and the world at large!) We'll cover topics including fine-tuning your resume, managing your online presence and responding to the toughest interview questions. We'll also discuss how you can turn simple steps, like asking your interviewer questions and sending a follow-up note, into unparalleled opportunities to close the deal. 12/4/2010 11:00:00 AM 12/4/2010 12:00:00 PM 2709 Thomas LaRock DBA Room 1 Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday. 12/4/2010 3:30:00 PM 12/4/2010 4:30:00 PM 2726 Allen White DBA/DEV Advanced Room 2 We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 12/4/2010 9:45:00 AM 12/4/2010 10:45:00 AM 2728 Allen White DBA/DEV Advanced Room 2 The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action. 12/4/2010 8:30:00 AM 12/4/2010 9:30:00 AM 2734 Jana Sattainathan DBA Room 1 Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple and efficient. Manageability and performance come part and parcel. 12/4/2010 1:00:00 PM 12/4/2010 2:00:00 PM 2752 Sergey Pustovit DBA Room 1 There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs. 12/4/2010 2:15:00 PM 12/4/2010 3:15:00 PM 2761 Joel Cochran Database Development Room 3 In this presentation I will walk though a complete real-world SSIS project that pulls data from an AS/400 and converts it to a SQL Server destination. In addition to specific AS/400 conversion issues I will also cover topics like dynamic OLEDB connections, and creating an effective work flow. Along the way we'll take a look at how I use Derived Columns, Conditional Split, Lookup, and Script components to solve every day conversion issues. 12/4/2010 8:30:00 AM 12/4/2010 9:30:00 AM 2762 Joel Cochran Database Development Room 3 The Script Component is an extremely powerful element in SSIS because it brings in the full capability of the .NET Framework. With first-class development tools and languages like C# you can solve problems that previously required very complex SQL or Expressions. If you'd like to learn enough C# to more effectively use the Script Component for Transformations, then this session is for you. 12/4/2010 9:45:00 AM 12/4/2010 10:45:00 AM 2778 Edwin Sarmiento DBA/DEV Advanced Room 2 Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery 12/4/2010 11:00:00 AM 12/4/2010 12:00:00 PM 2779 Edwin Sarmiento Professional Development Room 5 So you open up PowerPoint, create your slides and get ready to present. Sure, you know exactly how to do this - you've done it a lot of times in the past - but there’s more. Leveraging on the experiences learned from presenting at worldwide conferences such as SQL PASS Community Summit, TechEd, DevTeach and the likes, this session will look at what needs to be considered when creating powerful presentations that shine. 12/4/2010 1:00:00 PM 12/4/2010 2:00:00 PM 2784 Jared Nielsen DBA/DEV Advanced Room 2 Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing. 12/4/2010 1:00:00 PM 12/4/2010 2:00:00 PM 2788 Tim Chapman DBA/DEV Advanced Room 2 Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible. 12/4/2010 3:30:00 PM 12/4/2010 4:30:00 PM 2805 Karen Lopez Database Development Room 3 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 * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? * Implementing Party/party role...and others. Bring your votes, your debates, and your opinions. 12/4/2010 3:30:00 PM 12/4/2010 4:30:00 PM 2842 Jose Chinchilla BI Room 4 For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure.In this session attendees will learn some of the basic concepts that are key in understanding BI and DW. I will go over my 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started. 12/4/2010 8:30:00 AM 12/4/2010 9:30:00 AM 2843 Jose Chinchilla Professional Development Room 5 Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills. This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals. But why certify? Join me to find out the opportunities you may be missing on! 12/4/2010 2:15:00 PM 12/4/2010 3:15:00 PM 2855 Jeremiah Peschka DBA Room 1 Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server. 12/4/2010 8:30:00 AM 12/4/2010 9:30:00 AM 2865 Kendra Little DBA Room 1 Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand many aspects of the feature to evaluate where it might be useful to applications. This session will cover basic concepts of table partitioning. We'll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. New SQL 2008 R2 features for partitioning will be included in the discussion. 12/4/2010 11:00:00 AM 12/4/2010 12:00:00 PM 2868 John Sterrett Database Development Room 3 This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server 2008. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides. 12/4/2010 11:00:00 AM 12/4/2010 12:00:00 PM 2873 John Welch BI Room 4 When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. 12/4/2010 2:15:00 PM 12/4/2010 3:15:00 PM