SQLSaturday #59 - New York City 2010 11/20/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat59 New York City NY 10104 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 786 WhereScape USA, Inc. Gold Sponsor http://www.wherescape.com/home/home.aspx http://i51.tinypic.com/2cxuu53.jpg 40 100 821 Red Gate Software Gold Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 40 100 793 Quest Software Silver Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 40 100 755 SetFocus Bronze Sponsor http://www.setfocus.com http://www.sqlsaturday.com/files/7a061c5e-3598-40a9-92f4-23bd13f44832.gif 60 170 814 Pragmatic Works Bronze Sponsor http://www.pragmaticworks.com/ http://www.sqlsaturday.com/files/7556de93-bbbc-45b1-8a52-8ba92fee6654.jpg 60 170 819 Varigence Bronze Sponsor http://www.varigence.com http://www.varigence.com/images/VarigenceFullLogo.png 60 170 827 SafePeak Technologies Bronze Sponsor http://safepeak.com www.safepeak.com 60 170 836 Confio Software Bronze Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 848 Fusion-io Bronze Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 757 Microsoft Other Sponsor http://www.microsoft.com http://www.sqlsaturday.com/files/a5119bfe-4872-4893-9b41-73f10c9a01b9.gif 40 100 758 O'Reilly Media, Inc. Other Sponsor http://ug.oreilly.com/ http://oreilly.com/images/orn_logos/oralogo_bk200.gif 40 100 804 Pearl Knowledge Other Sponsor http://www.pearlknows.com http://i55.tinypic.com/2wch8if.jpg 40 100 845 Gerasus Software Other Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 2448 Steve Simon Track 4 Room D Within the realm of the financial world, data is often sourced from a plethora of financial systems that more often than not have different formats and business rules. This poses many challenges to the integration of the data into corporate data warehouses. Metrics and tools to detect data anomalies (prior to insertion into the corporate data warehouses) were often difficult to create and often overlooked. This hands-on presentation will show the attendee how we have been able to revamp and revise our preload data validations, often removing many of our ‘early warning’ queries and replacing these with SSIS 2008 Data Profiling Tasks. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2453 Aaron King Track 6 Room F This talk will focus on the benefits, features, and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2456 Kevin Goff Track 1 Room A In this presentation, I'll show about a half-dozen different report examples in SSRS 2008R2. Each report demonstrates different features in SSRS 2008R2 that are sure to please different business users. These new features include sales heat maps, sparklines, performance gauges, better page control, uses for the Tablix control, better charting, and new features for SharePoint 2010 integration. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM 2465 Kevin Goff Track 1 Room A If you know the basics of SSIS, and/or you simply want to see some intermediate-advanced examples, this session is for you. I'll spend about 20 minutes walking through 3 different SSIS packages that show tricks for using the data flow pipeline, scripting, multicast, aggregations, merge joins, package configurations, FTP, dynamic expressions, and even the dreaded Excel destination component. These packages are based on a 2-part article of mine that was published in CoDe magazine this year. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2482 Mark Kromer Track 1 Room A Discussion demos on techniques you can leverage 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 in your SQL Server BI applications. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2484 Joseph D'Antoni Track 5 Room E A deep dive into the configuration and utilization of the Management Data Warehouse feature in SQL Server 2008. This session will discuss how MDW is configured, managed and utilized. Also, how to generate reports and to customize data collection for your environment. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2499 William Pearson Track 3 Room C 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. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM 2500 William Pearson Track 3 Room C 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. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2513 Steve Simon Track 2 Room B OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in the tough and turbulent economic times. This beginner’s to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and poorly performing MDX queries and how many of the queries may be optimized to ensure that they are both efficient and effective. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM 2529 Joseph D'Antoni Track 5 Room E 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. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2547 Allan Hirt Track 4 Room D Forget a good portion of everything you know about clustering - Windows Server 2008 changes the game. Come see how the changes and improvements affect clustered SQL Server deployments. In addition to Windows, both SQL Server 2005 and SQL Server 2008 will also be discussed. The focus will be on SQL Server 2008 and how its changes to the setup, upgrade, and patching processes (among other things) impact the configuration and administration of a clustered SQL Server 2008 instance. Live demos will be shown, and one copy of Allan’s latest book, Pro SQL Server 2008 Failover Clustering, will be given away. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2548 Allan Hirt Track 2 Room B Are you confused by the various SQL Server high availability technologies? Do you understand what each one does and where each one may or may not benefit you? Do you know the basics of what you need to implement highly available SQL Server instances and databases? If these burning questions speak to you, so will this session. Whether you are an accidental DBA, new to SQL Server, or looking to brush up your skills, this session will cover the different methods of making SQL Server available, compare and contrast them, as well as and cover the top things you need to do to ensure uptime. Where appropriate, demos will be shown. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2557 Karen Lopez Track 2 Room B A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Implementing Party/party role * Natural vs. Surrogate keys * Today's vs. Tomorrow's Requirements * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2579 Steve Jones Track 4 Room D Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM 2585 Scott Weinstein Track 5 Room E Don't Repeat Yourself - it's the golden rule of good code, and with Common Table Expressions, Table Values Functions, and the APPLY operator, we'll show how well structured code can be created without stored procedures. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM 2590 Robert Pearl Track 2 Room B 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. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2611 Ayad Shammout Track 3 Room C In this session, I will cover PowerPivot - a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine, I will interactively explore and perform calculations on very large data sets. This session gives the user the freedom to learn the many uses of PowerPivot from importing, modeling, analyzing and pivoting millions of records to publishing to SharePoint. I will show how IT staff can track and monitor user generated PowerPivot workbooks in SharePoint and explore PowerPivot Management Dashboard. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2615 Linchi Shea Track 5 Room E Did you know that permission can have a profound impact on performance? Did you know that sometimes it's better to move data to the logic and other times it's better to move the logic to data? Did you know that it can make a huge performance difference whether you push data or pull data across the servers? The common thread among these questions is linked servers. Because of the convenience they provide in moving data around on the server side, linked servers are used in almost all the SQL Server environments, and are often abused in many. This session focuses on a series of linked server cases--primarily performance related cases--encountered in in the real world to help reveal traps and highlight best practices. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2619 Ayad Shammout Track 3 Room C If you are new to SQL Server 2008 R2, you will learn how to utilize Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. In this session, I will show how we minimize downtime while migrating from SQL Server 2005 Cluster to SQL 2008 R2. This session includes real life deployment and upgrade scenarios to achieve high availability and disaster recovery, the lessons learned, and the best practices. Technologies covered include Failover Clustering on Windows Server 2008 R2 and SQL 2008 R2 Database Mirroring. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2624 Chuck Kelley Track 5 Room E Data vaults are new constructs for the Data Warehouse. This session will 1) Introduce and discuss the data vault design technique 2) Discussion data movement from a data vault to a dimensional model and 3) Provide high performance ETL to implement them within SQL Server. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2697 Matt Van Horn Track 1 Room A 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. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2708 Thomas LaRock Track 1 Room A 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. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2729 Grant Fritchey Track 2 Room B Dynamic Management Views (DMV) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. More often than not people gather performance metrics through server side traces. This session will show how to gather information from the DMVs for currently executing, and recently executed queries. The session will demonstrate combining this information with other DMVs to get more intersting information such as the query plan and query text. I'll show where you can get aggregate information for the queries in cache to determine which queries are being frequently accessed or using the most resources. Indexes used, fragmentation and more. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2730 Scott Weinstein Track 4 Room D It's a given that the source code to your project's ETL, Cubes, User Interfaces, WCF services, etc are kept under tight version control. But many developers turn a blind eye to source code in their database - the critical views, stored procedures, and user defined functions. With a few concepts and tools build into every version of SQL Server I'll show how to build simple and free version control for your project. 11/20/2010 9:00:00 AM 11/20/2010 10:00:00 AM 2735 Jana Sattainathan Track 3 Room C Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple, efficient. Manageability and performance come part and parcel. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2739 Hilary Cotter Track 6 Room F Transactional Replication is a popular method for distributing data in SQL Server. It is most frequently used to offload reporting from an OLTP server to a reporting/OLAP Server. In this session SQL Server MVP Hilary Cotter shows you how to get up to speed quickly in deploying transactional replication solutions, as well as to how to squeeze optimal performance out of your transactional replication topology. Also covered is how to achieve DR using transactional replication, bi-directional transactional replication, how to integrate your replication solution with your DR solution. Also covered is peer to peer replication, a form or replication which keeps multiple geographically dispersed nodes to keep synchronized. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2741 Roman Rehak Track 4 Room D This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment. 11/20/2010 10:00:00 AM 11/20/2010 11:00:00 AM 2773 Michael Coles Track 6 Room F 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. 11/20/2010 11:00:00 AM 11/20/2010 12:00:00 PM 2774 Don Demsak Track 6 Room F An introduction for DBAs to OData - A Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today. 11/20/2010 1:00:00 PM 11/20/2010 2:00:00 PM 2909 Don Gabor Track 6 Room F Networking is challenging for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop, conversation expert and best-selling author Don Gabor will guide you through the networking process—including remembering names—and show you how to make professional connections that will pay off for years to come. 11/20/2010 2:00:00 PM 11/20/2010 3:00:00 PM