Microsoft SQL Server 2017 RC1 available

First release candidate of Microsoft SQL Server 2017 brings a lot of interesting and new features 
19 July 2017   833
Microsoft SQL Server

RDBMS that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environment.

Recently, Microsoft SQL Server team released Microsoft SQL Server 2017 release candidate 1. This is reported by Microsoft Technet Blog.

SQL Server 2017 has delivered:

  • Linux support for tier-1, mission-critical workloads  SQL Server 2017 support for Linux includes the same high availability solutions on Linux as Windows Server, including Always On availability groups integrated with Linux native clustering solutions like Pacemaker.
  • Graph data processing in SQL Server  With the graph data features available in SQL Server 2017 and Azure SQL Database, customers can create nodes and edges, and discover complex and many-to-many relationships.
  • Adaptive query processing  Adaptive query processing is a family of features in SQL Server 2017 that automatically keeps database queries running as efficiently as possible without requiring additional tuning from database administrators. In addition to the capability to adjust batch mode memory grants, the feature set includes batch mode adaptive joins and interleaved execution capabilities.
  • Python integration for advanced analytics  Microsoft Machine Learning Services now brings you the ability to run in-database analytics using Python or R in a parallelized and scalable way. The ability to run advanced analytics in your operational store without ETL means faster time to insights for customers while easy deployment and rich extensibility make it fast to get up and running on the right model.

Key enhancements in Release Candidate 1

In SQL Server 2017 RC1, there were several feature enhancements of note:

  • SQL Server on Linux Active Directory integration – With RC1, SQL Server on Linux supports Active Directory Authentication, which enables domain-joined clients on either Windows or Linux to authenticate to SQL Server using their domain credentials and the Kerberos protocol.
  • Transport Layer Security (TLS) to encrypt data – SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. SQL Server on Linux supports the following TLS protocols: TLS 1.2, 1.1, and 1.0.
  • Machine Learning Services enhancements – In RC1, team add more model management capabilities for R Services on Windows Server, including External Library Management. The new release also supports Native Scoring.
  • SQL Server Analysis Services (SSAS)  In addition to the enhancements to SSAS from previous CTPs of SQL Server 2017, RC1 adds additional Dynamic Management Views, enabling dependency analysis and reporting.
  • SQL Server Integration Services (SSIS) on Linux  The preview of SQL Server Integration Services on Linux now adds support for any Unicode ODBC driver, if it follows ODBC specifications.
  • SQL Server Integration Services (SSIS) on Windows Server  RC1 adds support for SSIS scale out in highly available environments. Customers can now enable Always On for SSIS, setting up Windows Server failover clustering for the scale out master.

SQL Server 2017 for faster performance

SQL Server 2017 has several new benchmarks demonstrating faster performance than competitive databases, and against older versions of SQL Server:

  • The world record TPC-H 1TB nonclustered data warehousing benchmark, achieved in April 2017 using SQL Server 2017 on Red Hat Enterprise Linux and HPE Proliant DL380 Gen9 hardware.
  • A new, nonclustered TPC-H 10TB data warehousing workload benchmark achieved using SQL Server 2017 on Windows Server 2016 and Lenovo ThinkSystem SR950 hardware. At 1,336,109 QppH, this newly published benchmark is a world record.
  • A new TPC-E benchmark achieved with SQL Server 2017 running on Windows Server 2016 on a Lenovo ThinkSystem SR650, a world record for 2 socket TPC-E results.

Streamline your DevOps using SQL Server 2017

In SQL Server 2017, developers have introduced support for SQL Server on Linux-based containers, a benefit for customers using containers in development or production. They’re also working to help developers get started developing an app for SQL Server as fast as possible with installation instructions, code snippets, and other handy information.

On new microsite DevOps using SQL Server, which launched today, developers and development managers can learn how to integrate SQL Server in their DevOps tasks. Find demos, documentation, and blogs, as well as videos and conference presentations. Or, join the DevOps conversation at Gitter channels.

Customer benefits from SQL Server 2017

In fact, with Early Adoption Program, customers can develop new applications for SQL Server 2017 or add Linux support to existing applications, and get the support and end-user license agreement that they need to go into production on SQL Server right now. Here are some customers already benefitting from SQL Server 2017 on Linux:

  • Convergent Computing  A system integrator and longtime Microsoft partner, Convergent Computing was able to achieve a much faster return on server and storage hardware investments than usual by moving some tier-2 applications to inexpensive, white box servers running SQL Server 2017 on Linux.
  • dv01 – Financial technology startup dv01 started out with an open source database on a competitor cloud. But when it ran into performance and scale problems, SQL Server was able to give it 15X faster performance, plus in-database advanced analytics. And by moving to SQL Server 2017, dv01 could standardize its operating systems on Linux—all with an easy migration.

Additional information can be found at SQL Server Blog.

Red Hat and Microsoft join forces

Two large IT companies work together to bring the best service for their customers
23 August 2017   1147

Microsoft announced the star of cooperation with Red Hat, widely known Linux based products developer.

Let's figure out what exactly this cooperation brings for the user.

  • Windows Server can be launched on Red Hat OpenShift Container Platform.
    • Windows Server containers will be natively supported on Red Hat OpenShift, a container application platform that brings Docker and Kubernetes to the enterprise. Red Hat OpenShift will be the first container application platform built from the open source Kubernetes project to support both Linux and Windows Server container workloads in a single platform across the multiple environments of the hybrid cloud, breaking down silos and making it easier for enterprises to pursue their cloud-native agenda.

      This capability was demonstrated at Red Hat Summit in May 2017, and is expected to be available as a Technology Preview in Spring 2018.

  • Red Hat OpenShift Dedicated on Microsoft Azure and Red Hat Enterprise Linux on Microsoft Azure Stack
    • Red Hat OpenShift Dedicated is a container platform as a cloud service managed by Red Hat. With this announcement, it is planned for availability on Azure, Microsoft’s enterprise-grade cloud platform with availability announced across 42 regions globally — more than any other public cloud provider. Microsoft and Red Hat engineers are working closely to optimize OpenShift while running on Azure, ensuring enterprise performance standards and matching integrated support.

Alongside Microsoft, Red Hat is providing a way for organizations to truly make the technology choices that matter to them, from containerized workloads to public cloud services, without adding an equal burden of complexity. Combined with our integrated support teams, we’re able to offer an achievable pathway to digital transformation that offers the capabilities, flexibility and choice required to power the future of enterprise IT. 
 

Matthew Hicks 

Vice president, Software Engineering, OpenShift and Management, Red Hat

  • SQL Server on Red Hat Enterprise Linux and OpenShift 
    • Red Hat announced the availability of .NET Core 2.0 as a container in OpenShift, and today the two companies are bringing the power and scale of one of the world’s leading relational database management systems to their joint platforms. SQL Server for Linux will be available in the coming months on Red Hat Enterprise Linux and OpenShift.As with all Red Hat and Microsoft joint initiatives, SQL Server for Linux on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform will be jointly supported by both Microsoft and Red Hat

Microsoft and Red Hat are aligned in our commitment to bring enterprise customers the hybrid cloud solutions they need to modernize their businesses as they shift to operate in a cloud-native world. Today, we’re extending this commitment as we again join forces to bring fully interoperable solutions that simplify container adoption and help customers make the most of their hybrid cloud strategies. 
 

John Gossman 

Lead Azure Architect, Microsoft Corp.