SQLSaturday #75 - Columbus 2011 6/11/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat75 Columbus OH 43212 1187 Quest Software Gold Sponsor http://www.quest.com/sql-server/ http://www.sqlsaturday.com/files/594f8c25-89ee-4e84-85dc-04e36bebbb8d.gif 60 170 1216 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1186 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1218 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1188 SSWUG.ORG Bronze Sponsor http://www.sswug.org http://www.sswug.org/editorial_images/SSWUG_LOGO_CLEAR.jpg 60 170 4426 Allen White Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last four years. He's President of the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx. @SQLRunr http://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_pro http://sqlblog.com/blogs/allen_white/default.aspx https://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr 48 48 4593 CBusPASS CBusPASS Lunch 48 48 3698 Craig Purnell Craig Purnell is the Database Administrator for Baker Hostetler, a large law firm based in Cleveland, Ohio. He has been working with SQL Server since 2002. He has 11 years of IT experience. Before joining Baker, Craig worked as a consultant programming custom ERP solutions for the transportation industry. He is a certified MCSE and MCITP and regularly presents at the Ohio North SQL Server user group. @CraigPurnell http://www.linkedin.com/in/craigpurnell https://api.twitter.com/1/users/profile_image?screen_name=@CraigPurnell 48 48 4443 Dave Rodabaugh Dave Rodabaugh is a Columbus-based consultant with 10 years of experience specializing in archtiecture and delivery of data warehouse/business intelligence solutions using the Microsoft SQL Server suite of products. 48 48 4249 Eddie Wuerch Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design and manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is an MCT @eddiew http://www.linkedin.com/in/eddiewuerch http://indydba.com https://api.twitter.com/1/users/profile_image?screen_name=@eddiew 48 48 4457 Erin Stellato Erin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. She has over 11 years of technology experience, and has worked with SQL Server for the last eight years. Erin works with customers to provide support for problems that involve the database and system performance. She is an active member of the SQL Server community and blogs about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability. @erinstellato http://www.LinkedIn.com/in/erinstellato http://www.erinstellato.com https://api.twitter.com/1/users/profile_image?screen_name=@erinstellato 48 48 4375 Jes Borland Jes Schultz Borland is a Database Administrator at Kimberly Clark. She holds an AAS - Programmer/Analyst degree. She has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, the PASS WIT virtual chapter, and the MADPASS chapter. She is also an avid tweeter, blogger and runner. @grrl_geek http://www.linkedin.com/pub/jes-borland/9/393/705 http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=420 https://api.twitter.com/1/users/profile_image?screen_name=@grrl_geek 48 48 3711 Kevin Boles I have been in IT since 1999 as an administrator, an analyst, an architect, a developer and, most recently, a manager for Elliott Tool Technologies LTD in Dayton OH. I have been managing and developing in SQL since Microsoft SQL Server 6.5 and have also handled applications running on Oracle, MySQL and IBM Universe. I guess you can call me a SQL addict. Fortunately, Elliott uses an ERP and other systems driven by MS SQL, and so my obsession for SQL can be quenched daily. @http://twitter.com/iriekcc http://www.linkedin.com/in/mwvisa1 https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/iriekcc 48 48 4394 Louis Davidson Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. Louis has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information visit drsql.org. @drsql http://www.linkedin.com/in/louisdavidson http://drsql.org https://api.twitter.com/1/users/profile_image?screen_name=@drsql 48 48 4406 Paul Hiles Paul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He specializes in automation, performance tuning and troubleshooting and High Availability. @PaulGHiles http://www.linkedin.com/in/paulghiles https://api.twitter.com/1/users/profile_image?screen_name=@PaulGHiles 48 48 4424 Rob Collie Rob spent 13 yrs at Microsoft in Redmond WA before relocating to beautiful Cleveland early last year. At MS, he worked primarily on Excel, designing many features of Excel 2003 and 2007. In his final act at MS, Rob joined the PowerPivot team and designed much of the PowerPivot for Excel toolset. Today, Rob is CTO at Pivotstream, the world's leading adopter of PowerPivot. He also runs PowerPivotPro.com PowerPivotFAQ.com, and consults/trains others on PowerPivot adoption. @powerpivotpro http://www.linkedin.com/in/robcollie http://powerpivotpro.com https://api.twitter.com/1/users/profile_image?screen_name=@powerpivotpro 48 48 4416 Sarah Barela Sarah Barela is the Manager of Database Services at MaximumASP. She specializes in the administration of enterprise environments with large numbers of SQL. Her latest interests lay in applying cloud technologies to SQL Server Environments. She has been a guest speaker at a number of PASS chapter meetings, SQL Server Worldwide Users Virtual Conferences, SQL Connections, SQL Saturday events and the 2007, 2009 2010 SQL PASS Summits. @sarahspace http://www.linkedin.com/profile/view?id=9178986trk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=@sarahspace 48 48 3818 William Pearson Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution. @Bill_Pearson http://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85e https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson 48 48 3698 3698 Craig Purnell Track 2 Room 2 A discussion involving the various touch points between SQL Server and AD: ADSI - loading AD user information into SQL Server for application integration; Registering SQL Server in AD for both browsing and replication; how to configure SQL Server to use Kerberos authentication; the use of service principal names on both server and client sides. 6/11/2011 3:45:00 PM 6/11/2011 4:45:00 PM 3711 3711 Kevin Cross Track 2 Room 2 For the Analytical Business User, we will explore some SQL syntax tricks and advanced techniques that will help you better take advantage of your application data. The goal of this session will be to learn how analytical functions, common table expressions and special keywords (e.g., PIVOT) can assist you in turning your data into useful business information! Furthermore, we will use Sales-based performance measure/trending style reports for our exploration of these tips... 6/11/2011 1:00:00 PM 6/11/2011 2:15:00 PM 3818 3818 William Pearson Track 1 Room 1 Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations. 6/11/2011 3:45:00 PM 6/11/2011 4:45:00 PM 3824 3824 William Pearson Track 1 Room 1 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. 6/11/2011 2:30:00 PM 6/11/2011 3:30:00 PM 4249 4249 Eddie Wuerch Track 3 Room 3 Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing! 6/11/2011 1:00:00 PM 6/11/2011 2:15:00 PM 4250 4250 Eddie Wuerch Track 4 Room 4 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 performance, including prevention, detection, and resolution of these problems. 6/11/2011 2:30:00 PM 6/11/2011 3:30:00 PM 4340 4340 Kevin Boles Track 2 Room 2 SQL Server Partitioning from A to Z We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005. 6/11/2011 2:30:00 PM 6/11/2011 3:30:00 PM 4342 4342 Kevin Boles Track 2 Room 2 Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability. 6/11/2011 10:45:00 AM 6/11/2011 12:00:00 PM 4375 4375 Jes Borland Track 1 Room 1 You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to 'wow', using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with: - Report properties such as headers, footers and backgrounds - Tablix properties such as ToolTip and NoRows - How to build and customize a matrix - How to effectively use lists, an often-overlooked feature - Adding charts to make reports visually appealing and easy to understand 6/11/2011 1:00:00 PM 6/11/2011 2:15:00 PM 4394 4394 Louis Davidson Track 2 Room 2 When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be 6/11/2011 9:00:00 AM 6/11/2011 10:15:00 AM 4406 4406 Paul Hiles Track 3 Room 3 DBA’s traditionally have a library of T-SQL scripts which they use in automating their job. PowerShell, Microsoft’s newest scripting language, can take those T-SQL scripts to the next level. PowerShell and the SMO (Server Management Objects) library allow a DBA to create scripts that will interact with the OS and SQL Server at the same time. In this session we reveal the power of automating SQL Server with PowerShell by reviewing a number of scripts that have been migrated from T-SQL to PowerShell. This session will include scripts that will backup databases, interrogate a server, and script out objects from a database. 6/11/2011 10:45:00 AM 6/11/2011 12:00:00 PM 4407 4407 Paul Hiles Track 3 Room 3 DMVs - Dynamic Management Views and Functions are the DBA’s looking glass into the internals of SQL Server. They will give a DBA a snapshot on how the database is performing and potential problem areas. In this session, we will review a number of DMVs describing the types of information that can be captures and how it might be used. This review will include index statistics, query performance, memory utilization to name a few. 6/11/2011 3:45:00 PM 6/11/2011 4:45:00 PM 4416 4416 Sarah Barela Track 4 Room 4 There is no hotter term right now than cloud computing, however, exactly what this means is a mystery to many. We will begin by defining what cloud computing is and the benefits the technology offers the DBA. You may see the benefits of the cloud, but are not comfortable trusting your sensitive data to this nebulous cloud. The goal of this session is to provide you a blueprint to design and build your own SQL Server cloud, where you can control the server availability and performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. In this session, I will show you how to use features like the resource governor, dynamic management views, policy based management and others to automate yo 6/11/2011 1:00:00 PM 6/11/2011 2:15:00 PM 4417 4417 Sarah Barela Track 3 Room 3 No matter how much we prepare, when disaster strikes we all feel a moment of panic. For some that panic quickly passes as we get down to work to fix the problem. For others the panic continues to grow as we search for a solution. Of course back up is crucial, but in this session I will provide useful real world best practices that will show how to recover from disaster and more importantly how to prepare for the inevitable. Specifically how to recover from common disaster scenarios. For example, what to do when the master database is corrupt, a drive array with half your database files fails, a hardware failure, a SQL injection attacks wipes out whole tables and many more. 6/11/2011 2:30:00 PM 6/11/2011 3:30:00 PM 4424 4424 Rob Collie Track 1 Room 1 The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :) 6/11/2011 10:45:00 AM 6/11/2011 12:00:00 PM 4426 4426 Allen White Track 3 Room 3 How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data. 6/11/2011 9:00:00 AM 6/11/2011 10:15:00 AM 4428 4428 Allen White Track 4 Room 4 We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 6/11/2011 10:45:00 AM 6/11/2011 12:00:00 PM 4434 4434 Sarah Barela Track 4 Room 4 Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks. I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores. The flip side of automation is auditing. Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control. We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office. 6/11/2011 3:45:00 PM 6/11/2011 4:45:00 PM 4443 4443 Dave Rodabaugh Track 1 Room 1 Like great grilling, great SSAS starts with fundamentals. We'll cook Rachel Ray's ingredients on the SSAS grill, showing all the basics for creating SSAS dimensions, measure groups, and performing basic calculations. Add a lettuce, tomato, mayonnaise, and you have a tasty cube! 6/11/2011 9:00:00 AM 6/11/2011 10:15:00 AM 4457 4457 Erin Stellato Track 4 Room 4 “The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Long-term collection and storage methods for data are reviewed to help you create a plan for building your own repository when you get back to the office on Monday. Tools covered include: Windows 6/11/2011 9:00:00 AM 6/11/2011 10:15:00 AM 4593 4593 CBusPASS CBusPASS Track 1 Room 1 Energizing the Next Generation - Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join four dynamic Women in Technology – Sarah Barela, Jen Myers, Erin Stellato and Jes Borland – to discuss this important and hot topic over lunch. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. 6/11/2011 12:00:00 PM 6/11/2011 1:00:00 PM 4593 4593 CBusPASS CBusPASS Track 2 Room 2 Energizing the Next Generation - Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join four dynamic Women in Technology – Sarah Barela, Jen Myers, Erin Stellato and Jes Borland – to discuss this important and hot topic over lunch. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. 6/11/2011 12:00:00 PM 6/11/2011 1:00:00 PM 4593 4593 CBusPASS CBusPASS Track 3 Room 3 Energizing the Next Generation - Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join four dynamic Women in Technology – Sarah Barela, Jen Myers, Erin Stellato and Jes Borland – to discuss this important and hot topic over lunch. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. 6/11/2011 12:00:00 PM 6/11/2011 1:00:00 PM 4593 4593 CBusPASS CBusPASS Track 4 Room 4 Energizing the Next Generation - Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join four dynamic Women in Technology – Sarah Barela, Jen Myers, Erin Stellato and Jes Borland – to discuss this important and hot topic over lunch. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. 6/11/2011 12:00:00 PM 6/11/2011 1:00:00 PM 4594 4594 CBusPASS CBusPASS Track 1 Room 1 Kickoff Event 6/11/2011 8:00:00 AM 6/11/2011 9:00:00 AM 4594 4594 CBusPASS CBusPASS Track 2 Room 2 Kickoff Event 6/11/2011 8:00:00 AM 6/11/2011 9:00:00 AM 4594 4594 CBusPASS CBusPASS Track 3 Room 3 Kickoff Event 6/11/2011 8:00:00 AM 6/11/2011 9:00:00 AM 4594 4594 CBusPASS CBusPASS Track 4 Room 4 Kickoff Event 6/11/2011 8:00:00 AM 6/11/2011 9:00:00 AM