SQLSaturday #160 - Kalamazoo 2012 9/22/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. #sqlsat160 Kalamazoo Valley Community College 6767 West O Avenue Kalamazoo Township MI 49009 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 2253 BlueGranite, Inc. Platinum Sponsor http://www.blue-granite.com http://www.blue-granite.com/site/Portals/0/sqlsaturday.jpg 60 170 2561 Quicken Loans Platinum Sponsor http://www.quickenloans.com http://www.sqlsaturday.com/files/a0f7137b-a74e-44d7-88c9-c470857040fe.png 60 170 2360 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2429 Idera Gold Sponsor http://www.idera.com http://www.idera.com/campaign_images/logo_Idera_tag_170x60.png 60 170 2469 New Horizons Computer Learning Centers Silver Sponsor http://www.nhgreatlakes.com http://i181.photobucket.com/albums/x177/marksap/NH-logo-color170x60fw.png 60 170 2670 Melissa Data Silver Sponsor http://www.MelissaData.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 2677 iQ for Business Silver Sponsor http://www.halobi.com http://www.halobi.com/images/halo-bi-small.png 60 170 2683 TEKsystems Silver Sponsor http://www.teksystems.com http://www.teksystems.com/Images/Layout/HomeFlash/teksystems.gif 60 170 2685 UpSearch Silver Sponsor http://www.upsearch.com http://www.sqlsaturday.com/files/55a668f2-9e99-4e24-bd3c-b33e94742827.png 60 170 2274 CozyRoc Bronze Sponsor http://www.cozyroc.com http://www.sqlsaturday.com/files/a0ffec3f-15a4-4f86-b1c0-0bc151bdb7d1.png 60 170 2352 Red Gate Software Bronze Sponsor http://www.red-gate.com/?utm_source=ugutm_medium=uglogoutm_content=sqlsat160utm_campaign=redgate http://www.sqlsaturday.com/files/4f9d23cd-7270-42a7-85bc-283d82eabacb.jpg 60 170 2355 SRT Solutions Bronze Sponsor http://www.srtsolutions.com http://www.sqlsaturday.com/files/301f6a55-d67f-44c4-85a8-91689b555ed5.png 60 170 2515 SQL Cruise Personal Sponsor http://www.sqlcruise.com http://www.sqlsaturday.com/files/6b6bae30-6179-4c5e-a3e0-a2042778c23c.png 40 100 2609 Yanni Robel Personal Sponsor http://yannirobel.com http://yannirobel.com/wp-content/uploads/2011/04/logo.png 40 100 2649 Gerasus Software Personal Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logoSmall.png 40 100 9406 SQLSaturday 160 Track 1 4540 SQL Saturday 160 Lunch 9/22/2012 12:30:00 PM 9/22/2012 1:15:00 PM 9406 SQLSaturday 160 Track 5 4230 SQL Saturday 160 Lunch 9/22/2012 12:30:00 PM 9/22/2012 1:15:00 PM 9409 Ron Johnson Track 1 4540 SSIS is a powerful and east to use data Extract, Transform, Load (ETL) tool SSIS providing a rich set of components to perform the most common ETL tasks with “drag-and-drop” ease. Packages can be constructed with rigorous error and exception handling as well as verbose logging allowing deployment of robust ETL processes.. This session will demonstrate a process for loading a comma-delimited data file into a staging table for further processing then validating the data and moving specific data into host tables using a a thorough example of a non-trivial ETL project with “real” data. The intended audience includes beginning SSIS developers, DBAs, and anyone with a desire to experience the magic of data management with this remarkable tool. 9/22/2012 10:15:00 AM 9/22/2012 11:15:00 AM 9412 Adam Belebczuk Track 1 4540 One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you're just curious about AlwaysOn, then you won't want to miss this session. 9/22/2012 9:00:00 AM 9/22/2012 10:00:00 AM 9428 David Eichner Track 3 4380 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy! 9/22/2012 9:00:00 AM 9/22/2012 10:00:00 AM 9449 Tim Ford Track 4 4240 Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It's enough to drive a lesser DBA crazy-insane. That's why it's important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can't control. In this session Tim will go over many of performance-enhancing methods he's developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy. 9/22/2012 4:00:00 PM 9/22/2012 5:00:00 PM 9478 Nitin Salgar Track 2 4370 This session is to introduce to SQL Azure Federations. Will walk you through the process of setting up federation, managing feredations etc and converting an existing database to Federations. This topic requires rudimentary SQL Azure understanding 9/22/2012 4:00:00 PM 9/22/2012 5:00:00 PM 9527 Jason Spangler Track 3 4380 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. 9/22/2012 1:30:00 PM 9/22/2012 2:30:00 PM 9538 Kevin Bullen Track 3 4380 Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don't have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors. 9/22/2012 11:30:00 AM 9/22/2012 12:30:00 PM 9618 Allen White Track 5 4230 Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform. 9/22/2012 10:15:00 AM 9/22/2012 11:15:00 AM 9636 Wendy Pastrick Track 5 4230 Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly. 9/22/2012 1:30:00 PM 9/22/2012 2:30:00 PM 9662 Jason Strate Track 5 4230 Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. 9/22/2012 2:45:00 PM 9/22/2012 3:45:00 PM 9667 Joseph D'Antoni Track 2 4370 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. 9/22/2012 11:30:00 AM 9/22/2012 12:30:00 PM 9701 Colleen Morrow Track 1 4540 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. 9/22/2012 4:00:00 PM 9/22/2012 5:00:00 PM 9759 Brent Ozar Track 4 4240 SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we're going to run out of memory to cache. In this session, we take a lesson from Microsoft's blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he's worked with in the field. 9/22/2012 9:00:00 AM 9/22/2012 10:00:00 AM 9784 Garrett Edmondson Track 2 4370 Provide an introduction to the Massive Parallel Processing (MPP) Architecture. Describe how Microsoft’s MPP Appliance, Parallel Data Warehouse (PDW), allows SQL Server to scale to hundreds of terabytes. The presentation will also contain real world performance metrics and lessons learned directly from someone who actually developed a Parallel Data Warehouse Solution. 9/22/2012 2:45:00 PM 9/22/2012 3:45:00 PM 9990 Jeff Moden Track 2 4370 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. ;-) 9/22/2012 9:00:00 AM 9/22/2012 10:00:00 AM 10027 David Giard Track 5 4230 We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way. Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. In this session, I will explain some of Tufte's most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data. 9/22/2012 9:00:00 AM 9/22/2012 10:00:00 AM 10286 Luke Jian Track 2 4370 A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans. 9/22/2012 10:15:00 AM 9/22/2012 11:15:00 AM 10326 Benjamin Nevarez Track 1 4540 This 400 (or maybe 500) level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well. 9/22/2012 2:45:00 PM 9/22/2012 3:45:00 PM 10365 Juan Soto Track 2 4370 Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job). I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out 9/22/2012 1:30:00 PM 9/22/2012 2:30:00 PM 10397 Shelly Noll Track 4 4240 Join some of the Women in Technology as we share our experiences and field questions from the audience. ALL ATTENDEES ARE WELCOME! 9/22/2012 12:30:00 PM 9/22/2012 1:15:00 PM 10457 Shelly Noll Track 3 4380 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. 9/22/2012 2:45:00 PM 9/22/2012 3:45:00 PM 10666 Hope Foley Track 5 4230 Want to create snazzy reports to impress the boss but aren't a BI expert? Don't climb the clock tower just yet, go get yourself PowerPivot 2012 and come to my session. We'll go over some very real world issues and ways PowerPivot can help solve it. Demos will be jam packed with many of the new features in 2012 at same time giving you a good base to get you started. And this session wouldn't be complete without covering BISM. We will definitely will cover how the BI world is all coming together as one to have hold and cherish in the BI Semantic Model. 9/22/2012 11:30:00 AM 9/22/2012 12:30:00 PM 10715 Eddie Wuerch Track 4 4240 Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be. There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes. 9/22/2012 10:15:00 AM 9/22/2012 11:15:00 AM 10716 Eddie Wuerch Track 4 4240 Performance tuning is both an art and a science. The more science you bring to your efforts, the better your art will be. There are many tools and techniques for finding performance problems, but solving them is usually left to the person using those techniques. This extended session focuses on what’s going on under SQL Server’s hood for a set of tasks normally hidden from users, such as: memory allocation, data manipulation, and on-disk and in-memory data structures. Armed with this knowledge, you will be better prepared to solve a variety of performance problems through deeper insight into the processes working behind the scenes. 9/22/2012 11:30:00 AM 9/22/2012 12:30:00 PM 10849 Anthony Mattas Track 1 4540 Have you ever wondered how to scale Analysis Services across the globe? This session will cover a unique approach to load balancing SQL Server Analysis services using a unique approach created by Carl Rabler and Josh Caplan to load balance SQL Server Analysis services using features already built in to SQL Server Analysis Services and some standard Microsoft technologies. 9/22/2012 11:30:00 AM 9/22/2012 12:30:00 PM 10975 Arie Jones Track 1 4540 Are you buidling systems to monitor and analyze mountains of data, and querying that from the typical relational database just isn't cutting it? Well, my friend, StreamInsight might just be the ticket for you! StreamInsight is Microsoft's platform for building high throughput, low-latency complex event processing (CEPs) systems. In this session, we will delve into what StreamInsight is and how to use it along with other entities such as Analysis Services and Integration Services to provide you big data customers the operational intelligence solutions that they deserve! 9/22/2012 1:30:00 PM 9/22/2012 2:30:00 PM 10976 Rob Kerr Track 4 4240 This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions. The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution. 9/22/2012 1:30:00 PM 9/22/2012 2:30:00 PM 10977 Rob Kerr Track 4 4240 This session is a deep dive that will show you how to use the Hadoop platform to extend traditional Microsoft BI solutions. The first half of the session covers big data architectures, the MapReduce process and strategies for integration of Hadoop data with traditional BI tools. The second half of the session demonstrates how to combine Hadoop, SQL Server Analysis Services, Power View and SharePoint 2010 into an end-to-end solution. 9/22/2012 2:45:00 PM 9/22/2012 3:45:00 PM 10999 Norman Kelm Track 3 4380 You've seen all the amazing scripts that use PowerShell, but writing your own is raising more questions. This session will help fill in the gaps by explaining all the moving parts of PowerShell 2.0, the integration with SQL Server and answer the following questions as well as others. Why is Invoke-Sqlcmd necessary? What is and why is there a Minishell for SQL Server? What makes the SQLSERVER: PS Drive so powerful? How does a remote SQL Server get added to the SQLSERVER: PS Drive? 9/22/2012 4:00:00 PM 9/22/2012 5:00:00 PM 11059 Tamera Clark Track 5 4230 Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data! 9/22/2012 4:00:00 PM 9/22/2012 5:00:00 PM 11201 SQL Saturday 160 Track 4 4240 Opening ceremonies for SQL Saturday 160 which will include important announcments, etc. 9/22/2012 8:30:00 AM 9/22/2012 9:00:00 AM 11202 SQL Saturday 160 Track 4 4240 Closing words and raffle. MUST BE PRESENT TO WIN! 9/22/2012 5:15:00 PM 9/22/2012 5:45:00 PM 11348 David Maxwell Track 3 4380 There are four basic tasks every DBA should know how to do. They are, in this order: Restore, Backup, Index and Stats maintenance, and Consistency Checking. After this session, beginning and 'involuntary' DBAs will know the basic ins and outs of each of these four critical tasks, as well as how to set up recurring maintenance on their servers, and handle some of the common issues these tasks present 9/22/2012 10:15:00 AM 9/22/2012 11:15:00 AM 11608 SQL Saturday 160 Track 2 4370 Vendor Session - BlueGranite, Inc 9/22/2012 12:30:00 PM 9/22/2012 1:15:00 PM 11609 SQL Saturday 160 Track 3 4380 Vendor Session - Quicken Loans 9/22/2012 12:30:00 PM 9/22/2012 1:15:00 PM