Dandy WeynSr. Technical Product Manager – SQL ServerMicrosoft Corp.

12 reasons to @ilikesql

Any Data, Any Size, Anywhere

Immersive Experiences,

Wherever You Are

New World of DataA Major Step With SQL Server 2012

MISSION CRITICAL CONFIDENCE

BREAKTHROUGH INSIGHT

CLOUD ON YOUR TERMS

Connecting withthe World’s Data

Required 9s & Protection

Blazing Fast Performance

Organizational Compliance

Peace of Mind

Rapid Data Exploration

Managed Self-Service BI

Credible Consistent Data

Scalable Analytics & DW

Scale on Demand

Fast Time To Solution

Optimized Productivity

Extend Any Data, Anywhere

1 2 3 4 5 6

7 8 9 10 11 12

Mission Critical Confidence

DemoMission Critical Confidence

Fast Time To Solution

Industry Standard Hardware, Co-Engineered with Partners, Pre-tuned and low TCO

Scale on demand

Cloud on Your Terms

Fast time to marketOptimized

productivityExtend any data,

anywhere

DemoCloud on Your Terms

Breakthrough Insight

Rapid dataexploration

Managedself-service BI

Credible,consistent data

Big Data analytics& scalable DW

DemoBreakthrough Insights

Summary

Organizational Compliance

Optimized Productivity

11Extend Any Data, Anywhere

Fast Timeto Solution

Scalable Analytics & DW

8Credible, Consistent Data

Peace of Mind

Managed Self-Service BI

4

Rapid Data Exploration

3Blazing-Fast Performance

2Required 9s& Protection

1

Scale on Demand

5 76

12109

MISSION CRITICAL CONFIDENCE

BREAKTHROUGH INSIGHT

CLOUD ON YOUR TERMS

AlwaysOn Reliable Secondaries

FileTableColumnStore Index

15k Partitions

SQL Server Data ToolsPower View

BI Semantic Model

Data Quality Services

Full-Text Search Performance

Distributed Replay

Reporting Alerts

ODBC Driver for Linux

Statistical Semantic SearchWindows Server Core Support

Multiple Secondaries

Availability GroupsDefault Scheme for Windows Groups

T-SQL Enhancements

Full Globe Spatial

SSMS to Windows Azure Platform

PowerPivot Enhancements

Master Data Management Excel Add-in

PowerShell 2.0 Support

PHP & Java Connectivity

SQL Audit for All Editions

CDC Support for SSIS

New SSIS Design Surface

Online Operation Enhancements

Multi-site Clustering

Unstructured Data Performance

Resource Governor Enhancements

Database Recovery Advisor

HA for StreamInsight

Flexible Failover Policy

Extended Events Enhancements

Contained Database Authentication

SharePoint Active Directory Support

SQL Server Express LocalDB

User-defined Audit

Audit Filtering

Audit Resilience

FTS Support for Czech and Greek

AlwaysOn Connection Director

Ad Hoc ReportingSSIS Troubleshooting

SSIS Package Management

T-SQL Debugger Enhancements

Spatial 2D Support

Unstructured Data Performance

SQL Server Launch

Hands-on-Labs

www.microsoft.com/sqlserverlabs

dandyw@microsoft.com ILIKESQL.COM

@ilikesql

Thank you!

Dandy Weyn

© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any

information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.