SQLSaturday #67 - Chicago 2011 3/26/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat67 Chicago IL 60101 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 888 DeVry University You Rock! http://www.devry.edu/ http://www.dal.devry.edu/Images/hdr_ul_2logos.gif 60 170 911 Red Gate Software You Rock! http://www.red-gate.com http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1031 SQL Sentry You Rock! http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1096 Quest Software You Rock! http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 1151 Embarcadero Tehcnologies You Rock! http://www.embarcadero.com http://edn.embarcadero.com/article/images/40882/thumb02000008.jpg 60 170 878 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/images/resized%20-%20idera_logo.png 60 170 1043 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1053 Microsoft Gold Sponsor http://www.microsoft.com http://www.microsoft.com/presspass/images/gallery/logos/web/mslogo-2.jpg 60 170 1014 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1070 Perpetual Technologies, Inc. Silver Sponsor http://www.PTI.net http://pti.net/logo 60 170 1097 Magenic Silver Sponsor http://magenic.com/ http://magenic.com/Portals/0/Magenic_esignature_logo.gif 60 170 1122 SQLskills.com Silver Sponsor http://www.SQLskills.com http://www.sqlskills.com/SQLskillsLogo.jpg 60 170 893 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1002 Wrox Bronze Sponsor http://www.wrox.com/WileyCDA/ http://www.sqlsaturday.com/files/81e45e31-9533-4473-9b69-ee734a5a7bf7.png 60 170 1121 Penton Media Inc Bronze Sponsor http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/%7Bc4e191cc-885e-42e4-bdaa-f39a5976393e%7D_PromoInt_SQL_LOGO_BW_192x45.jpg 60 170 1123 Morgan Kaufmann Bronze Sponsor http://www.mkp.com http://ww1.prweb.com/prfiles/2010/10/07/3321694/gI_MorganKaufmannlogo.JPG.jpg 60 170 1159 Apress Bronze Sponsor http://www.apress.com/ http://www.sqlsaturday.com/files/3425728c-3d8f-4207-a41a-93c484f6dda1.png 60 170 926 Gerasus Software Friend Of http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 1004 O'Reilly Media Friend Of http://ug.oreilly.com/ http://www.sqlsaturday.com/files/cf10f8e2-faf1-4402-901e-924d40b898f3.gif 40 100 889 Noel McKinney SQL Blogger http://noelmckinney.com/ http://noelmckinney.com/wp-content/uploads/2010/09/Noel-seated-compressed-NOTNULL-e1284844743579.jpg 40 100 901 Matt Velic SQL Blogger http://mattvelic.com http://mattvelic.com/wp-content/uploads/2010/12/MV-SQLSat-Logo.jpg 40 100 945 StrateSQL SQL Blogger http://www.jasonstrate.com http://jasonstrate.com/images/StrateSQLProfile.jpg 40 100 973 Brent Ozar SQL Blogger http://www.brentozar.com http://i.brentozar.com/brent-ozar-sqlsaturday.png 40 100 974 Silverwing Technologies, Inc. SQL Blogger http://www.programmersedge.com http://www.programmersedge.com/images/ProgrammersEdgeLogoSmall.png 40 100 977 sqlmashup SQL Blogger http://www.sqlmashup.com http://avatars.netvibes.com/248750635/64 40 100 1116 Aaron Bertrand SQL Blogger http://sqlblog.com/blogs/aaron_bertrand/ http://sqlblog.com/files/folders/33473/download.aspx 40 100 1133 SQLskills.com SQL Blogger http://www.SQLskills.com http://www.SQLskills.com/KimberlyLTrippColorBanner.jpg 40 100 1137 contextQ SQL Blogger http://contextQ.com http://contextq.com/Logos/contextQ_logo_v3.4.1.png 40 100 1149 Erin Stellato SQL Blogger http://www.erinstellato.com http://sonetring.net/images/erin.jpg 40 100 1106 Jes Schultz Borland SQL Blogger http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=420 http://a1.twimg.com/profile_images/1180273073/Twitter122010.jpg 40 100 1107 SQLRockstar SQL Blogger http://thomaslarock.com http://thomaslarock.com/wp-content/themes/tma/images/sql_rockstar_v7.jpg 40 100 1109 Karla Landrum SQL Blogger http://www.karlalandrum.wordpress.com http://www.gravatar.com/userimage/16784380/e57ef8681076ec40665d57ebecf2a1fc?size=20048 40 100 1110 Rodney Landrum SQL Blogger http://www.simple-talk.com/community/blogs/rodney/ http://www.gravatar.com/userimage/16784380/8cee550e094a6a1342f636f901112254?size=20048 40 100 1112 The Wendy Verse SQL Blogger http://wendyverse.blogspot.com http://3.bp.blogspot.com/_Ve9-butiy-A/Sdpz6AO2W1I/AAAAAAAAAC4/xq9MMSBt3bo/S220-h/08_08_Grandkids_56.jpg 40 100 1113 IndyDBA.com SQL Blogger http://IndyDBA.com http://a0.twimg.com/profile_images/1218539900/BioPic-Square_bigger.jpg 40 100 1023 SQLvariant SQL Blogger http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1064 Bob Pusateri SQL Blogger http://www.bobpusateri.com http://img.bobpusateri.com/bt/OJLogoSmall.jpg 40 100 1080 Yanni Robel SQL Blogger http://sqlscribbles.com http://sqlscribbles.com/wp-content/uploads/2010/05/Yanni.jpg 40 100 1098 Aaron Lowe SQL Blogger http://www.aaronlowe.net/ http://a3.twimg.com/profile_images/53466630/Aaron_bigger.jpg 40 100 1104 Doug Lane SQL Blogger http://www.douglane.net http://www.gravatar.com/avatar/7c3df04d5c5f3471d86847591f0e2e31.png 40 100 1105 InfoAdvisors SQL Blogger http://blog.infoadvisors.com http://blog.infoadvisors.com/wordpress/wp-content/uploads/2011/03/BlogLogoBanner.jpg 40 100 1190 Embarcadero Tehcnologies 'Gold' to 'You Rock!' Sponsorship Upgrade http://www.embarcadero.com http://edn.embarcadero.com/article/images/40882/thumb02000008.jpg 60 170 3064 Norman Kelm Room 117 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. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3081 Tim Ford Room 217 Learn how you can query Dynamic Management Views (and Functions) to troubleshoot performance issues, tune troublesome queries, learn the innermost secrets of your SQL Server instances, and capacity plan among other things. Tim pulls from his new project: The Periodic Table of DMVs as well as his sessions on DMVs at SQL Cruise to examine and discuss a wide variety of DMVs (and DMFs). 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3085 Brent Ozar Room 116 It’s hard to find good information about SQL Server storage. Should you put data and log files on different drives when they’re on a SAN? How do you know when to add more data files? Is there an advantage to using multiple filegroups? Brent’s a former SAN administrator and wrote the storage chapter of Professional SQL Server 2008 Internals and Troubleshooting. He’s got the answers you’re looking for, and he’ll help demystify what SQL Server’s doing inside the black box. Attendees will learn why you shouldn’t add files to an existing filegroup, how to get faster performance from TempDB, and how to check your file performance using DMVs. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3087 Bob Pusateri Room 216 What does the Bulk Logged recovery model really mean anyway? Backup and Recovery are two of the most crucial functions a DBA can perform, however they’re also some of the least understood. We’ll bust some myths and take a good look at how backups restores really work including a comparison of recovery models, important facts about the transaction log, and tips tricks for enhancing performance. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3095 Eddie Wuerch Room 216 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! 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3097 Ross LoForte Room 217 SQL Server 2005 and SQL Server 2008 offers many technologies that can be used to minimize downtime and maximize data protection for the business to ensure smooth operation, continuous access to business critical data, and meet availability levels according to various service level agreements. This presentation will start with an overview of the high availability and disaster recovery offered and then describe five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications. 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3100 Thomas LaRock Room 215 Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday. 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3104 Ted Krueger Room 218 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! 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3161 Mark Vaillancourt Room 118 Report Models can be a great way to empower your end users to create their own reports through a drag and drop tool. This presentation will discuss how to create, maintain and secure SSRS Report Models. Although the focus is on implementation, we will use Report Builder 3.0 to demonstrate report model consumption. We will also cover some tips and tricks learned through real-world experience implementing and supporting report models for clients. 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3162 Aaron Bertrand Room 216 This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Several demos and no marketing. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3172 Haidong 'Alex' Ji Room 117 BI data store mostly serves scan-centric operations. As such, it is important to minimize fragmentation during data loading process. I will demonstrate ways to look at fragmentation and how to best avoid them while achieving fast data loading process. BCP, partitions, partition switch, and verifications will be discussed and demonstrated in having data tightly packed with 0 to minimal fragmentation. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3180 Christina Leo Room 218 Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a chef analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3183 Nicholas Cain Room 214 Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We'll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I'll show you my Powershell profile if you show me yours. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3186 Hope Foley Room 216 There are many IT pros who know all the snazzy tools to create fantastic reports. The users who know the data inside and out may not know those tools, but odds are that they know Excel. Microsoft has released PowerPivot which seems to bridge the gap between the two worlds. These power users can now create their own fantastic reports within PowerPivot. We will explore what PowerPivot is and how can use it to create a self-service business intelligence solution. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3193 Aaron Lowe Room 218 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. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3195 Dave Paulson Room 118 This presentation will highlight case studies about some of the largest SQL Server customers who are pushing the envelope with SQL Server in various ways. This includes scalability in Database size, Transaction throughput and Replication, etc. This presentation has been given in the past by a member of the SQL Customer Advisory Team (SQLCAT.com), Kevin Cox, who has worked with some of these large customers. This session will effectively illustrate the capabilities of SQL Server, maybe beyond the limits you thought possible. This will give you confidence in recommending the use of SQL Server for your most demanding workloads within your organization. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3267 David Levy Room 118 As IT Professionals we inevitably will see situations where everything goes wrong. At times we are somewhat lucky and this just means diminished functionality or a slow system. Other times our organization is temporarily out of business. Regardless of the scope of the issue, how we react can have a direct impact on how quickly things are returned to normal. This session will cover how to communicate issues, including what to say, who to say it to and when to say it. Part of managing communication is to get everyone into a room, forcing them to talk, so time will be spent on designing an effective war room. The session will also cover how by setting out to prove that an issue is ours we are able to more quickly get at a root cause. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3299 Jason Strate Room 215 There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3300 James Volkmann Room 118 Creating Matrix Reports, Bar Charts and Maps with Report Builder 3.0. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3304 Michelle Ufford Room 117 Most DBA's have heard of indexes, but not everyone understands how they work. In this in-depth session, Michelle will cover the internals of indexes, including index filtering and partitioning. She'll compare the B-trees of different index types, explain fragmentation, and use undocumented commands to show you what an actual index page looks like. Attendees will walk away with a much better understanding of indexes, which is helpful when designing and tuning databases. If you've ever wondered just *what* goes on in an index, this is the session for you! 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3374 Grant Fritchey Room 217 This session, part of a full-day session which will be presented at SQL Rally, will introduce the query optimizer. Discussion will center around how the optimizer works. We'll explore the importance of statistics to the optimizer and how indexes affect the choices the optimizer makes. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3436 Jes Borland Room 218 SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have! 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3482 Allen White Room 214 The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action. 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3503 Kevin Boles Room 217 The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3507 Herve Roggero Room 116 In this session we will dive in the world of Azure, the Cloud Computing offering from Microsoft. We will take a look at SQL Azure from an application design perspective including design options, scalability and performance. If you are wondering what SQL Azure can do for you, how to best leverage it from a performance and scalability standpoint, and it compares to SQL Server, then this session is for you! 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3541 Arie Jones Room 214 Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3555 Karen Lopez Room 215 A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3684 Allan Hirt Room 214 While you can see how to deploy a failover cluster in 60 minutes, what a DBA really needs is a solid foundation of Windows to truly be able to understand that implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA focus. Using Windows Server 2008 R2, some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, using the new cluster logs for troubleshooting, and more. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3694 Craig Purnell Room 118 A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone H.A. tool for over 5 years. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3705 Jose Chinchilla Room 215 In this session I will showcase how to create custom hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will also learn how to optimize SSAS hierarchies by specifying the right cardinality option, relationship type, and member uniquenes properties. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 3773 Jeff Mlakar Room 116 The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn! 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3793 Erin Stellato Room 116 “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. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3835 Brian Davis Room 214 Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 3924 John Welch Room 117 SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options. 3/26/2011 9:15:00 AM 3/26/2011 10:30:00 AM 3941 Doug Lane Room 117 Do you have the need for data-driven subscriptions, but no room in the budget to buy Enterprise Edition? If so, this session is for you. We'll cover how you can deliver reports, by both file share and e-mail, on a limitless number of schedules, all using one simple package. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3944 Randy Knight Room 215 The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server. 3/26/2011 10:45:00 AM 3/26/2011 12:00:00 PM 3954 Jeremiah Peschka Room 216 Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 3967 David Stein Room 217 Building your first Data Warehouse is a long, and often difficult process. How can you get your boss to approve a Data Warehouse project? What’s the best way to explain dimensional modeling and the benefits of a Data Warehouse to a business person? What are the best/most cost effective ways of learning it? What kind of materials, hardware, software, etc do you need? What’s the best way to build a proof of concept that will impress your boss, as rapidly as possible? Come to this presentation, and I’ll answer all of these questions plus the most important question of all. “Is this good for the company?” Absolutely. 3/26/2011 2:30:00 PM 3/26/2011 3:45:00 PM 4022 SQL Saturday Room 116 Starting the day with some words from our You Rock sponsor and host, DeVry. 3/26/2011 8:30:00 AM 3/26/2011 9:00:00 AM 4023 SQL Saturday Room 116 Lunch 3/26/2011 12:00:00 PM 3/26/2011 12:45:00 PM 4024 SQL Saturday Room 116 Take this time to ask all the experts any questions you have. This will also be our raffle time so make sure you attend for your chance to win some awesome prizes from our awesome sponsors 3/26/2011 5:30:00 PM 3/26/2011 6:00:00 PM 4025 Red Gate Room 218 Red Gate You Rock Sponsor Session. Come hear about some awesome new products from our You Rock sponsor. 3/26/2011 1:00:00 PM 3/26/2011 2:15:00 PM 4026 Quest Software Room 116 Quest You Rock Sponsor Session. Come hear about some awesome new products from our You Rock sponsor. 3/26/2011 4:00:00 PM 3/26/2011 5:15:00 PM 4027 Women in Technology Room 216 Come join several respected Women in Technology (WIT) at lunch. 3/26/2011 12:00:00 PM 3/26/2011 12:45:00 PM 4120 SQL Sentry Room 215 Learn what SQL Sentry has to offer you! 3/26/2011 12:00:00 PM 3/26/2011 12:45:00 PM