SBI407: Add It Up: Analysis Services Aggregations
Craig Utley
Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.

SBI206: Analysis Services 2008 End-to-End
Craig Utley
Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Craig Utley has experience designing, implementing, and troubleshooting Analysis Services databases at dozens of companies worldwide through his more than 11 years of experience with the Microsoft BI stack. Far from a theoretical discussion, this session will present real-world lessons learned about what works in production environments. By attending this session, you will learn the proper design and implementation of your Analysis Services databases, allowing you to avoid common pitfalls while delivering the maximum value to your clients.

SBI408: Avoid Slow SSAS Queries: MDX Query Troubleshooting
Craig Utley
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.

SBI304: Combining Disparate Data in an SSRS Report
Brian Larson
One of the limitations of Reporting Services is the inability to relate data from two disparate data sources within a report. This session explores various techniques for overcoming this limitation. When security restrictions or other constraints make linked servers an impossibility, these approaches allow you to combine data from multiple sources and provide your users with the analysis they require.

SBI212: Data, Data, Who Owns the Data?
Stacia Misner
The SQL Server code-name "Kilimanjaro" release includes a new feature, called Master Data Services, to support master data management (MDM). You might be wondering, "If I’m already cleansing and conforming heterogenous data in my centralized data warehouse, why do I need Master Data Services?" Or conversely, "If I implement Master Data Services, do I really need a data warehouse?" Come to this session to learn the answers to these questions and how to use Master Data Services to integrate MDM into your data warehouse architecture.

SBI409: Demystifying Analysis Services Stored Procedures
Stacia Misner
Analysis Services stored procedures are nothing like the stored procedures you create for your SQL Server databases. Not much is written about this feature, so you might wonder whether you need to bother with them at all. Put simply, you can simplify your MDX queries, combine cube data with relational data, or personalize calculations for specific users–just to name a few possibilities with a little C# (or VB) code and MDX. Come to this session to learn some practical ways you can take advantage of Analysis Services stored procedures.

SBI210: Exploring the New Reporting Services
Stacia Misner
Reporting Services comes with lots of new features in Kilimanjaro, including the Shared Component Library, map controls, data feeds, lookup functions, and other enhancements. In this session, you’ll learn the tips and tricks necessary to use these features to full advantage in your report development projects.

SBI205: Gemini: Delivering Self-Serve BI
Craig Utley
If you are always looking for better ways to deliver value to the business as part of a BI project, make sure you examine the capabilities of Gemini. Using existing data and tools, users now have the ability to analyze vast quantities of data without first designing dimensions and measure groups. Users can explore the data and optionally share their analysis with others. See how Gemini opens the power of Analysis Services to non-technical users while still allowing the IT organization to administer and secure the data.

SBI301: Integrating Reporting Services with Application Security
Brian Larson
In many cases, we need the Reporting Services report server or a Reporting Services report to enforce some security restrictions. This requires the report server and the report to know the user’s identity. This session will explore techniques for passing credentials from a custom application to a Reporting Services report server. Both the use of standard Windows Integrated security and a custom security extension will be examined.

SBI303: Thinking Outside the Tablix: Creative Uses of Reporting Services
Brian Larson
Reporting Services is a powerful tool for creating busines charts and reports. That power can also be harnessed for a number of non-traditional uses as well. These include menuing, capturing user input, generating mail merge documents, and more. This session will expand your horizons; allowing you to use Reporting Services in new and creative ways.

SBI202: Tuples, Sets and Members: Understanding the Basics of MDX
Brian Larson
You may be comfortable using the Reporting Services graphical MDX query designer, but to truly unlock the power of Analysis Services you need to be able to code your own MDX queries. The hardest part of this process can be understanding the basics. This session will provide a solid understanding of what makes up MDX queries and will give you the tools and confidence you need to create your own custom queries.

