SQL Server 2012 Virtual Launch Event

Agenda

Ted Kummert

Corporate Vice President, Business Platform Division, Microsoft

Join Ted Kummert as he explores the Microsoft data evolution vision. As data continues to explode, executives are facing a sea of change and exploring short and long-term solutions to handle this unprecedented more

Duration : 15 Minutes

Quentin Clark

Corporate Vice President, Database Systems Group, Microsoft

Join this launch session to get a high-level look at what’s new in SQL Server 2012, the cloud-ready information platform. Through SQL Server 2012, Quentin will address some of the tough issues facing IT more

Duration : 20 Minutes

Mission Critical Confidence

Breakthrough Insights

Cloud on Your Terms

Customer Stories

Sessions	Speakers
Independent Research on SQL Server 2012 Register for this session to join our guests Noel Yuhanna and Jeffrey North of Forrester Research to get first-hand insight into the benefits of SQL Server 2012. Duration : 20 Minutes	Jeffrey North Principal Consultant Forrester Research Noel Yuhanna Principal Analyst Forrester Research
Required 9s and Data Protection: Introduction to SQL Server 2012 AlwaysOn, New High Availability Solution This session provides an overview of AlwaysOn and explains how you can build a high availability solution using the new features and capabilities. You will learn how to deploy an AlwaysOn solution, how to utilize your secondary hardware for better return of investment and how the new solution simplifies deployment, management of high availability in your environment. The session will also describe how to manage application connectivity of your primary OLTP applications and reporting applications in an AlwaysOn environment. Duration : 20 Minutes	Santosh Balasubramanian Senior Program Manager Microsoft
Required 9s and Data Protection: Automating SQL Server AlwaysOn Management SQL Server AlwaysOn provides easy and fully guided end-to-end user experiences for configuration, failing over with confidence and monitoring the health of Availability Group. In addition, SQL Server AlwaysOn has a built-in customizability and automation capability for Availability Group management. In this session, we will recommend and demonstrate an efficient way of planning and building a custom tailored solution and automation using AlwaysOn PowerShell commandlets for your mission critical databases. Pre-requisite session: Required 9s and Data Protection: Introduction to SQL Server 2012 AlwaysOn, New High Availability Solution. Duration : 20 Minutes	Erik Kang Senior Program Manager Microsoft Will Snavely Software Development Engineer Microsoft
Required 9s and Data Protection: Protect Data with Higher Chance of Recovery - Includes Recovery Advisor In this session we will look at new backup and restore capabilities in SQL Server 2012 in order to enhance database protection for customers. Duration : 20 Minutes	Kevin Farlee Senior Program Manager Microsoft
Blazing-Fast Performance: A Technical Best Practices Tour with ColumnStore Index Go behind the scenes with SQL Server engineers for a quick technical tour of the ColumnStore Index feature and an introduction to best practices for achieving astonishing performance with your ColumnStore Indexes. Duration : 20 Minutes	Susan Price Senior Program Manager Microsoft
Blazing-Fast Performance: Explore FileTables, Full-Text Search and Semantic Search for Faster, More Meaningful Results Across Unstructured Data 80% or more of the data produced and stored are so called unstructured documents and are often not stored in the database, but often need to be managed in conjunction with relational data. In order to facilitate the storage and management of unstructured data, SQL Server has evolved from storing blobs to providing a sophisticated integration with the Windows Filesystem and provides rich services over such data to provide an interesting and compelling application development experience. This presentation introduces the new unstructured data processing capabilities of SQL Server 2012 that provide full Windows application-compatible file management over files stored in SQL Server as well as the services to unlock the information in such data such as the extensions and improvements to Full-Text Search and the introduction of semantic similarity search. Duration : 20 Minutes	Michael Rys Principal Program Manager Microsoft
Organizational Compliance: Using the New Security Features and Audit Enhancements to Increase Compliance Policies Introduction to new security features in SQL Server 2012 such as User-Defined Server Roles and enhanced Auditing to increase organization compliance. Duration : 20 Minutes	Il-Sung Lee Senior Program Manager Microsoft Jack Richins Senior Developer Lead Microsoft
Why Should Oracle DBAs Consider Microsoft SQL Server Today’s medium and large enterprises are complex entities, built on a wide range of technologies. The biggest challenge emerging for IT implementers is cross-platform database management. In a recent survey on DB trends, a third of the respondents said they expect more DB platforms to be introduced in their organizations next year. Learn why Oracle DBAs should consider becoming bilingual DBAs and how Microsoft can help them grow and advance their IT careers. Duration : 5 Minutes	Bill Ramos SQL Server Workstream Manager Advaiya Inc
EMC for SQL Server 2012 - Mission Critical with Confidence This session will discuss technical considerations for deploying highly scalable, available mission critical SQL Server environments. Key topics discussed will include how to leverage both SQL Server and your Information Infrastructure to address requirements for performance, uptime/availability, and data protection… all focused on ensuring peace of mind. Duration : 20 Minutes	Eyal Sharon Practice Manager EMC Solutions Group
SAP & SQL Server – Delivering Mission Critical Confidence Today Working together closely for over 20 years, SAP and Microsoft enjoy a strong partnership with one unified goal: create customer value. Join us to learn how Microsoft SQL Server and SAP enterprise applications deliver mission critical confidence today, and positively position customers to approach tomorrow’s business challenges with greater confidence. Duration : 20 Minutes	John Broad Senior Director, Microsoft Alliance \| Global Ecosystem & Channels Group \| SAP AG

