SQL Server 20,165 Big Advantage Mining Enterprise user data value

SQL Server 20,165 Big Advantage Mining Enterprise user data value

Reprinted from: http://soft.zdnet.com.cn/software_zone/2016/0318/3074442.shtml

Microsoft hosted a "Data driven" event in New York, USA on March 10, and officially released a new generation of SQL Server 2016.

At the same time, two explosive messages were attached: Microsoft opened SQL Server 2016 to Linux, and also released a migration tool for Oracle databases, along with the associated migration incentives.

The industry has made a variety of speculations and speculations about these two messages.

A week later, SQL Server 2016 met with Chinese business users in Beijing, although Microsoft's performance still made it easy to feel its ambitions for Oracle database market share,

But more importantly, Microsoft's confidence in SQL Server 2016 for enterprise data mining.

The meaning of data
According to a study published by IDC, as long as the data are properly managed and analyzed, it can bring immediate economic benefits to the enterprise. If you can harness diverse data sources, leverage new analytics, provide more timely data insights for business members, and accelerate decision-making, the data will bring business value equivalent to $1.6 trillion for businesses worldwide.

In the eyes of Microsoft Global vice President and chief operating officer of Greater China Philippe Rogge, ThyssenKrupp Elevator's experience is sufficient to demonstrate the significance of data for business innovation and transformation.

"ThyssenKrupp Associates all of its elevators with data such as temperature, humidity, operating altitude and passenger status in the event of a failure,

Through analysis, it is possible to predict the conditions under which an elevator may fail, and to deal with possible faults in advance against the predicted results. Using predictive data models, ThyssenKrupp significantly reduces the risk of elevator operation,

Savings in maintenance and management costs. Philippe Rogge said that ThyssenKrupp's data exists in Microsoft's database, and Microsoft's database software plays an important role in the process of digging up data and using data.

But it is not the most fascinating experience for ThyssenKrupp to use data to reduce its own operating costs and risks, and it is even more fascinating that ThyssenKrupp sold the data model to its competitors in the form of services to help them maintain the elevator,

So as to achieve their own business transformation. Philippe Rogge that all of this is data-driven.

Data is everywhere, but the right tools are needed to extract insight into the wisdom that can guide decisions and create value. SQL Server as a widely deployed, cost-effective database product,

In the Chinese market has also been different industries, different sizes of enterprise customers recognition and affirmation. Cao, deputy director of Peking University Stomatological Hospital Information Center , said that Peking University's oral cavity has been updated since his system .

has been the use of PC server +sql server approach, from years of application, the stability of SQL Server is very good, the daily CPU occupancy rate is only 10%.

It is understood that at present, Peking University oral cavity as the national famous specialized hospital, the daily outpatient quantity can reach 4000~5000 person. Unlike the General hospital, the difficulty of data in the dental hospital system lies in the complex data flow.

Cao Strong introduction: "A periodontal examination big table to correspond to 1000 tables , each table data should correspond to correct, can not appear the slightest mistake, its complexity is conceivable."

"Such a complex data flow requires a high level of stability and logic for the database. At present, the Peking University oral SQL Server database has not shut down for two consecutive years, does not restart, the stability is very good .

In addition, Cao that he was most impressed by SQL Server's ability to manage unstructured documents as a structured database. "Every patient comes to an oral hospital, almost all of them have to take a dental film,

At present, the dental Tablet of Peking University oral cavity has hundreds of Gb,sql server calls to it is still very fast. Cao Qiang also indicated that it was very interested in the newly added R language features in SQL Server 2016 .

For Data Insights
In a keynote speech last week, Microsoft CEO Satya said: "The world is undergoing a digital transformation, the fourth industrial Revolution following the steam engine, electricity and information technology."

Data is the ' new power ' that drives the fourth industrial Revolution, and the new SQL Server 2016 will help us unlock insights, uncover intelligence, and predict the future from data. ”

Microsoft is confident about SQL Server 2016, and it doesn't seem to have any reason. In a series of Magic Quadrant reports recently released by Gartner,

Microsoft SQL Server is ranked as the "leader" in the Magic Quadrant for Business Database management systems, data warehousing and analytical data management solutions, business intelligence and analytics platform forces, and advanced analytics platforms.

As a new database born in the cloud, SQL Server 2016 is designed to fully blend data, intelligence, cloud computing technology trends, providing powerful performance, complete security, flexible cloud expansion capabilities,

and data intelligence at your fingertips.

Lindsey Allen, Microsoft's chief SQL Server team project Manager , said that the mission of SQL Server 2016 was to help companies uncover data intelligence and take advantage of the increasingly competitive data transformation.

As the most feature-rich version of SQL Server history, SQL Server 2016 combines data processing, data intelligence, and business Analytics to meet the full range of business needs of the enterprise.