SBI211: What’s DAX?
Stacia Misner
Sure, that Gemini application looks pretty in the demo, but its real beauty lies in the power of the calculations that give meaning to raw data. DAX is the new expression language that provides this power—taking familiar Excel functions to new levels, adding new functions to perform tasks never before possible in Excel, and allowing you to add a business logic without knowing a thing about dimensions and measures. In this session, you’ll learn how best to get started with DAX so that you can take full advantage of Gemini’s power.

DEVELOPER

SDV301: A Database Developer and DBA Perspective—LINQ to SQL and Entity Framework vs. Stored Procedures
Bob Beauchemin
This session covers the performance implications of using two new Microsoft data access frameworks. I’ll look at the good, the bad, and the ugly aspects of code generation with the frameworks using SQL Profiler, plan cache monitoring, and query plans. I’ll cover what the frameworks bring to the table when compared to using T-SQL stored procedures or using dynamic SQL and the obvious benefits to the application programmer. T-SQL code generation enhancements in .NET 4.0 versions of Entity Framework and LINQ to SQL will also be explored.

SDV304: Complex Event Processing with StreamInsight
Bob Beauchemin
While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, standing queries, and millisecond latency requirements requiring the data to be queried (and possibly summarized) while it’s in-flight. These requirements are shared by various scenarios across verticals such as manufacturing, oil and gas, power utilities, financial services as well as IT and data center monitoring. Microsoft’s StreamInsight product (now in CTP) uses an event provider model to produce, process, and consume streams of data. A LINQ query provider gives you the ability to query and morph data streams in-flight.

SDV306: Debugging T-SQL: Power Tools and Best Practices
Don Kiely
Management Studio in SQL Server 2005 and 2008 is built on Visual Studio, which means that there are a ton of debugging tools built into Management Studio. You’ve probably at least played with stepping through code, checking current values of local variables, and other basic techniques. But there is Oh, so much more! This session will explore some of the more powerful debugging techniques available in Management Studio so that you can start on your way to being a debugging ninja. We’ll also cover some best practices for eradicating the little pests from your T-SQL code, as well as some tips and tricks to make your debugging sessions more effective.

SDV307: Encryption 2.0: SQL Server 2008 Takes It Further
Don Kiely
Data encryption was introduced in SQL Server 2005 as a great feature for protecting your most sensitive data. Microsoft did a fine job with Encryption 1.0, and it only gets better in SQL Server 2008. Probably the best new feature for some scenarios is Transparent Data Encryption, which encrypts complete database and log files. But when that is overkill, you can encrypt only the specific data that needs protection. Another great new feature is external key management. During this session, we’ll explore the encryption options presented in SQL Server 2008 and see how they can add a nearly impenetrable layer of protection to your data, as well as look at where there could be chinks in the armor.

SDV309: Exploring SQL Server 2005 and 2008 Security
Don Kiely
There are few corporate assets as valuable in the information age as data. Enterprises spend billions to collect and generate it, slice and dice it in every conceivable way to mine marketplace intelligence from it, and replicate and back it up using elaborate, redundant schemes. Yet it is all too common to slack on security. Sure, SQL Server 2005 and 2008 are designed to be “secure by default,” but once you add databases and start letting users and their applications access the server you have already poked holes in the security. SQL Server comes with plenty of features that let you secure data, but it can be hard to get a handle on the right ones to use in your environment. During this session, we’ll explore myriad security features in SQL Server and how to put them to use in applications.

SDV305: Exploring SQL Server Azure Database and Data Tier Applications
Bob Beauchemin
Although SQL Server Azure database applications (database in the cloud) and Data Tier Applications (an application management feature in SQL Server 2008 R2) are totally different features, they are both implementations of non-traditional ways to manage applications. The set of SQL Server functionality that each one offers is amazingly similar. This session will show how to take a “traditional” application in a SQL Server database and either deploy it to the cloud or deploy it as a DAC application for local consumption and easier application deployment mobility.

