SQLSaturday #65 - Vancouver 20112/26/2011 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat65VancouverBC, CanadaV6E 4R5944WorkTamerhttp://www.worktamer.comhttp://www.worktamer.com/images/logo_transparent.gif60170998Iderahttp://www.idera.comhttp://www.idera.com/campaign_images/idera_logo_tag.jpg601701005Marathon Technologieshttp://www.marathontechnologies.comhttp://www.marathontechnologies.com/images/top_logo.gif601701076Microsoft Canada http://www.microsoft.com/en-us/sqlazure/default.aspxhttp://www.sqlsaturday.com/files/ab992e70-8e9a-45bd-b74c-b16998774e31.png601701007Fusion-iohttp://www.fusionio.comhttp://www.fusionio.com/images/fusionio-logo.gif601701030SQL Sentryhttp://www.sqlsentry.nethttp://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg60170981Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif60170987Quest Softwarehttp://www.sqlserverpedia.comhttp://www.quest.com/images/common/quest_logo.gif601701001SQLTeachhttp://www.sqlteach.comhttp://www.devteach.com/banners/SQLTeach2011-125x125.jpg60170868CozyRoc http://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png60170939Red Gate Softwarehttp://www.red-gate.comhttp://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg601701060SQL Server Magazinehttp://www.sqlmag.com/http://www.sqlsaturday.com/files/38829b85-bd42-494a-ab28-1cd879781485.jpg601701093SQLServer Magazinehttp://www.sqlmag.com601701047Stack Exchangehttp://www.stackexchange.comhttp://www.sqlsaturday.com/files/49a0dc28-e2e3-44b5-8709-78258ed342bf.PNG601701024Microsofthttp://technet.microsoft.com/en-ca/default.aspxhttp://vancouverbi.sqlpass.org/sql_micro_sm.gif601701058British Columbia Institute of Technology (BCIT)http://www.bcit.ca/cas/computingparttime/http://www.sqlsaturday.com/files/ec3e3878-4818-4ae5-bacf-02c9ad90c297.jpg601701056Black Ninja Softwarehttp://www.blackninjasoftware.comhttp://blackninjasoftware.com/wp-content/themes/overeasy/images/logo-trans.png601701041Advaiyahttp://blogs.msdn.com/b/billramo/http://desmond.yfrog.com/Himg640/scaled.php?tn=0server=640filename=i6hfa.jpgxsize=640ysize=640601701066Pluralsighthttp://www.pluralsight-training.net/microsoft/http://www.pluralsight-training.net/microsoft/sponsorships/pluralsight-logo-for-sponsorships-large.png601701075@SQLSoldierhttp://www.sqlsoldier.comhttp://www.sqlsoldier.com/imgs/wwssd_sm.png60170956SQLAndyhttp://www.sqlandy.comhttp://www.sqlandy.com/wp-content/themes/BlueStation/images/logoimg.png601701003Telerikhttp://www.telerik.comhttp://www.sqlsaturday.com/files/adb9bf3c-3187-401d-bb0d-3fc9f0690e3c.png601701038Scott Staufferhttp://www.sqlservertoolbox.com/http://www.sqlservertoolbox.com/Portals/0/SSTB_Logo.jpg601701015Advaiyahttp://www.advaiya.comhttp://www.sqlsaturday.com/files/cb1fb5aa-90b0-4cb2-87f1-0b55baa2b263.jpg601701018Pearson User Group Programhttp://www.informit.com/usergroupshttp://www.sqlsaturday.com/files/74dcc20f-4559-4f61-a9f9-679b6bc10f8c.jpg601701039Tim Costellohttp://www.timcost.comhttp://www.timcost.com/wp-content/uploads/2011/02/TimCostLogo_thumb.png601701040InfoAdvisorshttp://www.infoadvisors.comhttp://www.infoadvisors.com/images/loveyourdatachick-small.jpg601701079Yanni Robelhttp://sqlscribbles.comhttp://sqlscribbles.com/wp-content/uploads/2010/05/Yanni.jpg601701045@AaronBertrand of SQL Sentry, Inc.http://sqlblog.com/blogs/aaron_bertrand/http://sqlblog.com/files/folders/33473/download.aspx601701046Todd McDermidhttp://toddmcdermid.blogspot.comhttp://www.sqlsaturday.com/files/84fabcd3-db90-4c42-9018-d8589d2dc55b.PNG601701049sqlbellehttp://www.sqlmusings.comhttp://www.sqlmusings.com/wp-content/uploads/2011/02/sqlmusings-logo-2011.png601701059O'Reilly Mediahttp://oreilly.com/http://oreilly.com/images/orn_logos/sm.ora.logo.plain.gif601701050SQLvarianthttp://sqlvariant.com/wordpresshttp://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png601702914Aaron BertrandAaron is Senior Consultant at SQL Sentry, Inc. He has been a Microsoft MVP since 1997, has spoken at several user group meetings and SQL Saturday events, and blogs at SQLBlog.com (http://sqlblog.com/blogs/aaron_bertrand/).@AaronBertrandhttp://sqlblog.com/blogs/aaron_bertrand/https://api.twitter.com/1/users/profile_image?screen_name=@AaronBertrand48483392Allan HirtClustering MVP Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. He is currently based in the Boston, MA area and for the past ten years has traveled all over the world to work with and train clients. His most recent book is 'Pro SQL Server 2008 Failover Clustering' (Apress) and is currently working on a mission critical book for SQL Server Denali.@SQLHAhttp://www.linkedin.com/pub/allan-hirt/1/b72/673http://www.sqlha.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLHA48483275Argenis FernandezArgenis is a Senior DBA with Microsoft. He has over 12 years of experience in the IT industry, and has been working with SQL Server since version 6.5. He thoroughly enjoys working with SQL Server, managing large, geographically dispersed server farms and Powershell scripting. He hates manual work. He is an MCITP on SQL Server 2008 Database Administration and MCTS on SQL Server 2008 Database Development.
@afernandezhttp://www.linkedin.com/in/argenishttp://www.sqlps.comhttps://api.twitter.com/1/users/profile_image?screen_name=@afernandez48483690Bill RamosI'm currently the SQL Server Work Stream Manager for Advaiya. During my 15 years at Microsoft as a program manager, I shipped or been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Ashton-Tate/Microsoft SQL Server for OS2 (at Ashton-Tate), Excel 2003, Access 2003, Access XP, Access 2000, @billramohttp://www.linkedin.com/in/billramohttp://blogs.msdn.com/billramohttps://api.twitter.com/1/users/profile_image?screen_name=@billramo48483077Brent OzarBrent is a consultant and trainer with SQLskills. He's one of the few Microsoft Certified Masters of SQL Server outside of Microsoft, and he's been working with SQL Server for over a decade. He's also dabbled in SAN administration, VMware administration, and writing, including coauthoring Professional SQL Server 2008 Internals and Troubleshooting.@BrentOhttp://www.linkedin.com/in/brentozarhttp://www.brentozar.comhttps://api.twitter.com/1/users/profile_image?screen_name=@BrentO48482970Denny CherryDenny 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.@mrdennyhttp://www.linkedin.com/in/mrdennyhttp://www.mrdenny.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mrdenny48482929Donabel SantosDonabel Santos (MCTS/MCITP/MCT) is a Developer/DBA/Trainer at Black Ninja Software, where she works with her two favorite technologies – SQL Server and SharePoint. She teaches web development and database courses at British Columbia Institute of Technology (BCIT). She moderates the “Ask the Experts: PowerShell for SQL Server” from Idera/PowerShell.com, and has spoken at SQL Server events like DevTeach, VANPASS, VANTUG, and SQLSaturday. She blogs at sqlmusings.com, and tweets as @sqlbelle.@sqlbellehttp://ca.linkedin.com/in/donabelsantoshttp://www.sqlmusings.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlbelle48482962Gail ShawGail is a database consultant from Johannesburg, South Africa, specialising in performance tuning and database optimisation. Before moving to consulting she worked at a large South African investment bank and was responsible for the performance of the major systems there. Gail is a frequent poster on the SQLServerCentral forums and writes for the same site. She has presented at TechEd Africa and the PASS Community Summit. She was awarded MVP for SQL Server in July 2008. @SQLInTheWildhttp://za.linkedin.com/in/gailshawhttp://sqlinthewild.co.zahttps://api.twitter.com/1/users/profile_image?screen_name=@SQLInTheWild48483003Greg LarsenGreg Larsen has been working with SQL Server since 1999. He has authored over 100 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_viewmorehttp://sqlserverexamples.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GregoryLarsen48482965Jeremiah PeschkaJeremiah Peschka is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. When he is not volunteering with the development community, Jeremiah blogs about data storage, relational databases, and software development at http://facility9.com. He can also be reached on Twitter via @peschkaj@peschkajhttp://linkedin.com/in/jeremiahpeschkahttp://facility9.comhttps://api.twitter.com/1/users/profile_image?screen_name=@peschkaj48482930John HuangJohn is SQL Server Certified Master 2008, independent SQL Server consultant specialized in distributed database architecture, data warehouse and ETL, and database design, operation, security and programming. http://ca.linkedin.com/in/johnhuangca http://agilebi.com/jwelchhttps://api.twitter.com/1/users/profile_image?screen_name=48483150Karen LopezKaren López is Sr. Project Manager and Architect at InfoAdvisors, Inc. Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. @datachickhttp://linkedin.com/in/karenlopezhttp://www.infoadvisors.comhttps://api.twitter.com/1/users/profile_image?screen_name=@datachick48483373Kendra LittleKendra Little is a Senior Database Administrator at WildTangent Games who has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com.@Kendra_Littlehttp://www.linkedin.com/in/kendralittlehttp://littlekendra.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Kendra_Little48483314Randy KnightRandy Knight (MCITP) is an IT Professional who 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.
@randy_knight http://www.linkedin.com/in/randyknighthttp://www.sqlsolutionsgroup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@randy_knight48483433Richard BaumetRichard Buamet has been working for Phillips, Hager North Investment Management ( now under RBC Global Asset Management Inc.) for the last 10 years as a SQL Server DBA. He has also been the local PASS (Professional Association for SQL Server) Chapter leader for the last 4 years and a member since 2002. He has spoken at the local chapter as well as DevTeach in Vancouver, Microsoft TechDays in Vancouver, and Techfest in Vancouver. @RichBaumethttps://api.twitter.com/1/users/profile_image?screen_name=@RichBaumet48483368Scott KleinScott Klein is a SQL Azure MVP and co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States.. Scott is also a veteran author and speaker, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the recently released Pro SQL Azure.
@SQLScotthttp://www.bluesyntax.net/blogs.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLScott48483556Simon SabinSimon is the principal consultant for SQL Know How a company that delivers SQL Server Consultancy and Training. Specialising in the performance tuning and mentoring development teams to deliver high performance solutions utilising SQL Server. He has provided services for clients like Microsoft and Tesco.Simon was awarded as an MVP in 2006. He runs usergroups in London and Cambridge (http://www.SQLSocial.com) and in 2007 founded SQL Bits (Sqlbits.com) the largest SQL Server Conference in Europe@simon_sabinhttp://sqlblogcasts.com/blogs/simons.https://api.twitter.com/1/users/profile_image?screen_name=@simon_sabin48483112Tim CostelloTim Costello is a Tableau Evangelist for the Beryl Companies in Bedford Texas. Tim helps the people of the Beryl Companies and the hospitals they service make sense of the mountains of data they generate with the Microsoft SQL BI tools (SSIS, SSRS and SSAS) and Tableau software. Tim leads the Dallas / Fort Worth Tableau users group and is active in the North Texas SQL Server users group and the Greater Fort Worth SQL Server users group. @sqlagentmanhttp://www.linkedin.com/in/timothyfordhttp://thesqlagentman.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlagentman48483452Todd McDermidTodd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd is a SQL Server MVP – blogging, forum trolling, coding open-source extensions, and presenting on BI topics across the continent.@Todd_McDermidhttp://toddmcdermid.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Todd_McDermid48482904William PearsonBill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base over the years since. Bill's background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution. @Bill_Pearsonhttp://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85ehttp://www.databasejournal.com/article.php/1459531https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson484829042904William PearsonPoint GreyAttribute Discretization in Analysis Services (BI)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.2/26/2011 3:15:00 PM2/26/2011 4:15:00 PM29052905William PearsonPinnacle Ballroom 1Getting Started with MDXIn 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.
2/26/2011 2:00:00 PM2/26/2011 3:00:00 PM29142914Aaron BertrandPinnacle Ballroom 2What's new in SQL Server 2011 ('Denali')?This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Lots of demos and no marketing.2/26/2011 3:15:00 PM2/26/2011 4:15:00 PM29292929Donabel SantosPinnacle Ballroom 1SQL Server 2008 Reporting from the GroundIn 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 new visualization components including sparklines, data bars, gauges and maps.2/26/2011 8:45:00 AM2/26/2011 9:45:00 AM29302930John WelchPinnacle Ballroom 1Do You Know the Data Flow?The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.2/26/2011 10:00:00 AM2/26/2011 11:00:00 AM29332933John WelchPinnacle Ballroom 1Processing Flat Files with SSISWhen doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats. You’ll also see how to produce complex output formats.2/26/2011 11:15:00 AM2/26/2011 12:15:00 PM29622962Gail ShawPinnacle Ballroom 3Introduction to IndexesHave you heard about these things called indexes, but aren't really sure what they are or how to go about using them? If so, this session is for you.
We'll start with the basics of what an index is and why SQL likes them and look at some general guidelines for creating useful indexes, ones that will make your queries lightning fast.2/26/2011 11:15:00 AM2/26/2011 12:15:00 PM29652965Jeremiah PeschkaPinnacle Ballroom 3Refactoring SQLRefactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.2/26/2011 2:00:00 PM2/26/2011 3:00:00 PM29702970Denny CherryPoint GreyWhere should I be encrypting my dataIn this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.2/26/2011 11:15:00 AM2/26/2011 12:15:00 PM30033003Greg LarsenPinnacle Ballroom 3Through the Looking-Glass'Through the Looking-Glass, and What Alice Found There' - When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand.2/26/2011 8:45:00 AM2/26/2011 9:45:00 AM30053005John HuangPinnacle Ballroom 2Query PlanThis session will cover logical and physical operators that frequently showing on the query plan, and how to interpret query plans.2/26/2011 8:45:00 AM2/26/2011 9:45:00 AM30773077Brent OzarPinnacle Ballroom 2Virtualization and SAN Basics for DBAsThese two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.2/26/2011 10:00:00 AM2/26/2011 11:00:00 AM31123112Tim CostelloAmblesideTableau: Delivering Self-Serve BIrapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn't going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.2/26/2011 2:00:00 PM2/26/2011 3:00:00 PM31503150Karen LopezPinnacle Ballroom 2Database Design Contentious IssuesA highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Varchar(1) and other Varying datatypes * Identity Properties * Naming Standards - Who needs them? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
2/26/2011 11:15:00 AM2/26/2011 12:15:00 PM31533153Tim FordAmblesideWho Needs DMVs? You Do!Learn how you can query Dynamic Management Views (and Functions) to troubleshoot performance issues, tune troublesome queries, learn the innermost secrets of your SQL Server instances, and capacity plan among other things. Tim pulls from his new project: The Periodic Table of DMVs as well as his sessions on DMVs at SQL Cruise to examine and discuss a wide variety of DMVs (and DMFs).2/26/2011 3:15:00 PM2/26/2011 4:15:00 PM32753275Argenis FernandezAmblesideMulti-Server Management with SQL Server 2008 R2Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver queries, Utility Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits.
2/26/2011 10:00:00 AM2/26/2011 11:00:00 AM33143314Randy KnightPoint GreyBecome a Bilingual DBA! Oracle for the SQL Server 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.
2/26/2011 2:00:00 PM2/26/2011 3:00:00 PM33683368Scott KleinAmblesideSQL Azure - Cloud Database CoolnessWhat is SQL Azure and why should you be interested in it? What benefits can it have for your company? This session will discuss what SQL Azure is, why you should be looking at it, and how to work with SQL Azure. We will discuss deployment scenarios, briefly discuss how to develop applications for SQL Azure, including OData, and how SQL Azure can help face constant infrastructure challenges and demands. We will look at how to improve SQL Azure performance by looking at technologies such as Sharding and caching.2/26/2011 8:45:00 AM2/26/2011 9:45:00 AM33733373Kendra LittlePinnacle Ballroom 3No More Bad Dates: Using Temporal Data WiselyTemporal data can be confusing in SQL Server. It's no wonder: there are six data types for storing these values. In this session we'll discuss dates, times, and how they are stored internally. We'll talk about how to select a temporal data type and common issues with some types. We'll compare performance of different methods for computing temporal values. We'll also take a look at gotchas in features of SQL Server for which date and time data type choices can be critical. Choose wisely: the correct type and high performing data access logic will help your applications scale and save development and administrative time.2/26/2011 3:15:00 PM2/26/2011 4:15:00 PM33923392Allan HirtPoint GreyIs That A Failover Cluster On Your Laptop?ver the years, one of the most common questions I am asked is, 'How can I configure a cluster on my machine?' Ask no more! Production should never be the only place you have clusters. Having the ability to create a cluster that you can use as a sandbox for testing or as an instruction tool for presentations and demonstrations is something every DBA should have in their arsenal.This session will demystify the 'magic' behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V in Windows Server 2008 R2, and show how to configure things like the virtual machines, the domain controller, and the iSCSI storage solution.2/26/2011 10:00:00 AM2/26/2011 11:00:00 AM34333433Richard BaumetPoint GreyNUMA for the SQL ServerIn this session you will learn what is NUMA, how to identify systems with it, how SQL Server utilizes it, how to adjust SQL Server settings to accomidate for it, and finally how it can impact legacy SQL Server versions. 2/26/2011 8:45:00 AM2/26/2011 9:45:00 AM34523452Todd McDermidPinnacle Ballroom 1Data Warehouse ETL with Integration ServicesMicrosoft designed Integration Services with ETL processing for Data Warehouses in mind, so loading one should be pretty easy. It's not that bad, but there are a few things you should avoid and non-obvious best practices to use to make that ETL faster and more reliable. This session will explain how to accomplish Kimball style ETL using SQL Server Integration Services. We'll review the SCD Wizard and how it works for processing your dimension tables - and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices that apply directly to DW loads.2/26/2011 3:15:00 PM2/26/2011 4:15:00 PM35563556Simon SabinPinnacle Ballroom 3High Performance functionsFunctions are something we are taught in our first programming lesson are a good development practice, to encapsulate common code and ensure code reuse. In this session we will look at the different ways you can write functions in SQL Server and importantly look at the performance and pitfalls of each option. 2/26/2011 10:00:00 AM2/26/2011 11:00:00 AM36903690Bill RamosAmblesideTroubleshooting with the SQL Server 2008 DC MDW In this session you will learn about the SQL Server 2008 R2 data collector and management data warehouse for troubleshooting your problem situations with your SQL Server. I'll demonstrate several problem scenarios and how the MDW reports can help you identify the root cause. You'll also learn what data collection strategies might worh best in your environment.2/26/2011 11:15:00 AM2/26/2011 12:15:00 PM39583958Gail ShawPinnacle Ballroom 2Lies, Damned Lies And StatisticsEver wondered what the things called statistics are, why they're important and what needs to be done to maintain them? If so, this session is for you! In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate. Finally well cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.2/26/2011 2:00:00 PM2/26/2011 3:00:00 PM