SQLSaturday #23 - Louisville 2009 10/24/2009 12:00:00 AM A free one day training event for SQL Server professionals and those interested in SQL Server #sqlsat23 Louisville KY 40223 241 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/Images/endtoendlogo.jpg 60 170 242 JumpstartTV.com Gold Sponsor http://www.jumpstarttv.com http://www.jumpstarttv.com/images/header_logo.jpg 60 170 310 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 312 BI Voyage Silver Sponsor http://bivoyage.com http://bivoyage.com 60 170 313 Perpetual Technologies Inc Silver Sponsor http://www.perptech.com/ 60 170 314 BI Voyage Silver Sponsor http://bivoyage.com 60 170 328 Microsoft Corporation Silver Sponsor http://microsoft.com 60 170 677 Alexander Prusakov Alexander Prusakov is Sr. SQL Server DBA from Indianapolis, IN. As consultant, he is utilizing his expertise in database design, development, and administration for variety of companies. He provides database administration for enterprise size companies (over 50 servers and over 1000 databases) and helps small and medium size companies to re-design and re-develop core databases utilizing MS SQL Server 2005/2008. 48 48 633 Arie Jones Arie 'AJ' Jones is the Principal Microsoft Consultant and analyst for Perpetual Technologies, Inc. (PTI) in Indianapolis, Indiana. PTI provides mission-critical database and information systems support for SQL Server and Oracle environments nationwide. Arie leads PTI’s team of experts in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. @programmersedge http://www.linkedin.com/in/ariejones http://www.programmersedge.com https://api.twitter.com/1/users/profile_image?screen_name=@programmersedge 48 48 815 Brian Prince MS Evangelist Brian Prince talks of advantages of cloud computing. 48 48 753 Craig Utley Craig Utley is a SQL Server MVP, Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0, when he helped write Microsoft's first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions. He is a frequent conference speaker and published author. http://www.LearnMicrosoftBI.com 48 48 743 Dave Fackler Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses using SQL Server and has architected and developed enterprise ETL solutions with Integration Services. He has also implemented several front-end reporting applications using Reporting Services, SharePoint, and Microsoft Office technologies. http://www.linkedin.com/in/davefackler http://www.sqlpass.org/Community/PASSPort.aspx?ProfileID=105 https://api.twitter.com/1/users/profile_image?screen_name= 48 48 645 Derek Comingore Derek is a Principal Architect with BI Voyage, a Microsoft Partner specializing in BI solutions (www.bivoyage.com). As a SQL Server MVP and a certified professional in several Microsoft technologies, including SQL Server BI, he speaks at local and national SQL Server user groups and is a published author on SQL Server topics. Derek has been using SQL Server since 1999, when he was a student taking relational database classes at the University of North Dakota. 48 48 806 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. @ConfioDean http://www.linkedin.com/profile?viewProfile=key=18302796locale=en_US http://www.confio.com https://api.twitter.com/1/users/profile_image?screen_name=@ConfioDean 48 48 615 Jason Follas Jason Follas is a Technical Architect for Perficient, serving clients primarily located in the greater Detroit region (including Toledo, where he lives and serves as the President of the Northwest Ohio .NET User Group). Since 1994, he has developed many interesting solutions on the Microsoft platform, including an Aircraft Weight and Balance system used by an air freight company and blend optimization software. In 2007 and 2008, Microsoft recognized Jason as a Microsoft MVP (SQL Server). http://jasonfollas.com 48 48 666 Sarah Barela Sarah Barela is the Manager of Database Services at MaximumASP, a provider of Microsoft Windows based hosting services. Sarah has more than 13 years of administrative experience with SQL Server. She specializes in the administration of environments with large numbers of SQL Servers and providing high availability solutions. Sarah’s latest interests lay in applying cloud technologies to the SQL Server Environment. @sarahspace http://www.linkedin.com/profile/view?id=9178986trk=tab_pro http://www.betaforsqlserver.com https://api.twitter.com/1/users/profile_image?screen_name=@sarahspace 48 48 615 615 Jason Follas Track 1 Room 1 XML-based data is very prevalent in today's data world to the point that every database developer should know how to work with XML. Middle-tier translation of XML into relational data may be inflexible, and often leads to a loss of fidelity over time. One solution is to move the XML handling into the database itself in order to improve overall integration. SQL Server 2005 provides powerful XML processing features that allow easy access to data stored within XML without sacrificing any of the original fidelity. 10/24/2009 10:15:00 AM 10/24/2009 11:00:00 AM 617 617 Jason Follas Track 1 Room 1 Transact-SQL (T-SQL) is the language of SQL Server, and is literally used for everything from defining database objects to querying data from a database. In this primer, essential T-SQL syntax will be explained to demonstrate how to work with data in progressively complex ways. Also demonstrated will be how to write functions and stored procedures to handle more complex requirements, as well as some of the more powerful features of the T-SQL language itself. Finally, we’ll see examples of how to consume the results of a query from .NET using ADO.NET. 10/24/2009 9:00:00 AM 10/24/2009 9:45:00 AM 633 633 Arie Jones Track 1 Room 1 SQL Server 2008 provides a plethora of diagnostic tools from which you can wield as a DBA to diagnose problems within your database systems. Extended Events is an extended event handling system that parallels much of the functionality of SQL Trace. The one MAJOR difference is that Extended Events is highly scalable and configurable system that allows the administrator to collect as little or as much data as they wish in order to identify a possible problem. This session will focus on looking at the Extended Events architecture, how it works, how to use it, and some tools that may help you along the way. 10/24/2009 4:15:00 PM 10/24/2009 5:00:00 PM 634 634 Arie Jones Track 1 Room 1 Powershell is one of the wild fire pieces running through the Microsoft landscape right now. With its semi-integration with SQL Server 2008 it provides a powerful scripting environment for those people whom are looking for a more traditional route of automation other than .NET. Additionally, most administrative functions are merely a repetitive sequence of tasks that you do over and over again. This talk will consist of an introduction to the Powershell environment as seen through the DBAs eyes and demonstrate some scripts that can help you manage your environment. 10/24/2009 3:15:00 PM 10/24/2009 4:00:00 PM 645 645 Derek Comingore Track 2 Room 2 BI Voyage, an Attunity Partner Presents:Change Data Capture for SSISAttunity is the leading provider of change data capture (CDC) products that capture and deliver only the changes made to enterprise data sources, enabling efficient and real-time data integration, and eliminating the need for batch processing windows. With Attunity CDC products for SQL Server Integration Services (SSIS) you can build data integration solutions for real-time data warehousing supporting operational business intelligence requirements, replicate data from one source to another, and synchronize two or more data sources to ensure data consistency.Attunity CDC offering for SSIS includes:Attunity Oracle-CDC for SSISAttunity SSIS CDC Accelerator 10/24/2009 11:15:00 AM 10/24/2009 12:00:00 PM 666 666 Sarah Barela Track 1 Room 1 Learn how Hyper-V can provide on-demand scalability and improved resource utilization specifically for the unique SQL Server workload characteristics. We will discuss how to use Resource Governor to guarantee predictable performance, as well as, how to automate the allocation of resources based on the servers current performance, and how to contain problem processes. Finally, we will discuss how the Data Collector can be used to provide constant information about the health of the cloud to itself and to the DBA. Throughout the session, we will demonstrate how these ideas work together to create a new SQL Server infrastructure that will change as your needs change. 10/24/2009 1:15:00 PM 10/24/2009 2:00:00 PM 677 677 Alexander Prusakov Track 1 Room 1 Clustering is very important technology for High Availability and it is important for DBA to understand benefits and pitfalls. With very few available techniques and a lot of gray areas right decision might help to avoid extra costs. Presentation is unveiling clustering basics, reviews and compares clustering technologies including Microsoft, XCOTO Gridscale, and HP PolyserveMatrix. This presentation can be helpful not only to beginners but to intermediate level DBAs and infrastructure managers. 10/24/2009 11:15:00 AM 10/24/2009 12:00:00 PM 743 743 Dave Fackler Track 2 Room 2 Sure you've read the SSIS books. And sure you've seen a lot of SSIS presentations. But how do you put it all together to create a solid ETL framework for loading your data warehouse environment? In this session, we'll look at the ins and outs of a real-world ETL environment built using SSIS. We'll discuss the SSIS design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and several different data transformation requirements. We'll also discuss how the development team responsible for the ETL environment at the Department of Veterans Affairs handles package auditing and logging, team development, package testing, and automated deployments. 10/24/2009 9:00:00 AM 10/24/2009 9:45:00 AM 748 748 Dave Fackler Track 2 Room 2 SSIS Detailed session 10/24/2009 10:15:00 AM 10/24/2009 11:00:00 AM 753 753 Craig Utley Track 2 Room 2 Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles. 10/24/2009 2:15:00 PM 10/24/2009 3:00:00 PM 754 754 Craig Utley Track 2 Room 2 Are you seeking practical, in-depth technical advice for building a BI solution using SSAS? Analysis Services changed tremendously with the advent of SQL Server 2005. It introduced a new way of building dimensions and cubes that required a new way of modeling the solution. This session examines the best practices for properly designing cubes for performance and usability. It discusses some high-level topics but also looks at advanced topics such as alternative approaches to many-to-many dimensions, SCOPE statements, aggregation design, scalability issues, processing techniques, server properties, and more. 10/24/2009 3:15:00 PM 10/24/2009 4:00:00 PM 755 755 Craig Utley Track 2 Room 2 Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Far from a theoretical discussion, this seminar will present real-world lessons learned about what works in production environments. 10/24/2009 4:15:00 PM 10/24/2009 5:00:00 PM 792 792 Derek Comingore Track 2 Room 2 Introduction to Project Gemini 10/24/2009 1:15:00 PM 10/24/2009 2:00:00 PM 806 806 Janis Griffin Track 1 Room 1 Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects. 10/24/2009 2:15:00 PM 10/24/2009 3:00:00 PM 815 815 Brian Prince Track 1 Room 1 MS SQL Server Evangelist talks of advantages of cloud computing. 10/24/2009 12:00:00 PM 10/24/2009 1:15:00 PM