SDV212: GUIDs: A Gift or a Gremlin?
Kimberly L. Tripp
Since the invention of the GUID (April 1, 1995) my life as a DBA and "tuner" has been busy. I’ve seen databases designed with GUID keys run fairly well with small workloads completely fall over and fail because they just cannot scale. And, I know why GUIDs are chosen—it simplifies the handling of parent/child rows in your batches so you can reduce round-trips or avoid dealing with identity values. And, yes, sometimes it’s even for distributed databases and/or security that GUIDs are chosen. I’m not entirely against ever using a GUID but overusing and abusing GUIDs just has to be stopped! Please, please, please—database developers—come to this session so I can give you better solutions and explanations on how to deal with your parent/child rows, round-trips and clustering keys!

SDV308: Mastering Management Studio for Optimal Productivity
Don Kiely
There’s a good chance that you use Management Studio most days, whether you are a DBA or a developer. It makes a lot of routine tasks easy, such as writing queries, setting up security, and doing quick or detailed checks on a server’s health. But how well do you really know it? Have you customized it to better suit the way you work? Do you know how to incrementally search script files? Do you know how to fix corruptions in its settings files? Are you able to display cute cat pictures in it? In this session we’ll explore many of Management Studio’s hidden and lesser known features that can make you much more productive when working with SQL Server, and make it a more fun environment to work in.

SDV303: Modeling and Implementing Hierarchies with SQL Server
Bob Beauchemin
This session looks at support in SQL Server for hierarchical data, comparing and contrasting the methods of maintenance and query. I’ll focus on SQL Server 2008’s new hierarchyID data type, with a look at performance and ease-of-use compared with the adjacency model, nested set model, and XML storage and query.

SDV310: SQL Server Covering: Concepts, Concerns, and Costs
Kimberly L. Tripp
Using indexes to "cover a query" is one of the more important tuning strategies possible in SQL Server. So much so that many of the best indexing performance features target specifically this—covering. We’ll look at indexed views (added/improved in SQL Server 7.0 and 2000), INCLUDE (added in SQL Server 2005) and filtered indexes (added in SQL Server 2008). In this session, we’ll discuss the pros and cons of covering, and the different strategies possible to achieve it—as well as when it’s a good idea to consider covering and when it’s a must!

SDV311: Statistics: Are They Really Important?
Kimberly L. Tripp
SQL Server uses a cost-based optimizer which means that each query/batch submitted is evaluated in a variety of ways to determine the execution plan. If a query needs to process 10 rows the plan might be quite different than a query that must process millions of rows... but how does SQL Server know how many rows to process if all it knows is your query? The answer is statistics. Statistics are the basis of estimation for selectivity and join density—they are the most important piece of information that the optimizer has to help it do a better job. So, how do you make sure that your statistics are good, accurate, and up-to-date? Where are these stored? What do they look like? Are there cases where statistics just aren’t good enough? How do you deal with these situations? Come to this session and find out!

SDV302: Visualizing and Extending SQL Server Spatial Data: Maps, Reports, and Analysis
Bob Beauchemin
SQL Server 2008 R2 (Kilimanjaro release) will put spatial data support (including Bing Maps support) inside SQL Server Reporting Services, extending the data type’s usefulness to include maps and direct integration. And the spatial data types are even supported in the MapPoint application through a custom add-in. I’ll also show how to use SQL Server Spatial Data with Bing Maps directly, walking through a simple code example of how it’s done. Finally, I'll show how you can write your own extensions to the spatial library with examples.

KEYNOTE SESSION

SQLKEY: SQL Server - Next Generation Information Platform
Donald Farmer
SQL Server has evolved to a complete data platform enabling rich services and comprehensive management capabilities for all types of data. From unstructured data to fully structured data models SQL Server provides a variety of data types and technologies to enable next generation applications. In this keynote, Donald will go over the vision for the data platform, some of the capabilities in SQL Server 2008, how they’re being used by customers today and will provide some insight into what’s coming next in SQL Server 2008 R2 and beyond.

DBA

