SQLSaturday #164 - Cleveland 2012 8/18/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. #sqlsat164 DeVry University 4141 Rockside Road Suite 110 Cleveland OH 44131 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 2388 TMW Systems Gold Sponsor http://www.tmwsystems.com http://www.sqlsaturday.com/files/76890c37-e1d1-4c1c-aed0-8cb737a508a5.png 60 170 2389 Cynergies Solutions Group Gold Sponsor http://www.cynergies.net http://www.sqlsaturday.com/files/899b1ee7-ba89-42c9-8508-0059d5be7d6d.jpg 60 170 2390 Hyland Software Gold Sponsor http://www.hyland.com http://www.sqlsaturday.com/files/ee969ae0-5be7-43a9-8089-d195b0059d82.png 60 170 2395 Upsearch Gold Sponsor http://www.upsearch.com http://www.sqlsaturday.com/files/55a668f2-9e99-4e24-bd3c-b33e94742827.png 60 170 2397 DeVry University Gold Sponsor http://www.devry.edu/locations/campuses/loc_sevenhills.jsp http://www.sqlsaturday.com/files/bb009825-2f8b-4b15-8d41-4e5c1ac0d858.jpg.jpg 60 170 2422 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2560 SQL Sentry Gold Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 2375 Quest Software Silver Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2398 Solutient Silver Sponsor http://www.solutient.com/traininghome http://www.sqlsaturday.com/files/9f9033a3-b708-44f3-8c0a-9dd5aee58400.jpg 60 170 2459 Melissa Data Silver Sponsor http://www.MelissaData.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2539 New Horizons Computer Learning Centers Silver Sponsor http://www.nhcleveland.com/localweb/default.aspx?groupid=13 http://www.sqlsaturday.com/files/6a106547-962c-4b62-be66-16cadc11741f.jpg 60 170 2573 Sapien Technologies Friends of SQL Saturday http://www.sapien.com http://www.sqlsaturday.com/files/d17921c8-5d83-4110-b8e9-e928b8bdce65.jpg 40 100 2586 Red Gate Software Friends of SQL Saturday http://www.red-gate.com http://www.sqlsaturday.com/files/2fbc818d-54eb-40f6-8383-94477e750e4a.png 40 100 2508 SQL Cruise Blog Sponsor http://sqlcruise.com/2013-cruises/ http://www.sqlsaturday.com/files/a13cdd04-4912-459d-92f0-c7135aa88997.png 40 100 9692 Adam Belebczuk LL13 LL13 In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 9702 Colleen Morrow LL9 LL9 Who altered this view and how? When was this index created? What happened to my stored procedure? From SQL Trace to SQL Audit, from C2 to Extended Events, we'll explore various methods of auditing object changes in SQL Server in a quest to find the perfect DDL audit solution. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 9703 Colleen Morrow LL5 LL5 Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 9739 Rob Kerr LL16 LL16 Learn how to combine SQL Server and SharePoint technologies to deliver compelling insights and rich data exploration. This session covers architecture and deployment planning for BI solutions using SQL Server, Analysis Services, PowerPivot, Power View, Excel Services and related technologies. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 9741 Rob Kerr LL16 LL16 Analysis Services Tabular models provide a new paradigm for analytical data exploration and analysis. This session explains the architecture and significance of Tabular models powered by xVelocity, and will get you started creating high-performance analytical databases with stunning performance characteristics. Both PowerPivot and SSAS Server-based models will be covered. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 9983 Jeff Moden 114/115 114/115 Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive 'black arts' session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-) 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10010 Steven Wright LL9 LL9 This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it's performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We'll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server's performance. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10023 Eddie Wuerch LL9 LL9 Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them. 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10024 Eddie Wuerch LL15 LL15 Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you! 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10050 David Eichner LL16 LL16 Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources. This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently. 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10069 Craig Purnell LL5 LL5 LinkedIn is more than an online resume! The platform is chock full of useful features for networking, relationship building, and job searching. Think of it as your professional online image. LinkedIn is rapidly becoming the de facto platform for business networking. There are many powerful, advanced features that most people don’t know how to use or even exist. It is also an online communication platform, professional networking portal, and contacts database. Takeaways include: how to optimize and polish your profile, how to get your profile to 100%, quality vs. quantity networking strategies, selecting of and the correct use of LinkedIn groups 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10079 Shelly Noll LL13 LL13 A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10082 Josh Fennessy LL15 LL15 More often than not, a SQL DBA will also be requested (or required) to administer *other* applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations. This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 10099 Timothy Corey LL2 LL2 You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you. 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10105 Cory Stevenson LL2 LL2 In the SQL Server tool box there is a great tool called SQL Server Report Services. With five different interfaces, Report Services can be a bit challenging to setup and configure. Our focus will include setup, configuration, and deployment. When you walk away from this session, you will understand terms like BIDS, SSRS, Report Builder, and Crescent. Also, as part of this session we will cover the differences between SQL 2008 R2 and SQL 2012. If you are looking for steps to start developing your repertoire of SQL Server Report Services, this is definitely a session to attend! 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 10107 Lisa Gardner LL15 LL15 SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10125 Ira Whiteside LL16 LL16 This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10151 Joseph D'Antoni LL15 LL15 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. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10152 Joseph D'Antoni LL15 LL15 Are you really interested in the new Always On Availability Group feature in SQL 2012? Like really interested? We will talk about the basic architecture of AlwaysOn, then dive deep into the system views behind it, and then use Extended Events, to walk through what's going on inside of SQL and the Windows cluster to make AlwaysOn work. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10197 Jason Spangler LL2 LL2 Many new DBA's are unaware of the power of SQL Profiler. Many don't know it exists. And better yet, it's FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10216 Kevin Boles LL2 LL2 This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can get when suboptimal joins are used. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10217 Kevin Boles LL5 LL5 Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page! 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10260 Arie Jones LL13 LL13 Putting big data in the cloud is not without its difficulties and the Microsoft Azure teams have been consistently upping the resource limits that you are able to utilize within a given instance. Those of us with larger capacity instances still have to hedge our bets when looking at moving to the cloud. That is until the recent release of SQL Azure Federations, which offers a native SQL Azure based option to possible unlimited scalability. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, and put you on the right path to a successful Federation based deployment. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10291 Eric Wise LL5 LL5 In a world where “every company is becoming a software company”, building and managing a software development team that can consistently deliver value is a key concern for hiring managers and executives. In this presentation we cover the key qualities of good software, discuss research showing why hiring great developers pays big dividends, explore why your hiring process sucks, and cover common traits of high performing teams, and more importantly things in your environment that drive great developers away. Bonus: Most of the recommendations are inexpensive! 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10293 Steven Wright LL9 LL9 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. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10321 Stacia Misner LL16 LL16 Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10323 Stacia Misner LL16 LL16 Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch and cheer as SQL Server MVP Stacia Misner and a handpicked volunteer engage in word play, all wrapped up in SQL Server Reporting Services. They’ll push the limits with what can be built in SSRS and have a stupid amount of fun while doing it. Trash talk, board games and SQL…who could ask for more? 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10336 Dave Rodabaugh LL2 LL2 Whether you are starting your first business intelligence project or have a struggling effort underway, this presentation will explain the challenges typically encountered in a BI effort. Success factors are grouped by skills and staffing, philosophy and architecture, technology selection, development methodology, quanlity and testing, production engineering, and user training. Addressing these factors early can avoid a failed project, and turn a good project into a great project! 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10349 Thomas LaRock 114/115 114/115 A highly interactive debate between Thomas LaRock and Karen Lopez about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Quality vs Performance...and others. Bring your votes, your debates, and your opinions. 8/18/2012 11:15:00 AM 8/18/2012 12:15:00 PM 10350 Jeff Mlakar LL13 LL13 This is SQL Azure 102. Now that you have an idea of how to create and use a SQL Azure database in the cloud, let’s discuss the questions around Migration and Integration. How do you migrate to the Cloud? What are the challenges? Why should you Integrate On-Prem and Cloud data? How do you implement this? What are the tools available to you? We’ll cover these questions, demos on Migration and Integration, plus Backup and Syncing demos. 8/18/2012 2:45:00 PM 8/18/2012 3:45:00 PM 10359 Louis Davidson 114/115 114/115 In this session, I will do a design and code review of several common patterns of solving problems that a typical programmer will come up against. Problems like coding for hierarchical data, data driven design, dealing with image data, structure generalization, user specified schemas, dimensional reporting, and dealing with uniqueness beyond what you might deal with using a simple uniqueness constraint might allow you to deal with. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10360 Louis Davidson 114/115 114/115 SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more. 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10380 Matt Velic LL5 LL5 “No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. Blogging can land a book deal. In-house team lunch-and-learns can lead to community presentations. Most of all, good communication can be the skill that saves your job or opens the door to new horizons. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 10382 Allen White 114/115 114/115 This session will provide a panel discussion on how you can best manage your career. Panelists will include experts from the IT industry as well as local recruiters, discussing what they look for when hiring or promoting candidates for hire, and how you can distinguish yourself to get that job that you really want. 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10384 Sam Nasr LL13 LL13 The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer. 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10386 Brian Davis LL15 LL15 Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started. 8/18/2012 4:00:00 PM 8/18/2012 5:00:00 PM 10403 Kendal Van Dyke LL9 LL9 As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine. 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10406 Kendal Van Dyke LL9 LL9 Transactional replication can support synchronizing from as few as a hundred to as many as hundreds of millions or more of changes a day across multiple servers. However, replication is more than clicking your way through wizards; Monitoring and tuning are required to achieve optimal performance and the number of processes involved increase the likelihood that problems can (and usually will) occur. This session is for DBA already familiar with the basics of transactional replication and looking to go beyond the setup wizards to gain a deeper understanding of the technology. We'll cover monitoring techniques, calibrating performance, and troubleshooting common replication problems plus share some tricks and tips. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10435 Andy Warren LL5 LL5 Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10436 Andy Warren 114/115 114/115 SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don't see the point in applying such granular security. In this introductory level presentation we'll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we'll talk about why its so important to set security at the database and not just rely on the application enforced security. 8/18/2012 10:00:00 AM 8/18/2012 11:00:00 AM 10587 Allen White LL2 LL2 Let's get back to the basics - we'll talk about basic SQL and how set theory and the relational model are fundamental to building solid queries that do what you want and perform well, too. We'll look at simple queries as well as some more complex ones, how SQL Server satisfies those queries and why set-based logic will give your applications superior performance. This session will provide an introduction to Transact-SQL as well as some looks behind the curtain to see how things really work. 8/18/2012 8:45:00 AM 8/18/2012 9:45:00 AM 10823 SQLSaturday 164 LL2 LL2 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 LL5 LL5 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 LL16 LL16 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 114/115 114/115 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 LL15 LL15 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 LL9 LL9 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10823 SQLSaturday 164 LL13 LL13 Welcome to SQLSaturday 164! 8/18/2012 8:30:00 AM 8/18/2012 8:45:00 AM 10825 SQLSaturday 164 LL13 LL13 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 LL9 LL9 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 LL15 LL15 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 114/115 114/115 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 LL16 LL16 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 LL5 LL5 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10825 SQLSaturday 164 LL2 LL2 Prizes from drawings will be given away - must be present to win! 8/18/2012 5:00:00 PM 8/18/2012 5:30:00 PM 10826 Austin Zellner LL13 LL13 Few projects in Information Technology are as fraught with danger as data migration / ETL projects. With the life’s blood of the organization on the line ( the data ), these projects require strategies for success that are beyond just the code. After conquering successful data migration and merger projects, and surviving failed projects as well, I will present the life cycle of an ETL project, with strategies for handling the specifics of each phase. I will also share a battle hardened methodology for transforming and merging data with multiple key conflicts, and resolving overloaded fields. 8/18/2012 1:30:00 PM 8/18/2012 2:30:00 PM 10827 SQLSaturday 164 LL13 LL13 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 LL9 LL9 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 114/115 114/115 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 LL15 LL15 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 LL2 LL2 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 LL5 LL5 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM 10827 SQLSaturday 164 LL16 LL16 Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible! 8/18/2012 12:30:00 PM 8/18/2012 1:15:00 PM