Sessions	Speakers
Breakthrough Insights with Microsoft Big Data Are you wondering how to extract insights in a world where data is expected to grow by up to 44 times by 2020, with 85% of it coming from new sources? This session will outline how Microsoft’s Big Data solution enables you to unlock insights on all your data, including structured and unstructured data of any size. Through integration of Hadoop with powerful BI tools such as PowerPivot and Power View in SQL Server 2012, Microsoft empowers you to analyze all your data, including unstructured data from Hadoop. Duration : 20 Minutes	David Campbell Technical Fellow Microsoft
Independent Research on SQL Server 2012 Register for this session to join our guests Noel Yuhanna and Jeffrey North of Forrester Research to get first-hand insight into the benefits of SQL Server 2012. Duration : 20 Minutes	Jeffrey North Principal Consultant Forrester Research Noel Yuhanna Principal Analyst Forrester Research
Rapid Data Exploration: Empowering End User Insight Through Rapid Data Exploration and Visualization with Power View Introduction to Power View, the new thin, self-service ad hoc reporting tool. In this session we will highlight its main features, scenarios, show a demo, and discuss its relationship to other products in the BI stack (SharePoint, Excel). Duration : 20 Minutes	Carolyn Chau Lead Program Manager Microsoft
Rapid Data Exploration: Powerful Self-Service Analysis with PowerPivot Get a taste of what's new in PowerPivot, the self-service BI experience that enables information workers to build their personal and team BI applications within the familiar environment of Excel: This session will provide a quick introduction to PowerPivot, followed by demos highlighting the top 5 new modeling features delivered with the release of SQL Server 2012. Duration : 20 Minutes	Julie Strauss Senior Program Manager Microsoft
Big Data Analytics with Apache Hadoop and SQL Server 2012 In this session we will explore Apache Hadoop on Windows Server and Azure and powerful insights we can generate integrating with SQL Server. Duration : 20 Minutes	Saptak Sen Senior Product Technical Manager Microsoft
Managed Self-Service BI: End User Created, IT Managed Introduction to the BI continuum - IWs using the familiar tools like Excel, IT retaining control and governance of the workbooks. We will show how IT can manage the system in SharePoint, and how self-service BI solutions transition to managed corporate BI solutions. Duration : 20 Minutes	John Hancock Principal Program Manager Lead Microsoft
Credible, Consistent Data: Going Under the Hood with the New BI Semantic Model Introduction to the BISM, position tabular and multidimensional types of models. We will show how easy it is to create a model in PowerPivot, show how Power View is leveraging it, and highlight how easy is it to go from an individual workbook to the enterprise IT governed BI solution. Duration : 20 Minutes	Ashvini Sharma Principal Program Manager Lead Microsoft
Credible, Consistent Data: Improving Data Quality with the New Data Quality Services No matter how brilliant your BI tools are, it's garbage-in-garbage-out. This session will give an overview on the new Data Quality Services product in SQL Server 2012. Come watch this important scenario to learn how to position, sell, and demo the new DQS product. Duration : 20 Minutes	Gadi Peleg Senior Program Manager Microsoft
Credible, Consistent Data: Empowering IW / Data Experts to Efficiently Manage Important Data with the New Master Data Services Add-In for Excel Introduction to the improvements and new functionality in the SQL Server 2012 release, empowering IW to curate the organization’s important data, maintaining it accurate and relevant through its lifecycle, via easy model creation and validation. Duration : 20 Minutes	Anand Subbaraj Senior Program Manager Microsoft
Credible, Consistent Data: Introducing New Team-based Data Integration with Integration Services There are plenty of new features for SQL Server Integration Services (SSIS) in SQL Server 2012 that make it a very compelling release for your customers. This session will cover some of the highlights of the release, including the new Change Data Capture functionality. We will demonstrate how to bring together key components needed to build an effective ETL framework using SSIS. This reusable framework will show off the new functionality and productivity enhancements for existing users, and present a compelling story for customers who have never seen or used SSIS before. We will cover the end-to-end lifecycle of an SSIS solution, including how to maintain and manage the framework once it has been deployed into production. Duration : 20 Minutes	Matthew Roche Senior Program Manager Microsoft
Scalable Analytics & Data Warehousing: Fast Track Data Warehouse for SQL Server 2012 Fast Track for SQL Server 2012 has significant improvements, leveraging exciting new enhancements in SQL Server 2012 like the new xVelocity memory-optimized columnstore index feature. You will also see how Fast Track partners are working with the SQL Server team to transform the latest enhancements in server and storage technology into highly optimized data warehouse Reference Architectures. Duration : 20 Minutes	Eric Kraemer Senior Program Manager Lead Microsoft
What's new in Complex Event Processing using StreamInsight for SQL Server 2012 SQL Server 2012 includes Microsoft StreamInsight 2.0 - the next version of Microsoft's platform for complex event and stream data processing. A recent addition to StreamInsight’s capabilities is its support for checkpointing of query state which allows you to build highly available StreamInsight applications. As in previous releases, we have also made various improvements to our developer and administrator experience: the type system, the LINQ language, support for .Net 4.0, user-defined extensions, and performance counters. Join us for this session if you want to learn more about these features and see examples of how you can use them in your applications. Duration : 20 Minutes	Torsten Grabs Principal Program Manager Lead Microsoft
Why Should Oracle DBAs Consider Microsoft SQL Server Today’s medium and large enterprises are complex entities, built on a wide range of technologies. The biggest challenge emerging for IT implementers is cross-platform database management. In a recent survey on DB trends, a third of the respondents said they expect more DB platforms to be introduced in their organizations next year. Learn why Oracle DBAs should consider becoming bilingual DBAs and how Microsoft can help them grow and advance their IT careers. Duration : 5 Minutes	Bill Ramos SQL Server Workstream Manager Advaiya Inc
Enterprise Data Warehousing with SQL Server Parallel Data Warehouse Appliance Update AU3 SQL Server Parallel Data Warehouse delivers a massive parallel processing architecture (MPP) for scalability to 100sTB on your choice of open hardware standards with the lowest TCO. In the PDW Appliance Update 3 (AU3) for Parallel Data Warehouse, customers can gain breakthrough performance with the new cost-based query optimizer, even more flexibility and choice with both half and full rack options from Dell and HP and better alignment with the features you have come to expect in SQL Server. Watch this session to see how these investments add incredible value to Microsoft’s high-end data warehouse appliance offering giving customers massive scale at lowest cost. Duration : 20 Minutes	Dandy Weyn Senior Product Marketing Manager Microsoft
Extend the Power of Information to Everyone with HP and Microsoft on SQL Server 2012 Today, enterprises are faced with the ""data everywhere"" phenomenon. An unprecedented push and pull of data and information needs and a trend which Gartner predicts will grow by 650 percent during the next five years. From every workload including the largest OLTP, data warehousing, private cloud, and managed self-service BI, only HP and Microsoft integrate the hardware, software and services, on the scale you need, with industry-standard solutions that extend the power of information to everyone. Our joint portfolio of solutions accelerates time to application value for customers, improves performance and reduces the complexity and cost of deploying and running information critical data management applications. Duration : 20 Minutes	Steve Tramack Sr. Engineering Manager Hewlett-Packard

