SQLSaturday #130 - Jacksonville 2012 4/28/2012 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat130 1 UNF Drive Building 50 Jacksonville FL 32224 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 1795 Pragmatic Works Gold Sponsor http://www.pragmaticworks.com http://www.pragmaticworks.com/images/l4.gif 60 170 1864 American Computer Technolog and Alluvion Staffing Gold Sponsor http://www.alluvionstaffing.com http://www.bullhorn.com/BullhornPageContent/3676/alluvionstaffingcom_965856175.gif 60 170 1946 Quest Software Gold Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest_logo.gif 60 170 2103 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo-Idera.png 60 170 2175 SNI Technology Gold Sponsor http://www.snitechnology.com http://www.snitechnology.com/images/sni-technology-logo.gif 60 170 2220 University of North Florida College of Computing Gold Sponsor http://www.unf.edu http://pragmaticworks.com/images/UNFCollegeOfComputing.png 60 170 1820 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 2158 iMethods Inc. Silver Sponsor http://www.imethods.com http://jaxcodecamp.com/content/images/sponsor/im_logo.gif 60 170 2161 Incepture Silver Sponsor http://www.incepture.com/ http://members.myjaxchamber.com/sbaweb/images/Incepture.JPG 60 170 2205 Convergence Consulting Group Silver Sponsor http://www.ccgbi.com http://www.convergenceconsultinggroup.com/wp-content/uploads/logo.jpg 60 170 1796 Modis Bronze Sponsor http://www.modis.com/ http://www.img-svr.com/modis/email/modis-logo-170x60.jpg 60 170 1803 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://cozyroc.com/sites/default/files/images/logo.gif 60 170 1825 StrateSQL Blog Sponsor http://www.jasonstrate.com http://www.jasonstrate.com/images/StrateSQLBanner.jpg 40 100 1838 MarkTab Consulting Blog Sponsor http://www.marktab.net http://www.marktab.net/images/MarkTabNet_100x40.gif 40 100 2021 Shannon Lowder Blog Sponsor http://shannonlowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 2145 Craig Purnell Blog Sponsor http://www.craigpurnell.com http://www.craigpurnell.com/wp-content/uploads/2012/03/CraigPurnellSQLSatLogo.jpg 40 100 7399 SQLSatruday 130 1. BI (Auditorium 1) 1102 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 1. BI (Auditorium 1) 1102 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 1. BI (Auditorium 1) 1102 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 1. BI (Auditorium 1) 1102 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 1. BI (Auditorium 1) 1102 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7399 SQLSatruday 130 2. DBA (Auditorium 2) 1202 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 2. DBA (Auditorium 2) 1202 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 2. DBA (Auditorium 2) 1202 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 2. DBA (Auditorium 2) 1202 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 2. DBA (Auditorium 2) 1202 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7399 SQLSatruday 130 3. Personal Dev Azure 1400 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 3. Personal Dev Azure 1400 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 3. Personal Dev Azure 1400 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 3. Personal Dev Azure 1400 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 3. Personal Dev Azure 1400 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7399 SQLSatruday 130 4. BI Data Warehouse 1402 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 4. BI Data Warehouse 1402 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 4. BI Data Warehouse 1402 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 4. BI Data Warehouse 1402 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 4. BI Data Warehouse 1402 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7399 SQLSatruday 130 5. DBA 1404 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 5. DBA 1404 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 5. DBA 1404 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 5. DBA 1404 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 5. DBA 1404 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7399 SQLSatruday 130 6. BI 1406 4/28/2012 10:00:00 AM 4/28/2012 10:15:00 AM 7399 SQLSatruday 130 6. BI 1406 4/28/2012 1:00:00 PM 4/28/2012 1:15:00 PM 7399 SQLSatruday 130 6. BI 1406 4/28/2012 2:15:00 PM 4/28/2012 2:30:00 PM 7399 SQLSatruday 130 6. BI 1406 4/28/2012 3:30:00 PM 4/28/2012 3:45:00 PM 7399 SQLSatruday 130 6. BI 1406 4/28/2012 4:45:00 PM 4/28/2012 5:00:00 PM 7400 SQLSaturday 130 6. BI 1406 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7400 SQLSaturday 130 5. DBA 1404 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7400 SQLSaturday 130 4. BI Data Warehouse 1402 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7400 SQLSaturday 130 3. Personal Dev Azure 1400 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7400 SQLSaturday 130 2. DBA (Auditorium 2) 1202 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7400 SQLSaturday 130 1. BI (Auditorium 1) 1102 4/28/2012 11:15:00 AM 4/28/2012 12:00:00 PM 7402 David Eichner 6. BI 1406 Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 7403 Mike Davis 1. BI (Auditorium 1) 1102 Learn about the awesome new features in the new release of SQL Server 2012. Mike will cover the new tasks and transforms. He will also explain the new SSIS catalog and how to configure and run your packages using T-SQL. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 7409 Rob Volk 5. DBA 1404 Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 7416 Michael Antonovich 4. BI Data Warehouse 1402 For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by jusst connecting to a custom view. However, for most other data sources (and for those users without develo9pment access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. This session will explore DAX functions and expressions and how they differ from Excel expressions. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 7431 Jorge Novo 6. BI 1406 Learn the secrets of how to build SSIS Packages using the .NET Library. Build your packages using Metadata tables without the need of Integration Services. Create standard templates, add or modified existing Components on the fly. Create Custom SSIS Components for your organization. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 7448 Dmitri Korotkevitch 5. DBA 1404 No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does 'efficient indexing' mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint. This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM 7449 Dmitri Korotkevitch 5. DBA 1404 No system ever performs well even on the most powerful hardware unless the database is efficiently indexed. But what does 'efficient indexing' mean? Database Professionals impress customers by use of magic buzzwords such as “Indexing strategies” and “Performance tuning” and happily contribute to the myth about complexity of the subject. But with all complexity involved it’s not Rocket Science – the key point is to understand how SQL Server works with indexes and look at them from SQL Server standpoint. This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system. 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 7466 Chris Price 4. BI Data Warehouse 1402 With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 7491 Pam Shaw 6. BI 1406 So the big wigs have come up with a “master” report that shows everything you could ever want on a single report.  It includes grids and charts of varying sizes and complexities.  Did I mention they want it pretty as well?  In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes.  The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts.  We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work.  To get the most out of this session, you should be able to build a report in SSRS. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM 7518 David Liebman 3. Personal Dev Azure 1400 In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 7885 Mike Maglin 3. Personal Dev Azure 1400 We would like to offer a one-hour session that deals with the following 4 subjects: 1. a high level view of the IT job market along with comparisons to previous periods; 2. the high-demand skill sets related to SQL, BI, and MS in general; 3. tips from staffing firms and hiring managers on how to craft your resume for maximum impact; 4. tips on nailing the interview. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM 7911 Gareth Swanepoel 2. DBA (Auditorium 2) 1202 In the fantasy world of Middle-earth live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes.If you are a production DBA who needs to find out about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments or if you are a BI developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is for you. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 7952 Christopher Daily 3. Personal Dev Azure 1400 This session will provide an overview of Scrum and answer the reason why a DBA should care about Scrum. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 7955 Chad Churchwell 2. DBA (Auditorium 2) 1202 This presentation will focus on the concepts behind AlwaysOn, benefits it provides, and a demo of setting up AlwaysOn Availability groups 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 8022 James McAuliffe 5. DBA 1404 Focus: FileTable and Statistical Semantic Search In SQL 2012 It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It's like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 8058 Bradley Ball 2. DBA (Auditorium 2) 1202 Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. In SQL 2012 we add Spatial Data Types. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 8061 Adam Jorgensen 1. BI (Auditorium 1) 1102 Come learn how to get your executives and end users excited about analytics you can deliver quickly. The new Tabular features of Analysis Services are quicker and easier to develop and combine with PowerView (Crescent) to make for amazing (AND PORTABLE) visualizations that your end users will be excited about. As usual this will be all demo and you will get hands on exposure and experience with this new technology. 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8086 Devin Knight Brad Schacht 1. BI (Auditorium 1) 1102 The Microsoft BI stack is fairly complex, especially on the front-end. In this session, we will cover when to use PerformancePoint, Reporting Services, Power View, PowerPivot or Excel Services. Brad and Devin will also show a little of each of these tools in action. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM 8098 Tom Brenneman 3. Personal Dev Azure 1400 In this session, Tom will go over how to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities. 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8142 Eric Wisdahl 5. DBA 1404 In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 8238 Bradley Schacht 1. BI (Auditorium 1) 1102 In this session Brad will provide you an overview of SharePoint 2010 and how it can be integrated with your current or new Business Intelligence infrastructure. He will discuss the general use of SharePoint for BI, basic setup and installation of the farm, as well as an overview of a completed SharePoint site. Brad will take you on a tour of SharePoint Central Administration including how to allow your site to be able to take advantage of many of the BI features such as PowerPivot, Excel Services and Reporting Services. With SQL Server 2012 right around the corner Brad will give you a sneak peak at of some of the improvements that are coming to SharePoint for those of you who want to be on the cutting edge of this growing technology. 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 8305 Troy Gallant 4. BI Data Warehouse 1402 One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 8312 Kyle Walker 4. BI Data Warehouse 1402 In this session, you will learn valuable techniques on how to performance tune your SSIS packages. As many of you know, creating ETL to carry out a specific task is one thing, but optimizing that ETL to run in an acceptable amount of time is a whole different animal. You will learn about methods and properties that aren’t really mentioned in your introductory or even mid-level SSIS courses, as well as some unconventional tricks that I’ve picked up along the way. To get the most out of this session, you will need to have previous knowledge and experience with SQL Server Integration Services (Not an intro session). 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 8391 Jason Thomas 6. BI 1406 SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some advanced tips and tricks around them. Come to this session and take your charting skills to the next level. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 8421 Kevin Boles 5. DBA 1404 The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure! 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8497 Dustin Ryan 4. BI Data Warehouse 1402 The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It's easier than you might think. In this session, attendees will learn the basic MDX query syntax, how to navigate a hierarchy, how to create dynamic time calculations, and more. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM 8561 Christina Leo 2. DBA (Auditorium 2) 1202 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 cooking 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. 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8564 Mike Milligan 6. BI 1406 Take advantage of SQL Server predictive analytics in Office Excel 2010 and Office Visio 2010.! •Table Analysis Tools for Excel: Provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. •Data Mining Client for Excel: You can create, test, explore, and manage data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. •Data Mining Templates for Visio: Enables you to render and share your mining models as annotatable Visio 2010 drawings. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 8620 Jason Hofferle 6. BI 1406 PowerShell is Microsoft's automation engine, which includes a command-line shell and scripting language. Since its initial release in 2006, it has become an essential tool for managing Microsoft technologies and products from vendors such as VMware. This session will explain what PowerShell is, demonstrate the fundamentals, and provide some reasons why everyone working with Microsoft products should know the basics. 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8622 Jonathon Moorman 3. Personal Dev Azure 1400 This session will describe what to expect when interviewing for a sql server developer position. The session will include tips to strengthen your interviewing techniques and pit falls to avoid. The session will explain why 'I don't know.' is a perfectly acceptable answer and when it's okay to brag. 4/28/2012 2:30:00 PM 4/28/2012 3:30:00 PM 8623 Tom Lannen 1. BI (Auditorium 1) 1102 So now that your data warehouse is complete now what? In this session Tom will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS. 4/28/2012 10:15:00 AM 4/28/2012 11:15:00 AM 8635 Jorge Segarra 2. DBA (Auditorium 2) 1202 In this session we cover backups and restores from beginning to end. Want to know how to do point-in-time restores? Don't understand what the different recovery models mean? How do you handle backups for different size databases? All of these questions and more will be answered in this session. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 8638 John Welch 4. BI Data Warehouse 1402 So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance. 4/28/2012 12:00:00 PM 4/28/2012 1:00:00 PM 8667 Brian Knight 1. BI (Auditorium 1) 1102 Learn about some of the new developer features in SQL Server 2012. Brian will start by showing you the new SQL Server Data Tools (AKA Juneau) that allows you design, troubleshoot and deploy data changes easier. Then, learn what's changed in the SQL Server 2012 T-SQL and data types that allow you to store amazing new data in SQL Server like files. 4/28/2012 3:45:00 PM 4/28/2012 4:45:00 PM 8671 SQL Saturday 1. BI (Auditorium 1) 1102 Event closing ceremonies. Prizes and raffles giveaways. 4/28/2012 5:00:00 PM 4/28/2012 5:15:00 PM 8761 Shawn Harrison 3. Personal Dev Azure 1400 Knowledge of SSIS is essential in the world of BI today. It is a powerful tool for data cleansing and archiving. In this session for beginners, Shawn will cover all the basics of SSIS and package design. Attendees will gain a full understanding of what SSIS is and how to start using it effectively. 4/28/2012 9:00:00 AM 4/28/2012 10:00:00 AM 8762 Thomas LaRock 2. DBA (Auditorium 2) 1202 When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices. 4/28/2012 1:15:00 PM 4/28/2012 2:15:00 PM