SQLServer2014withEmbargoBIeditsFINAL(053020.ppt_第1页
SQLServer2014withEmbargoBIeditsFINAL(053020.ppt_第2页
SQLServer2014withEmbargoBIeditsFINAL(053020.ppt_第3页
SQLServer2014withEmbargoBIeditsFINAL(053020.ppt_第4页
SQLServer2014withEmbargoBIeditsFINAL(053020.ppt_第5页
已阅读5页,还剩27页未读, 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

1、SQL Server 2014 and the Data Platform,DEVELOPMENT,MANAGEMENT,IDENTITY,VIRTUALIZATION,DATA,The Cloud OS,Transforms the datacenter Empowers people-centric IT Unlocks insights on any data Enables modern business applications,“By 2015, business revenues from IT innovation enabled by the cloud could reac

2、h US$1.1 trillion a year.” IDC,In-Memory now a viable solution,Key Trends,$1.1Trillion Enabled by cloud innovation,90%,1957,1962,1967,1972,1982,1987,1992,1997,2002,2007,2012,1977,Of the worlds data has been created in the last two years,10 x increase every five years,85% from new data types,Data Exp

3、losion,Volume Velocity Variety,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,AlwaysO

4、n 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 plat

5、form,SQL Server 2014 and the Data Platform,Mission Critical Performance,Faster Insights from Any Data,Platform for Hybrid Cloud,Mission Critical Performance,In-Memory Built-In Average 10 x faster for new and existing SQL Server apps Secure & Scalable Most secure with enterprise scale using Windows S

6、erver High Availability The 9s you need, with AlwaysOn Mission Critical Support Live support designed for mission critical solutions,7x Faster Performance Enables Real Time Updates,Business Challenge SAAS provider to large retailers wanted to increase inventory availability refresh speed to improve

7、customer satisfaction,Key Benefits Increased sales with greater throughput and improved customer satisfaction 7x faster performance enables near real time inventory updates,In-Memory Built-In,Select only highly utilized tables to be in-memory Optimize in-memory to fit existing hardware,In-memory per

8、formance across OLTP, DW and BI All in a single SKU,On average 10 x faster, without having rewrite entire app Leverage full SQL Server capabilities,Built-in,Flexible,Spans All Workloads,Database Vulnerabilities,Most utilizeddatabase in the world,Least vulnerabledatabase,Secure,46% Market share,5year

9、s in a row,*National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013, Market share from IDC 2013,SQL Server 2014 Resource Governance,Up 640 logical processors 64 vCPUs/VM 1 TB memory/VM 64 nodes/cluster,Network virtualization provides flexibility and isolation As

10、sign minimum and maximum bandwidth,Storage virtualization Enterprise-class network storage on standard hardware Storage tiering for higher performance,Scalable,Scale Compute,Scale Networking,Scale Storage,Pool 1,Pool 2,Pool 3,App 1,App 2,App 3,App 6,App 4,App 5,High Availability,Multi-DB failover, m

11、anual 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,Increased Availability,Efficient,Easy to Deploy & Manage,Unif

12、ied HA/DR Solution,Primary,Secondary 2 Running BI Workloads,Secondary 1 Running Back-ups,Synchronous data movement,Asynchronous data movement,AG_Listener,Mission Critical Support,Prioritized 24x7 problem resolution Access to advanced technical training,Solution validation & architectural reviews On-

13、site solution-engineering expertise Fastest response times available from Microsoft,Ecosystem of 70,000+ SQL Server Partners,Premier Support,With Premier Mission Critical,SQL Server 2014 and the Data Platform,Mission Critical Performance,Faster Insights from Any Data,Platform for Hybrid Cloud,Faster

14、 Insights from Any Data,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 2013 Complete BI platform Scale your BI models a

15、nd enrich and secure your data with a complete platform spanning cloud and on-premises,Syndromic SurveillancePlatform,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

16、Spot outbreaks in near real-time Combine on-prem structured data with hand written notes & social media feeds,Local Data Mart,National Data Mart,“This will reinvent the way we work with medical records in the future.” Paul Henderson BI Division Head,Easy Access to Data, Big & Small,Key Features,Sear

17、ch, Access & Shape,Combine with Unstructured,Easily Manage & Query,Simplify access to public & corporate data Easily preview, shape, & format your data,Combine and refine data across multiple sources Gain insight across relational, unstructured, & semi-structured data,Common management of structured

18、 & unstructured data Query across relational DB & Hadoop with single T-SQL Query,Project Codename “Data Explorer” Windows Azure Marketplace Windows Azure HDInsight Service & Microsoft HDInsight Server (preview) 100% Apache Parallel Data Warehouse with Polybase,Powerful Insights with Familiar Tools,M

19、odel & Mash-up,Visualize & Analyze,Connect & Collaborate,Access and mash-up data from virtually any source Model data using familiar tools,Generate insights fast with powerful data visualizations Quickly analyze up to millions of rows of data in Excel with PowerPivot and Power View,Connect & collabo

20、rate around data Easily share insights for improved decision making,Powerful Insights with Familiar Tools,Model & Mash-up,Visualize & Analyze,Connect & Collaborate,Access and mash-up data from virtually any source Model data using familiar tools,Generate insights fast with powerful data visualizatio

21、ns Quickly analyze up to millions of rows of data in Excel with PowerPivot and Power View,Connect & collaborate around data Easily share insights for improved decision making Mobile Clients for any device,Complete BI Platform,Quality & Accuracy,Scale User-driven BI,Security, Governance & Compliance,

22、Cleanse data and improve data quality Seamlessly integrate data from any source,Complete and enterprise-grade BI platform Build and deploy secure & scalable BI solutions,Empower business users to manage data governance Deliver credible, consistent data to the right users,SQL Server 2014 and the Data

23、 Platform,Mission Critical Performance,Faster Insights from Any Data,Platform for Hybrid Cloud,Platform for Hybrid Cloud,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 Serve

24、r in the cloud to gain benefits of cloud computing Complete & Consistent Deploy a complete and consistent data platform from on-premises to cloud,SQL Database service is a “Game Changer” Leads to greater revenue,Business Challenge Cost effective solution to deal with massively variable demand for on

25、line ticket sales,Key Benefits 150,000 ticket sales in 10 seconds Massive scale out Manage compliance,Hybrid Cloud Solutions,Manual or Automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency,Fast disaster recovery (low RTO) Easy to deploy & manage

26、,Cloud bursting Greater global reach Better isolation of internal assets,Simplified Cloud Backup,Cloud Disaster Recovery,Extend On-Prem Apps,Hybrid Cloud Solutions,Fast disaster recovery (low RTO) Easy to deploy & manage,Cloud bursting Greater global reach Better isolation of internal assets,Simplif

27、ied Cloud Backup,Cloud Disaster Recovery,Extend On-Prem Apps,Manual or Automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency,Hybrid Cloud Solutions,Fast disaster recovery (low RTO) Easy to deploy & manage,Cloud bursting Greater global reach Bett

28、er isolation of internal assets,Simplified Cloud Backup,Cloud Disaster Recovery,Extend On-Prem Apps,Manual or Automatic At an instance level with point in time restore Measures DB usage patterns to set backup frequency,Gain Cloud Scale by Extending On-Prem Apps,On-Premise Network,SQL Servers,Domain

29、Controller (authenticating all users on-prem & cloud),VPN Tunnel Windows Azure Virtual Network,Windows Azure,Windows Azure Load Balancer,Web Servers,Linked Server,Easy On-Ramp to Cloud,Easily migrate on-prem SQL Server to a Windows Azure VM Designed for users unfamiliar with Windows Azure,Ideal for

30、existing apps & dev/test new apps Full SQL Server functionality Full VM control,Ideal for new variable-demand apps Dynamic scale-out of database No patching of OS or DB HA built-in with 99.9% SLA,New Migration Wizard,SQL Server in a Windows Azure VM,Windows Azure SQL Database service,Cloud Migration Wizard,DB,Complete & Consistent Data Platform,Off-Premises,Microsoft Cloud,On-Premises Data Center,SQL Server in a Windows Az

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论