SDB312: Achieving SQL Server High Availability with Hyper-V R2 and Live Migration
Ross Mistry
Virtualization is a major part of today’s data centers. The operating efficiencies offered by virtualization allow organizations to dramatically reduce operational effort and power consumption. This session will cover best practices and strategies associated with running SQL Server 2008 on Hyper-V specifically with Windows Server 2008 R2. Moreover, you will understand how to leverage the new features and functionality associated with Windows Server 2008 R2 in order to virtualize SQL Server while also achieving high availability and disaster recovery from a single solution.

SDB303: Automating and Analyzing with SQL Trace and RML Utilities
Andrew Kelly
SQL Profiler is a terrific tool that many of us use on a regular basis. But there are some inherent limitations and potential performance implications that everyone should be well aware of. Analyzing data directly thru Profiler can be difficult as well when dealing with large amounts of data and events. The solution is to use the built-in capability of SQL Trace along with the RML utilities from MS PSS to analyze the information you really need. This session will cover all of these aspects in detail along with sample code that you can use to get started immediately with your quest to seek out the worst offending statements in your system.

SDB308: Building the Right Backup Strategy
Paul Randal
In many situations, database backups are critical for recovering from a disaster, but there are lots of misconceptions about how backups work and what a good backup strategy is. The purpose of taking backups is, of course, to be able to restore them at some point–but that can sometimes be easier said than done, depending on what you want to be able to restore. In this in-depth session, Paul will explain how the three most common types of backups work and how they can be combined into an effective backup strategy. Paul will also cover how restore works, the three recovery options for restoring a backup, and a variety of useful examples. You don’t want to find out that your backups are unusable when disaster strikes–this session provides the knowledge you need to make sure you can recover. (It is recommended that you attend the Logging and Recovery session before this one.)

SDB401: Collecting and Analyzing File and Wait Statistics
Andrew Kelly
Since SQL Server 2000 we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server. More specifically these are the File & Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL Server 2008 currently has over 480 events so far. This session will show you how to efficiently capture and analyze the information provided by a set of DMVs in SQL Server 2005 and SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system.

SDB306: DBA Mythbusters
Paul Randal
It’s amazing how many myths and misconceptions have sprung up and persisted over the years about SQL Server—after 10 years helping people out on forums, newsgroups, and customer engagements, Paul has heard it all. Are there really non-logged operations? Can interrupting shrinks or rebuilds cause corruption? Can you override the server’s MAXDOP setting? Will the server always do a table-scan to get a row count? These are just a few of many, many myths that Paul will debunk in this fast-paced session about how SQL Server operates and should be managed and maintained.

SDB309: Follow the Rabbit: Q&A
Paul Randal
Kimberly L. Tripp
Now a conference staple, Kimberly and Paul come loaded with slides and highlights from all of their sessions of the conference. If you don’t ask questions, they’ll start adding to the content discussed previously by diving deeper and tying in discussions they’ve had in breaks, after their sessions and with your questions. This is really YOUR time to ask questions! This session seems unfocused but is often not only informative but highly interactive and fun.

SDB311: Implementing a SQL Server 2008 Failover Cluster with Windows Server 2008
Ross Mistry
So your boss has given you the marching orders to build a new failover cluster with SQL Server 2008 on Windows Server 2008. The challenge–where do I start? What edition of SQL Server 2008 should I use? What edition of Windows Server 2008 should I use? Do I need shared storage? If so, how should I carve up the LUNs? Does SQL Server support active/active failover clustering? What is the difference between single instance and multiple failover instance configurations? Does SQL Server support stretch clustering? As you can see, there are numerous items which need to be correctly addressed. This session will provide you with the knowledge to successfully plan and implement a SQL Server 2008 failover cluster on Windows Server 2008. Tips, tricks and best practices will be covered.

SDB305: Leveraging Centralized Management Servers in SQL Server 2008
Kimberly L. Tripp
SQL Server 2008 has a variety of features that aid in supporting multiple servers—from Centralized Management Servers to Multi-server Script Execution to Policy-based Management and Performance Data Collection. Attend this session and see how you can easily execute scripts on multiple servers, create policies that verify (and possibly set)—your most critical database settings with only a few clicks. And, much of this can be done against your existing and earlier versions of SQL Server (limitations and restrictions will be covered). Finally, collecting performance data from SQL Server 2008 servers and storing this data in a management data warehouse lets you better analyze trends and tune the most expensive queries through interactive click-through reports (the reports are similar to Performance Dashboard). The combination of all of these options means that your SQL Server 2008 servers have the most capabilities, but even having a SQL Server 2008 management server to help manage your existing (2000/2005) servers is a must. This session will be demo-packed and filled with practical solutions!

