SQLSaturday #54 - Salt Lake City 2010 10/23/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat54 Salt Lake City UT 84095 728 Quest Software Gold Sponsor http://www.quest.com/database-management/ http://www.quest.com/images/common/quest_logo.gif 60 170 731 SQL Server Magazine / Penton Media Inc. Silver Sponsor http://www.sqlmag.com http://www.sqlmag.com/Portals/1/Images/Subscription/SQL_ColorLogo_150x35.jpg 60 170 803 Robert Half Technology Silver Sponsor http://www.roberthalftechnology.com 60 170 805 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 718 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 750 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 802 DawaBI Bronze Sponsor http://www.DawaBI.com http://www.dawabi.com/Data/Sites/1/logos/DawaBI_Logo_DawaBI_W_Tag_1.jpg 60 170 823 Gerasus Software Personal Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 2616 Ben Miller Ben Miller has been using SQL Server since SQL 4.2 in the 90's. He has been on the Systems Engineer, Consultant, Field Guy and also spent 7 years at Microsoft both in SQL Server Support and in the DBA realm. I have used and deployed all versions of SQL Server including a new Cluster of SQL Server 2008 R2. He loves to automate and integrate using all tools from Powershell and SMO and even some C#. He is a native of Utah and has a family with his wife and 2 children and they reside in Lehi. @dbaduck http://www.linkedin.com/in/dbaduck http://dbaduck.com https://api.twitter.com/1/users/profile_image?screen_name=@dbaduck 48 48 2757 Breakfast Bagels Breakfast of bagels and coffee will be served during registration. @SqlAsylum http://www.linkedin.com/in/patwright http://www.utahsqlsaturday.com https://api.twitter.com/1/users/profile_image?screen_name=@SqlAsylum 48 48 2745 Craig Berntson Craig Berntson has been a Microsoft MVP since 1996, most recently for C# and has spoken at developer events across the US, Canada, and Europe. He is the co-author of the book “Continuous Integration in .NET” available from Manning. Craig lives Salt Lake City where he develops hospital database and analytical software for a Fortune 100 company. You can contact him at craig@craigberntson.com, through his blog at www.craigberntson.com/blog, or on Twitter, www.twtter.com/craigber. @craigber http://www.linkedin.com/in/craigber http://www.craigberntson.com https://api.twitter.com/1/users/profile_image?screen_name=@craigber 48 48 2334 Denny Cherry Denny Cherry (MCSA, MCDBA, MCTS, MCITP) is the Manager of Information Systems for Awareness Technologies in Marina del Rey, California. In this role he manages not only the production databases, but also the entire production environment including the VMware environment, SAN Storage Array, Windows Domain and all production virtual servers. Denny has been working with Microsoft technology for over 15 years starting with Windows 3.51 and was an official Windows 7 beta testers. @mrdenny http://www.linkedin.com/in/mrdenny http://www.mrdenny.com https://api.twitter.com/1/users/profile_image?screen_name=@mrdenny 48 48 2580 Jason Brimhall Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2008. He has experience in performance tuning, high transaction environments, as well as large environments. He is currently a DB Architect and an MCDBA. He is he VP of the Las Vegas User Group (SSSOLV). @sqlrnnr http://www.linkedin.com/in/dbajbrimhall http://jasonbrimhall.info https://api.twitter.com/1/users/profile_image?screen_name=@sqlrnnr 48 48 2439 Nicholas Cain Nicholas Cain (MCTS, MCITP) has been a production DBA for 10 years supporting databases from a couple of MB in size right up to the multiple TB range. He has implemented various High Availability and Disaster Recovery techniques to ensure his customers can always get to their data. @anonythemouse http://www.linkedin.com/in/niccain http://englishtosql.com https://api.twitter.com/1/users/profile_image?screen_name=@anonythemouse 48 48 2420 Pat Wright Pat Wright has worked with SQL Server for the past 10 years through 2000-2008 R2 versions of SQL Server. Specializing in Performance tuning and large scale high transaction environments. Has worked with BI and DW projects as well as Operational DBA. Named SQL MVP in 2006 and 2007. Led the SLC SQL User group fro 3 years, Co-Founder of Utah Geek events and organizer of the Utah Code camp. @SqlAsylum http://www.linkedin.com/in/patwright http://speakerrate.com/sqlasylum https://api.twitter.com/1/users/profile_image?screen_name=@SqlAsylum 48 48 2581 Randy Knight Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for one of the largest and most successful dot coms. @randy_knight http://www.linkedin.com/in/randyknight https://api.twitter.com/1/users/profile_image?screen_name=@randy_knight 48 48 2723 Scott Heffron Scott began his database engineering career helping to create and implement a Geographical Information System (GIS) for the City of Tacoma in Washington state. Scott eventually began to lead development groups in the area of mobile and web development. http://www.linkedin.com/in/ScottPHeffron http://www.CTR-SQL.com 48 48 2756 Tek Systems With more than 25 years of experience, we annually deploy 70,000 technical professionals from 90 locations throughout North America, Europe, and Asia. Our capabilities include IT and communications staff augmentation and direct placement services; managed, project-based, and outsourced applications and infrastructure services; education services; and comprehensive workforce management solutions. @SqlAsylum http://www.linkedin.com/in/patwright http://www.teksystems.com/ https://api.twitter.com/1/users/profile_image?screen_name=@SqlAsylum 48 48 2719 TJay Belt TJay Belt is a seasoned IT professional with over a decade of technical experience. Currently serving as a Senior Database Engineer with Cybersource in the Infrastructure Engineering group, TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst, and DBA. Prior to Cybersource, he worked at several software companies, working at internal customer sites in the United States and abroad. @tjaybelt http://www.linkedin.com/in/tjaybelt http://tjaybelt.blogspot.com/ https://api.twitter.com/1/users/profile_image?screen_name=@tjaybelt 48 48 2496 William Pearson Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base over the years since. Bill's background as a CPA, Internal Auditor and Management Accountant 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 http://www.databasejournal.com/article.php/1459531 https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson 48 48 2334 2334 Denny Cherry Room 200 Room 200 We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. How to determine it your SQL Server database is a good candidate for virtualization. 10/23/2010 9:00:00 AM 10/23/2010 10:00:00 AM 2335 2335 Denny Cherry Room 200 Room 200 In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations. 10/23/2010 3:30:00 PM 10/23/2010 4:30:00 PM 2336 2336 Denny Cherry Room 200 Room 200 One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server. 10/23/2010 11:30:00 AM 10/23/2010 12:30:00 PM 2420 2420 Pat Wright Room 209 Room 209 We all hear that infamous statement “My query is running slow”. In this session we’ll review queries to show you what can be done to correct poorly running queries. We’ll review the execution plans and what you should look for. We’ll discuss Set based logic vs procedural based logic. We’ll discuss Functions and their effect on performance. 10/23/2010 1:00:00 PM 10/23/2010 2:00:00 PM 2439 2439 Nicholas Cain Room 206 Room 206 What happens if your hardware fails or your data center loses power? Do you have a Disaster Recovery (DR) plan in place that you can implement quickly? Log shipping allows you to keep copies of your databases closely synced and ready to come online in an emergency. Log shipping also offers options for read-only warm standby databases to reduce load from your production servers, adding additional value to your investment. In this session we'll Log Shipping, how it works, and how it differs from its cousin, Mirroring. We'll discuss practical uses for Log Shipping and work through a demonstration to show you how you can get it up and running in your environment. 10/23/2010 1:00:00 PM 10/23/2010 2:00:00 PM 2496 2496 William Pearson Room 206 Room 206 In this session 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/23/2010 10:15:00 AM 10/23/2010 11:15:00 AM 2580 2580 Jason Brimhall Room 200 Room 200 In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster. 10/23/2010 1:00:00 PM 10/23/2010 2:00:00 PM 2581 2581 Randy Knight Room 206 Room 206 Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been. 10/23/2010 11:30:00 AM 10/23/2010 12:30:00 PM 2582 2582 Randy Knight Room 200 Room 200 In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two. 10/23/2010 2:15:00 PM 10/23/2010 3:15:00 PM 2583 2583 Randy Knight Room 206 Room 206 Over the last 3 versions of SQL Server, Microsoft has included a variety of tools which make managing and monitoring SQL Server much easier. Policy Based Management, the Management Data Warehouse, Central Management Servers, and Utility Control Points all make a DBA's job much easier, particularly if you are responsbile for a large number of instances. In this session, we will review each of these tools and how they can be implemented in an integrated fashion to provide an enterprise view of your database ecosystem. 10/23/2010 3:30:00 PM 10/23/2010 4:30:00 PM 2616 2616 Ben Miller Room 209 Room 209 Ever wondered how SQL Server can provide extra security for your database as it sits on the disk? This session will cover how to set it up, and some of the requirements to make it work. I will also discuss some of the gotchas that you must watch for when using TDE. 10/23/2010 9:00:00 AM 10/23/2010 10:00:00 AM 2677 2677 William Pearson Room 209 Room 209 Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services many-to-many scenario. 10/23/2010 2:15:00 PM 10/23/2010 3:15:00 PM 2719 2719 TJay Belt Room 206 Room 206 If you maintain a Hot/Warm/DR solution, you may need to switch between these, from time to time. Ensuring that your systems are in sync and ready to be failed over too, at a moment’s notice is imperative. Performing this task on your own time scale will assist with practicing the steps necessary inside the database, as well as outside the database. A lot of moving parts are involved in a DB Switch. Let’s discuss what you as a data professional can do to assist in this endeavor. 10/23/2010 2:15:00 PM 10/23/2010 3:15:00 PM 2720 2720 TJay Belt Room 209 Room 209 We have all needed to know what is happening in our database systems. We have often been tasked with finding poor performing queries. Maybe we are being hit with Auditing and Compliance needs. All these and many more issues can be resolved with SQL Server Profiler. Maybe with SQL Server Trace. But which one, and when? Auditing databases can be tiresome, but a good trace and supporting reports can really help out. This presentation will show you some of my own ideas, along with others' ideas on best uses for Profiler and Trace. Once armed with this knowledge, you should be able to take it back to your shops and implement systems that assist you track down these issues more easily. 10/23/2010 11:30:00 AM 10/23/2010 12:30:00 PM 2723 2723 Scott Heffron Room 209 Room 209 We have all been on a vacation. Our thoughts sometimes are to get to the rides quickly so that we can hit each one and get through the park without missing anything. This talk will be on given a list of points (Attractions) and their pairwise distances, the task is to find a shortest possible tour that visits each point (Attractions) exactly once. We will be discussing Dkjkstra's routing algorithm to solve the problem using T-SQL. 10/23/2010 10:15:00 AM 10/23/2010 11:15:00 AM 2731 2731 Nicholas Cain Room 200 Room 200 The key to being able to recover data in an emergency is to have a good backup and to know how to restore that backup to get up and running again as quickly as possible. In this session we'll talk about how to design a backup and restore strategy that's a good fit for you, including discussion around the types of backups that can be taken. We will also work through a couple of demos showing backup and restore in action. After all a backup is only good if you can restore it. 10/23/2010 10:15:00 AM 10/23/2010 11:15:00 AM 2745 2745 Craig Berntson Room 206 Room 206 LightSwitch is a new member of the Visual Studio family that is targeted to the business developer. But as a DBA, you may find great functionality from it. This session will provide a high-level overview of LightSwitch and discuss how users will access data. You will also learn useful ways to use LightSwitch in your daily work. 10/23/2010 9:00:00 AM 10/23/2010 10:00:00 AM 2756 2756 Tek Systems Room 200 Room 200 Lunch will be provided by Tek systems. 10/23/2010 12:30:00 PM 10/23/2010 1:00:00 PM 2757 2757 Breakfast Bagels Room 200 Room 200 Breakfast of bagels and coffee will be served during registration. 10/23/2010 8:30:00 AM 10/23/2010 9:00:00 AM