SQLSaturday #43 - Redmond 20106/12/2010 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat43RedmondWA98052451Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif60170498Quest Softwarehttp://www.quest.comhttp://www.quest.com/images/common/quest-logo.gif60170589Microsoft Corporationhttp://www.microsoft.comhttp://www.sqlsaturday.com/files/f540f572-1e01-4aff-bdde-17ec2132c431.png60170590expressor softwarehttp://www.expressor-software.comhttp://www.expressor-software.com/templates/1/images/top_logo.gif60170454Red Gate Softwarehttp://www.red-gate.com/about/community_relations/sql_saturday.htmhttp://www.red-gate.com/images/redgatelogo_black.jpg60170443WestClinTechhttp://www.westclintech.comhttp://westclintech.com/portals/0/images/xldb_logo.jpg60170468Fusion-iohttp://www.fusionio.comhttp://www.fusionio.com/images/logo-light.png60170572Attunityhttp://www.attunity.comHTTP://www.attunity.com/images/logo_attunity.gif60170455Telerik Inchttp://www.telerik.comhttp://www.sqlsaturday.com/files/4e712e83-83fd-4f2a-8426-4466acfbc079.JPG60170462Pearson User Group Programhttp://www.informit.comhttp://www.informit.com/display/InformIT/images/psts/User_Group_Logo.gif40100467Apress Inc.http://apress.com/http://www.sqlsaturday.com/files/324de488-0141-406f-8e4c-901dfd58492a.gif40100505Kalen Delaneyhttp://www.SQLServerInternals.comhttp://covers.oreilly.com/images/9780735626249/cat.gif401001383Buck WoodySee http://buckwoody.com@BuckWoodyhttp://linkedin.com/buckwoodyhttp://blogs.msdn.com/buckwoodyhttps://api.twitter.com/1/users/profile_image?screen_name=@BuckWoody48481576Chuck LathropeDatabase Operations Manager for Demand Media with 20 years of IT support experience in Microsoft environments. Was nominated last year as one of the top five candidates for Exceptional DBA Award. Been focused on Microsoft SQL Server since 2002. Chuck loves to share his knowledge and is passionate about SQL Server and SharePoint.
@SQLGuyChuck on Twitter.
@SQLGuyChuckhttp://www.linkedin.com/in/chucklathropehttp://www.sqlwebpedia.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLGuyChuck48481377CLIFFORD DIBBLEClifford has been a program manager in SQL Server since 2002. Among other things, he was the active PM for “system views”, “DMVs”, ”DDL triggers”, and “resource database” during the 9.0 release. During the 10.0 release, Clifford was off working on an incubation project. For the 10.5 and 11.0 releases, he is focused on multi-instance manageability and SQL management packs.http://www.linkedin.com/pub/clifford-dibble/5/20b/23b48481819David LydstonDavid Lydston is the Lead Systems Engineer for Apollo Data Technologies in Bellevue, WA. He holds MCITP Database Administrator certification for SQL Server 2005, and an MS in Information Systems Management. David has worked with SQL Server in the healthcare field since 2002; specializing in securing PHI and change management/monitoring. http://www.apollodatatech.com/48481499Dean RichardsDean Richards has over 20 years of performance tuning, implementation and strategic database architecting experience and has spoken at SQL Saturday events across the nation. Prior to Confio, Dean was a technical director for Oracle Corporation managing technical aspects of key accounts including short and long-term technical planning and strategic alliances. Specifically, Dean has focused his entire career on performance tuning of Oracle and SQL Server environments.@ConfioDeanhttp://www.linkedin.com/profile?viewProfile=key=18302796locale=en_UShttp://www.linkedin.com/profile?viewProfile=key=18302796locale=en_UShttps://api.twitter.com/1/users/profile_image?screen_name=@ConfioDean48481565Donabel SantosDonabel Santos is a Developer/DBA/Trainer at Black Ninja Software, based in beautiful Vancouver, British Columbia, where she works with her two favorite technologies – SQL Server and SharePoint. She also teaches web development and database courses at British Columbia Institute of Technology. She is an MCP, MCTS (SharePoint), MCITP DBA/Developer, and an MCT.She has spoken at DevTeach, VANPASS, Victoria Users Group, VANTUG, and is currently helping run VANPASSBI (http://vancouverbi.sqlpass.org)@sqlbellehttp://ca.linkedin.com/in/donabelsantoshttp://www.sqlmusings.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlbelle48481785Doug WheatonDoug Wheaton has over 20 years experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences thoughout the US on the topic of data integration using Microsoft SSIS. 48481385Greg LarsenGreg Larsen has been working with SQL Server since 1999. He has authored over 125 articles related to SQL Server. He holds a MCITP Database Administrator and Developer certification for SQL Server 2005 and is a SQL Server MVP. Greg also hosts the www.sqlserverexamples.com website which contains a number of T-SQL examples to help you manage your SQL Server environment and application T-SQL code. Greg has a full-time DBA gig, but also provides SQL Server consulting services in his spare time. @GregoryLarsenhttp://www.linkedin.com/profile/view?id=24644283authType=nameauthToken=gCE7locale=en_USpvs=pptrk=ppro_viewmorehttps://api.twitter.com/1/users/profile_image?screen_name=@GregoryLarsen48481452Kalen DelaneyKalen Delaney has been working with SQL Server for 22 years, and provides advanced SQL Server training to clients around the world. She is a contributing editor and columnist for SQL Server Magazine and the author of several books on SQL Server, including SQL Server 2008 Internals and Inside Microsoft SQL Server 2005: Query Tuning and Optimization.@sqlqueenhttp://www.SQLServerInternals.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlqueen48481881lunch lunchlunch48481592Matt MassonMatt Masson has worked in the BI industry for the past nine years, and is now a developer on the SQL Server Integration Services (SSIS) team. Matt provides a unique insider's view to the SQL Server Integration Services product. Prior to joining Microsoft in 2006, Matt was employed with Cognos Inc., where he worked on a number of Reporting and CPM products. He maintains the SSIS team blog on MSDN.com, and frequently presents SSIS topics at SQL BI related conferences all over North America.@mattmassonhttp://www.linkedin.com/in/mmassonhttp://blogs.msdn.com/mattmhttps://api.twitter.com/1/users/profile_image?screen_name=@mattmasson48481393Remus RusanuI am an independent consultant offering SQL Server development and administration services. I’ve been working professionally with databases since 1994. For more than 6 years I’ve been a developer with Microsoft, member of the SQL Server team in Redmond, WA.http://rusanu.com48481539Rick MorelanRick is the author of the “SQL Joes 2 Pros” book series. Rick has worked for Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+). He has also provided training for NW University, Volt Technical Education, and Microsoft. @Joes2Proshttp://www.joes2pros.com/https://api.twitter.com/1/users/profile_image?screen_name=@Joes2Pros48481375Robert DavisRobert started his career workign with SQL Server as a database developer in February 2000. In 2003, he accepted his first DBA job. Robert worked as a Data architect/DBA. In 2007, Robert started working as a contractor at Microsoft. He worked contracts at Microsoft as both a production DBA on operations teams and as a development DBA on an engineering team.
In 2009, he accepted an FTE position with the PQO Ops team as an Ops Engineer (DBA). He is the technical lead for the PQO Ops SQL V-Team.http://www.sqlservercentral.com/blogs/robert_davis/default.aspx48481775Scott StaufferScott's an independent consultant working out of the Metro Vancouver Area of British Columbia assisting clients with data system solutions to their business challenges. He has worked in IT for over 14 years, and although Scott has managed systems with early version SQL Server on OS/2, he really started digging deep into SQL Server with the release of SQL Server 6.5. With a keen interest in continuous learning, sharing knowledge, and building community, Scott founded 2 PASS Chapters in Vancouver.@SQLSocialitehttp://ca.linkedin.com/in/ScottStaufferhttp://www.twitter.com/SQLSocialitehttps://api.twitter.com/1/users/profile_image?screen_name=@SQLSocialite48481525Sumeet BansalSumeet Bansal is Principal Solutions Architect for Fusion-io. He designs architectural solutions with Fusion-io products that deliver unprecedented levels of scalability, performance and simplicity. Sumeet has more than 11 years IT and database-infrastructure experience, including work as vice-president of information technology at MS SQL-based Internet retailer Wine.com, senior database architect for MS SQL-based eVineyard inc., and systems analyst for Akiba Bank Limited.48481793Todd McDermidTodd has been developing software for a while, mostly in the supply chain management area. In the past few years, he’s discovered the Data Warehousing and Business Intelligence technologies within SQL Server. He’s an MCSD, an MCTS on SQL BI, and a SQL Server MVP. Todd blogs, moderates MSDN SSIS forums, and manages several open source extensions to Integration Services on CodePlex.@Todd_McDermidhttp://ca.linkedin.com/in/toddmcdermidhttp://toddmcdermid.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Todd_McDermid484813751375Robert Davis2007 - MontlakeUsing SQL Trace/Profiler EffectivelyThe session will cover the difference between SQL Trace and SQL Profiler, and why we recommend using SQL Trace in a production environment. Topics covered will be how and when to use SQL Profiler vs SQL Trace, how to create a trace template and convert it to a SQL script, and how to start a SQL Trace running in response to a performance event. Demos will include creating a trace template and converting it to a script and an example of how SQL Profiler can bring your whole server to a crawl.6/12/2010 2:00:00 PM6/12/2010 3:15:00 PM13771377CLIFFORD DIBBLE2003 - Capitol HillUtility Control Point in SQL 2008 R2Learn how the Utility Control Point (UCP) in SQL 2008 R2 can help you with your capacity management and consolidation projects. In this talk, you will learn the key concepts around the UCP and see a demo. This is also your chance to give us feedback about how you want the UCP to evolve in the 11.0 release of SQL Server.6/12/2010 2:00:00 PM6/12/2010 3:15:00 PM13781378Robert Davis2007 - MontlakeAdventures in SQL Server Masters CertificationThe Microsoft Certified Master for SQL Server program is a 3 week program of in-depth training by the foremost experts in the field and certification.
Come find out what the MCM:SQL is all about. Speaker is going through the March rotation of the MCM program. Get his take on what the program was like. Is it easy or hard? Is it intense or laid back? Is it worth the effort and expense?6/12/2010 3:30:00 PM6/12/2010 4:45:00 PM13831383Buck Woody2003 - Capitol HillSQL Server for the Oracle DBACome 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.6/12/2010 3:30:00 PM6/12/2010 4:45:00 PM13851385Greg Larsen2015 - Queen AnneExploring SQL Server System Information with DMVsThis 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.6/12/2010 9:00:00 AM6/12/2010 10:15:00 AM13931393Remus Rusanu2015 - Queen AnneHigh Volume Real Time Contiguous ETL and AuditHigh 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.6/12/2010 2:00:00 PM6/12/2010 3:15:00 PM14521452Kalen Delaney2015 - Queen AnneThe Compression SessionSQL Server 2008 allows you to compress your data in several different ways. Your tables can be compressed using row compression or page compression, and your can also choose to compress your backups. In this session we'll look at what kinds of data give you the most space savings when compressed, and we'll also discuss the algorithms SQL Server uses to compress your data. Knowing how SQL Server performs compression will allow us to evalutate when the space savings will be worth the cost, and when you might want to avoid compression.6/12/2010 12:30:00 PM6/12/2010 1:45:00 PM14991499Dean Richards2003 - Capitol HillTuna Helper for DBAs and DevelopersMany 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.6/12/2010 10:30:00 AM6/12/2010 11:45:00 AM15121512William Vaughn2003 - Capitol HillLeveraging Local Data Cache and Bi-Di SyncThis 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. 6/12/2010 12:30:00 PM6/12/2010 1:45:00 PM15131513William Vaughn2007 - MontlakeReport Builder 2.0—A New BeginningThis session introduces developers, architects and managers to Report Builder 2.0. Is it perfect? Ah, not so much, but it does have a lot of promise. We’ll take a close look at the mechanisms used to create and customize new RDL reports, save, deploy and launch them and the issues you’ll likely encounter along the way. We’ll experiment with alternative data sources, parameters and expressions and see how far you can stray from the Reporting Services path. We’ll see what reports require a Reporting Services catalog and which do not. Before long your end-users will be using this newly designed tool to help them create their own reports – without having to call you on the phone every five minutes.6/12/2010 9:00:00 AM6/12/2010 10:15:00 AM15251525Sumeet Bansal2015 - Queen AnneAccelerating SQL with Solid State (w/ iPod Raffle)Solid-state technologies are changing the way that MS 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 MS SQL Servers perform. This session will address: 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: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices 4) Customer proof: Wine.com case study 5)Raffle for a Steve Wozniak 6/12/2010 10:30:00 AM6/12/2010 11:45:00 AM15391539Rick Morelan2003 - Capitol HillExplicit Transaction ManagementLearn the basics and a few tricks to help your more advanced SQL transactions make sense. Concepts from chapter nine of Beginning SQL Joes 2 Pros are explained by author Rick Morelan. Isolation levels and table hints can be narrowed down to a few easy rules around just two questions. 1) What should SQL check before it allows data changes? 2) What should SQL show when someone else is making changes? 6/12/2010 9:00:00 AM6/12/2010 10:15:00 AM15651565Donabel Santos2007 - MontlakeSQL Server and PowerShellThis session will cover how you can get started with PowerShell, and how you can use PowerShell with SQL Server. Powershell, a scripting language that leverages Microsoft .NET Framework, can help you manage and automate SQL Server. Demos will include common PowerShell tasks and commands, and querying/scripting/automating SQL Server using SMO and applicable .NET Libraries.6/12/2010 12:30:00 PM6/12/2010 1:45:00 PM15661566Donabel Santos2007 - MontlakeSQL Server 2008 Reporting from the Ground UpIn this session we will explore the rich reporting features introduced in SQL Server 2008 and 2008 R2 Reporting Services, including Report Builder 3.0. We will walk through how to create basic reports, add parameters, enhance layout, and integrate newvisualization components including sparklines, data bars, gauges and maps.6/12/2010 10:30:00 AM6/12/2010 11:45:00 AM15761576Chuck Lathrope2015 - Queen AnneReplication Performance Tuning and TroubleshootingThis session is for users who want to improve their throughput using Replication Profiles and Server/Networking tweaks. I will also cover custom monitoring stored procedures that don't require you to keep replication monitor on all the time. Last item covered are some queries you can use to see replication errors and common solutions to them. It is expected that you know how to setup replication. Session will be focused towards SQL 2005/08 and transactional replication. But can apply towards SQL 2000 and merge replication.6/12/2010 3:30:00 PM6/12/2010 4:45:00 PM15921592Matt Masson2011 - Pioneer SquareSSIS Performance Design PatternsNeed a fast data integration solution, but don't have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We talk about how to set performance expectations, and how to put together a simple framework to record benchmarks for your ETL process. We go over the basics of smart package design, and then look at a number of design patterns for common data warehousing problems, such as Slowly Changing Dimension processing, Range Lookups, and Change Detection.6/12/2010 10:30:00 AM6/12/2010 11:45:00 AM17751775Scott Stauffer2011 - Pioneer SquareSSIS for the faint of heartScott's gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use the tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server's DTS functionality. ETL? It's okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your 'Extract, Transform, and Load' processes.6/12/2010 9:00:00 AM6/12/2010 10:15:00 AM17851785Doug Wheaton2011 - Pioneer SquareHeterogeneous Data Integration with SSIS CDCThis session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined. 6/12/2010 12:30:00 PM6/12/2010 1:45:00 PM17931793Todd McDermid2011 - Pioneer SquareData Warehouse Dimension Processing with SSISThe 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.6/12/2010 2:00:00 PM6/12/2010 3:15:00 PM18191819David Lydston2011 - Pioneer SquareAuditing your SQL ServerNew in SQL Server 2008 Enterprise Edition is a feature called SQL Audit. This feature allows you to record statements executed against the SQL Server at the server and database scopes, for database, schema and object classes. Unlike prior features that could be used for capturing these statements, SQL Audit allows the user, greater granularity in statements captured, multiple output targets, and the ability to capture statements previously un-captureable. In this presentation, code will be presented to setup and monitor SQL Audits along with tips and additional code to enhance your SQL Server auditing experience.6/12/2010 3:30:00 PM6/12/2010 4:45:00 PM18811881lunch lunch2003 - Capitol HillLunch BreakPizza will be served for lunch6/12/2010 11:45:00 AM6/12/2010 12:30:00 PM