SDB302: Say NO to Maintenance Plans
Andrew Kelly
The built-in Maintenance Plans are OK to get up and running in a hurry but they are far from ideal. There are inherent limitations with the implementation and in the event there is a problem, troubleshooting can be almost impossible. This session will cover in detail a set of stored procedures that you can use to create your own custom maintenance jobs. You will have the flexibility to modify them to suit your every need far easier than the Maintenance Plans ever could. And since these utilize pure T-SQL they are easy to maintain and far easier to troubleshoot than the “black boxed” built-in maintenance plans. Creating your own custom jobs is fast and as a result you will have a much better understanding of what is being done by each task putting you in a better position to effectively troubleshoot any problems that may arise.

SDB304: SQL Server Configuration Best Practices
Andrew Kelly
There is simply no substitute for proper planning when it comes to deploying and configuring a SQL Server instance. Do you know what options you should change or set when installing or configuring a SQL Server instance? If not, you are certainly not alone. This session will cover the best practices for the key areas regarding the configuration of the SQL Server instance and the underlying server. Keeping these best practices in mind will give you a head start on ensuring your database will be scalable and perform at its best.

SDB310: Standardize, Consolidate, and Virtualize Your SQL Server Infrastructure
Ross Mistry
As organizations use ever increasing numbers of applications to manage business processes, provide new services, and gain an insight into business performance, the number of SQL Server systems that are required to support those applications has grown significantly. This typically leads to a proliferation of SQL Server systems, instances and databases within an organization’s infrastructure. However with the advances in hardware and SQL Server technologies, SQL Server systems can significantly handle greater workloads compared to the past. Therefore, it is now possible to consolidate SQL Server databases onto a fewer physical servers, which results in better utilization, reduced hardware and support costs. This session will outline strategies of how to consolidate SQL Server systems and databases on fewer servers. In addition, it will also focus on how to plan for consolidation and outline challenges DBAs may face.

SDB307: Understanding Logging and Recovery in SQL Server
Paul Randal
Some of the most misunderstood parts of SQL Server are its logging and recovery mechanisms. The fact that the transaction log exists and can cause problems if not managed correctly seems to confound many DBAs. Why is it possible for the transaction log to grow unbounded? Why does it sometimes take so long for the database to come online after a system crash? Why can’t logging be turned off completely? Why can’t I recover my database properly? Just what is the transaction log and why is it there? In this in-depth session, Paul will unravel the mysteries of the transaction log—it’s architecture and behavior under different recovery models—as well as how logging and recovery work in SQL Server. This is essential knowledge you need for understanding how backup, restore, log-shipping, database mirroring, and other technologies work.

VENDOR SESSION

VENDOR02: A Day in the Life of a Developer
Richard Pegden
Understand how Micro Focus next generation developer tools can help make a developer’s day-to-day tasks so much easier. This presentation will centre around how Analyzer Express, Visual COBOL, DevPartner and SilkTest can help developers build, analyze and test the highest quality code with Micro Focus and Visual Studio 2010. The first 10 attendees to the Micro Focus vendor session will receive a free 6-month DevPartner license.

VENDOR03: Building Better Software: From Planning to Construction to Testing
Joel Semeniuk
Chris Eyhorn
Todd Anglin
Building software doesn’t start or stop, when you write code. Great software requires just as much focus on planning and testing as on construction. In this demo-heavy developer session, you will see how the complete Telerik toolset enables software development teams of any size to be more productive at all points in the software development process. This session will be your first chance to see brand new products from Telerik and learn time saving tips from experts in the .NET community. Two Telerik Premium Collections will be raffled at this session.

