SQLSaturday #13 - Atlanta 2009 4/25/2009 12:00:00 AM A free one day training event for those that use or want to learn SQL Server #sqlsat13 Atlanta GA 30009 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 160 Microsoft Gold Sponsor http://www.microsoft.com http://www.codegumbo.com/images/SQLSat20090425/microsoft_Logo.jpg 60 170 150 Confio Software Gold Sponsor http://www.conifo.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 117 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/Images/endtoendlogo.jpg 60 170 118 JumpstartTV.com Gold Sponsor http://www.jumpstarttv.com http://www.jumpstarttv.com/images/header_logo.jpg 60 170 154 SQL Sentry, Inc. Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/UI/customMenu/headLogo.jpg 60 170 149 Magenic Silver Sponsor http://www.magenic.com http://www.magenic.com/Portals/0/Skins/MagenicHomePageGlass/magenic_logo.jpg 60 170 152 Solid Quality Mentors Silver Sponsor http://www.solidq.com http://www.sqlsaturday.com/images/solidquality.png 60 170 158 Red Gate Bronze Sponsor http://www.red-gate.com/ http://www.codegumbo.com/images/SQLSat20090425/RG.jpg 60 170 145 Intellinet Bronze Sponsor http://www.intellinet.com http://www.intellinet.com/images/intellinet_color_logo.gif 60 170 148 Edgewood Solutions for MSSQLTips.com Bronze Sponsor http://www.mssqltips.com/ http://www.mssqltips.com/images/mssqllogo.gif 60 170 338 Stuart Ainsworth Development 2 Room 4 This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating 'how-to' do something. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 339 Stuart Ainsworth Development 2 Room 4 This session is actually 4 sessions in one. Speakers will each take 15 minutes to demonstrate something in SQL Server; it could be shortcuts in Management Studio, setting up and using a particular 3rd-party tool, or a code snippet. Slide decks are discouraged; the focus is on demonstrating 'how-to' do something. 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 348 Kevin Boles DBA Room 1a EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 349 Kevin Boles DBA 2 Room 2 Lets dig into both the fundamentals and details of how SANs work and how we can best utilize them to improve SQL Server's IO performance and reliability. 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 351 Sergey Barskiy Development Room 1c Integrating CLR assemblies to support custom image creation and encompassing complex business logic in SQL server/SSRS. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 352 Whitney Weaver Development Room 1c SQL Server makes available a tremendous amount of meta data about the internal workings of the product. Join Whitney Weaver to see how many common DBA and developer tasks can be accomplished via the meta data in system views and DMVS. 4/25/2009 3:45:00 PM 4/25/2009 4:35:00 PM 353 Whitney Weaver DBA 2 Room 2 Data volumes continue to grow and it is extremely important to know the features available to manage that growth. Whitney Weaver will discuss the partitioning functionality implemented in SQL 2005 and 2008 that will help you take your data applications to the next level. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 358 Tejas Patel BI Room 1b Intent of this session is to demonstrate use of Data Mining Web Controls Library with web applications. Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed. 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 367 Shawn Wildermuth Development 2 Room 4 While tools like Visual Studio's Database projects can help build and version databases, Oslo's new MSchema language can provide a powerful abstraction from the minutea of data models. In this talk I will show you how to use MSchema for build/deployment scenarios and using it to version your schemas. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 368 Shawn Wildermuth DBA 2 Room 2 The idea of exposing data across the Internet is a scary thought for most DBAs, but ADO.NET Data Services provides the security to allow you to feel better about how its handled. Since so many applications now require the Internet, ADO.NET Data Services represents a sensible way to provide that data. Come to this talk to be talked down from the ledge of fear about the technology. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 371 Jenifer Underwood BI Room 1b This session will walk through building an Analysis Services Cube in SQL Server 2005 and 2008. It will also cover real world project roadmaps, common mistakes and basic dimensional modeling concepts. 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 372 Jenifer Underwood BI Room 1b This session will walk through building reports in Reporting Services 2008 and Excel 2007 that query data from Analysis Services Cubes. It will also explain a variety of reporting solution architecture options using Microsoft's Business Intelligence technologies. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 373 Erik Veerman BI 2 Room 3 This session dives deep into the underlying structure of the SSIS data flow pipeline in order understand how the SSIS engine is handling your data and how to monitor and optimize your data flow design. This review includes a drill-down into the data buffer architecture, execution trees, engine threads, column lineage, synchronous and asynchronous transformation outputs, data flow buffer tuning, pipeline monitoring, pipeline optimization, error identification and troubleshooting. Understanding the pipeline internals will lead to better package designs with more efficient and scalable data flow architectures for your SSIS environment. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 380 Scott Russell Development 2 Room 4 This session provides an overview of date / time data types, comparing capabilities and benefits of the new types in SQL Server 2008 with those from prior versions. A process will be presented on how to profile date / time data content in current tables, to better understand the implications (data preservation or loss) in migrating existing date / time data types to the newer types. Tools to simplify the data profiling process will be demonstrated. 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 387 Andy Warren DBA Room 1a This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 389 Michael Mollenhour DBA Room 1a In this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 390 Michael Mollenhour BI 2 Room 3 In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel. 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 393 Joe Celko Development Room 1c A look at the programing techniques for Trees Hierarchies using the nested sets model. The stress will be on avoidance of recursive CTE and cursor programming. 4/25/2009 12:15:00 PM 4/25/2009 1:35:00 PM 394 Robert Cain Development Room 1c Business Intelligence is one of the top five skillsets for 2009. In this introductory course you can learn the basics of data warehousing, including design, population, analysis and reporting with a focus on the SQL Server toolset. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 395 Robert Cain Development 2 Room 4 Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 396 Robert Cain BI Room 1b SQL Server Integration Services is Microsoft's powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for BI but for data conversion as well. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 397 Geoff Hiten DBA Room 1a Both developers and Administrators will learn new features of SQL 2008 designed to improve productivity and manageability. Focusing on breadth rather than depth, this session will give data professionals just enough information to decide whether a specific feature is worth their time to investigate more fully. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 398 Geoff Hiten DBA 2 Room 2 Come learn how to take some of the mystique out of SQL Clustering. Learn how to build, migrate, and operate SQL Server Clustering using the newest Windows Server 2008 Operating system. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 399 Tom Mills DBA 2 Room 2 Suffering from server sprawl? Licensing fees killing your budget? Too many databases, not enough DBAs? These are all issues driving organizations to start consolidating their SQL Server infrastructure to reduce costs, improve administrative efficiencies, and increase performance. This session will present a methodology that can be applied to your database environment to consolidate and save big! Whether you are a database architect, DBA or manager, you'll be able to apply what you learn in this session to get results. 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 400 Louis Davidson Development Room 1c In this session I will give an overview of the common normal forms and show why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming 'difficulties' are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). Properly structured data structures make it easier to work wit 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 401 Noah Subrin Development Room 1c This session will present five short examples of solutions to real business world problems based on T-SQL or Visual Studio. 4/25/2009 2:45:00 PM 4/25/2009 3:35:00 PM 405 Mark Tabladillo BI 2 Room 3 Microsoft provides excellent tutorials and information about data mining through the fictional Adventure Works demos. However, what happens when you stray off that neat-and-tidy path? Data miners should be concerned about data preparation, proper algorithm selection, and correct interpretation. This interactive experience will consist of succinct audience participation demos to introduce some practical issues in real-world data mining. 4/25/2009 10:15:00 AM 4/25/2009 11:05:00 AM 406 Curtis Smith BI 2 Room 3 Session will cover working with images and subreports. I will cover real world examples of issues encountered when working with images and subreports. Examples will include 'conditional subreports'. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 407 Lee Johnson BI 2 Room 3 Database auditing is something everyone would like their databases to do, but implementing it without slowing data access down can be difficult. In this session I will show you how to use the CLR to create triggers that do not have a big performance hit and do not have to be rewritten if the tables change. 4/25/2009 9:15:00 AM 4/25/2009 10:05:00 AM 409 Kendal Van Dyke Development Room 1c XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it! 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 410 Kendal Van Dyke DBA Room 1a Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren’t properly inflated and wonder why you’re only doing 180 when the manufacturer says it can do 220? Your answer was probably close to something like “Of course not!”. Now let’s suppose that your “million dollar race car” is really your DB server and your “tires” are your hard drives. Do you know the right configuration to use to get the best performance out of them? Sure, there’s RAID 1, RAID 10, and RAID 5…but do you know which combination of partition offset, RAID stripe size, and allocation unit size to use? 4/25/2009 3:45:00 PM 4/25/2009 4:35:00 PM 411 Brian Kelley BI Room 1b We'll look at best practices for securing SQL Server and the data contained within from both a DBA and developer perspective. Starting with the basics of how to relate security to business personnel, we'll then dive in to the technical aspects of locking down SQL Server. SQL Server 2000 through 2008 will be covered. 4/25/2009 11:15:00 AM 4/25/2009 12:05:00 PM 413 Janis Griffin DBA 2 Room 2 There are many ways to use SQL Server Wait types for performance tuning of a Microsoft database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues. 4/25/2009 3:45:00 PM 4/25/2009 4:35:00 PM 414 Kevin Kline DBA Room 1a Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate: - Performance Monitor (PerfMon) - SQL Profiler/Server-side Trace - Correlating PerfMon and Profiler results - Graphic Explain Plan and Transact-SQL Showplan - SQL Server 2005 and 2008 DMVs - When to 4/25/2009 1:45:00 PM 4/25/2009 2:35:00 PM 415 Kevin Kline BI Room 1b The SQL Server database platform is hosting larger and larger databases. But the industry term “Very Large Database” (VLDB) is more difficult to define than ever with multi-terabyte database becoming very common. This session will answer questions like: - How do I configure my SQL Server instances to support multi-terabyte databases? - What risks and problems do VLDBs pose? - How do I overcome issues presented by VLDBs? Administrating and protecting very large databases is extremely difficult and very hard to learn except through direct experience. This session helps you learn from the experiences of others so that you can apply their lessons learned and mitigate your risks before you ever experience them. 4/25/2009 3:45:00 PM 4/25/2009 4:35:00 PM