Sessions	Speakers
Building the modern enterprise with Hybrid IT In today’s modern enterprise you will likely have applications across multiple deployment environments from the Traditional non-virtualized, to Private and Public Clouds. This session will outline Microsoft’s Hybrid IT strategy and associated solutions to help you optimize your IT environment and your application portfolio. The session will focus on the database intensive application scenarios to illustrate the value a Hybrid IT environment can bring to your enterprise. Duration : 20 Minutes	Tiffany Wissner Director of Product Marketing Microsoft
Independent Research on SQL Server 2012 Register for this session to join our guests Noel Yuhanna and Jeffrey North of Forrester Research to get first-hand insight into the benefits of SQL Server 2012. Duration : 20 Minutes	Jeffrey North Principal Consultant Forrester Research Noel Yuhanna Principal Analyst Forrester Research
Scale on Demand: Optimizing SQL Server 2012 for Private Cloud SQL Server 2012 delivers a wealth of features that allow IT teams to more efficiently set up and control the database side of their private cloud environments. Some of the key enhancements include; added investments in Resource Governor for multi-tenancy environments, improvements to SysPrep for faster creation of VMs for use in the private cloud environment, and dynamic memory to better control memory on-the-fly without taking databases offline. SQL Server 2012 also aligns with System Center 2012 to best enable management through a single pane of glass for IT. Watch this demo to see how these features can help with your private cloud initiatives. Duration : 20 Minutes	Xin Jin Program Manager Microsoft
Optimized Productivity: T-SQL Enhancements SQL Server 2012 comes with an impressive addition of T-SQL functionality. These enhancements cover a range of topics such as ease-of-use, performance and improved metadata discovery. In this session Tobias will give an overview of these features and dive a bit deeper into some of them using live-coding demos. Duration : 20 Minutes	Tobias Ternstrom Senior Program Manager Lead Microsoft
Big Data Analytics with Apache Hadoop and SQL Server 2012 In this session we will explore Apache Hadoop on Windows Server and Azure and powerful insights we can generate integrating with SQL Server. Duration : 20 Minutes	Saptak Sen Senior Product Technical Manager Microsoft
Synchronizing Data “From On-Prem to Cloud” or “Cloud to Cloud” Using SQL Azure Data Sync We’ll take a look at SQL Azure Data Sync and see how it can be used to provide an on-going data synchronization for various scenarios like hybrid applications (on-prem to cloud), scale out (cloud to cloud), geo distribution (cloud to cloud across data centers) and so on. We will also show you how SQL Azure Data Sync can be used with other Azure platform capabilities like Azure Reporting Services. Duration : 20 Minutes	Mark Scurrell Senior Program Manager Lead Microsoft Sudhesh Suresh Sr. Program Manager Microsoft
Optimized Productivity: A New Unified Development Experience with SQL Server Data Tools (SSDT) Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform, both on-premises and in the Windows Azure cloud with SQL Azure. This session introduces the core features of SSDT to both DBAs and developers. Duration : 20 Minutes	Gert Drapers Principal Group Program Manager Microsoft
Peace of Mind: Scale Mission Critical Application Testing with Distributed Replay In this session we will look at a new tool in SQL Server 2012 called Distributed Replay that can be used for different types of testing using real application workloads. One of the examples we will demonstrate is how DReplay can be used to perform application compatibility testing in preparation for upgrading to SQL Server 2012. Duration : 20 Minutes	Joe Yong Senior Program Manager Microsoft
Fast Time to Solution: Introduction to HP Business Decision Appliance and HP Business Data Warehouse Appliance Understand the capabilities and use of two appliances built with HP: one for managed self service BI, and one for data warehouses up to 5TB. Duration : 20 Minutes	Dana Kaufman Principal Program Manager Microsoft
Fast Time to Solution: A Private Cloud - Understanding the HP Database Consolidation Appliance Understand what is the first Database Private Cloud appliance, what are the technologies used, business benefits, and the simplified support and deployment model. This is the first solution that out of the box delivers all the capabilities of a database private cloud and can support 100s to 1000’s of demanding workloads through powerful virtualization technology. All with a single integrated support model. Learn how you can get your private cloud running in days! Duration : 20 Minutes	Britt Johnston Principal Group Manager Microsoft
Peace of Mind: Quick Tour Through the New SQL Server Migration Assistant In this session we will review SSMA modules that automate assessment, schema conversion, data migration and testing of Oracle and Sybase migrations to SQL Server 2012. Duration : 20 Minutes	Dmitry Balin CEO and co-founder DB Best Technologies
Fast Time to Solution: Introduction to SQL Azure and Cloud Database Solutions This session will provide an overview of SQL Azure and its features. In this session we will focus on key benefits and features, and also demonstrate provisioning and managing SQL Azure databases using SQL Server Management Studio and the SQL Azure Web-based management portal. Duration : 20 Minutes	Greg Leake Director of Technical Marketing Microsoft
Scale on Demand: Enable On-demand Scale with SQL Azure Federation SQL Azure Federation is a new technology that provides the foundation for building applications that can scale to hundreds of nodes in SQL Azure. In this talk we'll look at an overview of federations and how one can build applications that can elastically engage nodes based on the application needs using a policy through federation operations. Duration : 20 Minutes	Cihan Biyikoglu Senior Program Manager Lead Microsoft
Why Should Oracle DBAs Consider Microsoft SQL Server Today’s medium and large enterprises are complex entities, built on a wide range of technologies. The biggest challenge emerging for IT implementers is cross-platform database management. In a recent survey on DB trends, a third of the respondents said they expect more DB platforms to be introduced in their organizations next year. Learn why Oracle DBAs should consider becoming bilingual DBAs and how Microsoft can help them grow and advance their IT careers. Duration : 5 Minutes	Bill Ramos SQL Server Workstream Manager Advaiya Inc

