SQL Server 14 - rhipe

SQL Server 2014: The Data Platform for the Cloud. 1. The Evolution of Microsoft Data Platform. SQL Server. 2000. SQL Server. 2005. SQL Server. 2008.
展开查看详情

1.SQL Server 2014: The Data Platform for the Cloud 1

2.The Evolution of Microsoft Data Platform SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 XML ● KPIs Management Studio ● Mirroring Compression ● Policy-Based Mgmt ● Programmability PowerPivot ● SharePoint Integration ● Master Data Services AlwaysOn ● ColumnStore Index ● Data Quality Services ● Power View ● Cloud Connectivity Mission Critical & Cloud Performance Cloud-Ready Self-Service BI SQL Server 2014 In-Memory Across Workloads ● Performance & Scale ● Hybrid Cloud Optimized ● HDInsight ● Cloud BI Performance & Productivity Mission Critical Modern DB platform 2

3.SQL Server 2014 as an Enterprise Customer Data Platform Mission Critical Performance Faster Insights from Any Data Platform for Hybrid Cloud In-Memory Built-In Average 10x faster for new and existing SQL Server apps Secure & Scalable Most secure with enterprise scale using Windows Server High Availability The 9’s you need, with AlwaysOn Mission Critical Support Live support designed for mission critical solutions Easy access to data, big & small Search, access, and shape internal and external data, and combine with unstructured data Powerful insights with familiar tools Speed up analysis and time to insight with the familiarity of Excel in Office and Office 365 and access via mobile devices Complete BI platform Scale your BI models and enrich and secure your data with a complete platform spanning cloud and on-premises Hybrid Cloud Solutions Enable new hybrid scenarios like cloud backup and cloud DR to reduce costs and improve on-premises DR Easy On-Ramp to Cloud Easily migrate and run SQL Server in the cloud to gain benefits of cloud computing Complete & Consistent Deploy a complete and consistent data platform from on-premises to cloud 3

4.SQL Server 2014 as an Enterprise Customer Data Platform Mission Critical Performance Faster Insights from Any Data Platform for Hybrid Cloud In-Memory Built-In Average 10x faster for new and existing SQL Server apps Secure & Scalable Most secure with enterprise scale using Windows Server High Availability The 9’s you need, with AlwaysOn Mission Critical Support Live support designed for mission critical solutions Easy access to data, big & small Search, access, and shape internal and external data, and combine with unstructured data Powerful insights with familiar tools Speed up analysis and time to insight with the familiarity of Excel in Office and Office 365 and access via mobile devices Complete BI platform Scale your BI models and enrich and secure your data with a complete platform spanning cloud and on-premises Hybrid Cloud Solutions Enable new hybrid scenarios like cloud backup and cloud DR to reduce costs and improve on-premises DR Easy On-Ramp to Cloud Easily migrate and run SQL Server in the cloud to gain benefits of cloud computing Complete & Consistent Deploy a complete and consistent data platform from on-premises to cloud 3

5.In-Memory Built-In Across Workloads Select only highly utilized tables to be in-memory Optimize in-memory to fit existing hardware In-memory performance across OLTP, DW and BI All in a single SKU On average 10x faster, without having rewrite entire app Leverage full SQL Server capabilities Flexible Built-in Spans All Workloads 16x Faster With In-Memory 250,000 requests/sec OLTP SQL Server 2014 with In-Memory Bwin Game Application Offer high performance services across your offerings with In-Memory Built-In capability 5

6.Up 640 logical processors 64 vCPUs/VM, 1 TB memory/VM, 64 nodes/cluster Supports the preparation of VM templates through SQL Server SysPrep Enterprise-class network storage on standard hardware Storage virtualization / Storage tiering for higher performance Network virtualization Improved Multi-Tenancy, Scalability, and Density Scale & Density Multi-Tenant Management Cost Efficiency Storage & Network Key Scalability Features SQL Server 2014 Resource Governor adds IO governance SysPrep at c luster level Windows Server 2012 R2 Hyper-V Storage Spaces NIC Teaming Online VHDX Resize Network & Storage QoS Scalability, performance, multi-tenant management for highly scalable hosting services 6

7.AlwaysOn High Availability Enhancements Unified HA/DR Solution Primary Secondary 2 Running BI Workloads Secondary 1 Running Back-ups Synchronous data movement Asynchronous data movement AG_Listener AG AG AG Multi-DB failover, manual or automatic Up to 8 secondary replicas 100% availability during all online operations HA without expensive SANs Offload reads & backups to secondaries Deployment & management wizards Monitoring dashboard within SSMS & System Center Easy to Deploy & Manage Efficient Increased Availability Offer premium high availability services with increased SLA with SQL Server AlwaysOn 7

8.Continuous Growth of BI Capabilities Driving Analytics on any Data Web app optimization Smart meter monitoring Equipment monitoring Advertising analysis Life sciences research Fraud detection Healthcare outcomes Weather forecasting Natural resource exploration Social network analysis Churn analysis Traffic flow optimization IT infrastructure optimization Legal discovery Customer Business Scenarios INSIGHTS SELF-SERVICE | COLLABORATIVE | MOBILE | REAL-TIME NON-RELATIONAL 1 0 0 1 1 1 DATA MANAGEMENT RELATIONAL STREAMING SHARE AND GOVERN DISCOVER AND RECOMMEND TRANSFORM AND CLEAN DATA ENRICHMENT Microsoft Big Data and BI Platform 8

9.Upgrading to SQL Server 2014 What do these features mean for your business? Mission Critical Performance Capture the performance you need to run critical applications Faster Insights from Any Data Solve the Big Data problem for your business with improved BI Platform for Hybrid Cloud Embrace modern cloud computing to innovate business solutions SERVICE PROVIDER WINDOWS AZURE CUSTOMER 1 CONSISTENT PLATFORM Use the Consistent, Cloud-based Data Platform to Achieve Your Business Vision 9

10.Call to action 10

11.7x Faster Performance Enables Real Time Updates Business Challenge SAAS provider to large retailers wanted to increase inventory availability refresh speed to improve customer satisfaction Key Benefits Increased sales with greater throughput and improved customer satisfaction 7x faster performance enables near real time inventory updates Solution Before With In-Memory Daily Asynchronous Sync Online Retailers Near Real-Time S ync Online Retailers Customers Customers

12.Syndromic Surveillance Platform Identify Outbreaks in Minutes Business Challenge Healthcare software vendor sought a solution to combine different data types to help identify disease outbreaks earlier Key Benefits Spot outbreaks in near real-time Combine on-prem structured data with hand written notes & social media feeds Local Data Mart Clinical App Windows 8 App National Data Mart “This will reinvent the way we work with medical records in the future.” Paul Henderson BI Division Head Hadoop File Management Natural Language Processor Clinical App Anonymiser