MSDN Release sql server2014 preview , Here's the picture :

SQL Server 2014 New characteristics :

Microsoft SQL Server Head of Department Eron Kelly Introduce , By putting transaction processing into memory , new SQL Server 2014 It can improve the performance in the test 50 More than times . In the new version ,DBA There are two options , They can set which database instances or tables to put into memory . It will also provide a diagnostic tool , Can be DBA Offer advice . And the table granularity is SQL Server 2014 The biggest difference from other memory databases .

Kelly say :“ You can put selected tables in memory , The others are in Hard disk On . So you don't need to buy high-end hardware . This is what we do with SAP HANA The difference between , Using the existing hardware devices can fully show the advantages of Microsoft memory database .”

In addition to the in memory database ,SQL Server 2014 There are also some new features to watch out for .

The first is the new column storage index technology , be called xVelocity ColumnStore. It can continuously load data , At the same time, column storage index can make SQL Server Compressing data in an index , So as to further improve the query performance . It is associated with SQL Server 2012 What's the difference between the column store index in ? stay SQL Server 2012 in , After you convert the table to column storage mode , The data cannot be changed in the index . and SQL Server 2014 You can load and delete data in the existing column storage index .

Another new feature is fast backup to Windows Azure SQL Database( Microsoft cloud database ). stay SQL Server 2014 in ,DBA Can be in SSMS Right click , Choice in Azure Create a second and third database backup under , For disaster recovery .

Kelly Introduce ,SQL Server 2014 A new data storage management function will also be added in , Be similar to Oracle Database 12c Database heat map of ( Reference resources :Oracle Database 12c 12 new features of ).DBA It can be used to store active data in a solid state Hard disk On , Other relative “ cold ” On a regular hard disk .

 

Introduction SQL Server 2012 when , Microsoft will import the new column storage function into its database . But column storage is just a memory index . stay SQL Server 2014 in , This column storage function has been upgraded , Faster queries , The data is further compressed , It brings users more real-time analysis and processing ability .

SQL Server 2014 It also provides buffer pool expansion for SSDs , So paging is faster . Microsoft is improving AlwaysOn technology , This technology has also been introduced into SQL Server 2012, So it can meet the requirements of mission critical , Thus, as many as eight L2 caches can be read , And it doesn't affect its operation during online indexing .

SQL Server 2014 Would be right Windows Azure Provide simpler and more seamless backup , Users can back up their company's data to the cloud at the instance level , Achieve disaster recovery . Backup can be done automatically or manually , If necessary , Backup data can be recovered to Windows Azure In the virtual machine .

sql server 2014 More related articles in the preview

  1. Microsoft released Windows Server 2016 Preview, Third Edition , Developers need to focus on Nano Server

    Microsoft has released Windows Server 2016 and System Center 2016 Third Technology Preview , It's already available for download .Windows Server 2016 The third version of the technology preview is also the first to include ...

  2. Window 7 Platform IE11 Browser preview release

    After that Windows 8.1 brought IE11 After browser , today Window 7 as well as Windows Server 2008 R2 Platform IE11 The browser preview has also been released . Of course, this is just a developer preview , Probably ...

  3. PHP Professional development IDE——Zend Studio 10.5 Preview release

    Zend Studio It's a new generation of PHP IDE, Efficient development and maintenance PHP Code is at the heart of it .Zend The company has now released Zend Studio 10.5 preview , The preview version improves the ability of quick response and error checking . Therefore use ...

  4. Windows Server 2019 Preview Introduction

    stay Windows server 2012.Windows server 2016 Before it's fully popularized , yesterday Windows Server Team announced that Windows Server 2019 Will be in 2018 The second half of the year ...

  5. VS2019 The preview version has been released

     VS2019 The official version has been released :https://www.cnblogs.com/zhaogaojian/p/10648904.html 1. Click to download https://visualstudio.microso ...

  6. Windows Server 2016 Preview download

    Download address : Window Server 2016 Technical Preview 3 http://care.dlservice.microsoft.com/dl/download/7/3/C/7 ...

  7. Finally waiting for you ! Microsoft officially launched Windows Terminal preview

    Some time ago , All the time . The tech community receives the ultimate torture from tech buddies : Microsoft Build What was mentioned at the conference **6 Mid month ** Go up Windows store Of Windows Terminal When can I use it ? Yes ...

  8. news :SQL Server 2017(vNext) The third public CTP( Community Technology Preview ) Released

    I saw a news today , Share with you , If you are interested, you can try . SQL Server 2017 CTP3 On 5 month 23 Date issued , The detailed version number is 6.7.55.0. You can try to install it . On the download page , At present, it is SQL  ...

  9. SQL Server 2014 BI New characteristics ( 3、 ... and )Power Query and Power Map Function preview

    Power Query and Power Map It's Microsoft not long ago WPC Posted on Power BI Zhongxin aims at Excel The function of . With these two functions , Self help BI It will be more convenient for you to find and process data and enrich the visualization function of data . Powe ...

Random recommendation

  1. md5 application

    /* md5 Tool class */ public class MD5Util { /** Global array **/ private final static String[] strDigits = { "0&q ...

  2. Selling dog meat to deceive readers —— Tan Haoqiang 《C Programming ( The Fourth Edition )》 The so-called “ according to C99”( Two )

    Selling dog meat to deceive readers —— Tan Haoqiang <C Programming ( The Fourth Edition )> The so-called “ according to C99”( Two ) stay < Tan C>p4:“ The narration of this book is based on C99 Based on standards ”, The following from C89 To C99 In terms of the main changes ...

  3. .htaccess according to IP Address restricted access

    shielding IP Address shielding IP Addresses are sometimes very necessary , For example, for a foreign trade company website , A visit from home will not bring any economic benefits , And it takes up server resources , Cause access delay and other problems . If you want to block a particular IP have access to : order ...

  4. ok6410 android driver(3)

    This article discusses the Makefile and how to port the module to different platform (localhost and ...

  5. iOS “ Get verification code ” The countdown function of the button

    iOS There are many implementation details for the countdown of ,Cocoa Touch For us NSTimer Classes and GCD Of dispatch_source_set_timer Methods to use the timer more conveniently . We can also easily ...

  6. c Introduction to the basic knowledge of language learning ( 3、 ... and ):scanf function

    This section continues with c The basic knowledge of language . scanf function : It is used to receive data input by users . grammar :scanf(" Format controls ", Address list ); You need to use the address symbol to get the address :&(shift+7) example ...

  7. turn :ReportViewer Control method

    a. ReportViewer relation Report1.rdlc A simple presentation of b. For Report1.rdlc Presentation c. Using program generated DataSet Fill in the report d. Calling stored procedure Generate DataSe ...

  8. How to go from Terminal Command Line Compile and run Scope

    Ubuntu SDK Most of our developers are very effective . It can even help us debug online . In this article , We introduced how to use command line Compile and execute our scope. 1) Create a master Scope We can ...

  9. JavaScript Deep copies of objects and arrays in

    Arrays or deep copies of objects are often used in interviews and in our projects , Below I summarize to share with you . The first thing to know is what is a deep copy ? What is shallow copy ? Deep copy : The source and copy objects are independent of each other , Any change to one of these objects will not affect the other ...

  10. Hadoop Of namenode Management mechanism of , Working mechanism and datanode How it works

    HDFS Preface : 1) design idea Divide and rule : Put big papers . Lots of files , Distributed storage on a large number of servers , In order to take a divide and conquer approach to the operation and analysis of massive data : 2) In the big data system : For all kinds of distributed computing framework ( Such as :mapr ...