VENDOR01: Introduction to High Speed Coding in Visual Studio with CodeRush
Mark Miller
Learn how to write C# and VB code quickly and with great efficiency using CodeRush for Visual Studio. See powerful code building features including code templates, selection wrapping, and declare from usage; refactorings for improving code quality & performance; advanced navigation, selection, and clipboard tools; background code analysis, a full-featured test runner and so much more. If you’re interested in seeing what moving up to the full featured version of CodeRush can do for your productivity and for your team, be sure to see this session. The first 200 who attend will receive a FREE copy of CodeRush and Refactor! Pro (valued at $249.99 & $99.00 respectively) and a FREE copy of DXperience WPF Edition (valued at $799.99).

VENDOR05: Line of Business Applications with Silverlight 4, Visual Studio 2010 & Infragisitcs
Andrew Flick
Have you wondered what benefits Silverlight can bring to your line of business applications? Do you want to learn how Visual Studio 2010, in conjunction with Silverlight, can not only improve your applications but can help you build them faster? In this code-focused session, you will learn 10 key tips for building rich line of business applications in Silverlight, and how new features and capabilities of Visual Studio 2010 can help you get there.

VENDOR04: Test-Driven Development of ASP.NET MVC Applications
Hadi Hariri
With the release of version 2, ASP.NET MVC has become one of the defacto frameworks for web development using the ASP.NET stack. It was designed with testablility and extensibility in mind. In this session we're going to put it through the test of building an ASP.NET MVC application using Test Driven Development. We'll introduce the basic ideas behind TDD and then move on to show, step by step, how to build applications from the ground up using this technique.

MICROSOFT DAY - SQL SERVER

SMS05: Advanced Microsoft SQL Server 2008 R2 StreamInsight
Jonathan Goldstein
Galex Yen
Microsoft SQL Server 2008 R2 StreamInsight is a new platform for building rich data processing over real-time event streams. Come to get a detailed walkthrough of the three major components of StreamInsight: input and output adapter SDK, the StreamInsight engine runtime, and the semantics of the continuous standing queries hosted in the StreamInsight engine. Examine best practices for performance and scalability, and hear a few case studies of real-world StreamInsight implementations and the lessons learned from them.

SMS04: Building and Managing Applications with SQL Azure and Windows Azure
Henry Zhang
Are you looking to reduce the costs of building and maintaining enterprise applications? Do you want to extend the reach of your applications across multiple devices, locations, and partners? SQL Azure and Windows Azure provide you a friction free, highly scalable platform for building applications. The scale and reach of the cloud lights up a new class of application scenarios. Come see how easy it is to consume SQL Azure from within Windows Azure.

SMS07: Data Tier Applications in Visual Studio 2010
Charlie Carson
Come explore the new enhancements in SQL Server 2008 R2, known as Application and Multi-Server Management, which enable a more efficient way to develop, deploy, and manage data-tier applications and instances. See how a new single unit of deployment for database applications is integrated with Microsoft Visual Studio and helps enable developers to more quickly write higher quality database applications, author deployment policies based on the needs of their applications, and hand off a single package to database administrators. Also, learn how improvements combine a first-class Transact-SQL IDE with a new Visual Studio 2010 project template known as .DACPAC (Database Application Component) to produce a comprehensive model of the objects, policies, and runtime resources required by a data-tier application.

SMS11: Developing Rich Reporting Solutions with Microsoft SQL Server 2008 R2
Sean Boon
Did you always want to be the hero and build professional looking reports in a few clicks? Do you need to empower your users to build their own reports? Do you need to light up your applications with interactive reports? This session will walk you through the latest improvements of SSRS 2008 R2 by showing you how to build reports with Maps, Data bars, Sparklines, and indicators with a few mouse clicks by simply using the new Report part gallery. This session will also demo the new report manager, report viewer and new integration with SharePoint 2010.

