SQLSaturday #173 - Washington DC 2012 12/8/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat173 Microsoft MTC Wisconsin Ave Suite 700 Chevy Chase MD 20815 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 2627 Aspect Consulting Gold Sponsor http://www.aspect-consulting.com http://www.aspect-consulting.com/media/17527/aspect_logo.jpg 60 170 2659 Idera Gold Sponsor http://www.idera.com http://www.idera.com/campaign_images/idera_logo_notag.png 60 170 2725 Knowlogy Corporation Gold Sponsor http://www.knowlogy.com http://www.knowlogy.com/images/logoforchat.jpg 60 170 2745 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2758 WaterOx Consulting, Inc. Gold Sponsor http://www.wateroxconsulting.com http://wateroxconsulting.com/waterox-sqlsat.jpg 60 170 2759 Microsoft Gold Sponsor http://www.microsoft.com http://techtickerblog.com/wp-content/uploads/2009/06/microsoft-logo.jpg 60 170 2776 CapTech Consulting Gold Sponsor http://www.captechconsulting.com http://upload.wikimedia.org/wikipedia/commons/thumb/2/2a/CTV_logo_2012_jpg.jpg/320px-CTV_logo_2012_jpg.jpg 60 170 2794 Melissa Data Gold Sponsor http://www.MelissaData.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2822 House of Brick Technologies Silver Sponsor http://www.houseofbrick.com http://davidklee.net/hob_sqlsat_logo.png 60 170 2631 CozyRoc LLC Bronze Sponsor http://www.cozyroc.com http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 2772 MSSQLTips.com Bronze Sponsor http://www.mssqltips.com/ http://www.mssqltips.com/images/mssql_logo_130.jpg 60 170 2838 Apex Systems Bronze Sponsor http://www.apexsysteminc.com http://new.snagajob.com/employer/images/logos/APEX_Brand_Logo580.jpg 60 170 2658 SQL Cruise Personal Sponsor http://sqlcruise.com/2013-cruises/ http://sqlcruise.com/wp-content/uploads/2012/08/sqlsat_sqlcruise_sm.png 40 100 2727 Radney Consulting LLC Blog Sponsor http://www.timradney.com http://timradney.com/wp-content/uploads/2012/09/BlogSponsor.jpg 40 100 2847 SQL Saturday #173 Pre-cons Blog Sponsor http://www.eventbrite.com/org/2855142065 http://blogmedia.eventbrite.com/wp-content/uploads/event-brite.jpg 40 100 11068 SQLSaturday 173 DBA 1 Room 1 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11068 SQLSaturday 173 DBA 2 Room 2 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11068 SQLSaturday 173 BI / SSAS 1 Room 5 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11068 SQLSaturday 173 Developer Room 3 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11068 SQLSaturday 173 BI / SSAS 2 Room 6 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11068 SQLSaturday 173 Professional Development Room 4 Lunch Break 12/8/2012 12:30:00 PM 12/8/2012 1:30:00 PM 11069 SQLSaturday 173 Professional Development Room 4 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11069 SQLSaturday 173 BI / SSAS 2 Room 6 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11069 SQLSaturday 173 Developer Room 3 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11069 SQLSaturday 173 BI / SSAS 1 Room 5 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11069 SQLSaturday 173 DBA 2 Room 2 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11069 SQLSaturday 173 DBA 1 Room 1 12/8/2012 7:30:00 AM 12/8/2012 8:30:00 AM 11070 SQLSaturday 173 DBA 1 Room 1 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11070 SQLSaturday 173 DBA 2 Room 2 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11070 SQLSaturday 173 BI / SSAS 1 Room 5 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11070 SQLSaturday 173 Developer Room 3 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11070 SQLSaturday 173 BI / SSAS 2 Room 6 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11070 SQLSaturday 173 Professional Development Room 4 Raffle/Closing Remarks 12/8/2012 5:15:00 PM 12/8/2012 6:00:00 PM 11073 Geoff Johnson BI / SSAS 1 Room 5 As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11077 Rob Volk Developer Room 3 Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them...even though they deserved it! Learn how to create tables with no names, columns with duplicate names, and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance! 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11078 Rob Volk Developer Room 3 In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys! 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11114 William E Pearson III BI / SSAS 1 Room 5 In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, 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. 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11117 Wayne Sheffield DBA 1 Room 1 Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?' 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11118 Wayne Sheffield Developer Room 3 SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11130 Ira Whiteside DBA 1 Room 1 Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census' has written a series of white papers on record linkage and particular a technique called 'Blocking Indexs'. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of 'real world' examples(Code) and you will leave a master of record linkage and the concepts behind it 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11178 David Klee DBA 2 Room 2 Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11197 Joseph D'Antoni DBA 2 Room 2 Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice. 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11227 Michael Corey DBA 2 Room 2 A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA how to virtualize a business critical application like SQL server 2012. It will be based upon experience learned using VMWare as the virtualization platform. But many of the lessons taught will carry over to any virtualized platform. 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11316 Paul Rizza BI / SSAS 2 Room 6 Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11357 Jason Horner BI / SSAS 1 Room 5 In this session, we will walk through the process of building a spatial data warehouse from the ground up. We will first design a basic spatial data warehouse, then identify and import a spatial data source by using Microsoft SQL Server Integration Services (SSIS), and finally write a spatial query to provide data to SQL Server Reporting Services (SSRS). We will also review basic concepts of working with spatial data in SQL Server. 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11430 Jason Hall Professional Development Room 4 In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid and beginning execution plan analysis. 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11443 Ryan Brickey Professional Development Room 4 With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. To help prevent this for happening, we will review the do’s and don’ts that should be considered when getting to know with a new environment. 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11521 Kevin Boles Developer Room 3 The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure! 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11523 Kevin Boles DBA 2 Room 2 We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over a dozen times now and it is always very highly rated! 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11607 Steven Wright DBA 1 Room 1 In this presentation, Steve will provide an overview of Resource Governor, a feature introduced in SQL Server 2008 that gives DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He’ll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11620 Tim Radney DBA 2 Room 2 It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy. 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11625 Kevin Goode Professional Development Room 4 Being a DBA is not all smiles and sunshine; sometimes you have to deal with the tedious topic of licensing. As a DBA, developer, or consultant, you are responsible for ensuring that your company or client is in compliance and can pass software audits. As with any Microsoft product license, there are complicated nuances of the SQL Server licensing program with many new twists added in 2012. This session will help you understand what you can and cannot do with various license types, and, how you could save your company some serious money. 12/8/2012 10:15:00 AM 12/8/2012 11:15:00 AM 11705 Brian Moran Professional Development Room 4 Data professionals spend a lot of time asking questions. You spend countless hours refining your techcial skills but how much time do you spend learning researching and practicing the art of asking questions? What might happen to your career if you did? This session presents a bit of theory on the art and science of questions. Here's a question for you: Did you know that asking 'why' questions can make people feel defensive and can color the way they respond to you? Strange but true. We'll review some of the biggest mistakes you can make when asking questions and I’ll offer a few some tips on how you can turn mediocre questions into great questions. And oh yeah. I'll leave time for asking questions at the end. 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11708 Stacia Misner BI / SSAS 2 Room 6 Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration. 12/8/2012 2:45:00 PM 12/8/2012 3:45:00 PM 11724 Carlton Ramsey DBA 1 Room 1 This session will go over what PowerShell is and walk though some example code of ways I use PowerShell to help me as a DBA. 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11728 derek dai BI / SSAS 2 Room 6 This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment. 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11729 Konstatin Melamud Developer Room 3 Topic will provide a more in depth look into query execution plans and is targeted for junior to senior DBA’s. You will learn how to identify what indexes are being used by the SQL optimizer, different type of index operations that are performed by SQL server and what operations are generally considered as a preferred method of data retrieval. We will discuss how to determine if indexes used by the optimizer are the optimal ones and the exceptions to the rules. Finally we will discuss the relationship between different types of index operation and different types of join types within SQL Server including how the SQL Optimizer determines which join type it will use and pros and cons of each type. 12/8/2012 1:30:00 PM 12/8/2012 2:30:00 PM 11730 John Sterrett BI / SSAS 2 Room 6 If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. You will learn how to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag. 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11731 Kevin Goff BI / SSAS 1 Room 5 It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11735 Andy Leonard BI / SSAS 1 Room 5 Co-presented with Darryll Petrancuri! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this presentation, Andy Leonard demonstrates one approach to loading partitioned tables and managing the partitions using SSIS 2012, and reporting partition metrics using SSRS 2012.Objectives1. A practical solution for loading Big Data Fact tables (1B+ rows).2. Learn more about SQL Server 2012 table partitioning.3. Learn more about using SSIS Expression Language to generate dynamic SQL in SSIS 2012. 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11739 Mike Walsh Developer Room 3 Join Brian Moran, Tim Radney, Mike Walsh and perhaps a few more special guests in a panel discussion on some of the worst practices we often see DBAs do. A little secret - we've done them, too. We'll tell you some of the ways you are hurting your databases, tell you about some of the disasters we've been involved in and even share a few horror stories of the ones we've caused. We'll leave plenty of time for QA and give you a chance to share your own or stump us with a 'what would you do....' question. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM 11744 Allen White DBA 1 Room 1 The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances. 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11750 SQLSAT DC Professional Development Room 4 An hour of open panel QA to discuss your professional development. Topics may include resumes, interviews other questions. Join Brian Moran and others as they openly discusses and answers any questions you have regarding your professinal development in SQL Server. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM 11758 Jason Thomas BI / SSAS 2 Room 6 SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level. 12/8/2012 11:30:00 AM 12/8/2012 12:30:00 PM 11765 Eddie Wuerch Professional Development Room 4 Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session 12/8/2012 4:00:00 PM 12/8/2012 5:00:00 PM 11828 SQLSAT DC Professional Development Room 4 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11828 SQLSAT DC BI / SSAS 2 Room 6 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11828 SQLSAT DC DBA 1 Room 1 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11828 SQLSAT DC DBA 2 Room 2 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11828 SQLSAT DC Developer Room 3 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11828 SQLSAT DC BI / SSAS 1 Room 5 Opening remarks 12/8/2012 8:30:00 AM 12/8/2012 9:00:00 AM 11829 SQLSAT DC DBA 1 Room 1 An hour of open panel QA to discuss your SQL HA/DR questions. Join Adam Belebczuk and others as they openly discuss and answer any questions you have regarding High Availability, Distaster Recovery, Replication and SQL Server. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM 11831 SQLSAT DC BI / SSAS 1 Room 5 An hour of open panel QA to discuss your SQL Big Data questions.Join Jim Rotan and others as they openly discuss and answer any questions you have regarding Big Data and SQL Server. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM 11832 SQLSAT DC DBA 2 Room 2 An hour of open panel QA to discuss your SQL Performance questions. Join Kevin Boles, Carlos Charon, Eddie Wuerch, and Konstatin Melamud as they openly discuss and answer any questions you have regarding SQL Server Performance. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM 11833 SQLSAT DC BI / SSAS 2 Room 6 An hour of open panel QA to discuss your SQL DW / BI questions. Join Stacia Misner, Carlton Ramsey and Jason Thomas as they openly discuss and answer any questions you have regarding DW / BI and SQL Server. 12/8/2012 9:00:00 AM 12/8/2012 10:00:00 AM