Windows 10: First release candidate of SQL Server 2017 now available

Brink · Jul 17, 2017

We are pleased to announce availability of the first public release candidate for SQL Server 2017, Release Candidate 1 (RC1), which is now available for download. This means that development work for the new version of SQL Server is complete along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux, and Docker containers.

In our seven community technology previews (CTPs) to date, 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. Check out the getting started instructions.

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. Check out the getting started instructions.

Machine Learning Services enhancements – In RC1, we 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. See the Analysis Services blog for more information.

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. (ANSI ODBC driver is not supported.)

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, we have introduced support for SQL Server on Linux-based containers, a benefit for customers using containers in development or production. We’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 our 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 our Gitter channels.

Customers are already benefitting from SQL Server 2017

In fact, with our 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.

Get started with SQL Server 2017 RC1 today!

Try the release candidate of the SQL Server 2017 today! Get started with our updated developer tutorials that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice. For more ways to get started, try the following:

Watch our recent Security and Monitoring, Client Tools, SQL Server Agent, or Backup engineering town halls on demand

Install on Red Hat Enterprise Linux

Install on Ubuntu Linux

Install on SUSE Linux Enterprise Server

Pull and run a Linux Docker container on Linux, Windows, or macOS

Download the preview for Windows

Create a SQL Server on Linux virtual machine in Azure

Active Directory Authentication with SQL Server on Linux

Sign up for the Early Adoption Program (EAP) – The Early Adoption Program is designed to help customers and partners evaluate new features in SQL Server 2017, and to build and deploy applications for SQL Server 2017 on Windows and Linux.

Have questions? Join the discussion of SQL Server 2017 at MSDN. If you run into an issue or would like to make a suggestion, you can let us know through Connect. We look forward to hearing from you!
Click to expand...

Source: First release candidate of SQL Server 2017 now available | SQL Server Blog

See also: What's new in SQL Server 2017 RC1 for Analysis Services | Analysis Services Team Blog

:)

srfreeman · Jul 17, 2017

Outlook 2010 and BCM 2010 doesn't work after the Windows Update on Windows 10

Note:
https://support.microsoft.com/en-us/kb/2681562

Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10

For SQL Server 2008 R2

SQL Server 2008 R2 is not supported on Windows 10.

For SQL Server 2008

SQL Server 2008 is not supported on Windows 10.

This has been known for quite some time.

ronengineer · Jul 17, 2017

windows 10 repeated update failures

Apparently, my problem with repeated upgrade failures has been resolved by a new windows upgrade successfully installed on 2/28/2017: "Important Update for SQL Server 2016 RTM (KB3210111)."

The original problem was failure ed to install daily from 2/15/2017 to 2/27/2017: "Critical Update for SQL Server 2016 MSVCRT Prerequisites KB3164398". This upgrade has not attempted to install since 2/27 and my PC is now up to date. I assume the 2/28/2017
upgrade was a fix for the problem.

I still have the event viewer failure to run problem. Can you help with that problem? I would appreciate the help.

Windows 10: First release candidate of SQL Server 2017 now available

First release candidate of SQL Server 2017 now available

First release candidate of SQL Server 2017 now available

First release candidate of SQL Server 2017 now available - Similar Threads - release candidate SQL

Will the СU32 be released for MS SQL Server 2017?

Will the СU32 be released for MS SQL Server 2017?

SQL Server 2017 Reporting Services Release Candidate now available

SQL Server 2017 now generally available

General availability of SQL Server 2017 on October 2, 2017

New SQL Server 2016 Release Candidate (RC2)

SQL Server 2017 CTP 2.1 now available

PowerShell Core 6 Release Candidate now available

SQL Server 2017 Release Candidate 2 (RC2) is now available