SMS06: Developing with SQL Server Spatial: Flat Maps to Round Earth
Michael Rys
With the advent of GPS devices, spatial data is becoming increasingly more central to data processing and everyday applications. This session provides an overview for the Microsoft SQL Server 2008 spatial types and methods, focusing on some common pitfalls and differences between the flat map type geometry and round earth type geography. This session is geared towards programmers with some spatial background, but is applicable for the spatially novice audience as well.

SMS09: High Availability and Disaster Recovery for Mission Critical Applications—Best Practices and Recommendations
Darmadi Komo
Justin Erickson
Mission critical applications require careful planning to achieve maximum uptime. Various factors like availability SLAs for RPO (Recovery Point Objective) and RTO (Recovery Time Objective), log generation rates, latency, storage environment, virtualization, etc., contribute towards building the availability strategy. Come to this session to learn about how you can develop the right HADR solution for your environment. We will share the best practices and real life customer deployment experiences to reinforce key points. Technologies that we will cover include Failover Clustering, Database Mirroring, Log Shipping, Transactional Replication & Hyper-V.

SMS01: Introducing Master Data Services in SQL Server 2008 R2
Tyler Graham
Master Data Services is a component of SQL Server 2008 R2 that will enable you to improve the quality of key data assets such as products, customers, locations, accounts, cost centers and many others. Come learn how MDS can serve a wide range of analytic (dimension management) and operational (master data management) scenarios. This session will cover product architecture and include an extensive demonstration.

SMS02: Large Scale Data Warehouses with Microsoft SQL Server 2008 R2 Parallel Data Warehouse
Christian Kleinerman
This session provides an overview of the new Data Warehousing capabilities in SQL Server 2008 R2 Parallel Data Warehouse Edition. This new edition implements a Massively Parallel Processing (MPP) architecture on top of the robust scale-up capabilities of SQL Server to enable massive scale-out, into the tens and hundreds of terabytes, for the same low TCO SQL Server delivers. In collaboration with several hardware partners, SQL Server Parallel Data Warehouse will provide an appliance-like solution that lets customers customize the system to conform to their existing hardware environment.

SMS12: Managing PowerPivot for IT (Previously Project Gemini)
Sean Boon
This session focuses on the role of IT Pros in the Managed Self-Service BI environment consisting of PowerPivot for Excel and SharePoint. We will show how to setup a new SharePoint farm with PowerPivot from scratch, and also show how you can add PowerPivot into your existing SharePoint installation. We will also demonstrate the tools and services available to IT Pros for managing the PowerPivot environment, including the Management Dashboard.

SMS10: Planning a Complete BI Infrastructure for Your Business
Donald Farmer
Business Intelligence can cover a wide range of topics, from data integration and data quality, through enterprise analytics, to dashboards and end-user tools.
This session aims to help the IT professional charged with “bringing BI to the business.” We’ll survey the business and technical issues to be addressed, and we’ll equip you with a simple, but effective methodology for approaching BI problems.
You’ll return to your data center with a much better understanding of BIs benefits, but also a surer grasp of where and how to start implementing a solution effectively.

SMS03: SQL Server Consolidation Prescriptive Guidance
Justin Erickson
This session will focus on helping to choose between using virtualization, instance, or database as a SQL Server consolidation strategy. We will highlight the key areas to consider, features that are available (in SQL Server 2008 and R2) for each approach as well as provide some of the important differentiators for helping to make a decision. We will provide decision trees to help guide administrators through the process and also provide case studies and customer scenarios.

SMS08: Taking Your Database Application Beyond Relational with SQL Server 2008: A Technical Overview
Michael Rys
An increasing number of database applications need to manage not only relational data but need to manage data that does not fit the relational paradigm. In this session, we will provide an overview of the beyond relational capabilties in SQL Server 2008 that will enable such database applications to continue to leverage the benefits of the database system such as performance, scale and manageability. We will provide scenarios and overviews on managing unstructured data with Filestreams and the Remote Blob Store API, and show what is new in Fulltext Search and XML. Finally, we will showcase the new semi-structured data management capabilities such as sparse columns and filtered indexes.