SQLSaturday #89 - Atlanta 2011 9/17/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat89 Georgia State University - Alpharetta location 3775 Brookside Pkwy Alpharetta GA 30022 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 1292 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1294 Red Gate Software Gold Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1321 WhereScape USA, Inc. Gold Sponsor http://www.wherescape.com http://upload.wikimedia.org/wikipedia/commons/e/ed/Wherescape.png 60 170 1348 Idera Gold Sponsor http://www.idera.com https://lh5.googleusercontent.com/-mdYL_onU4JM/Thszg1z-NxI/AAAAAAAAAHY/4FnYYlMhECc/s144/Idera.png 60 170 1361 EMC Gold Sponsor http://www.emc.com http://cloudcentrics.com/wp-content/uploads/2011/03/emc_logo.jpg 60 170 1449 Tek Systems Gold Sponsor http://www.teksystems.com http://www.sqlsaturday.com/files/1546bee6-3031-4b7b-b5da-20ce9cc22958.jpg 60 170 1288 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1314 Intellinet Silver Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 1319 Pragmatic Works Silver Sponsor http://pragmaticworks.com/ http://sqlchicken.com/wp-content/uploads/2010/12/logo498864_lg.jpg 60 170 1549 SQL Sentry, Inc. Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1503 SSWUG.ORG Bronze Sponsor http://www.sswug.org http://www.sswug.org/editorial_images/SSWUG_LOGO_CLEAR.jpg 60 170 1554 Telerik Bronze Sponsor http://www.telerik.com http://clicdata.files.wordpress.com/2011/06/telerik_logo_rgb_photoshop.jpg 60 170 1562 SQLskills.com Bronze Sponsor http://www.SQLskills.com http://www.sqlskills.com/SQLskillsLogo.jpg 60 170 1516 SQL Solutions Group Personal Sponsor http://www.sqlsolutionsgroup.com http://www.sqlsolutionsgroup.com/images/logo2.jpg 40 100 1278 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1279 Tim Radney Blog Sponsor http://www.timradney.com http://tradney.files.wordpress.com/2011/06/me2.jpg 40 100 1280 ShannonLowder.com Blog Sponsor http://ShannonLowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1282 Melissa Coates Blog Sponsor http://www.sqlchick.com http://sqlchick.com/storage/SQLChick_Logo.png 40 100 1285 Stuart R Ainsworth Blog Sponsor http://www.codegumbo.com http://codegumbo.com/images/codegumbo_banner.jpg 40 100 1336 SQL Joe Blog Sponsor http://www.sqljoe.com http://sqljoe.files.wordpress.com/2010/04/sqlsjoeheader3.jpg 40 100 4667 Robert Volk Development Room 7 Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance! 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 4690 William E. Pearson III BI Track 2 Room 2 Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to some 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, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services 'many-to-many' dimension scenario. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 4695 Jon Boulineau Powershell Room 5 Powershell is becoming an essential skill for any IT professional working with Microsoft products. Many of the concepts upon which Powershell is built are new to non-developers . In this session, we learn the skills necessary to get started. You will learn the object-oriented concepts that are essential to understanding Powershell and see some examples of how Powershell can change the way you think about your job. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 4697 Jen Underwood BI Track 1 Room 1 This session will cover SSIS, SSRS, SSAS, PowerPivot, BISM and Crescent. We will walk through high level overviews of new features in SSIS, SSRS, SSAS and take a deeper look at improvements in PowerPivot, the new Business Intelligence Semantic Model and new Project Crescent for ad-hoc reporting. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 4698 Jen Underwood BI Track 1 Room 1 This session will cover what you need to know about PowerPivot, how to build PowerPivot models from a variety of data sources, common challenges and basic DAX. We will also look at some often overlooked creative implementations of PowerPivot to expedite BI application delivery and expand Self-Service BI. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 4717 Tim Radney Professional Dev Room 6 TEMPDB is just for temporary data right? It is installed by default and gets recreated each time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 4727 Nathan Mourfield Development Room 7 This session covers a basic overview of SSAS in 08. The session will go over how cube and dimensions are build and developed, basic data mining, and the other information SQL Devs and Data Analysts need to know moving into Analysis Services. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 4748 Stuart Ainsworth Development Room 7 The xml datatype in SQL Server expands the potential of the relational platform to store increasingly complex forms of data, but without the use of the appropriate query language, much of that potential can remain unused. This session will cover the basics of SQL Server XQuery and FLWOR; the assumption is that attendees will have some basic exposure to XML (including the use of XML in SQL Server). Learn how to 'run queries within a query', and how to extract XML data into a tabular format. Coverage will include the five basic XML methods (.exist(), .value(), .query(), .nodes(), and .modify()) and FLWOR (for, let, where, order by, and return). 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 4764 Nicholas Cain Powershell Room 5 PowerShell is a very powerful management tool and you can spend hours writing magical scripts to provide automation for frequently run tasks. Often forgotten is the PowerShell profile, a place you can add your own functions which can provide you lightning fast access to information. In this session we'll talk about the power a profile puts at your fingertips. I will also demo (and share) several PowerShell functions that I use frequently for common tasks like checking database backups and disk space. I'll show you my PowerShell profile if you show me yours. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 4765 Nicholas Cain Powershell Room 5 As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I'll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We'll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed. 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 4770 Sarah Barela DBA Track 1 Room 3 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. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 4823 Sven Aelterman Development Room 7 Are you faced with the dilemma of where to store large files that are related to your structured, relational data? In this session, FILESTREAM will be discussed in details, with lots of demos, so you'll know when to use this SQL Server 2008 and up feature to handle BLOB storage. The demos will show how to enable FILESTREAM at the instance level, database level and table level; and how to leverage the features for optimum performance in your applications. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 4879 Geoff Hiten DBA Track 2 Room 4 AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 4881 Scott Russell DBA Track 1 Room 3 This session will describe an ETL-based approach to loading Active Directory (AD) content into a SQL Server DB. This DB can then be used to provide program-based or interactive access to AD content using familiar SQL syntax without the complexity or limitations of using special AD tools or LDAP queries to directly access AD content. AD content includes users, computers, groups, and group memberships. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 4895 Brian Moran Professional Dev Room 6 Full title is 'Are you a Linchpin? Career management lessons to help you become indispensible.' Are consultants better that people who work for ‘regular’ companies? Perhaps it is the other way around? No classification of IT worker is inherently smarter or better than another. However, I believe that many successful SQL Server professionals share similar characteristics that shape their careers and success. Of course they have interesting differences as well! This session explores 20 years of my ideas, learning, and research on this topic. The session also shares the experience of several top SQL Server professions as they share personal thoughts on what has made them indispensible. This is a panel session. 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 4899 Brian Moran Professional Dev Room 6 Leadership Coaching: A repeatable methodology for Leadership Development. Leadership coaching is the practice of using relational influence, the people kind, not the database kind ?, to develop and empower adult leaders. Coaching embraces a set of structured techniques designed to help you make other people more effective in reaching their goals and developing as leaders and is very different from mentoring or counseling and is being embraced more and more by management guru’s around the world. Do you have a systematic approach for developing yourself as a leader? Do you have a systematic approach for investing in and equipping the next generation... (I will edit this to fit...) 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 4911 Mike Walsh DBA Track 3 Room 8 What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; It’s the same for us. Even if a freak accident occurs, training and preparation can make all the difference; it's the same for us. In this session we’ll discuss as a group some real-life disasters and see what skills, attitudes and thought processes we can take back to our day jobs. We'll look at a handful of aviation disasters and look for patterns of behavior at fault or that saved the day. Hopefully you'll leave looking for those behaviors in yourself and on your project teams. Fasten your seatbelt! 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 4919 Grant Fritchey DBA Track 2 Room 4 Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we'll gain an understanding of what exactly parameter sniffing is and why it's usually so helpful. Then, we'll explore how parameter sniffing can wrong and I'll show you seven different ways you can deal with it when it does. You'll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment. 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 4935 Evan Basalik DBA Track 3 Room 8 Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and general connectivity. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 4942 Adam Jorgensen BI Track 1 Room 1 Come get hands on with Analysis Services and learn how to quickly build a cube in your environment as well as best practices from the SSAS Maestro program co-course director. Adam will get you building cubes right in this session! Come check it out and get to ask your questions! 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 4957 Mark Tabladillo Professional Dev Room 6 Developing a social media platform is a challenge for high-end professionals and consultants. The presenter has successfully leveraged web media to establish a blog (http://marktab.net), cofound an online journal (http://solidq.com/sqj), become a paid video presenter, and secure a spot at Microsoft TechEd 2011. This presentation introduces the basic elements for 2011 of a successful web strategy, starting with discovering your own best personal focus given current market needs. The presenter includes experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 4958 Alex Tocitu DBA Track 3 Room 8 How do you know your scripts or T-SQL code ran successfully and accomplished what it was ment to? This talk will discuss a generic framework for testing/logging results from database scripts, stored procedures, and other T-SQL coded objects. 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 4991 Teo Lachev BI Track 2 Room 2 SQL Server 2011 'Denali' unveils the Business Intelligence Semantic Model (BISM) that will support the full spectrum of BI needs for personal, team, and organizational business intelligence. This session introduces you to BISM and focuses on its tabular capabilities. My goal is bring you up to speed on the new developments in Analysis Services and PowerPivot for the 'Denali' release. 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 5021 John Welch BI Track 2 Room 2 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 or packages that adhere to a pattern, 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. 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 5031 Dean Richards DBA Track 3 Room 8 SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 5071 Jim Christopher Powershell Room 5 StudioShell is an open-source deeply integrated PowerShell host available inside of Visual Studio 2010. It’s goal is to fundamentally change the way you interact with your IDE and your code. It exposes many of Visual Studio’s extensibility points in a simple and consistent way, and it makes the Visual Studio programmability features interactive and discoverable. What an add-in does in a compiled binary, StudioShell can accomplish with a one-liner. Come see the possibilities in a session of practical demonstrations given by the author. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 5073 Jim Christopher Powershell Room 5 Let's face it - I'm no SQL guy, and you're no .NET developer. But that just means there is a ton we can learn from each other. Some spend an hour hearing and sharing practical, time-saving PowerShell hacks you can start using today. Start taking your one-liners and turn it into a crisp, clean, reusable PowerShell! 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 5079 Melissa Coates BI Track 2 Room 2 The Microsoft BI stack has a few choices for visualization. We will explore options, flexibility, limitations, and ease of use for creating dashboards scorecards with: * PerformancePoint Services 2010 * Reporting Services 2008 R2 * SharePoint Server 2010 * PowerPivot * Crescent. This session will be a fun one! We will compare and contrast options available in each tool, such as: charts, gauges, maps, indicators, sparklines, data bars, and decomposition trees. The goal is to determine when you might choose one tool in the Microsoft BI stack versus another. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 5081 Eric Wisdahl BI Track 1 Room 1 This session will examine the different types of data flow components, execution trees, data buffers, performance metrics and logging mechanisms. In determining how the buffers are built and used, the developer will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The developer will further learn how to capture performance metrics to identifiably track these impacts. Finally, the session will take a look at the controls and effects of parallel package and parallel task execution. 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 5099 Adam Machanic DBA Track 1 Room 3 The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within is the data you need to help solve virtually any performance problem, quickly debug issues, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions--information gleaned from heavy use of the objects in a number of environments. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. Attend this session and you will be the master of your SQL Server instance. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 5101 Louis Davidson Development Room 7 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 will be discussed 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 5104 Adam Machanic DBA Track 1 Room 3 Over the past five years, multi-core processors have made the jump from semi-obscure to commonplace in the data center. Today we regularly expect to see 16, 32, or 64 cores in even our lower-end servers. Are you getting everything you can out of the wealth of processing power at your disposal? Attend this session to take a detailed look at how and why SQL Server processes queries in parallel, as well as methods for controlling parallel processing via configuration options, the Resource Governor, and query-level hints. This session will enable you to immediately evaluate, understand, and improve the state of parallel processing on your servers. . 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 5105 Kevin Boles DBA Track 1 Room 3 Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine. 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 5120 Aaron Nelson Powershell Room 5 In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You'll see a battle between two database professionals (Aaron Nelson and Julie Smith), attempting to load a database in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the ETL Smackdown 9/17/2011 11:45:00 AM 9/17/2011 12:45:00 PM 5156 Eric Melcher BI Track 1 Room 1 This session will provide attendees with an overview of how Master Data Management solutions can be delivered using SQL Server Master Data Services. This will include a brief overview of MDM concepts, a walkthrough of the Master Data Services capabilities, and a demonstration of the product. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 5164 Kevin Kline DBA Track 3 Room 8 Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen? 9/17/2011 10:15:00 AM 9/17/2011 11:30:00 AM 5198 Bobby Dimmick Professional Dev Room 6 … in which our young hero tells his story of going from lonely developer to community leader. A discussion of discovery, education, and adventure. Learn how to grow beyond a cube dweller to become someone recognized in the community as an enabler and educator. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 5209 Mary Ledbetter BI Track 1 Room 1 Studies show that in most cases the Query Tool is not the problem! Today's challenge is Data, and no one can help manage your data better than WhereScape RED. WhereScape and Microsoft have partnered for the newly announced Microsoft SQL Server Fast Track Data Warehouse 3.0. WhereScape RED provides Native support for Microsoft SSIS, SSAS, and T/SQL for the agile production of enterprise-level data integration and transformations solutions. WhereScape RED is an IDE for managing data warehouses, marts, stores and vaults. RED is the only product that supports the entire data management life cycle by integrating source system exploration, schema design, metadata management, scheduling and enhancement into a single integrated design. 9/17/2011 11:45:00 AM 9/17/2011 12:45:00 PM 5210 Dean Richards DBA Track 1 Room 3 Come learn how Ignite for SQL Server is the one SQL Server performance monitoring solution that identifies, analyzes and resolves all of the performance problems affecting applications and users depending on a Microsoft SQL Server instance. Ignite doesn't just show health metrics, it correlates the most important performance data to build a complete picture of SQL Server performance for the DBA, Developer, and DBA manager. Response time, queries, sessions, and server resources, are all analyzed by Ignite Performance Intelligence to show both historical and real-time conditions affecting database applications. 9/17/2011 11:45:00 AM 9/17/2011 12:45:00 PM 5211 Bob Ward DBA Track 2 Room 4 Have you ever encountered a wait type with SQL Server but can’t find any information on what it means? Perhaps you have thought the meaning of these is hidden away somewhere in a dark closet? In this talk, we will explore the internals of wait types within the SQL Server Engine. Rather than cover some of the more common wait types such as lock and latches, we will explore the more advanced and obscure wait types that may be surfaced by the engine. The ones you can’t find much information about. 9/17/2011 1:00:00 PM 9/17/2011 2:15:00 PM 5212 Bob Ward DBA Track 2 Room 4 The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have ever monitored a SQL Server closely, you know you can’t escape latches. Come to this advanced session exploring the internals of how SQL Server uses the concept of latches for synchronization of key internal data structures. This talk is a very advanced “500” session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests 9/17/2011 3:45:00 PM 9/17/2011 4:45:00 PM 5213 Bob Ward DBA Track 2 Room 4 This session will wrap up Bob's first session and lead into his second. 9/17/2011 2:30:00 PM 9/17/2011 3:30:00 PM 5483 Audrey Hammonds BI Track 2 Room 2 You know the concepts of normalization, logical modeling, and physical implementation. But what happens when you’ve inherited a less than perfect data model? You need to renovate while keeping the production system humming. In this session, we’ll talk about how to evaluate an existing model, how to approach design when your system is up and running and how to incrementally apply database design changes in a fast-moving environment. Every database, even ones consisting of a collection of flat, unrelated tables, has the potential to become a beautiful database. All you need is an eye for design and a strategy to get you there. 9/17/2011 9:00:00 AM 9/17/2011 10:00:00 AM 5775 Dilip Tailor DBA Track 3 Room 8 EMC will be presenting it's overall EMC strategy in conjunction with Microsoft technology solutions including SQL, Sharepoint and Exchange with an emphasis on best practices around Microsoft SQL. EMC has a long history of partnership with Microsoft in terms of integration and solution deployment and EMC will walk through the partnership synergies and it's product portfolio innovation around SQL Server including storage, backup and recovery, virtualization and security. 9/17/2011 11:45:00 AM 9/17/2011 12:45:00 PM