SQLSaturday #118 - Madison 2012 4/21/2012 12:00:00 AM (GMT-06:00) Central Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat118 Madison Area Technical College - Truax Campus 3550 Anderson St Madison WI 53704 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 1704 Tushaus Computer Services Gold Sponsor http://tushaus.com http://www.tushaus.com/Images/TushausLogo.png 60 170 2106 Red Gate Gold Sponsor http://www.red-gate.com http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1691 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 1887 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 1919 Rubix Consulting LLC. Bronze Sponsor http://www.rubixconsulting.net/ http://www.rubixconsulting.net/Portals/0/rubix_rgb_small.jpg 60 170 1971 Trek Bicycle Corporation Exhibitor http://trekbikes.com http://www.sqlsaturday.com/files/efe576af-35d5-4023-a11f-04958401f225.jpg 40 100 2098 CUNA Mutual Group Exhibitor http://cunamutual.com http://seanpkelley.com/images/cmg_horiz_4c_nounit_170x20.jpg 40 100 1698 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1735 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1934 Doug Lane Blog Sponsor http://www.douglane.net http://www.gravatar.com/avatar/7c3df04d5c5f3471d86847591f0e2e31.png 40 100 2055 Steve Hughes - Data on Wheels Blog Sponsor http://www.dataonwheels.com http://dataonwheels.files.wordpress.com/2011/12/dataonwheelslogolglines.png 40 100 2109 joshuafennessy.com Blog Sponsor http://joshuafennessy.com http://joshuafennessy.files.wordpress.com/2011/10/josh-headshot.jpg 40 100 2122 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 2123 Sean P. Kelley Blog Sponsor http://seanpkelley.com http://seanpkelley.com/images/SeanPKelley-100x40.gif 40 100 2132 Tracy McKibben Blog Sponsor http://www.realsqlguy.com http://dl.dropbox.com/u/65661/Logo_100x40.jpg 40 100 2168 Jes Schultz Borland Blog Sponsor http://tinyurl.com/tinyJes http://lessthandot.com/images/logo_prod.png 40 100 2184 SQLFriends Blog Sponsor http://sqlfriends.org/ http://sqlfriends.org/wp-content/uploads/2012/04/SQLFriends.png 40 100 6372 Josh Fennessy Room 142B Room 142B 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. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 6378 Bob Pusateri Room 142A Room 142A SQL Server's data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we'll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you're getting the most out of them. 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 6380 Ted Krueger Room 350 Room 350 How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 6417 Jes Borland Room 321 Room 321 Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 6460 Ross McNeely Room 350 Room 350 Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting. This method is also helpful for processing many smaller cubes. 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 6501 Tim Ford Room 322 Room 322 Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps. Suprise 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. 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 6511 Michael Steineke Room 322 Room 322 Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board! 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 6519 Joey D'Antoni Room 322 Room 322 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. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 6579 Jason Strate Room 321 Room 321 The world of databases is constantly changing. It used to be that we kept all of our servers and data locked up in big, expensive server rooms in the back of the building. Now days, you hear about data existing in this cloud-thing. So what happens when you come in on Monday morning and the latest database was deployed in the cloud. In this session, we’ll look at what it means to be a DBA with SQL Azure and how the more things change the more they stay the same. 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 6690 Sanil Mhatre Room 336 Room 336 In this session we will explore Service Broker, one of the lesser known features available since Microsoft SQL Server 2005. This technology provides a robust asynchronous programming model and can be reliably used to develop lightning fast applications that scale very well and can boost your application's throughput. We will look at a few examples of real world service broker implementations in OLTP as well as batch processing modes. We will also discuss some of the commonly used tools for troubleshooting a service broker set up, as well as few common pitfalls to avoid . 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 6694 Kevin Bullen Room 142B Room 142B 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. 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 6785 Steven Murawski Room 142B Room 142B Sick and tired of typing at a command prompt or scrolling through buffers of text output? ShowUI (an open source PowerShell Module) is a great tool for quickly and easily creating great looking UI with all the power of PowerShell behind it. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 7137 Aaron Lowe Room 322 Room 322 SQL Server Data Tools (SSDT) formerly known as Project Juneau is the next iteration of Visual Studio for Database Professionals aka DataDude. Let's chat about some of the great new features, and some of the features that aren't so great. 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 7148 Doug Lane Room 350 Room 350 Do you remember what it was like to fall in love? Wasn't it wonderful? Lately it hasn't been the same. There's no spark anymore. You've been stuck doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong, and you're even thinking about seeing other reporting products. In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven't been listening), and show you some new -- and easy -- tricks you may not have known RS can do. You'll leave knowing more about troubleshooting using the execution log, understanding how to design reports for high performance, how to deal with blank pages, and more. 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 7367 Stacia Misner Room 321 Room 321 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 is challenged by her progeny and protégé Erika Bakse to an hour of 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. Swag, trash talk, board games and SQL…who could ask for more? 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 7368 Stacia Misner Room 322 Room 322 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. 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 7722 Zach Mattson Room 142A Room 142A Why am I here? This is a question you might ask yourself each day at work. Perhaps its mundane tasks, reactive troubleshooting, or just filling out TPS reports on a Friday afternoon. This session is going to attack the mundane and show you some of the things Powershell can bring to the table for working with SQL Server. From performance monitoring to writing tests, it promises to be entirely scripts and demos compiled from real work on a large OLTP SQL environment . The theoretical will be ignored as well as any common decency towards mass produced beer. No SSIS or Powerpoint will be harmed during this presentation. 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 7797 Luke Jian Room 336 Room 336 Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 7894 Eddie Wuerch Room 322 Room 322 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. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 7904 Tracy McKibben Room 142B Room 142B Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover. 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 7914 Ed Leighton-Dick Room 350 Room 350 Normalizing a database - splitting apart tables into simpler, more focused tables - can yield concrete benefits, including manageability, scalability, and space savings. The concept is a central tenet of a relational database system such as SQL Server, yet far too many database professionals are unfamiliar with it. This session will present a practical primer on normalization: what it is, why it's beneficial, how to do it, and when not to do it. 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 7939 Farouq Abukhamireh Room 336 Room 336 A demo-rich presentation of PowerPivot 2012 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 7942 Bill Fellows Room 321 Room 321 The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences. 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 7950 Ira Whiteside Room 142A Room 142A 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. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 7954 David Peterson Room 350 Room 350 Demystifying PowerPivot from the SharePoint Admin Perspective. PowerPivot can be a maddening undertaking to the SharePoint Admin. We'll walk through the basic architecture of PowerPivot within SharePoint. Then we'll setup an actual working PowerPivot and store it in SharePoint. We'll also walk through setting up the PowerPivot Refresh. Along the way David will share anecdotes, tips hints, SharePoint war stories, and the occasional movie quote. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 7978 Mark Vaillancourt Room 336 Room 336 Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 4/21/2012 1:15:00 PM 4/21/2012 2:30:00 PM 8001 Mike Donnelly Room 336 Room 336 As with most things in the IT world there is more than one way to skin the SSIS configuration cat.* I'll focus on SQL Server 2008 methods (being called Package Deployment method in SQL 2012) and show how to use 1)XML config files or 2)an environment variable or registry entry that points to a config database. I'll also give a brief overview of the new project deployment method in SQL 2012. *[No cats were skinned in the making of this presentation.] 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 8031 Norman Kelm Room 336 Room 336 The new version of SQL Server is just around the corner, so let's take a look at what's coming to SSIS. We'll cover the enhancements to deployment, reporting, development and performance. We'll also cover what's been removed. This will be based on the RC0 release of SQL Server 2012. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 8067 Erin Stellato Room 321 Room 321 The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge. 4/21/2012 4:15:00 PM 4/21/2012 5:30:00 PM 8068 Erin Stellato Room 321 Room 321 There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 8077 Steve Hughes Room 142A Room 142A As SQL Server Analysis Services becomes commonly used in various business intelligence solutions, many administrators are looking for ways to monitor and tune performance on the platform. This session will cover various monitioring techniques and tools and how to use that information to tune Analysis Services. 4/21/2012 2:45:00 PM 4/21/2012 4:00:00 PM 8079 Steve Hughes Room 142A Room 142A Window functions are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 8083 Jason Thomas Room 142A Room 142A SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them. 4/21/2012 9:30:00 AM 4/21/2012 10:45:00 AM 8122 Dave DuVarney Room 350 Room 350 In this session we will look at common elements of an ETL framework including logging, auditing and configuration. We'll dive into the new features within SSIS 2012 and how they facilitate a solid ETL framework. 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 8134 Craig Purnell Room 142B Room 142B We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them 4/21/2012 8:00:00 AM 4/21/2012 9:15:00 AM 8137 Eric Selje Room 142B Room 142B You're a database application developer who's using SQL Server now, but you're no DBA. Sure you use SQL Server Management Studio (SSMS), and maybe you're even pretty good at designing tables and executing queries. But there's a whole lot more functionality in this seemingly simple program than you may realize. In this session we'll share features in SSMS that you may have overlooked but will make your life as a developer a lot easier. 4/21/2012 11:00:00 AM 4/21/2012 12:15:00 PM 8606 SQL Saturday Team Room 142B Room 142B Sponsor Session 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8607 SQL Saturday Team Room 142A Room 142A Sponsor Session 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8608 SQL Saturday Team Room 142A Room 142A Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8608 SQL Saturday Team Room 142B Room 142B Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8608 SQL Saturday Team Room 350 Room 350 Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8608 SQL Saturday Team Room 336 Room 336 Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8608 SQL Saturday Team Room 321 Room 321 Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8608 SQL Saturday Team Room 322 Room 322 Closing Ceremonies 4/21/2012 5:30:00 PM 4/21/2012 6:00:00 PM 8609 Lunch Lunch Room 322 Room 322 Lunch 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8609 Lunch Lunch Room 321 Room 321 Lunch 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8609 Lunch Lunch Room 336 Room 336 Lunch 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8609 Lunch Lunch Room 350 Room 350 Lunch 4/21/2012 12:15:00 PM 4/21/2012 1:00:00 PM 8610 SQL Saturday Registration Room 350 Room 350 Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM 8610 SQL Saturday Registration Room 336 Room 336 Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM 8610 SQL Saturday Registration Room 321 Room 321 Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM 8610 SQL Saturday Registration Room 322 Room 322 Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM 8610 SQL Saturday Registration Room 142B Room 142B Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM 8610 SQL Saturday Registration Room 142A Room 142A Registration 4/21/2012 7:00:00 AM 4/21/2012 8:00:00 AM