SQLSaturday #45 - Louisville 2011 1/22/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat45 Louisville KY 40292 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 870 Red Gate Software Gold Sponsor http://www.red-gate.com I will send you this seperately 60 170 871 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 886 Microsoft Silver Sponsor http://www.microsoft.com 60 170 902 Perpetual Technologies, Inc. Silver Sponsor http://www.PTI.net http://pti.net/logo.jpg 60 170 864 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 895 Sogeti USA Bronze Sponsor http://us.sogeti.com 60 170 1821 Craig Utley BI Room 118 If you are always looking for better ways to deliver value to the business as part of a BI project, make sure you examine the capabilities of PowerPivot. Using existing data and tools, users now have the ability to analyze vast quantities of data without first designing dimensions and measure groups. Users can explore the data and optionally share their analysis with others. See how Gemini opens the power of Analysis Services to non-technical users while still allowing the IT organization to administer and secure the data. 1/22/2011 3:00:00 PM 1/22/2011 4:00:00 PM 1823 Craig Utley BI Room 118 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. 1/22/2011 1:45:00 PM 1/22/2011 2:45:00 PM 2534 William Pearson BI Room 118 Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, we will discuss the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability. 1/22/2011 9:00:00 AM 1/22/2011 10:00:00 AM 2626 Michael Coles Advanced DBA Room 119 In 2007 the media was buzzing with reports that hackers stole 45.7 million credit card numbers from a major retailer's databases. Experts agree the damage could have been mitigated with database encryption. In this presentation attendees will learn how to secure their corporate data in SQL Server 2008. Attendees will explore cell-level encryption, cryptographic hash functions, transparent database encryption (TDE), extensible key management (EKM), and even SQL CLR. By attending this presentation you will learn techniques that will ensure that your company doesn't appear in the headlines in the headlines for all the wrong reasons. Don't become another statistic; data security is a topic that no database professional can afford to ignore. 1/22/2011 3:00:00 PM 1/22/2011 4:00:00 PM 2628 Michael Coles DBA Room 116 SQL Server 2008 once again improves on the classic built-in SQL Server full-text search (FTS) functionality by making FTS more efficient and transparent. In this course attendees will learn both the basics of the new Integrated FTS (iFTS) and how to build user-friendly Google-style search interfaces on top of SQL Server for the benefit of their end users. 1/22/2011 9:00:00 AM 1/22/2011 10:00:00 AM 2681 Eddie Wuerch Developer Room 117 An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs. The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases. 1/22/2011 11:30:00 AM 1/22/2011 12:30:00 PM 2710 Thomas LaRock DBA Room 116 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. 1/22/2011 10:15:00 AM 1/22/2011 11:15:00 AM 2713 Tim Chapman Advanced DBA Room 119 Ever wonder if there is an easy way to gather performance metrics? Look no further...there is! In this session, we'll look at how to use free SQL Server diagnostic tools. We'll cover capturing performance counters, DMV data along with SQL trace data and correlate the information. A must have for quickly and easily finding system bottlenecks. 1/22/2011 11:30:00 AM 1/22/2011 12:30:00 PM 2714 Kevin Cross Developer Room 117 Demonstrate what my dear Aunt Sally has to do with your T-SQL code as we explore order of operations and a select statement's execution order in general. 1/22/2011 4:15:00 PM 1/22/2011 5:15:00 PM 2746 Kim Tessereau DBA Room 116 This session will offer examples of B-Tree indexes, as well as offer an introduction to the query optimizer. It will cover obtaining execution plan information, queries that use join operations and finally, myths about optimizing and indexes. 1/22/2011 4:15:00 PM 1/22/2011 5:15:00 PM 2789 Tim Chapman Developer Room 117 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. 1/22/2011 9:00:00 AM 1/22/2011 10:00:00 AM 2844 Eddie Wuerch DBA Room 116 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/22/2011 1:45:00 PM 1/22/2011 2:45:00 PM 2922 Michael Coles BI Room 118 Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session is specific to Datamart ETL, but much of the information presented can be applied to any SSIS solution. 1/22/2011 11:30:00 AM 1/22/2011 12:30:00 PM 2938 John Welch Developer Room 117 SQL Azure allows you to host your data in SQL Server in the cloud. That provides some big benefits in scalability and management. However, it leaves open the question, “How do you get your data into / out of the cloud?” At some point, you are going to need to move data to or from an on-premise store to SQL Azure. In this session, we’ll discuss the available options for this, including SSIS, the Sync Framework, and BCP. We’ll cover the pros and cons for each. We’ll drill into one of the options, SSIS, in detail, and review performance options and potential issues that you may encounter when doing this. 1/22/2011 1:45:00 PM 1/22/2011 2:45:00 PM 2943 Louis Davidson DBA Room 116 In this session I will give an overview of how to design a database, including the common normal forms and 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). 1/22/2011 11:30:00 AM 1/22/2011 12:30:00 PM 2947 Dave Fackler BI Room 118 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 (updated for 2010) session, we'll look at the ins and outs of a real-world ETL environment built using SSIS. We'll discuss the ETL design patterns used to handle a multi-tiered data warehouse environment with multiple data sources, different loading schedules, and 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. 1/22/2011 4:15:00 PM 1/22/2011 5:15:00 PM 2981 Randy Knight DBA Room 116 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/22/2011 3:00:00 PM 1/22/2011 4:00:00 PM 2982 Randy Knight Developer Room 117 Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been. 1/22/2011 10:15:00 AM 1/22/2011 11:15:00 AM 3102 Louis Davidson Developer Room 117 This is a vendor session. 1/22/2011 3:00:00 PM 1/22/2011 4:00:00 PM 3103 Kathi Kellenberger DBA Room 116 A panel discussion headed by Kathi Kellenberger of Microsoft. Details to be updated soon. 1/22/2011 12:30:00 PM 1/22/2011 1:30:00 PM 3259 Allen White Advanced DBA Room 119 Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Buiding a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. 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. 1/22/2011 10:15:00 AM 1/22/2011 11:15:00 AM 3260 Allen White Advanced DBA Room 119 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. 1/22/2011 1:45:00 PM 1/22/2011 2:45:00 PM 3277 Kathi Kellenberger Advanced DBA Room 119 SQL Server provides a rich set of security features that allow customers to satisfy their security goals. Everything from encrypting sensitive data to recording all activity within a particular database is easily attainable with the features introduced in 2008. While SQL Server does not provide a packaged solution to facilitate Separation of Duties, it does provide functionality that allows Separation of Duties to be achieved. Come to this session to understand how to leverage the functionality available in SQL Server implemented through free community tools and achieve all of your compliance goals. 1/22/2011 4:15:00 PM 1/22/2011 5:15:00 PM 3280 Arie jones BI Room 118 SQL Server 2008 R2 provides many compelling reasons to upgrade especially in the area of Reporting Services. In this session, we will walk through all of the new data visualizations that are available in the latest release from Microsoft. You will learn how to use Sparklines, Indicators, Data Bars, as well as the integrated Bing Maps control in order for you to create more captivating data visualizations for your BI projects. Along the way we'll also delve into other important new features such as shared datasets, new data sources, and the Report Part Gallery. You'll leave this session with the knowledge you need to take your next BI project to the next level. 1/22/2011 10:15:00 AM 1/22/2011 11:15:00 AM 3284 Arie Jones Advanced DBA Room 119 Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment 1/22/2011 9:00:00 AM 1/22/2011 10:00:00 AM