SQLSaturday #98 - East Iowa 2011 10/1/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat98 University Capitol Centre Room 2520, University of Iowa 201 S Clinton St Iowa City IA 52240 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 1616 GoDaddy.com Platinum Sponsor - T-shirts http://www.godaddy.com/jobs http://eastiowa.sqlpass.org/Portals/55/Sponsors/godaddy_logo.jpg 60 170 1510 Modis Gold Sponsor http://www.modis.com http://www.modis.com/images/images/modis-logo.png 60 170 1598 Red Gate Software Ltd Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/archive/redgatelogo_black.jpg 60 170 1471 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_40.jpg 60 170 1559 Integrated DNA Technologies, Inc. Silver Sponsor http://www.idtdna.com https://www.beneathwater.com/MiscFiles/IDTLogo.jpg 60 170 1484 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1567 TEKsystems Bronze Sponsor http://www.teksystems.com http://www.teksystems.com/Images/layout/teksystems.gif 60 170 1569 Emergent Networks Bronze Sponsor http://www.emergentnetworks.com/ http://www.emergentnetworks.com/images/sqlsaturday/EmergentNetworks.jpg 60 170 1596 Involta Bronze Sponsor http://involta.com/ http://www.involta.com/html/images/Logo.gif 60 170 1608 Aureus Group Bronze Sponsor http://www.aureusgroup.com http://www.aureusgroup.com/design/Aureus-Group-logo.jpg 60 170 1620 Mercy Medical Center Community Jobs Only https://careers.mercycare.org/applicantnavigator http://www.mercycare.org/imgs/logo.gif 40 100 5214 William Pearson Track 1 2520D (Seminar Room) In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …” 10/1/2011 12:30:00 PM 10/1/2011 1:45:00 PM 5221 William E. Pearson III Track 4 2523 (Training Room) 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. 10/1/2011 8:30:00 AM 10/1/2011 9:45:00 AM 5224 William E. Pearson III Track 3 2520B (Conference Room) SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best. 10/1/2011 3:30:00 PM 10/1/2011 4:45:00 PM 5230 Jason Strate Track 2 2520C (Conference Room) For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery. 10/1/2011 3:30:00 PM 10/1/2011 4:45:00 PM 5234 Jason Strate Track 2 2520C (Conference Room) Without proper indexing SQL Server can be hard pressed to create efficient and performant execution plans. Dynamic Management Views (DMV) and system views provide a slew of information about indexes that can be used to analyze indexes within SQL Server. In this session we’ll go under the hood of SQL Server to look at DMVs and system views to know what indexes you have, should have, and how they feel about the way applications are treating them. 10/1/2011 12:30:00 PM 10/1/2011 1:45:00 PM 5237 Jason Strate Track 1 2520D (Seminar Room) 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. 10/1/2011 8:30:00 AM 10/1/2011 9:45:00 AM 5289 Tim Plas Track 3 2520B (Conference Room) A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features. 10/1/2011 10:00:00 AM 10/1/2011 11:15:00 AM 5395 Ross McNeely Track 4 2523 (Training Room) 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. 10/1/2011 10:00:00 AM 10/1/2011 11:15:00 AM 5396 Ross McNeely Track 2 2520C (Conference Room) Creating individual SSIS Packages for individual business-to-business data files is not only time consuming, but becomes a maintenance nightmare. This presentation will show you how to create a single SSIS package that can generate varying length and formatted text files. By utilizing stored procedures you will see how the time from specification to file delivery can be greatly reduced and simplified. Additional areas we will cover include the support tables to control file run times, creating file variables at run time, and how to report file success. 10/1/2011 2:00:00 PM 10/1/2011 3:15:00 PM 5397 Ross McNeely Track 3 2520B (Conference Room) In this session explore the use of the SQL Server spatial data types. We will see an example of the geography spatial data type used to represent data in a round-earth coordinate system. Then the geometry spatial data type which represents data in a flat coordinate system will be demonstrated. Both spatial types are CLR data types and provide a powerful way for businesses; such as; retailers to identify where their shoppers are concentrated, or for call centers to visualize the effect of top performers on others. 10/1/2011 8:30:00 AM 10/1/2011 9:45:00 AM 5509 Brian Duhn Track 4 2523 (Training Room) AAS (Asynchronous Audit Service) Looking for a simple audit service? Look no further! With AAS you can easily identify who did what, when, and from where! 10/1/2011 12:30:00 PM 10/1/2011 1:45:00 PM 5517 Norman Kelm Track 1 2520D (Seminar Room) Everyday more DBAs and SQL developers are given responsibility for ETL development. They have a strong SQL background with little or no .Net language programming experience. As they progress with SSIS, they can come up against perceived limitations in the capabilities of SSIS using only the built-in tasks. What they may not realize is the extensibility available to SSIS via the Script Task. This presentation will provide them with the tools they need to move beyond that perceived limitation. 10/1/2011 3:30:00 PM 10/1/2011 4:45:00 PM 5522 Steven Murawski Track 4 2523 (Training Room) 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. 10/1/2011 3:30:00 PM 10/1/2011 4:45:00 PM 5538 Ted Krueger Track 2 2520C (Conference Room) As a seasoned DBA, we often forget the basics of query tuning may be an area others haven’t been introduced to. Tuning can be a mystery for developers and DBAs that are starting out with SQL Server. Each operation and its cost can lead to lengthy research escapades, determining if the work is even worth the time to attempt a change in the overall execution plan. This session is going to discuss the basics of tuning; however, we can't end there. The second half of the session, the discussion portion, will focus on the key operations in the execution plan. The overall goal of the session is to take away knowledge on how to start with a query and use execution plans to refine it and turn it into a finely tuned process. 10/1/2011 10:00:00 AM 10/1/2011 11:15:00 AM 5539 Ted Krueger Track 1 2520D (Seminar Room) Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks! 10/1/2011 2:00:00 PM 10/1/2011 3:15:00 PM 5545 Aaron Lowe Track 3 2520B (Conference Room) Database development is unique due to its dependency on data. We can't just throw away old data and not allow for backward compatibility. However until recently the toolset for managing database code and allowing for things such as refactoring, code analysis and unit testing has been sorely lacking. Within the last 5 years the tools have matured to allow for structured database development. Let's take a look at Visual Studio Database Professional to see how. 10/1/2011 12:30:00 PM 10/1/2011 1:45:00 PM 5546 Aaron Lowe Track 4 2523 (Training Room) As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let's discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night. 10/1/2011 2:00:00 PM 10/1/2011 3:15:00 PM 5623 Michael Steineke Track 2 2520C (Conference Room) Overview of new features and enhancements in SQL Server ‘Denali’ to help support High Availability and Disaster Recovery. Breakdown of AlwaysOn Feature set, and design considerations. What are Availability Groups, and Readable Secondary’s, and how do they work. Multi-Subnet SQL clustering, what no more stretched VLAN? Including demo’s and working systems to review configurations. 10/1/2011 8:30:00 AM 10/1/2011 9:45:00 AM 5624 Michael Steineke Track 3 2520B (Conference Room) 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! 10/1/2011 2:00:00 PM 10/1/2011 3:15:00 PM 5655 Bill Preachuk Track 1 2520D (Seminar Room) Having consistent, regular, verified backups are only a starting point. When failures happen - and they will happen - can you recover your database? In this presentation we will dive into the mechanics of database restores and discuss how choices made previously in database/server/backup design can have profound effects on how (and what) you can recover. We will also discuss spectacular ways to fail miserably... all in the hopes of preventing those same failures in the future. 10/1/2011 10:00:00 AM 10/1/2011 11:15:00 AM 5721 I-380 PASS Breakout 2520D (Seminar Room) Check-in and opening remarks 10/1/2011 8:00:00 AM 10/1/2011 8:30:00 AM 5722 I-380 PASS Breakout 2520D (Seminar Room) Closing remarks and door prize giveaway 10/1/2011 4:45:00 PM 10/1/2011 5:00:00 PM 5723 I-380 PASS Breakout 2520D (Seminar Room) Enjoy lunch while networking! Areas will be designated for discussion about various SQL Server topics. Pick an area and sit in on the conversation. Participants may visit as many discussion areas as they like during the allotted time. 10/1/2011 11:30:00 AM 10/1/2011 12:30:00 PM