Sessions	Speakers
Interview with Paul Lisagor, Director of Data Services at Motricity Paul Lisagor, Director of Data Services discusses moving a business-critical database from Sybase IQ to the Microsoft platform. Using SQL Server 2012, Motricity quickly completed the migration of its columnar-style database. It enhanced its competitiveness and gained a high-availability solution with fast performance, rapid disaster recovery, easier management, and a quick ROI. Duration : 20 Minutes	Paul Lisagor Director of Data Services Motricity David Hobbs-Mallyon Senior Marketing Manager Microsoft
Interview with Devan Govender, Chief Software Architect at BetOnSoft Devan Govender, Chief Software Architect discusses the challenges in the gaming industry and how building hybrid applications using both SQL Server 2012 and SQL Azure allows BetOnSoft to deliver the high availability, high performance and scalable infrastructure they require. Duration : 20 Minutes	David Hobbs-Mallyon Senior Marketing Manager Microsoft Devan Govender Chief Software Architect BETONSOFT
Online Gaming Firm Implements Real-Time Analytics and Scales for Planned Growth BetOnSoft has deployed a hybrid application solution that takes advantage of the high-availability features in Microsoft SQL Server 2012 AlwaysOn and the scalability of SQL Azure. Now, the company’s infrastructure can exceed 10 times its previous peak loads while running intensive real-time data analytics. BetOnSoft has achieved the availability it needs and can use its hybrid infrastructure to scale to meet unexpected business growth. Duration : 20 Minutes	Devan Gavender
Interview with Tony Jaskeran, Head of Business Intelligence at Havas Media Tony Jaskeran, Head of Business Intelligence talks about how Havas Media is adapting to the rapidly changing world of media. Starting by developing a Business Intelligence strategy, they then built a data platform using SQL Server 2012, delivered standard insight and then used Power Pivot to deliver more powerful analytical tools that the whole business is able to use giving them significant competitive edge. Duration : 20 Minutes	David Hobbs-Mallyon Senior Marketing Manager Microsoft Tony Jaskeran Head of Business Intelligence Havas Media
Advertising Firm Boosts Client Services with Faster Reporting and New BI Capabilities Havas Media wanted to improve operations and client services with better business intelligence (BI) tools. After evaluating more than 20 solutions-including those from Oracle and IBM-Havas Media-implemented a Microsoft data warehouse and BI solution to take advantage of enhanced reporting capabilities. As a result, it has cut report generation time by 80 percent and improved customer client service. The company is more competitive with the new solution and believes that BI services will drive business growth. Duration : 20 Minutes	Tony Jaskeran
Interview with Dave Mariani, VP of Engineering at Klout Dave Mariani, VP of Engineering discusses how Klout uses big data and analytics to help consumers, advertisers and data partners leverage their influence in social media. He also talks about how Klout uses Hadoop to manage the large scale of data that they process and how they then use Microsoft SQL Server Analysis Services to query this data. This allows Klout to monitor the ecosystem, to model changes and provide insight on the data and discover patterns across the social landscape. Duration : 20 Minutes	Bruno Aziza Director Microsoft
Data Services Firm Uses Microsoft BI and Open Source to Boost Insight into Big Data Klout wanted to give clients faster, more detailed insight into hundreds of terabytes of social-network data. It also wanted to boost efficiency. To do so, Klout deployed a business intelligence solution based on Microsoft SQL Server 2012 Enterprise and open-source software. As a result, Klout processes data queries in near real time, minimizes costs, boosts efficiency, increases insight, and facilitates innovation. Duration : 20 Minutes	David Mariani

Time Until Event

FURTHER. FORWARD. FASTER.

Experience the excitement of the SQL Server 2012 Virtual Launch Event

Agenda