SQLSaturday #73 - Orange County 2011 4/9/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat73 Orange County CA 92647 1083 Idera Gold Sponsor http://www.idera.com http://www.idera.com/campaign_images/idera_logo_tag.jpg 60 170 1154 Embarcadero Technologies Gold Sponsor http://www.embarcadero.com/solutions/microsoft-sql-server http://www.embarcadero.com/images/et/corporate_logo/emblogo_01_3c_gw.jpg 60 170 1156 Strategy Companion Gold Sponsor http://www.strategycompanion.com http://www.strategycompanion.com/_Style/images/home_header_00.jpg 60 170 1125 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 942 Melissa Data Bronze Sponsor http://www.melissadata.com http://www.sqlsaturday.com/files/e2f0bd76-db55-4ce1-a8b6-36e861c58f2c.jpg 60 170 4117 Andrew Karcher Andrew Karcher @akarcher http://www.linkedin.com/in/andrewkarcher https://api.twitter.com/1/users/profile_image?screen_name=@akarcher 48 48 4045 Benjamin Nevarez Benjamin Nevarez is a database professional based in Los Angeles, California and author of “Inside the SQL Server Query Optimizer” which will be published this March by Red Gate books. With more than 15 years of experience with relational databases, Benjamin also holds a Master’s Degree in Computer Science and has been working with SQL Server since version 6.5. He has been a speaker at several technology conferences, including the PASS Community Summit since 2007. @BenjaminNevarez http://www.benjaminnevarez.com https://api.twitter.com/1/users/profile_image?screen_name=@BenjaminNevarez 48 48 3645 Bob Abernethy Bob Abernethy is SVP GM of Strategy Companion Corporation. A veteran of Oracle Corporation and Siebel Systems, Bob brings over twenty years of software industry experience to his discussion with customers about their Business Intelligence implementations. Bob received his Bachelor of Science degree from Cornell University in New York and his Masters of Management Information Systems from West Coast University in Southern California. http://www.linkedin.com/pub/bob-abernethy/7/445/93 http://www.strategycompanion.com 48 48 4259 Bret Stateham I am a technical trainer and consultant based out of Ramona, CA. I provide contract training and consulting services primarily on Microsoft platforms. I have over 20 years of experience in the IT field, and over a decade of experience as a trainer. I am a published author having contributed to multiple Syngress publications.To learn more about me, view my company website at www.netconnex.com, read my blog at blogs.netconnex.com, or follow me at twitter.com/bstateham @bstateham http://blogs.netconnex.com/ https://api.twitter.com/1/users/profile_image?screen_name=@bstateham 48 48 4137 Carlos Bossy Carlos Bossy is a MCTS SQL Server 2008 BI Consultant with 25 years of experience in software and database development. Carlos is an independent consultant and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies. @carlosbossy http://www.linkedin.com/in/carlosbossy http://www.carlosbossy.com https://api.twitter.com/1/users/profile_image?screen_name=@carlosbossy 48 48 4157 Clint Kunz Clint Kunz is a Data Platform Technology Specialist working for Microsoft Corporation in Southern California. He has been working with SQL Server and in the Business Intelligence area for over 10 years. @cgkunz http://www.linkedin.com/in/clintkunz https://api.twitter.com/1/users/profile_image?screen_name=@cgkunz 48 48 3963 Colin Smith I have worked in IT for just over 7 years. I have worked my way through the Help Desk, Workstation Technician, Windows Server Admin, and now at the DBA stop. As a DBA I have worked with MSSQL, Sybase, and Oracle. I have pretty much settled down and work mostly with MSSQL now. @smithco32 http://itknowledgeexchange.techtarget.com/dba/ https://api.twitter.com/1/users/profile_image?screen_name=@smithco32 48 48 3771 David McCarter David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com... a web site dedicated to helping programmers in all aspects of programming. David has written for magazines like the VB Programmers Journal and has published three books (the latest is 'David McCarter's .NET Coding Standards' available at: http://codingstandards.notlong.com). @davidmccarter http://www.linkedin.com/in/davidmccarter https://api.twitter.com/1/users/profile_image?screen_name=@davidmccarter 48 48 3639 Denise McInerney Denise McInerney began working as a SQL Server DBA in 1998. Denise's focus is on design and performance tuning of OLTP databases. She currently works as a Staff Database Administrator at Intuit where she designs, tunes and manages databases that support an eCommerce web site. Denise has been an active PASS volunteer since 2003, serving on the Program Committee, organizing the Women In Technology luncheon and founding the WIT Virtual Chapter. She was the recipient of the PASSion Award in 2007. @denisemc06 https://api.twitter.com/1/users/profile_image?screen_name=@denisemc06 48 48 3600 Denny Cherry Denny Cherry has over a decade of experience managing SQL Server and is currently the Manager of Information Systems at Awareness Technologies. Denny holds several Microsoft Certifications as well as being a Microsoft MVP. @mrdenny http://www.linkedin.com/in/mrdenny http://itke.techtarget.com/sql-server/ https://api.twitter.com/1/users/profile_image?screen_name=@mrdenny 48 48 3644 Diana Dee Diana is a Microsoft Certified Trainer who has taught Microsoft courses to IT professionals and college students since 1996. Diana has been a course developer throughout her computer teaching career. She has revised and developed database design, administration, and querying courses for an on-line University and for a major training company. She presented 'How Indexes Optimize Query Performance' at SQL Saturday #44, April 2010. @SQLDee https://api.twitter.com/1/users/profile_image?screen_name=@SQLDee 48 48 4056 Harold Wong I am an IT Pro Evangelist who absolutely loves technology. I have been working with computers since the early 80's (TRS80 and Commodore C64). I am fortunate enough to be in a role where I get to spend time with the community to talk about Microsoft technologies and not have to worry about a sales quota. This allows me to share my opinions (good and bad) about the state of our platform. @haroldwong http://blogs.technet.com/b/haroldwong https://api.twitter.com/1/users/profile_image?screen_name=@haroldwong 48 48 3607 Ike Ellis Ike is the Lead SQL Instructor and SQL Course Author for DevelopMentor. He first worked with Microsoft SQL Server in 1997. Ike started as an independent consultant and trainer in September, 2000. Recent projects include a planning and financial solution used by a major retailer, a SQL Server Analysis Services project for a top ten university, an attorney scorecard tool used by the oldest intellectual property law firm in the US, and SQL performance tuning for a medical imaging company. @ellisteam1 http://www.linkedin.com/in/ikeellis http://ellisteam.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@ellisteam1 48 48 4003 Jose Pons SQL Server veteran: 6/7/2000/2005 and 2008 Back-end developer: 7+ years Database Administrators: 7+ years Web Developer: C#/VB.NET.ASP/VB-COM/JavaScript: 10+ years http://www.linkedin.com/pub/jose-pons/10/ba7/a19 48 48 4057 Jospeh Vertido Mr Vertido has extensive experience in the creation and support of Data Quality Tools, including several Fuzzy Matching Products. @/melissadata http://www.linkedin.com/company/melissa-data http://www.melissadata.com https://api.twitter.com/1/users/profile_image?screen_name=@/melissadata 48 48 3657 Juan Soto Juan Soto is a Senior Access Developer at IT Impact Inc., where he specializes in Access with SQL Server databases. His passion for Access is second to none in helping a wide range of businesses and leveraging both technologies in a secure, stable and efficient environment. He's a frequent speaker at Access user groups nationwide and recently spoke at Chicago's SQL Server User Group in December. To learn more about Juan, please visit his site: AccessExperts.net or blog: AccessExperts.net/blog @jsoto22 http://www.linkedin.com/in/juansoto http://www.AccessExperts.net https://api.twitter.com/1/users/profile_image?screen_name=@jsoto22 48 48 3655 Lynn Langit Lynn Langit is a Sr. Developer Evangelist for Microsoft. She's worked in the SQL Server space for over 10 years. Her latest book is 'Smart Business Intelligence Solutions with SQL Server 2008' (MSPress). @llangit Lynn Langit http://blogs.msdn.com/SoCalDevGal https://api.twitter.com/1/users/profile_image?screen_name=@llangit 48 48 3704 Mark Rosenberg Mark Rosenberg has been writing software with Microsoft technologies for the last 10 years. He has been speaking to user groups and at code camps for the last 2 years and been a certified trainer for the last year. Mark likes to talk to developers and has been talking to anyone who will listen. He is very active in the community, both speaking at user groups and running 2 user groups in Southern California. @m_rosenberg https://api.twitter.com/1/users/profile_image?screen_name=@m_rosenberg 48 48 3970 Meredith Ryan-Smith Meredith Ryan-Smith has over 10 years experience in IT with responsibilities ranging from ‘manning’ the help desk to VMS-VAX cluster administration. Most recently she has served as the senior production database administrator for The Bell Group, a supplier to the jewelry industry. Within the PASS community she is the chair person for the Women In Technology Virtual Chapter and has spoken at several SQL Saturdays. @coffegrl http://www.linkedin.com/profile/view?id=10839821trk=tab_pro http://meredithryansmith.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@coffegrl 48 48 3670 Peter Kral Peter Kral is a T-SQL Developer and SQL Server Database Administrator with over a decade of experience with Microsoft SQL Server since version 6.5. A Sr. DB Engineer for Provide Commerce, home of ProFlowers.com and RedEnvelope.com, he is part of a database team that mantains transactional and data warehouse databases for a half-billion dollar company with over 500 employees. Peter also helps coordinate the monthly San Diego SQL Server User Group meetings that are hosted at Provide Commerce. @pkral http://www.linkedin.com/in/peterkral http://www.prvd.com https://api.twitter.com/1/users/profile_image?screen_name=@pkral 48 48 4124 Phil Robinson Phil is an independent database developer and BI consultant with more than ten years experience working with SQL Server. His current areas of focus are data repository design, data mining, ETL and data visualization using SQL Server 2005/2008 business intelligence tools. Phil is active in the community as a SQL Saturday San Diego co-founder and serves as president of the San Diego SQL Server User Group. http://www.linkedin.com/in/sqldbdev http://www.sqldbdev.com https://api.twitter.com/1/users/profile_image?screen_name= 48 48 3898 Randy Knight Randy Knight (MCITP) has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for Match.com, one of the largest and most successful dot coms. He is currently the owner and Principal Consultant for SQL Server Solutions Group LLC, a Utah-based SQL Server consultancy. @randy_knight http://www.linkedin.com/in/randyknight http://www.sqlsolutionsgroup.com https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 4012 Reagan Williams Reagan Williams is an SQL Developer Administrator with almost 10 years of software development experience. Starting out with writing custom CGI web components in C++ SQL Server 2000, he currently works on a BI team at a Southern California insurance firm, specializing in moderately sized DBs (>1b records, >2 TBs). @reaganbwilliams http://www.linkedin.com/in/reaganwilliams http://www.rwsql.com https://api.twitter.com/1/users/profile_image?screen_name=@reaganbwilliams 48 48 4125 Rob Kerr Rob Kerr is CTO with BlueGranite, a Microsoft BI and Data Management Gold partner. Rob has over 20 years’ experience in IT management and consulting. He is an expert in Microsoft BI, specializing in SQL Server Analysis Services and SharePoint BI. His passions include stunning data visualizations, wicked fast database performance and mobile business intelligence. Rob holds a BA in CIS and Microsoft MCITP certifications in both BI Development and Database Administration. @robkerrbi http://www.linkedin.com/in/kerrrob http://blog.robkerr.com https://api.twitter.com/1/users/profile_image?screen_name=@robkerrbi 48 48 3641 Ted Tasker Ted Tasker joined Microsoft in 2008 as a SQL Technology Solution Professional – and is now focused on SQL Parallel Data Warehouse. Ted has over 15 years of experience with SQL Server going back to version 4.2.1. Prior to joining Microsoft, he spent 10 years leading DW and BI departments in financial and Internet entertainment companies. In his current role, Ted provides technical guidance and support in evaluation and implementation planning of very large SQL Server Data Warehouses. http://www.linkedin.com/pub/ted-tasker/3/720/1a8 48 48 4134 Thomas Mueller Thomas Mueller has been working with databases for over 15 years. He received his Master of Science in Information Systems from the Claremont Graduate University. For the last 6 years Thomas has been leading a database team at a medical consulting company in Santa Ana, CA. In addition to databases his interests include data warehousing, data mining and LEGO®. Thomas regularly participates in community events such as round tables, user groups, code camps, and conferences. @tmspecial http://www.linkedin.com/in/tmspecial https://api.twitter.com/1/users/profile_image?screen_name=@tmspecial 48 48 3600 3600 Denny Chery Rustler Hangout Rustler Hangout 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. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 3603 3603 Denny Chery Tech 100 Tech 100 In this session we will look at the features which are provided with Microsoft SQL Server 'Denali' as part of the 'Always On' features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution. Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database. 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 3607 3607 Ike Ellis Tech 118 Tech 118 Learn what SQL Azure means to the developer and the DBA. We'll discuss key differences, gotchas, and performance tuning methods. If we have time, we'll cover SQL Reporting Services in the cloud and SQL Azure Data Sync Services. Lynn Langit and Ike Ellis will be speaking. 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 3639 3639 Denise McInerney Tech 101 Tech 101 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. 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 3640 3640 Denise McInerney Tech 117 Tech 117 How to Succeed on a Distributed Team More and more technology professionals work with colleagues who are based all over the world. Being part of a distributed team means dealing with differences in communication style, work culture and time zones. Based in the U.S., Denise McInerney works on a team that has more than 50% of its members in India. In this session Denise will share her tips and techniques for how to be successful when working with people around the globe. 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM 3641 3641 Ted Tasker Tech 100 Tech 100 In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture. PDW is capable of delivering very fast query performance and can house up to 500 TB of data. This session will overview both the HW and SW architecture of the PDW appliance. It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData. Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 3644 3644 Diana Dee Tech 100 Tech 100 Would you like to understand the basic structure of relational databases? Have you ever wondered how you can flawlessly decide whether two tables have a one-to-many, many-to-many, or one-to-one relationship? Do you want to understand the basics of top-down and bottom-up database design? Do you want to be able to explain normalization to third normal form? Then this presentation is for you! Content: • Keys and dependencies / determinants • What are the entities? (Top-down design) • Table connectivity (one-to-many or many-to-many) • What are the attributes? (Bottom-up design) • Normalization 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 3645 3645 Bob Abernethy Tech 100 Tech 100 We will take a look at how the focus and characteristics of BI have changed over the last 25 years up to the present. We will also discuss the recent history of Microsoft's focus on BI, and will take an in-depth look another approach to SQL Server-based BI provided by Strategy Companion Corporation. You will see why companies such as Citigroup, L'Oreal, Honeywell, DataQuick, and many others have embraced Analyzer, Strategy Companion's award-winning, zero-footprint front-end to Analysis Services for their BI applications. You'll see why SQL Server magazine called Analyzer 'the best solution to complete the Microsoft BI platform' and how you can quickly implement cost-effective, self-service BI for your non-technical business users. 4/9/2011 12:30:00 PM 4/9/2011 1:15:00 PM 3655 3655 Lynn Langit Tech 118 Tech 118 Using mostly demos, Lynn will show you how to work with SQL Azure using tools and techniques. She will cover migrating data, feature compatibility and futures. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 3657 3657 Juan Soto Tech 116 Tech 116 Access can be a rapid development UI for small SQL Server databases, saving you time and money over .Net, IF you follow the right strategies and avoid the pitfalls. We will discuss how to fine tune the relationship between the two, strategies on importing data, how to minimize connections to SQL Server and touch on Access Data Projects. We will also discuss where Access as the presentation layer makes sense and DBA strategies in working with Access developers. At the end you will walk away with a better sense of managing the Access/SQL Server relationship. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 3663 3663 Juan Soto Tech 116 Tech 116 SQL Server Express was the best thing to ever happen to Microsoft Access, it provides security, multi-user service, and processing power beyond what Jet could ever provide. Now you can migrate small databases to a environment that can meet corporate IT policies and enjoy it without paying for a server license. We will discuss migration strategies to SQL Server Express, backup and maintenance, and optimizing the relationship between the two. We will also cover avoiding road blocks and what every SQL Server table should have when working with Access. 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM 3670 3670 Peter Kral Tech 101 Tech 101 Many SQL Server Database Administrators or T-SQL developers have not had the chance to learn about Powershell scripting. This presentation introduces Powershell scripting within SQL Server Agent jobs, explaining the critical basics you'll need to get started. You'll see examples of SQL jobs that use Powershell scripts to manage files, to control other jobs, and to create and mail simple reports. By the end, you'll be ready to create your first SQL Server Agent job with a Powershell job step. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 3671 3671 Peter Kral Tech 100 Tech 100 SSIS provides the Checkpoint functionality for recovery after a package failure, but many experienced SSIS developers eschew it because of its lack of granularity when restarting a failed package. Sometimes the restarted package will execute tasks that had partially succeeded previously, causing data consistency issues or outright data destruction! In this session, you will see SSIS package design that allows predictable, scalable recovery after a partial or complete failure during execution. Intended for experienced SSIS developers with knowledge of SSIS Expressions and T-SQL. 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM 3704 3704 Mark Rosenberg Tech 116 Tech 116 This is a 100 level session on T-SQL for beginners 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 3771 3771 David McCarter Tech 116 Tech 116 Learn how to build real world nTier applications with the Entity Framework and related services. With this new technology built into .NET, you can easily wrap an object model around your database and have all the data access automatically generated or use your own stored procedures and views. Then learn how to easily and securely expose your object model using WCF with just a few line of code using ADO.NET Data Services. The session will demonstrate how to create and consume these new technologies from the ground up. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 3772 3772 David McCarter Tech 116 Tech 116 In this session I will show you how I used the Entity Framework Services to design and create an API servicing layer to expose back end data to partners. We will dive into using the Entity Framework (data layer), WCF Data Services (service layer), T4 templates (business entities), WCF Message Inspectors (security) and more. 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 3898 3898 Randy Knight Tech 101 Tech 101 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. 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 3899 3899 Randy Knight Tech 101 Tech 101 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. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 3929 3929 Denny Cherry Rustler Hangout Rustler Hangout During this session we will be digging into the internals of SQL Server indexes. 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM 3963 3963 Colin Smith Tech 101 Tech 101 This is a level 100 session going over the basics of powershell. The second half of the session will be seeing powershell in action and some cool scripts for the DBA to help wet the appetite. Powershell is a great tool in the DBA toolbelt that will make you a more valuable assett to your company. I will go over the basics and show you some things that will allow you to do just about anything you want with Powershell.. 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 3970 3970 Meredith Ryan-Smith Tech 118 Tech 118 Most accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available. 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 4003 4003 Jose Pons Tech 117 Tech 117 Check out SSIS capabilities and see the diference from DTS technology. 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 4004 4004 Jose Pons Tech 101 Tech 101 Let's put to the test TSQL and see how far the SQL Server engine goes. To attend you need to understand execution plans and SQL Server engine concepts, otherwise it would be fun. 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM 4012 4012 Reagan Williams Tech 118 Tech 118 This session will provide techniques on how to make SSIS packages more reliable and robust in production. Topics to cover: - Transactions - Error Handling - Logging - Package Configurations We'll get to do some development, move a lot of data around and have some fun. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 4045 4045 Benjamin Nevarez Tech 100 Tech 100 You are implementing partitioning because you want easier management for very large tables and indexes and want to improve your data loading, deletion and archival operations. But you also need to know the query processing implications and understand how partitioning will impact your existing queries. On the other side, many developers believe that the primary purpose of partitioning is to make your queries run faster. This session will show you the reality and will focus on both how to implement partitioning to achieve better maintenance and data availability and how it will impact query processing, including potential issues, benefits and recommendations. 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 4046 4046 Benjamin Nevarez Rustler Hangout Rustler Hangout This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach. 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 4056 4056 Harold Wong Tech 100 Tech 100 This session will cover Microsoft Virtualization technologies in Windows 7 and Windows Server 2008 R2 (Hyper-V). I will cover how to use the tools in both environments to create and manage Virtual Machines (VMs) and explain when to use Windows 7 versus Server 2008 R2. Lastly, I will show how to configure your system for multi-boot using Boot to VHD. If you have a USB hard drive with 10 GB of free space, I will also give you an unactivated VHD with Server 2008 R2 installed and ready to go with Hyper-V. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 4057 4057 Jospeh Vertido Tech 118 Tech 118 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,SSS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined. 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 4117 4117 Andrew Karcher Registration Area Registration Area Opening Session 4/9/2011 8:00:00 AM 4/9/2011 8:20:00 AM 4118 4118 Andrew Karcher Registration Area Registration Area Raffle 4/9/2011 5:00:00 PM 4/9/2011 5:30:00 PM 4124 4124 Phil Robinson Tech 117 Tech 117 In this session we will explore the 2008R2 chart types along with the Data Bar, Sparkline and Indicator data regions. We will take a simple table report and enhance it by adding these graphic elements 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 4125 4125 Rob Kerr Tech 117 Tech 117 Microsoft provides a well-integrated set of components that leverage SQL data to deliver compelling BI solutions. In this intermediate-level session we'll pull back the covers from the SharePoint 2010, Analysis Services, PowerPivot and SQL architectures to demonstrate best practices and real-world demos showing how to integrate these technologies into a seamless end-user experience. The session will focus on SharePoint 2010 BI features, security, Analysis Services, Reporting Services Integrated mode, PowerPivot, Excel Services and mobile device integration. 4/9/2011 9:45:00 AM 4/9/2011 10:45:00 AM 4132 4132 David Moutray Tech 116 Tech 116 In the words of Brent Ozar (www.BrentOzar.com), 'You can't be a great SQL developer without using Test Driven Development. In the words of Grant Fritchey (www.ScaryDBA.com), 'Test Driven Development with SQL Server made me want to tear my hair out.' Testing in T-SQL may be more cumbersome than in other development languages, but eventually all software must be tested. How can you thoroughly test a data-dependent application without testing the data pieces that drive the application components? If the database has problems, they will eventually affect the rest of the application. This session explores the basics of Test-Driven Development: unit tests; setting up test data; and automating your tests. 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 4134 4134 Thomas Mueller Rustler Hangout Rustler Hangout In this session SQL Server experts/users will talk about several SQL Server topics. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 4135 4135 Denise McInerney Rustler Hangout Rustler Hangout Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more girls and young women to consider a career in technology? Join a panel of dynamic Women in Technology including Meredith Ryan Smith, Lynn Langit, Denise McInerney and others to discuss this important topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. Everyone is welcome, male and female. 4/9/2011 12:30:00 PM 4/9/2011 1:15:00 PM 4137 4137 Carlos Bossy Tech 117 Tech 117 Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions. 4/9/2011 11:00:00 AM 4/9/2011 12:00:00 PM 4140 4140 Carlos Bossy Tech 117 Tech 117 Take this opportunity to see the development of a real-world data mining model from inception to deployment. The Business Intelligence components of SQL Server make it possible to create powerful predictive models that can easily be incorporated into our applications. In this presentation Carlos Bossy will demonstrate how to develop a data mining model using Analysis Services through the entire lifecycle. You will learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target, selecting the appropriate data, and adapting it for maximum results. 4/9/2011 2:45:00 PM 4/9/2011 3:45:00 PM 4157 4157 Clint Kunz Rustler Hangout Rustler Hangout What are the largest SQL Server projects in the world and how do they scale? Come to this session and find out. Based on the work of Microsoft's SQL Server Customer Advisory Team (SQL CAT). SQL CAT represents the customer-facing resources from the SQL Server Product Group. SQL CAT is comprised of product and solution experts that regularly engage in the largest, most complex, and most unique customer deployments worldwide. 4/9/2011 1:30:00 PM 4/9/2011 2:30:00 PM 4158 4158 Clint Kunz Rustler Hangout Rustler Hangout This session is almost all demonstration of the Full Microsoft Business Intelligence stack. We will show off all of the latest RTM product sets. Scorecards and Dashboards in SharePoint 2010 and Performance Point Services. SharePoint 2010 Collaboration Integration, Reporting Services Integration into Dashboards, and SharePoint. Data Visualizations using Bing Maps, Reporting Services, and PivotViewer, and finally Managed Self Service Business Intelligence with PowerPivot and Excel 2010. Several demos specific to a Telecommunications provider, a Financial Services provider, and other industry examples. 4/9/2011 8:30:00 AM 4/9/2011 9:30:00 AM 4259 4259 Bret Stateham Tech 118 Tech 118 SQL Server 2008 R2 Reporting Services provides a new map visualziation that allows you place your data in customized map reports. In this session we will review how to get your data onto the map! 4/9/2011 4:00:00 PM 4/9/2011 5:00:00 PM