SQLSaturday #85 - Orlando 2011 9/24/2011 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. #sqlsat85 Seminole State College of Florida 100 Weldon Blvd Building UP Sanford FL 32773 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 1311 Red Gate Software Platinum Sponsor http://www.red-gate.com/ http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1437 Strategy Companion Corporation Gold Sponsor http://www.strategycompanion.com/m_home.aspx http://i1104.photobucket.com/albums/h322/joshua-pierce/Strategy-Logo.jpg 60 170 1463 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1535 Nimble Storage Gold Sponsor http://www.nimblestorage.com/ http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/Nimble_logo.png 60 170 1329 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1352 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1481 CozyRoc Silver Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1513 GrapeCity, Inc. Silver Sponsor http://www.gcpowertools.com http://www.ineta.org/codechallenge/logo/GrapeCity%20PowerTools%20P%20and%20R%20200.png 60 170 1521 Pragmatic Works Silver Sponsor http://pragmaticworks.com/ http://pragmaticworks.com/images/PragmaticWorks-footer-logo.jpg 60 170 1561 Soaring Eagle Consulting Silver Sponsor http://www.soaringeagle.biz http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/soaringeagle.png 60 170 1581 Wrox Silver Sponsor http://www.wrox.com http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/wrox_logo.png 60 170 1548 Telerik Bronze Sponsor https://www.telerik.com http://orlando.sqlpass.org/Portals/56/images/telerik_logo.jpg 60 170 1597 Pearl Knowledge Solutions, Inc. Bronze Sponsor http://www.pearlknows.com http://pearlknows.com/wp-content/pk_images/pearl_logo.jpg 60 170 1252 SQL Balls Blog Sponsor http://www.SQLBalls.com http://2.bp.blogspot.com/-QqNucWZajf8/TcNgNipa3-I/AAAAAAAAAKc/Inw_nTV1a-4/s1600/sqlballslogonolensflare+copy.jpg 40 100 1254 Silverwing Technologies, Inc. Blog Sponsor http://www.programmersedge.com http://www.programmersedge.com/images/ProgrammersEdgeLogoSmall.png 40 100 1265 ShannonLowder.com Blog Sponsor http://ShannonLowder.com http://shannonlowder.com/wp-content/themes/vigilance_pro/images/lowder-wp-logo.png 40 100 1277 SQLvariant Blog Sponsor http://sqlvariant.com/wordpress http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 1519 SQL Solutions Group Blog Sponsor http://www.sqlsolutionsgroup.com http://www.sqlsolutionsgroup.com/images/logo2.jpg 40 100 1606 SpeedPass Blog Sponsor http://www.sqlsaturday.com http://orlando.sqlpass.org/Portals/56/Images/admitone.png 40 100 1570 Apress Book Sponsor http://www.apress.com http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/Apress_sponsor.jpg 40 100 1601 O'reilly Book Sponsor http://oreilly.com/ http://orlando.sqlpass.org/Portals/56/Sponsor%20Images/oreilly_logo.png 40 100 1602 McGraw-Hill Book Sponsor http://www.mheducation.com/div_professional/index.shtml http://orlando.sqlpass.org/Portals/56/sponsor%20Images/mcgraw_logo.png 40 100 4536 Rob Collie BI 1 UP3206 The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :) 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 4544 Plamen Ratchev DBA 2 UP4105 Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions. 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 4556 William E. Pearson III BI 1 UP3206 The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 4562 William E. Pearson III BI 2 UP3207 In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 4581 Adam Jorgensen BI 2 UP3207 In this session, the attehdees will learn how to drive and build a PowerPivot solution and reports as they rotate through the podium as volunteers. 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 4617 Michael Antonovich BI 1 UP3206 This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 4622 David Liebman BI 1 UP3206 In this presentation I will show you how to create a simple report and deploy the report to the Report Server using SQL Server Business Intelligence Development Studio(BIDS). 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 4627 Dmitri Korotkevitch DBA 1 UP4104 One of the biggest challenges for modern OLTP Systems is the amount of data needed to be collected and processed. Business requirements, industry standards and regulations require systems to retain enormous amount of information. Offline data archiving is not often an option especially with the hosted solutions - customers expect old data to be available on the fly. Keeping all data in the single instance of SQL Server is the most expensive option from hardware cost and management standpoints. This session demonstrates several data sharding techniques that can be used to partition the data across multiple database servers focusing on the task of separating production and historical data in OLTP systems 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 4637 Maximo Trinidad Misc UP3205 I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 4684 Janis Griffin Performance UP3208 Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools. 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 4696 Rob Volk DBA 2 UP4105 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/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 4838 Mike Davis SSIS UP4103 Mike shows you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them. 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 4841 Mike Davis SSIS UP4103 In this session, you’ll learn how to load a Data Warehouse using SQL Server Integration Services (SSIS) and T-SQL. You'll see a battle between two database experts (Mike Davis and Luis E Figueroa), attempting to load the data warehouse 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 SQL Smackdown. 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 4859 Don Stevic DBA 1 UP4104 When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 4886 Nathan Heaivilin Performance UP3208 Every wonder what the database engine does when you run a proc? Want to know what is causing the procedure or sql statement to run really slow? This session with provide you with a start to understanding both of these. 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 4946 Andy Warren Misc UP3205 A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 5032 Brian McDonald BI 2 UP3207 SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it ** 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 5045 Bradley Ball DBA 2 UP4105 Page and Row Compression are powerful new tools. Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. We can turn it on, we can turn it off, but we want more! What are Access Methods and how in the SQL Engine do they affect Compression? What are the “Gotchas” of Page Compression? How does Compression differ in the way it treats Non-Leaf Leaf Level pages? What additional functionality did we get in DBCC Page, DMV’s, Perfmon Counters, and Extended Events to support our usage of Compression? How do complex query plans affect Compression? Come find out! 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5083 Eric Wisdahl SSIS UP4103 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/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 5087 Daniel Taylor DBA 2 UP4105 Just like any good tradesman understanding your tools is key to getting the job done accurately and timely. Are you Database Developer or DBA? If so are you familiar with the out of the box tools provide to us by Microsoft? During this session I will walk thru some of the SSMS tools I find useful and help me get the job done in an accurate and timely manner. We will also walk thru some of the tools shared with the development teams which they have found useful to complete their daily tasks. 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 5195 Erin Stellato Performance UP3208 The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 5201 Buck Woody DBA 2 UP4105 The cloud! Move everything to the cloud! No, wait, the cloud is awful! Don’t move anything to the cloud! Wait – what’s “the cloud”? Buck Woody, Microsoft’s “Real World DBA” will show you how to figure out where your data should live, based on actual decision points. You’ll learn about Windows and SQL Azure, and when it makes sense to put data locally or remotely. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 5241 Janis Griffin DBA 2 UP4105 More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 9/24/2011 12:45:00 PM 9/24/2011 1:30:00 PM 5265 Phillip E. Rosen BI 2 UP3207 I will demonstrate how to develop MS Excel BI Dashboards in the following ways: 1. Workbook style with Office data connections stored on local PC or networked document drive 2. excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render 3. Convert excel pivot table into excel OLAP formulas 4. Discuss SP 2010 BI Center 5. Discuss references to cap off session. 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 5288 Ronald Dameron Misc UP3205 I'll review several intermediate PowerShell script examples that a DBA can use to automate repetitive tasks on multiple servers. Examples will include but not limited to, how to chart database growth, check how cluttered msdb is, check security configurations, create a login and set permissions. 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 5293 Kevin Boles Performance UP3208 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/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 5295 Kevin Boles Performance UP3208 What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 5304 Rodney Landrum DBA 1 UP4104 Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet. 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 5332 Norm Bowen DBA 1 UP4104 In this session, we will cover the various stages/steps of a data conversion project including concept, project planning, analysis, development and QA. We will also discuss some best practices, and other considerations that might not be directly a part of the data conversion, but is related to, or can be impacted by it. 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5340 Bradley Schacht SSIS UP4103 In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS. 9/24/2011 8:30:00 AM 9/24/2011 9:30:00 AM 5341 Bradley Schacht SSIS UP4103 One of the biggest hurdles in any organization is migrating from DEV to PROD with minimal issues. In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier. Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables. After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration. At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package! 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5352 Michael Wells Misc UP3205 As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours. 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 5385 James McAuliffe SSIS UP4103 For many SSIS scenarios, a desired outcome is to implement logic or rules that are used in existing enterprise applications, only to do so in an a bulk data loading scenario. Many times the logic being applied is complex and multi-step. We will examine various scenarios where complex logic from shared code sources can be applied in SSIS processing scenarios. 1 How to use code from shared enterprise sources 2. How to implement external code in script component 3. How to implement external code in sql CLR 4. Performance comparison. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 5386 Robert Biddle BI 2 UP3207 You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session you'll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform. 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5388 Jorge Segarra Misc UP3205 We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature! 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 5389 Kyle Walker BI 1 UP3206 Join Kyle's session on SSRS subscriptions! In this session, you will get a chance to see some real world subscription requests and how to implement them. Some requests, which are common across a lot of businesses, fall outside of the functionality of Reporting Services so this session will also require some knowledge of SSIS. 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5393 Eddie Wuerch Performance UP3208 Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them. 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5404 Patrick Thompson DBA 1 UP4104 The session will look at ways that the Sql and NoSql worlds can fit together. It will cover some of the major NoSql offerings such as Cassandra, MongoDb and Hadoop, and present some idea on how Sql fits with these non-Sql stores. It will particularly emphasize hadoop and some of the problems and opportunities offered by mixing hadoop and sql. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 5407 Chad Miller Misc UP3205 You’ve run PowerShell scripts and need to store the output . In this session we’ll look at sending Powershell output to text, CSV, HTML, Excel, and SQL Server data sources. 9/24/2011 1:30:00 PM 9/24/2011 2:30:00 PM 5419 Craig Purnell DBA 2 UP4105 A Review of the upgrade process to SQL Server 2008 R2. A checklist of considerations for things a company would likely encounter coming from SQL Server 2000 or 2005. The Pros and Cons of in-place upgrades vs. the Build-out-new approach. There will also be some lessons learned sprinkled in as the presenter has personally led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor. Enterprise interfaces and stuff you will see in the real world, deprecated features and how to test for them 9/24/2011 11:00:00 AM 9/24/2011 12:00:00 PM 5435 Kendal Van Dyke DBA 1 UP4104 XML is a technology that Developers and DBAs alike share a love-hate relationship with; it's powerful and flexible yet it can be bloated and difficult to work with at the same time. Regardless, XML has found a home in many applications - including SQL Server (e.g. execution plans) - so it's important to understand how to work with it in your databases. This session will show you how to use the XML data type, perform basic operations on XML data, and how to use FOR XML to create XML from relational data. This isn't a session to convince you to use XML, but to show you what you can do with XML when you do need to use it! 9/24/2011 9:45:00 AM 9/24/2011 10:45:00 AM 5501 Bob Abernethy BI 1 UP3206 Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services. 9/24/2011 12:45:00 PM 9/24/2011 1:30:00 PM 5715 Russ Fustino DBA 1 UP4104 Join Russ Fustino as he takes a tour of the new ActiveReports 6 Silverlight Report Viewer. Now all the power of reporting the award winning ActiveReports for Windows and ASP.NET, is now available in Silverlight! He will show how this component is designed for reporting in Microsoft Silverlight 4 and higher. See how the Silverlight Report Viewer is simple, lightweight, flexible, localizable, and easy to customize for quick end user deployment. It includes these features: ?Preview reports loaded from a file, document stream, ASPX page, RPX Handler, or WCF service. ?End-user toolbar with Table of Contents (TOC), Thumbnails, Print, Search, Zoom, and Navigation buttons, plus you can add your own custom buttons. *And More! 9/24/2011 12:45:00 PM 9/24/2011 1:30:00 PM 5716 Jeff Garbus BI 2 UP3207 This session consists of real-life examples of poorly performing t-sql code and what was done to improve performance by several orders of magnitude. Jeff will cover a variety of performance topics from misuse of tempdb, to excessive io, to taking advantage of new t-sql features. These examples are also featured in his most recent (and well-reviewed) book, 'Microsoft Transact - SQL, The Definitive Guide'. 9/24/2011 2:45:00 PM 9/24/2011 3:45:00 PM 5831 Chris Wolfley BI 1 UP3206 Nimble Storage, launched by the co-founders of NetApp and Data Domain, has built a purpose-built storage architecture that integrates flash memory and high-capacity disk for the first time, combining primary storage, backup, replication, and disaster recovery in a single 'converged' solution. Join this informative session where you will review the evolution of data storage and protection, learn about Nimble Storage's breakthrough solution for SQL Server environments, and review real-world case studies that demonstrate its performance and reliability. 9/24/2011 4:00:00 PM 9/24/2011 5:00:00 PM 5846 Herve Roggero Performance UP3208 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! 9/24/2011 12:45:00 PM 9/24/2011 1:30:00 PM