SQLSERVER2014 2014年4月1日发布
SQLSERVER2014 2014年4月1日 发布 http://blogs.technet.com/b/microsoft_blog/archive/2014/03/18/sql-server-2014-released-to-manufacturers-will-be-generally-available-april-1.aspx 吸引眼球的地方: 首个云数据平台 in-memory 内存技术(In-Memory O
SQLSERVER2014 2014年4月1日发布
http://blogs.technet.com/b/microsoft_blog/archive/2014/03/18/sql-server-2014-released-to-manufacturers-will-be-generally-available-april-1.aspx
吸引眼球的地方:
首个云数据平台
in-memory 内存技术(In-Memory OLTP 性能提升30倍,每秒处理250,000请求)
Today I am very happy to announce SQL Server 2014 has been released to manufacturing and will be generally available on April 1.
SQL Server 2014 is the culmination of thousands of hours of hard work from Microsoft engineers and thousands of hours of testing
and input from our preview customers. The result is an important component of Microsoft’s overall cloud-first data platform.
The platform delivers breakthrough performance, accelerated insights through tools everyone uses
and the ability to scale globally on-premises and in the cloud – letting our customers get the most from their data.
This release of SQL Server is significant in that, in addition to delivering key hybrid scenarios, it rounds out our journey to
embrace in-memory technology(拥抱in-memory内存技术). Several years back, we began exploring the changing hardware
landscape – memory being one of the key areas of focus. Today, our in-memory technology spans the core workloads in the data platform:
business intelligence as part of Analysis Services, Excel and Power BI for Office 365; complex event processing with StreamInsight; in-memory columnstore in SQL Server and our data warehousing product; and now with SQL Server 2014 – in-memory transaction processing.
The completeness of Microsoft’s data platform and the strength of its mission-critical capabilities are the reasons our customers increasingly
build on and deploy SQL Server. It has garnered market share and industry recognition because it meets the increasingly
demanding needs of business customers of all sizes. SQL Server is the most widely-deployed database in the world and continues to gain revenue share at the expense of our competitors. Our data platform has surpassed our competitors in key technology areas like cloud, in-memory
and business intelligence. With SQL Server 2014, we’ll continue to build on that momentum with an enterprise-ready, mission-critical database.
Built-in in-memory technology for faster application performance
What I am most proud of is that the technology innovations we’re delivering today in SQL Server 2014
help customers create new business value and open up new possibilities and opportunities with data.
In-memory transaction processing
(In-Memory OLTP), speeds up an already very fast experience by delivering speed improvement of up to 30x.
For a company like bwin, the largest regulated online gaming company, faster processing means not only can they serve more customers
by scaling their applications to 250,000 requests a second, but it means the experience their customers have
with their application is better, faster and smoother. It is exciting to see what customers can do
when raw performance and throughput of a database changes this dramatically.
Important to our in-memory work is our approach to build SQL Server’s In-Memory OLTP right into the box.
This means our customers don’t need expensive additional software to take advantage of the technology.
More importantly, it means customers do not have to rewrite their application or deploy new servers. We approached in-memory columnstore the same way – it is built into SQL Server and our data warehouse product Parallel Data Warehouse. Our customers have appreciated this approach, and it sets us apart from our competitors.
Hybrid cloud capabilities offer greater flexibility
The other key area of investment for SQL Server 2014 has been hybrid features that span the cloud and on-premises,
giving customers a choice in how they deploy database solutions. Customers can easily and securely backup and recover on-premises
SQL Server databases using Windows Azure. SQL Server 2014’s AlwaysOn technology was not just improved for this release,
it was built to enroll Windows Azure virtual machines running SQL Server into a customers’ disaster recovery solution.
This turnkey solution builds on SQL Server 2014 availability in Windows Azure virtual machines – one can get SQL Server with its in-memory
and mission-critical features up and running in an Azure VM in literally a few minutes. SQL Server 2014 will be available in a Windows Azure virtual machine image as part of general availability on April 1.
Windows Azure and SQL Server provide a continuum of capability and flexibility in deployment options for our customers – on-premises
and in the cloud. Windows Azure also supports an important data workload – Windows Azure HDInsight, our Apache Hadoop-based solution
in the cloud. Today, we’re announcing the general availability of Hadoop 2.2 support in Windows Azure HDInsight,
which has been updated to take full advantage of the latest Hadoop 2.2 platform, including support for YARN and Stinger Phase 2.
There has never been a more exciting time in the database and broader data platform industry.
In an era where nearly everything will become digitized, today we’re delivering the data platform that will help our customers digitize their business. Customers can download SQL Server 2014 on April 1 or register today to be notified once the release is available.
Customers can also learn more about the release and our data platform strategy at our “Accelerate your Insights” event on April 15,
where I will be joined by Microsoft CEO Satya Nadella and COO Kevin Turner. In addition, some of our customers deriving value from
our data platform today will also be in attendance. I encourage you save the date and tune in for the event.

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

"Usage of Division Operation in OracleSQL" In OracleSQL, division operation is one of the common mathematical operations. During data query and processing, division operations can help us calculate the ratio between fields or derive the logical relationship between specific values. This article will introduce the usage of division operation in OracleSQL and provide specific code examples. 1. Two ways of division operations in OracleSQL In OracleSQL, division operations can be performed in two different ways.

Interpretation of MyBatis dynamic SQL tags: Detailed explanation of Set tag usage MyBatis is an excellent persistence layer framework. It provides a wealth of dynamic SQL tags and can flexibly construct database operation statements. Among them, the Set tag is used to generate the SET clause in the UPDATE statement, which is very commonly used in update operations. This article will explain in detail the usage of the Set tag in MyBatis and demonstrate its functionality through specific code examples. What is Set tag Set tag is used in MyBati

What is Identity in SQL? Specific code examples are needed. In SQL, Identity is a special data type used to generate auto-incrementing numbers. It is often used to uniquely identify each row of data in a table. The Identity column is often used in conjunction with the primary key column to ensure that each record has a unique identifier. This article will detail how to use Identity and some practical code examples. The basic way to use Identity is to use Identit when creating a table.

Solution: 1. Check whether the logged-in user has sufficient permissions to access or operate the database, and ensure that the user has the correct permissions; 2. Check whether the account of the SQL Server service has permission to access the specified file or folder, and ensure that the account Have sufficient permissions to read and write the file or folder; 3. Check whether the specified database file has been opened or locked by other processes, try to close or release the file, and rerun the query; 4. Try as administrator Run Management Studio as etc.

How to use SQL statements for data aggregation and statistics in MySQL? Data aggregation and statistics are very important steps when performing data analysis and statistics. As a powerful relational database management system, MySQL provides a wealth of aggregation and statistical functions, which can easily perform data aggregation and statistical operations. This article will introduce the method of using SQL statements to perform data aggregation and statistics in MySQL, and provide specific code examples. 1. Use the COUNT function for counting. The COUNT function is the most commonly used

Database technology competition: What are the differences between Oracle and SQL? In the database field, Oracle and SQL Server are two highly respected relational database management systems. Although they both belong to the category of relational databases, there are many differences between them. In this article, we will delve into the differences between Oracle and SQL Server, as well as their features and advantages in practical applications. First of all, there are differences in syntax between Oracle and SQL Server.
