With SQL Server, new in-memory capabilities for transaction processing and enhancements for data warehousing complement our existing technologies for data warehousing and analytics. Scale and transform your business with up to a 30x performance gain for transaction processing using existing hardware, and a greater-than 100x performance gain for data warehousing.
 

SQL Server consistently leads in TPC-E, TPC-H and real-world application performance benchmarks. SQL Server is SAP-certified to run some of the most demanding workloads. Get more predictable performance of virtualized SQL Server instances with IO governance in Resource Governor.
 

Gain mission-critical uptime, fast failover, improved manageability, and better use of hardware resources through enhanced AlwaysOn in SQL Server, a unified solution for high availability. In SQL Server, setting up AlwaysOn becomes even easier with new Add Replica wizard, and if you are looking to implement hybrid HA using Microsoft Azure Virtual Machines, you can take advantage of new AlwaysOn templates to automate HA setup.
 

With SQL Server and Windows Server, physical processing now scales up to 640 logical processors, and virtual machines scale up to 64 logical processors. SQL Server also utilizes storage spaces and network virtualization to optimize your resources. It can also run on Windows Server Core to lower the surface area of attack.
 

Help secure data for mission critical workloads with transparent data encryption, robust auditing, extensible key management and encrypted backups. It is even easier to manage permissions for data access to support separation of duties across various users.

SQL Server Management Studio helps you centrally manage your database infrastructure, both on-premises and in the cloud. Added support for Windows PowerShell 2.0 automates management tasks and enhancements to let you more efficiently create virtual machines. Distributed Replay simplifies application testing on a single database.

 

Updated developer tools are integrated into Visual Studio and are available for download to build next-generation web, enterprise, business intelligence, and mobile applications spanning on-premises and the cloud. Customers can use industry standard APIs (ADO. NET, ODBC, JDBC, PDO, and ADO) across varied platforms including .NET, C/C++, Java, Linux, and PHP.

 

In 2017, you can run SQL server on your favorite platform, Windows, Linux, and Docker Containers. You can build modern applications by using the language of your choice, on-premises and in the cloud, no matter on Windows, Linux and Docker containers. SQL server 2017 is the least vulnerable database over the HYPERLINK "https://www. microsoft.com/en-us/sql-server/sql-server-2017" \l "footnote" last seven years in the NIST vulnerabilities database, in which data at rest and in motion are well protected. The real-time analytics at up to 1M prediction/second helps enterprises to gain transformative insights in business.
 

There are many new features and functions to be enhanced on SQL Server 2016 from the perspectives of performance and security. The industry-leading OLTP (online transaction processing) is to be built with breakthrough scalability, performance, and availability. Security is enhanced to protect data at rest and in motion by lowering the vulnerability and using a build-in-row security. End-to-end mobile BI transforms data into actionable insights with only 1/5 cost. You could also using R language to analyze data directly within the SQL Server database—without moving the data! It’s also helping you to work easier between your datacenter, private cloud, and Microsoft Azure!
 

Leverage existing skills and familiar tools like Active Directory and SQL Server Management Studio across on-premises SQL Server and Microsoft Azure. Have the flexibility to run your SQL Server workloads in Azure Virtual Machines (VM), giving you complete control of the VM. Or use Azure SQL Database service to further simplify managing your SQL Server instances while providing unique scale-out architecture.
 

Scale your BI models, enrich and help secure your data, and ensure quality and accuracy with a complete BI solution. Build comprehensive, enterprise-scale analytic solutions with Analysis Services and simplify BI model deployment with the BI Semantic Model.

 

Accelerate time-to-insight using Microsoft Excel. Search, access, and shape internal, external, structured, and unstructured data for analysis in Excel.

 

Accelerate time-to-insight, on-premises and in the cloud, with SQL Server and Power BI. Get richer visualizations using Power Map and Power View. Search, access, and shape internal, external, structured, and unstructured data with Power Query. Access insights from anywhere using Power BI.

 

Scale to petabytes of data for enterprise-grade relational data warehousing using scale out Massive Parallel Processing (MPP) architecture using the Analytics Platform System (APS) and have the ability to integrate with non-relational sources like Hadoop. Support your needs from smaller datamarts to your largest enterprise data warehouses while making queries more than 100x faster than your legacy data platform, and reduce storage with new enhanced data compression.

 

Integration services include rich support for extract, transact and load (ETL) tasks, and the ability to run and manage as a separate SQL Server instance. Improve data quality by using organizational knowledge and third-party data providers to cleanse data through Data Quality Services.