SQLSaturday #69 - Philadelphia 2011 3/5/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat69 Philadelphia PA 19034 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 952 DeVry University Platinum Sponsor http://www.devry.edu/locations/campuses/loc_ftwashingtoncampus.jsp http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/DeVry_University.jpg 60 170 937 Anexinet Silver Sponsor http://www.anexinet.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Anexinet_Banner.jpg 60 170 962 SQL Server Magazine Silver Sponsor http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/{4c554f51-5143-4a1c-b3a8-8c9c22203c7c}_ALL_SQL_LOGO_SQLServerMag_175x41.jpg 60 170 978 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1008 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1034 Red Gate Software Silver Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1042 Turnberry Solutions Silver Sponsor http://www.turnberrysolutions.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/TurnberrySolutions.jpg 60 170 1054 Quest Software Silver Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 1067 Aspect Consulting Silver Sponsor http://www.aspect-consulting.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/aspect-consulting.jpg 60 170 891 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 907 ModelRight Bronze Sponsor http://www.modelright.com http://www.modelright.com/images/modelrightsqlmagbannerad.gif 60 170 927 Telerik Inc Bronze Sponsor http://www.telerik.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/Telerik.JPG 60 170 947 O'Reilly Media Bronze Sponsor http://oreilly.com/ http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/OReily.jpg 60 170 1020 Gerasus Software Bronze Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 60 170 1026 SAPIEN Technologies, Inc. Bronze Sponsor http://www.sapien.com http://pssug.sqlpass.org/Portals/22/SQLSaturdayLogos/SapienTechnologies.jpg 60 170 1086 Branegy Systems Bronze Sponsor http://www.branegy.com http://www.branegy.com/branegy_logo.jpg 60 170 1087 MJDP Resources, LLC Bronze Sponsor http://mjdpresources.com http://images9.fotki.com/v131/photos/0/1115480/9541694/MJDPlogo_Final-vi.jpg 60 170 3209 William E. Pearson III BI Track #2 (106) Room 106 Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3213 William E. Pearson III Prof Devel / Dev (113) Room 113 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. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3214 William E. Pearson III BI Track #2 (106) Room 106 Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services 'many-to-many' dimension scenario. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3252 Greg Seidel DBA Track #1 (108) Room 108 Reduce downtime of SQL 2008 failover over clusters by applying service packs and cumulative updates using Rolling Upgrades. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3279 Robert Pearl DBA Track #2 (109) Room 109 Based on the popular cover-story article appearing in SQL Server Magazine, Robert Pearl expands on ways to measure SQL Server's performance and present the information in a readable and useful format. He will bring us useful tips for getting and analyzing I/O information, and troubleshoot performance bottlenecks. In addition, Robert will scratch the surface and introduce performance tuning using a methodology called Waits and Queues, with respect to I/O. By using this methodology one can identify the best opportunities to improve performance, the so called “biggest bang for the buck”. These performance improvements are likely to have a significant return on the performance tuning time investment. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3288 Raj More DBA Track #2 (109) Room 109 I will talk about designing structures that hold data for the business 1. Designing Lookup tables and Data Tables. 2. Surrogate keys and exceptions thereto. 3. The differences between Logical models and Physical implementation. We will wrap up with an Interactive design session. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3302 Mark Kromer Dev Track #1 (110) Room 110 This session will introduce you to the world of database cloud utility computing with SQL Azure. We will walk through a step-by-step process of migrating an on-premises SQL Server database to SQL Azure. We’ll demonstrate a reporting application that works as-is regardless of the SQL Server database location on prem or cloud. You will also experience developing T-SQL code in Visual Studio and utilize SSMS to deploy code from development to production in SQL Azure using the Data-Tier Application DAC capability. Lastly, we will demonstrate using the Silverlight Database Manager tool for managing and modifying your cloud databases directly. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3303 Mark Kromer BI Track #2 (106) Room 106 We will dive into discussions lots of demos on techniques you can leverage for your own Microsoft SQL Server SharePoint BI solutions. I'll show examples and how to create cool dashboards with compelling visualizations for office-based users and mobile users. This session will be geared toward SQL Server professionals with .NET code samples that can be easily re-used. 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3318 Wayne Sheffield Dev Track #2 (111) Room 111 Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, ''When do I use one or the other and what are the various impacts of doing so?' 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3333 Michael Coles BI Track #2 (106) Room 106 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. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3334 Michael Coles Prof Devel / Dev (113) Room 113 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. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3335 Joe Toscano Dev Track #1 (110) Room 110 In this session Joe will first discuss the benefits and requirements of table partitioning in SQL 2008 and then go through the planning and implementation steps of partitioning an 11 million row sample table. Once complete, we will then review in detail our sliding window requirements and see exactly how the partitioning toolbox commands (Split, Merge Switch) can be used to implement our scenario. You will get to see the actual partitioning code and the sliding window code. No prior table partitioning experience is assumed. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3361 Kevin Goff BI Track #1 (105) Room 105 In this presentation, I'll show 10 rather cool looking reports created in SSRS 2008R2 - everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to new page/group control features in R2. Since no presentation can cover the creation of all ten, I'll let the majority of the audience decide which to cover. 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3363 Kevin Goff BI Track #1 (105) Room 105 SharePoint 2010 provides many opportunities to render data from business intelligence applications. In this presentation, I'll show examples of building BI content in SharePoint 2010 using PerformancePoint Services, Excel Services, SSRS, and PowerPivot. Because I'm covering many applications, I won't be able to cover any one topic too heavily. But at the end of the presentation, the attendee will see several examples of how BI applications can use SharePoint 2010 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3375 Joe Dantoni Dev Track #1 (110) Room 110 Data 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. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3387 Alex Grinberg Dev Track #2 (111) Room 111 In this session I'll demonstrate how T-SQL code can be improved using latest features for SQL Server 2005 and up, such as CTE (Common Table Expression), OUTPUT clause, Ranking functions, EXCEPT, INTERSECT, XPath query, MERGE statement and others. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3415 Patty Pickup Prof Devel / Dev (113) Room 113 The dictionary defines a hierarchy as “any system of persons or things ranked one above another.” Classic examples that you may want to model in a database are an org chart or a bill of materials. A less well-behaved example is the dependency of database objects (sysdepends). These examples will be used to explain HIERARCHYID, recursive CTE (Common Table Expressions) and the Adjacency List Model. 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3460 Dale Cunningham DBA Track #2 (109) Room 109 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. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3486 Janis Griffin Dev Track #2 (111) Room 111 Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3487 Janis Griffin Dev Track #2 (111) Room 111 Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3496 Bill Wolff Dev Track #1 (110) Room 110 Bill will demonstrate the latest Microsoft patterns and practices for SQL Server data access. This includes LINQ query syntax, Entity Framework data modelling, REST web services using WCF Data Services (oData), and client side data models with WCF RIA Data Services. 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3499 Joe Dantoni Misc / Vendor (121) Room 121 Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3519 Randy Knight DBA Track #1 (108) Room 108 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. 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3520 Randy Knight Dev Track #2 (111) Room 111 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. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3571 Bharat Kenjale DBA Track #2 (109) Room 109 System database call tempdb, which is used for storing temporary objects and has been a key component of SQL Server since its inception. The role of tempdb has been brought to the forefront with a plethora of new features and optimizations that depends upon temporary objects. Session will discuss on -> How SQL Server uses tempdb for internal and user created temporary objects -> How to troubleshoot and avoid common tempdb issues -> How to monitor and tune tempdb performance -> How configuration best practices can increase the performance and availability of tempdb 3/5/2011 2:15:00 PM 3/5/2011 3:30:00 PM 3592 Sebastian Meine DBA Track #2 (109) Room 109 This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affect query concurrency and performance. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3597 Dennis Lloyd and Sebastian Meine . Prof Devel / Dev (113) Room 113 It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3610 Matt Van Horn BI Track #1 (105) Room 105 I will offer a 100 level into to Reporting Services and show you how to build reports using the Business Intelligence Development Studio 2008. We will cover all the basics that you will need to know to build a real report currently knowing nothing about reporting services. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3611 Matt Van Horn BI Track #1 (105) Room 105 I 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. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3672 Mihail Mateev Dev Track #1 (110) Room 110 Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data from SQL Azure Spatial, data files from Windows Azure Storage, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure Storage and SQL Azure Spatial and will create a several sample Windows Azure applications, that use this data. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3676 Muthu Ramanathan DBA Track #1 (108) Room 108 CausesTools used in troubleshootingIdentifying risks and mitigating. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM 3677 Muthu Ramanathan BI Track #1 (105) Room 105 Overview Architecture Query plans Demos 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3680 Hilary Cotter DBA Track #1 (108) Room 108 Performance problems getting you down? Replication may be the solution. SQL Server replication is a native SQL Server component used to move data from one server to another, and sometimes back again. It's most popular use case is to offload reporting from bogged down OLTP servers - it can also be used for scale out solutions, transforming data, consolidating data, moving data closer to its consumers, proving high availability solutions and disaster recovery. 3/5/2011 10:00:00 AM 3/5/2011 11:15:00 AM 3930 Sharon Dooley Prof Devel / Dev (113) Room 113 Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s bottom line? What does it mean for women and their families when they have access to hi-tech jobs? This session is open to both men and women. The panelists will present brief remarks and then the floor will be open for the audience to ask questions of the panelists. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3969 Mark Kromer BI Track #2 (106) Room 106 Learn about the value of building multi-dimensional cubes for reporting on your data in SQL Server. Learn how and where to go to get started with building cubes in SSAS, PowerPivot and the new ways to build semantic models in SQL Server Denali, starting at level 101 for beginners. 3/5/2011 3:45:00 PM 3/5/2011 5:00:00 PM 3982 Said Salomon DBA Track #1 (108) Room 108 Overview of data encryptions and key management that is built into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys. 3/5/2011 12:30:00 PM 3/5/2011 1:45:00 PM 3996 Vince Napoli Misc / Vendor (121) Room 121 This session is for the beginner to SQL Server Integration Services (SSIS). In this session, we will step you through creating an Extraction, Transformation, and Load (ETL) package in SSIS from scratch to move and process your data. We will start with an overview of SSIS in general, and then highlight the different connections, tasks, and transformations available in the workflow and data flow engines as we build our new SSIS package. When you leave you will be to create a basic SSIS package on your own. 3/5/2011 8:30:00 AM 3/5/2011 9:45:00 AM