SQLSaturday #47 - Phoenix 2011 2/19/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat47 Phoenix AZ 85225 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 616 SQL Server Magazine Gold Sponsor http://www.sqlmag.com http://pensacola.sqlpass.org/Portals/29/LOGO_SQL%20Server%20Magazine[1].JPG 60 170 959 GoDaddy.com Gold Sponsor http://www.godaddy.com/jobs http://www.getresponsereview.net/wp-content/uploads/2009/11/godaddy.jpeg 60 170 964 Statera Gold Sponsor http://www.statera.com http://www.sqlsaturday.com/files/0fc8df55-01f1-4282-9a1a-5f0d3a589c33.png 60 170 549 Quest Software Silver Sponsor http://www.quest.com/landing/?ID=4771 http://www.mmcug.org/images1/Quest_color2.jpg 60 170 860 Idera Silver Sponsor http://www.idera.com http://www.sqlsaturday.com/images/resized%20-%20idera_logo.png 60 170 897 Neudesic Silver Sponsor http://www.neudesic.com/Pages/Default.aspx https://www.regonline.com/custImages/251802/Neudesic%20Logo%201%20JPG.JPG 60 170 909 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 958 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.pclaunches.com/entry_images/0810/19/fusion-io_logo.jpg 60 170 994 Melissa Data Silver Sponsor http://www.melissadata.com http://www.sqlsaturday.com/files/e2f0bd76-db55-4ce1-a8b6-36e861c58f2c.jpg 60 170 1025 Gerasus Software Silver Sponsor http://www.gerasus.com http://www.sqlsaturday.com/files/a56807a5-4b30-4d8f-adb0-e26e75c9bfce.png 60 170 867 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 976 Advaiya Bronze Sponsor http://www.advaiya.com http://www.sqlsaturday.com/files/cb1fb5aa-90b0-4cb2-87f1-0b55baa2b263.jpg 60 170 1772 Michael Collins Track 2 IRN-125 In this session, we'll look at using Visual Studio Database Edition tools in Visual Studio 2008 and 2010 to develop and deploy databases. We'll review how to manage your database changes, publish incremental changes to a development database, and how to deploy your database into a production environment. 2/19/2011 10:15:00 AM 2/19/2011 11:15:00 AM 1773 Michael Collins Track 5 IRN-130 You can't develop software in 2010 without considering the impact of running applications in the cloud instead of your own servers. Microsoft has expanded SQL Server to the cloud with SQL Azure. In this session, we'll take a look at SQL Azure and how to get started with it. We'll cover best practices of developing solutions based around SQL Azure. Finally, we'll cover what features that SQL Azure doesn't have and things that you have to know when developing applications for the Azure platform. 2/19/2011 1:45:00 PM 2/19/2011 2:45:00 PM 1789 Colin Smith Track 1 IRN-124 This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive. 2/19/2011 10:15:00 AM 2/19/2011 11:15:00 AM 2094 Meredith Ryan-Smith Track 5 IRN-130 Many of us started our IT careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what we considered “normal.” Today, with our careers underway, how do we build a life outside of our IT world? I will share the tips, tricks and tools I’ve discovered and used to create a work/life balance that allows us to feel fulfilled and refreshed outside the office while maintaining our effectiveness as successful data professionals. 2/19/2011 10:15:00 AM 2/19/2011 11:15:00 AM 2521 William Pearson Track 5 IRN-130 In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 2/19/2011 11:30:00 AM 2/19/2011 12:30:00 PM 2798 Tara Kizer Track 5 IRN-130 We'll touch on SQL Profiler and review its best practices so that you don't impact the production system while gathering data. We'll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We'll also examine the things that I look for when troubleshooting performance issues. 2/19/2011 4:15:00 PM 2/19/2011 5:15:00 PM 2880 Janis Griffin Track 1 IRN-124 Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. 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 type data, column selectivity, and several more that will help you succeed on future tuning projects. 2/19/2011 1:45:00 PM 2/19/2011 2:45:00 PM 2882 Janis Griffin Track 4 IRN-128 Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools. 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3026 Ira Whiteside Track 5 IRN-130 We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms 2/19/2011 3:00:00 PM 2/19/2011 4:00:00 PM 3027 Ira Whiteside Track 3 IRN-127 Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts 2/19/2011 10:15:00 AM 2/19/2011 11:15:00 AM 3135 Meredith Ryan-Smith Track 1 IRN-124 Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one. 2/19/2011 4:15:00 PM 2/19/2011 5:15:00 PM 3178 ORION GEBREMEDHIN Track 3 IRN-127 This session will deal with a detailed explanation of SSRS report delivery methods. And will focus on the two types of report delivery subscriptions; standard and Data Driven Subscriptions. A working demonstration of both methods will be shown. In the render device settings, we will discuss how we can can use device information settings on the report server to customize rendering and to override the default values that are supplied by the server. A practical demonstration will be provided. 2/19/2011 11:30:00 AM 2/19/2011 12:30:00 PM 3179 ORION GEBREMEDHIN Track 3 IRN-127 This session will describe OLAP Cube partitioning with practical examples. Hands on demonstration of OLAP cube Usage Based Optimization will be performed. The session will identify the QueryLogTable and QueryLogSampling settings , and how the contents of the QueryLogTable are used will be explained with practical examples. 2/19/2011 3:00:00 PM 2/19/2011 4:00:00 PM 3206 William E. Pearson III Track 5 IRN-130 Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity. 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3282 Bill Ramos Track 4 IRN-128 In this sessions, you will learn about the various data collection strategies that are available for SQL Server 2008 R2 and with System Center Operations Manager to help you in troubleshooting and capacity planning for your applications. You'll see what strategies you can use during application development, deployment, and operating in production. You'll also learn how to use the data collected for capacity planning. 2/19/2011 10:15:00 AM 2/19/2011 11:15:00 AM 3283 Zach Mattson Track 2 IRN-125 Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with SMO to not only be proactive, but productive in monitoring the servers in your environment. Attendees will come away from the session with an understanding of how to read the server event logs, check backups, and collect performance metrics. This will be useful for general monitoring in your environment and can also be used for collecting data in a physical to virtual migration. 2/19/2011 3:00:00 PM 2/19/2011 4:00:00 PM 3306 Jonathan Atkins Track 2 IRN-125 Illustrate methods for cursor alternatives including real world examples using: -set based logic -coalesce -while loops -common table expressions 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3371 John Racer Track 3 IRN-127 With the introduction of Report Builder in Reporting Services 2005, end users were given the tools to create self-service Reporting Services reports quickly and easily. In this session we will discuss concepts of the Report Model including Entities, Attributes, Roles and other components. We will discuss organization and security within the Report Model to protect data and create a logical view for the business. Then we will cover the methods for creation of an over an existing database and modify them to support specific needs. Once we deploy the Report Model we will build reports and see how the evolution of the Report Builder has enhanced the self-service reporting experience. 2/19/2011 4:15:00 PM 2/19/2011 5:15:00 PM 3372 John Racer Track 4 IRN-128 Reporting Services has quickly become and enterprise class report delivery system. As such, user adoption can grow quite rapidly and before you know it higher usage can bring the Report Server to its knees. This is why monitoring and maintaining reporting services from the beginning is important part of any deployment. In this session we will cover common scenarios for monitoring reporting services performance, tracking down performance issues and troubleshooting errors. We will also review solutions to improve performance in the report execution and engine configuration. Finally, we will discuss techniques to scale up and scale out to distribute load and isolate various forms of activity. 2/19/2011 11:30:00 AM 2/19/2011 12:30:00 PM 3399 Amy Lewis Track 3 IRN-127 Come learn how to create your first cube using SSAS. In this session, we will start from scratch and create an Analysis Services solution including setting up the data source, data source view, dimensions, hierarchies, attribute relationships, and creating some custom measures. At the end of the session we will browse the cube using Excel to create some ad-hoc reports. 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3400 Amy Lewis Track 3 IRN-127 Come learn how to use Integration Services to create an ETL (Extract, Transform, and Load) solution for populating your data marts/data warehouse. This session will cover best practices for dimension and fact table loading, package configurations, package variables, error and event handling, and SSIS package deployments. 2/19/2011 1:45:00 PM 2/19/2011 2:45:00 PM 3435 Denise McInerney Track 2 IRN-125 The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA. 2/19/2011 4:15:00 PM 2/19/2011 5:15:00 PM 3461 Dale Cunningham Track 1 IRN-124 A real life application of the Confio product Ignite8 to solve one companies serious production issues. This session will touch on many SQL Server tools, disciplines and resources and bring them all together into a synergy of useful index generation, interpreting execution plans, and using Benchmark Factory to get real performance measurements. 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3493 Denny Cherry Track 4 IRN-128 We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them. All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server. 2/19/2011 1:45:00 PM 2/19/2011 2:45:00 PM 3494 Denny Cherry Track 4 IRN-128 In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs. 2/19/2011 4:15:00 PM 2/19/2011 5:15:00 PM 3495 Denny Cherry Track 1 IRN-124 In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations. 2/19/2011 11:30:00 AM 2/19/2011 12:30:00 PM 3523 Robert Miller Track 6 IRN-131 An overview of Database Mirroring. 2/19/2011 9:00:00 AM 2/19/2011 10:00:00 AM 3789 Robert Miller Track 6 IRN-131 After creating and activating a Database Mirror, how do you manage and monitor your Mirror? 2/19/2011 11:30:00 AM 2/19/2011 12:30:00 PM 3906 Bill Ramos Track 1 IRN-124 Bill Ramos will share with you how the Microsoft SQL Server development team designed the new SQL Server Denali Always On dashboard for the Availability Group feature that will be available later this year. Bill walk through how the team started with a vague idea of a new UI, capturing the functional requirements, verifying the metrics for success, and creating the first round of prototypes to validate with concepts with the TAP customers. 2/19/2011 3:00:00 PM 2/19/2011 4:00:00 PM