SQLSaturday #61 - DC 201012/4/2010 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat61RestonVA20190825Microsofthttp://www.microsoft.comhttp://techtickerblog.com/wp-content/uploads/2009/06/microsoft-logo.jpg40100830The FUZION Agencyhttp://www.FUZIONAgency.comhttp://www.FUZIONAgency.com/themes/FUZION/images/logoFUZION.jpg40100838Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif40100839iderahttp://www.idera.com/Content/Home.aspxhttp://www.idera.com/images/Logo.jpg40100843redgatehttp://www.red-gate.com/?utm_source=SQLsaturday61utm_medium=bannerutm_campaign=sqlmonitor http://www.sqlsaturday.com/images/resized%20-%20redgate_logo.png40100844CapTechhttp://www.captechconsulting.com/http://sphotos.ak.fbcdn.net/hphotos-ak-snc4/hs977.snc4/77047_457363549340_237246899340_5222566_5493063_n.jpg40100847Fusion-iohttp://www.fusionio.com/http://www.fusionio.com/images/fusionio-logo.gif40100857SQL Server Magazinehttp://www.sqlmag.com/http://img.en25.com/eloquaimages/clients/PentonMediaInc/{c4e191cc-885e-42e4-bdaa-f39a5976393e}_PromoInt_SQL_LOGO_BW_192x45.jpg60170826Wroxhttp://www.wrox.comhttp://www.mikewach.com/adobe/wrox.gif60170794Quest Softwarehttp://www.quest.com/sql-server/http://www.quest.com/images/common/quest_logo.gif60170779Edgewood Solutionshttp://www.mssqltips.com/http://www.mssqltips.com/images/mssqllogo.gif60170842CozyRoc http://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png60170849telerikhttp://www.telerik.com/http://www.telerik.com/Libraries/Company/TelerikLogoPreview.sflb601702726Allen WhiteAllen is a consultant and mentor 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 four years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.@SQLRunrhttp://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_prohttp://sqlblog.com/blogs/allen_white/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr48482651Andy LeonardAndy Leonard is an Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, SQL Server MVP, PASS Regional Mentor, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs for SQLBlog.com. 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 2008.@AndyLeonardhttp://www.linkedin.com/in/andyleonardhttp://sqlblog.com/blogs/andy_leonardhttps://api.twitter.com/1/users/profile_image?screen_name=@AndyLeonard48482778Edwin SarmientoEdwin Sarmiento works as a SQL Server DBA/Windows Engineer for The Pythian Group in Ottawa, ON in Canada. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement - 'To help people grow and develop their full potential as God has planned for them.' @bassplayerdochttp://ca.linkedin.com/in/edwinsarmiento https://mvp.support.microsoft.com/profile/edwin.sarmientohttps://api.twitter.com/1/users/profile_image?screen_name=@bassplayerdoc48482734Jana SattainathanJana Sattainathan is a Database/Application Architect with Transamerica Reinsurance, one of the biggest reinsurers in the U.S. He has been in the IT industry for over 15 years with a career centered mostly around databases from different vendors. Jana loves architecting efficient database solutions for effectively dealing with extremely large volumes of data. He currently holds the following certifications: MCITP - SQL Server 2005 Developer and Administrator Oracle Certified Professional.@SQLJanahttp://www.linkedin.com/profile?viewProfile=key=32361953locale=en_UStrk=tab_prohttps://api.twitter.com/1/users/profile_image?screen_name=@SQLJana48482784Jared NielsenJared Nielsen frequently lectures at Code Camps, SQL Saturdays, Marketing Events, and Trade Shows with a focus on packaged goods, e-business, and exclusionary dominance web marketing techniques. He is the inventor of the Atomic Data Model that incorporates the best of fifth normal data modeling techniques and the latest SQL Server technologies. His past projects include WorldATPTour.com, WTATour.com, Yahoo! Sports, FootballFanatics.com, BigOTires.com, AOL TV, Barnett Brass and Copper and more.@FUZIONAgencyhttp://www.linkedin.com/in/nielsendatahttp://www.FUZIONAgency.comhttps://api.twitter.com/1/users/profile_image?screen_name=@FUZIONAgency48482855Jeremiah PeschkaJeremiah Peschka is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. When he is not volunteering with the development community, Jeremiah can be found blogging about data storage, relational databases, and software development at Facility9. He can also be reached on Twitter via @peschkaj.@peschkajhttp://linkedin.com/in/jeremiahpeschkahttp://facility9.comhttps://api.twitter.com/1/users/profile_image?screen_name=@peschkaj48482761Joel CochranJoel Cochran is an Expression Blend MVP, an INETA Community Champion, and a Microsoft Certified
Technology Specialist (MCTS) in Windows Forms and WPF. A frequent speaker
at User Groups and Code Camps, he enjoys teaching and writing about .NET and other topics.
You can find him online at http://www.developingfor.net or on Twitter at http://twitter.com/joelcochran.
Joel has served as the Director of Operations for Stonewall Technologies, Inc., an ISV, in Staunton, VA, since 2000. @joelcochranhttp://www.linkedin.com/in/joelcochranhttp://www.developingfor.nethttps://api.twitter.com/1/users/profile_image?screen_name=@joelcochran48482868John SterrettJohn 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_welchhttp://www.linkedin.com/in/johncwelchhttp://agilebi.com/jwelchhttps://api.twitter.com/1/users/profile_image?screen_name=@john_welch48482842Jose ChinchillaJose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a BI consultant for Convergence Consulting Group. Jose has12+ years of experience in IT and has focused his career in OLTP and OLAP database design and specializes in ETL/ELT, Data Warehousing and Multidimensional Analysis using SQL Server 2008 BI tools. He is also the current president of the Tampa Bay area Business Intelligence PASS Chapter.@http://twitter.com/sqljoehttp://linkedin.com/in/josechinchillahttp://www.sqljoe.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqljoe48482656Joseph DantoniJoseph D'Antoni is database administrator with over 10 years experience using a wide variety of RDBMS systems. His specialties include working in FDA regulated environments and disaster recovery planning. Joe is currently a DBA at Synthes in West Chester, PA@jdantonhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton48482805Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors, Inc. 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.@datachickhttp://linkedin.com/in/karenlopezhttp://www.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48482865Kendra LittleKendra Little has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com.@Kendra_Littlehttp://www.linkedin.com/in/kendralittlehttp://littlekendra.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Kendra_Little48482662Kevin Goff2010 SQL Server MVP
2005-2008 .NET/C# MVP
SQL Server/Business Intelligence senior instructor and courseware author - SetFocus, LLC
Columnist for CoDe Magazine (Baker's Dozen Productivity Series) @KevinScottGoffhttp://www.KevinSGoff.nethttps://api.twitter.com/1/users/profile_image?screen_name=@KevinScottGoff48482696Matt Van HornMatt, a seasoned developer with proficiencies in a wide-array of programming languages and platforms, focuses on creating flexible and dynamic code tailored to the specific needs of customers. Matt is an experienced presenter, regularly speaking at Usergroup meetings and Code Camps.@phpn00bhttp://www.anythingtheycando.com/blog/index.phphttps://api.twitter.com/1/users/profile_image?screen_name=@phpn00b48482631Michael ColesMichael Coles is an independent consultant with 15+ years' SQL Server experience. He has authored or coauthored several books on the topic, including 'Expert SQL Server 2008 Encryption', 'Pro SQL Server 2008 XML', and 'SQL Server MVP Deep Dives'. Michael is a Microsoft MVP (SQL). @Sergeant_SQLhttp://www.linkedin.com/profile/view?id=44414148locale=en_UStrk=tab_prohttp://sqlblog.com/blogs/michael_coles/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@Sergeant_SQL48482703Sandra MuellerSandra Mueller is a 16 year MCT focusing on Microsoft SQL Server platform. She started with Administration in 1997 and moved into Database Design and performance optimization. In 2004 after activation with the Air National Guard focus turned to SQL Server 2005 and its Business Intelligence capabilities. She is currently working as a Senior BI Analyst with SQL Server 2008 OLAP solutions. @SandraAMuellerhttp://www.linkedin.com/in/sandramuellerhttp://www.SQLStrongBI.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SandraAMueller48482752Sergey PustovitSenior Escalation Engineer, Microsoft. As member of SQL Server Escalation Services Sergey works on most challenging technical issues, interacts closely with SQL Development team working on problem resolutions and providing product feedback. He has 15 years of industry experience, working with distributed database systems, designing and developing business solutions for the financial industry. http://blogs.msdn.com/sqlblog48482660Steve RadichSteve Radich is founder of BitShop.com, the Business Innovative Technology Shop - I've been involved in the design, development, maintainance and performance troubleshooting for web servers with SQL Server backends since SQL 4.3 (1996). I have extensive knowledge of IIS, Classic ASP, ASP.Net, and SQL Server - as well as several Virtualization technologies. I've presented on all these technologies at Users Groups and/or Code Camps. Previously IIS and Classic ASP MVP.@bitshopsteverhttp://www.LinkedIn.com/in/SteveRadichhttp://www.BitShop.comhttps://api.twitter.com/1/users/profile_image?screen_name=@bitshopstever48482709Thomas LaRockThomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).@https://twitter.com/#!/SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttp://thomaslarock.comhttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/#!/SQLRockstar48482788Tim ChapmanTim Chapman is a SQL Server MVP and MCITP originally from Louisville but now resides in Chapel Hill, NC where he works as a database engineer and consultant. Tim has over 10 years of database design and administration experience. @chapmandewhttp://www.linkedin.com/pub/tim-chapman/5/242/896http://www.sqlservernation.comhttps://api.twitter.com/1/users/profile_image?screen_name=@chapmandew48482670William PearsonBill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base over the years since. Bill's background as a CPA, Internal Auditor and Management Accountant 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_Pearsonhttp://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85ehttp://www.databasejournal.com/article.php/1459531%20https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484826312631Michael ColesRoom 2Introduction to SQL Server Spatial DataSQL 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 PM12/4/2010 3:15:00 PM26512651Andy LeonardRoom 5Some Thoughts on Managing TeamsAre 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 AM12/4/2010 9:30:00 AM26542654Andy LeonardRoom 3Introduction to Incremental Loads 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 PM12/4/2010 3:15:00 PM26562656Joseph DantoniRoom 3Deploying Data Tier Applications with SQL 2k8 R2Data 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 PM12/4/2010 2:00:00 PM26602660Steve RadichRoom 5A better way to store and archive SQL BackupsHow 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 AM12/4/2010 10:45:00 AM26622662Kevin GoffRoom 4Applied MDX in OLAP applications
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 PM12/4/2010 4:30:00 PM26652665Kevin GoffRoom 4Introduction to PowerPivotAre 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 AM12/4/2010 12:00:00 PM26702670William PearsonRoom 4Design and Implement BI Like Edison!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 PM12/4/2010 2:00:00 PM26962696Matt Van HornRoom 4SSRS Interactive ReportsI 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 AM12/4/2010 10:45:00 AM27032703Sandra MuellerRoom 1Data Files and Transaction Logs – Beyond the GUIs 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 AM12/4/2010 10:45:00 AM27072707Michael ColesRoom 5Sell Yourself Into An Interview!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 AM12/4/2010 12:00:00 PM27092709Thomas LaRockRoom 1Performance Tuning Made EasyPerformance 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 PM12/4/2010 4:30:00 PM27262726Allen WhiteRoom 2Gather SQL Server Performance Data with PowerShellWe 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 AM12/4/2010 10:45:00 AM27282728Allen WhiteRoom 2Automate Policy-Based Management using PowerShellThe 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 AM12/4/2010 9:30:00 AM27342734Jana SattainathanRoom 1Partitioning in SQL Server 2005/2008Starting 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 PM12/4/2010 2:00:00 PM27522752Sergey PustovitRoom 1SQL Server Performance Related DMVsThere 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 PM12/4/2010 3:15:00 PM27612761Joel CochranRoom 3SSIS for real: A walk through a real world projectIn 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 AM12/4/2010 9:30:00 AM27622762Joel CochranRoom 3Intro to C# for the SSIS Script ComponentThe 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 AM12/4/2010 10:45:00 AM27782778Edwin SarmientoRoom 2DBA Disaster Recovery Techniques To Keep HandyNothing 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 recovery12/4/2010 11:00:00 AM12/4/2010 12:00:00 PM27792779Edwin SarmientoRoom 5Presentation WOW!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 PM12/4/2010 2:00:00 PM27842784Jared NielsenRoom 2SQL and SEO - the FUZION of data and marketingBringing 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 PM12/4/2010 2:00:00 PM27882788Tim ChapmanRoom 2Writing faster queriesPoor 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 PM12/4/2010 4:30:00 PM28052805Karen LopezRoom 3Database Design Contentious IssuesA 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 PM12/4/2010 4:30:00 PM28422842Jose ChinchillaRoom 4Business Intelligence: Decaffeinated Please!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 AM12/4/2010 9:30:00 AM28432843Jose ChinchillaRoom 5Get Cert! Get Cred!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 PM12/4/2010 3:15:00 PM28552855Jeremiah PeschkaRoom 1Fundamentals of SQL Server InternalsWant 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 AM12/4/2010 9:30:00 AM28652865Kendra LittleRoom 1Table Partitioning: Evaluation, Planning, OptionsDoes 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 AM12/4/2010 12:00:00 PM28682868John SterrettRoom 3Monitor your SQL Server farm with PBM and CMSThis 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 AM12/4/2010 12:00:00 PM28732873John WelchRoom 4Processing Flat Files with SSISWhen 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 PM12/4/2010 3:15:00 PM