According to Lindsey Allen, the following five major advantages allow SQL Server 2016 to meet the needs of a digital transformation enterprise.

Improved data processing performance. SQL Server 2016 improves OLTP transactions by 30 times times with real-time memory technology, and upgradeable memory-Columnstore Technologies (Columnstore) enable analysis to be up to 100 times times faster,

The query time is reduced from a few minutes to just a few seconds.
New security features. SQL Server 2016 has added a series of security features, always encrypted (all Encrypted) to protect the data in transit and after storage security;

Transparent Data encryption (encryption) enables all user data encryption with minimal system resources, support for version 1.2 secure Transport Layer Protocol (TLS) ,

Enhanced its ability to protect against malicious attacks, while Dynamic Data masking (DDM) and row-level security (RLS) allow developers to limit specific users when developing applications to secure data.
Born in the cloud. Most of the features of SQL Server 2016 have been tested and deployed on the Microsoft Azure Public Cloud, which covers 22 data centers worldwide and handles billions of of requests every day.

SQL Server and applications developed on top of it can be deployed and run on Enterprise private cloud, hosted cloud, and Microsoft Azure Public cloud services.

The new Stretch database technology allows customers to dynamically, transparently and securely extend their transactional data to Azure at any time, creating truly super-large databases at a more cost-effective level.

In addition, customers can leverage a new, real-time, high-availability model for low-cost disaster preparedness management.
end-to-end mobile bi. SQL Server 2016 provides real-time analysis and prediction of operational and analytical data through support for R language , advanced analytics capabilities;

Power BI is responsible for translating data insights into real-time insight into business insights that are visible to decision makers in every business process, leveraging new mobile intelligence applications,

Users can get data intelligence insights at any time on mobile devices on different platforms, such as iOS, Android, and Windows phone.
Cost advantage. In the same application environment (two 8-core processors run OLTP, business intelligence, data warehousing, advanced analytics, ETL tools, etc.) and Oracle database to compare and calculate,

The results show that users who choose SQL Server 2016 can save up to $10 million in 3 years of input.
At the same time, Microsoft offers a free migration tool, SQL Server Migration Assistant, to help users with the migration from Oracle, Sybase, MySQL to SQL Server 2016 70%~75% ，

The rest needs to be done through the services provided by the partner.

Embrace Linux
Opening SQL Server 2016 to Linux is undoubtedly a blockbuster for the industry,

This enables SQL Server to truly become a data platform that seamlessly connects Windows Server to Linux systems, between users ' on-premises data centers and cloud environments.

Microsoft now offers a limited preview of the core database capabilities of SQL Server for Linux, and is scheduled for formal business in 2017.

In recent years, Microsoft has been known for its openness to open SQL Server to Linux as well as office and Outlook into iOS and Android platforms and Hdinsight into Linux.

Lindsey Allen says Microsoft will gradually develop the functionality of the Linux version of SQL Server, which is gradually open to users after testing.

Microsoft's launch of Linux-oriented SQL Server has been widely welcomed and recognised by the industry, said Al Gillen, group vice president of corporate infrastructure at IDC, "by introducing this key product on Linux,

Microsoft has fulfilled its commitment to become a cross-platform solution provider. This gives customers more choice and eliminates the obsession with operating system constraints. We believe that this will accelerate SQL Server's overall market share increase. ”

Huawei has been the first in its "Kunlun" series of servers on the Linux version of the SQL Server Preview version of the integration of software and hardware integrated evaluation.

"Huawei is actively responding to Central's demand for ' technological innovation '," said Zhang Huahua, the head of Huawei's IT product line, "actively layout domestic high-end servers and storage devices, and has achieved good results."

To meet customer demand for cloud computing, big data, and high performance computing, Huawei's IT product line is partnering with Microsoft to

In the Huawei ' Kunlun ' series of 16-way, 32-channel open architecture minicomputer , the new version of SQL Server in memory computing and Linux operating system support to provide a series of features are thoroughly tested.

We hope to cooperate with Microsoft, promote the integration of hardware and software, for the ' Internet + ' strategy of Chinese enterprise users of the data transformation, to provide the best cost-effective choice.

Microsoft is open-minded to achieve product, service, technology innovation, so that more users in their own choice of environment, in their own familiar way to enjoy the advantages of Microsoft technology.

Microsoft recently acquired Xamarin and launched Microsoft R Server to provide better support for Hadoop and Teradata to meet the diverse needs of a wider range of users.

At present, more than 8,000 companies have registered, including the "World Fortune 500" enterprises in the 25%.

With the release of the new SQL Server 2016, Microsoft has demonstrated a vision of the future that is intertwined with data, intelligence and cloud computing, and is committed to driving the innovation and transformation of business in the digital transformation era.

SQL Server 20,165 Benefits Mining Enterprise User data value