SQLSaturday #27 - Portland 2010 5/22/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat27 Portland OR 97203 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 480 Oregon SQL -developers   http://osql-d.sqlpass.org http://osql-d.sqlpass.org/Portals/35/SponsorLogos/OSQL-d.png 60 170 476 Microsoft   http://www.microsoft.com http://www.microsoft.com/presspass/images/gallery/logos/web/mslogo-1.jpg 60 170 478 Edgelink   http://www.edgelink.com/ http://www.portlandcodecamp.org/Content/2010/Sponsors/EdgeLink.png 60 170 564 DeVry University   http://www.devry.edu/locations/campuses/loc_portland.jsp http://www.portlandcodecamp.org/Content/2010/Sponsors/DeVry.jpg 60 170 490 Alliance Development    http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 511 Quest Software    http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 513 Smarsh    http://www.smarsh.com http://osql-d.sqlpass.org/Portals/35/SponsorLogos/smarsh(r)_logo400dpi_small.jpg 60 170 528 DevExpress    http://www.devexpress.com http://community.devexpress.com/themes/Devexpress/images/common/header-logo.gif 60 170 477 Red-Gate     http://www.red-gate.com http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 485 Idera      http://idera.com http://osql-d.sqlpass.org/Portals/35/SponsorLogos/Idera%20New09.jpg 60 170 512 DiscountASP       http://www.discountasp.net/portland/ http://osql-d.sqlpass.org/Portals/35/SponsorLogos/DiscountASP-200-100-6mo.gif 60 170 514 PADNUG         http://padnug.org http://osql-d.sqlpass.org/Portals/35/SponsorLogos/PADNUGlogo.png 60 170 516 Telerik           http://www.telerik.com/ http://osql-d.sqlpass.org/Portals/35/SponsorLogos/telerikLogo-web-225x90px.jpg 60 170 518 Umbraco           http://umbraco.org/ http://public.bay.livefilestore.com/y1pv4koe88BjiITmLjhgolUjbzlLLNVUlFb3gJBOiBABhAVbym01EDHujEiGnUvPRy7uayIEMsVvb2JoNSGGaoGxg/umbraco-200x200.png 60 170 542 Z-Tech Staffing           http://www.z-techstaffing.com http://www.portlandcodecamp.org/Content/2010/Sponsors/Z-TechStaffing.png 60 170 556 Kryptiq           http://www.kryptiq.com/ http://www.kryptiq.com/logo.gif 60 170 558 Intel IT           http://www.intel.com/it/ http://www.intel.com/sites/sitewide/HAT/30recode/pix/intlogo.gif 60 170 563 Widmer Brewing           http://www.widmer.com http://www.portlandcodecamp.org/Content/2010/Sponsors/Widmer.jpg 60 170 571 Valentina-db           http://valentina-db.com/ http://www.portlandcodecamp.org/Content/2010/Sponsors/valentina.png 60 170 577 University of Portland           http://www.up.edu/ http://www.up.edu/images/banner_title.png 60 170 578 WestClinTech           http://westclintech.com http://westclintech.com/Portals/0/images/wct_logo.jpg 60 170 479 Response Interactive           http://www.responseim.com/ http://www.portlandcodecamp.org/Content/2010/Sponsors/ResponseInteractive.png 60 170 517 Hitachi Consulting, Inc           http://www.hitachiconsulting.com http://www.hitachiconsulting.com/images/hitachi-consulting-logo.png 60 170 523 Apex Systems           http://www.apexsystemsinc.com http://osql-d.sqlpass.org/Portals/35/SponsorLogos/Apex_Logo_(Color__Large__80dpi).jpg 60 170 515 ComponentOne            http://www.componentone.com http://www.componentone.com/newimages/Company/Logos/c1logo_horizontal_200.png 60 170 522 Cooleremail            http://www.cooleremail.com http://www.cooleremail.com/images/thumbnail_2_burst.jpg 60 170 524 Codesmith Tools            http://www.codesmithtools.com http://www.codesmithtools.com/images/codesmith.gif 60 170 814 Joe Celko Track 1 Franz 034 A look at the basic Nested Sets versus Adjacency List models. Why Nested sets model hierarchies and Adjacency List model trees. This will stress the need for constraints to prevent cycles in either model. The problems of hierarchical aggregation -- Nested Sets requires one set-oriented query and Adjacency List requires iterations or recursion. 5/22/2010 4:45:00 PM 5/22/2010 6:00:00 PM 945 Buck Woody Track 4 Shiley 101 Come hear Buck Woody, Microsoft's 'Real World DBA' give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we'll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your 'knowledge arsenal', come hear this overview. You'll also get a list of resources that will enable you to research further. 5/22/2010 1:30:00 PM 5/22/2010 2:45:00 PM 1200 Paul Turley Track 1 Franz 034 The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our forthcoming Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports. 5/22/2010 10:45:00 AM 5/22/2010 12:00:00 PM 1201 Paul Turley Track 3 Franz 223 Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awsome power of a cube and to gain deep insight from a single version of the truth. Learn to develop dynamic, advanced reports by parameterizing MDX queries using expressions and custom code. 5/22/2010 4:45:00 PM 5/22/2010 6:00:00 PM 1388 Greg Larsen Track 4 Shiley 101 This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away. 5/22/2010 9:00:00 AM 5/22/2010 10:15:00 AM 1500 Dean Richards Track 5 Shiley 123 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 I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects. 5/22/2010 4:45:00 PM 5/22/2010 6:00:00 PM 1510 Sumeet Bansal Track 5 Shiley 123 Solid-state technologies are changing the way that SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how SQL performs. 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: 4) Customer proof: Wine.com case study 5/22/2010 3:15:00 PM 5/22/2010 4:30:00 PM 1546 Timothy Ford Track 4 Shiley 101 Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY. 5/22/2010 4:45:00 PM 5/22/2010 6:00:00 PM 1547 Timothy Ford Track 5 Shiley 123 This session is targeted for those who have found themselves accidentally responsible for the SQL Server databases where they work, or are generally new to SQL Server. We'll cover the basics of Backup and Restore processes as well as a high overview of HA architectures available including Database Mirroring, Clustering, Replication, and Log Shipping. Scripts will be provided for immediate use in your own environment as a take-away from this presentation. 5/22/2010 9:00:00 AM 5/22/2010 10:15:00 AM 1624 Todd McDermid Track 3 Franz 223 Your CIO's top priority in 2010 is probably Business Intelligence. If you don't know what BI is, or are trying to deliver it directly from your OLTP database, you need to find out what you're getting into. BI is all about helping your business users make better decisions, faster. Find out what it will take to deliver what your CIO is asking for. BI from your OLTP database has problems - it requires technical knowledge of your data model, compromises your line of business application responsiveness, and won't perform well. The solution to all of those issues is to construct a Data Warehouse based on Dimensional Modeling. I'll show you why normalized OLTP databases have problems supporting BI, and how Kimball method Data Warehouses don't. 5/22/2010 9:00:00 AM 5/22/2010 10:15:00 AM 1627 Todd McDermid Track 3 Franz 223 The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: 'rolling your own SCD' with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated. 5/22/2010 3:15:00 PM 5/22/2010 4:30:00 PM 1685 Denny Cherry Track 4 Shiley 101 In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best. 5/22/2010 3:15:00 PM 5/22/2010 4:30:00 PM 1686 Denny Cherry Track 2 Shiley 319 We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. 5/22/2010 10:45:00 AM 5/22/2010 12:00:00 PM 1687 Denny Cherry Track 2 Shiley 319 Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. 5/22/2010 1:30:00 PM 5/22/2010 2:45:00 PM 1693 William Vaughn Track 1 Franz 034 Drawn from my monthly Progressive webinar, this 'deep dive' session discusses the three major players in the Reporting Services report authoring suite. These include Visual Studio BI report-authoring tool set, Report Builder 2.0 and the ReportViewer control. We start with a discussion of how SQL Server Reporting Services works and why you care followed by demos that show how to develop and deploy reports in each of these paradigms. Along the way we’ll emphasize security, performance and best-practice designs. 5/22/2010 7:30:00 PM 5/22/2010 10:00:00 PM 1694 William Vaughn Track 1 Franz 034 This session discusses how to build a Local Data Cache leveraging Visual Studio 2008 and the SQL Compact engine. We’ll show how to avoid concurrency problems from the beginning and how to deal with them once they occur. We’ll see how to setup custom change tracking using SQL Server 2008 and highlight how it’s done in SQL Server 2005. We’ll also explore how SQL Server decides which rows are to be sent to the client with snapshot, download, upload and bi-directional synchronization. We’ll also see how to implement an application using this technology. 5/22/2010 9:00:00 AM 5/22/2010 10:15:00 AM 1708 Remus Rusanu Track 2 Shiley 319 High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring. 5/22/2010 4:45:00 PM 5/22/2010 6:00:00 PM 1740 Greg Larsen Track 2 Shiley 319 This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session, you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session, you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements. 5/22/2010 3:15:00 PM 5/22/2010 4:30:00 PM 1840 Paul Litwin Track 1 Franz 034 In this session, learn how to set up standard and data-driven subscriptions using Report Manager. We discuss creating file-share, email, and null subscriptions; and how to deal with potential issues with parameters and security. We also demonstrate a sophisticated Microsoft ASP.NET-based application that creates subscriptions by calling the SSRS Web Services API. 5/22/2010 1:30:00 PM 5/22/2010 2:45:00 PM 1844 Carlos Bossy Track 3 Franz 223 Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications. 5/22/2010 1:30:00 PM 5/22/2010 2:45:00 PM 1845 Carlos Bossy Track 3 Franz 223 Many DBAs are thrust into a data warehouse project with little training and no experience, or they are forced to take over the existing Data Warehouse. Designing or fixing a Data Warehouse model that supports the full range of BI functions can be a challenge for the OLTP DBA. This session will reveal the essential components that you should put in place for a successful implementation, including concepts such as the Importance of Transformation, Redundancy and why Reuse can be Detrimental, and one of his favorite topics, Ease of Query. Additionally, the significance of Integration, Metadata, and Governance towards creating a rock-solid, sometimes brilliant, foundation for your Business Intelligence Data Architecture will be presented. 5/22/2010 10:45:00 AM 5/22/2010 12:00:00 PM 1860 Todd McDermid Track 2 Shiley 319 SQL Server Integration Services is Microsoft’s Extract Transform Load/Data Integration (ETL/DI) tool, replacing DTS. SSIS is a very powerful and complex tool that can read data in from virtually any source, transform and mash that data however you like, then send it out to virtually any type of destination. Understand how SSIS can be used to do just that – from the basics. Find out how to get started using SSIS, hear what it’s really good at, and figure out what things you need a hacker’s spirit to accomplish with it. This session is demo heavy; Tasks, expressions, precedence constraints, text files, Excel, SQL, data type conversions, performance, scripts, configurations, scheduling, and more will be covered with examples. 5/22/2010 7:30:00 PM 5/22/2010 10:00:00 PM 1861 Tim Giorgi Track 1 Franz 034 Visual Studio Database Edition (VSDB) offers many benefits for the deployment process as well as the development of database updates. You may know it by its nickname - the 'Data Dude'. It provides for declarative style of approaching updates in a collaborative environment. This tool has been undergone significant enhancements recently and has many compelling features. We'll view some the key functional areas of the tool, discuss best practices, and take a look at what features companies could take advantage of. VSDB is free to download for use with Visual Studio 2008 Developer and Team Suite Edition. It is also included as part of the Visual Studio 2010 Premium edition. 5/22/2010 3:15:00 PM 5/22/2010 4:30:00 PM 1862 Buck Woody Track 2 Shiley 319 'R2'? What does THAT mean? Is this a 'full' release or not? Buck Woody, Microsoft's real-world DBA and all around Gadfly will regale you with the explanation of such acronyms as 'DAC', 'UCP' and 'MDW', and he'll explain what StreamInsight, Master Data Services and PowerPivot can really do for you. You'll take a quick tour of the features you should know about in SQL Server 2008 R2, the version of SQL Server that just couldn't wait for another year. 5/22/2010 9:00:00 AM 5/22/2010 10:15:00 AM 1866 Munir Ghamrawi Track 5 Shiley 123 This session will show how to achieve 99.9999 High Availability of SQL Server database on physical cluster and on Cloud.• SQL Server 2008 cluster Deployment• SQL Server 2008 Mirroring• Sql Server cloud deplyment. 5/22/2010 10:45:00 AM 5/22/2010 12:00:00 PM 1868 Atul Borkar Track 5 Shiley 123 Data Architecture – a “Corner Stone” of Enterprise Architecture -As the organizations across the globe, aggressively pursues their strategic objectives; a key strategy and method is required in this pursuit, and that is ‘Data/Information Availability’. Accurate, reliable and available information enables the organization to make timely and better business decisions. We have seen many differing methodologies over the years with CRM, Portals, B2B efforts and score carding capabilities. The need for well structured and quality information is more important than ever. As a result, we are seeing a significant acceptance and synergy relative to the importance and value having a robust Data Architecture. Most organizations today have a co 5/22/2010 1:30:00 PM 5/22/2010 2:45:00 PM 1871 Joshua Jin Track 4 Shiley 101 Interpreting SQL performance counters and OS related counters is an essential skill for a SQL DBA. In this session, we will discuss most relevant OS and SQL performance counters, vital signs, and preferred threshold values. 5/22/2010 10:45:00 AM 5/22/2010 12:00:00 PM