Windows 10: SQL Server next version Community Technology Preview 1.1 now available

Brink · Dec 16, 2016

Microsoft is excited to announce that the next version of SQL Server (SQL Server v.Next) Community Technology Preview (CTP) 1.1 is now available for download on both Windows and Linux. In SQL Server v.Next CTP 1.1, part of our rapid preview model, we made enhancements to several database engine and Business Intelligence (BI) capabilities which you can try in your development and test environments.

Key enhancements in SQL Server v.Next on Windows CTP 1.1 for Analysis Services tabular models include:

New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This infrastructure enables:

Support for additional data sources, such as MySQL. Additional data sources are planned in upcoming CTPs.

Data transformation and data mashup capabilities.

Support for BI tools such as Microsoft Excel enable drill-down to detailed data from an aggregated report. For example, when end-users view total sales for a region and month, they can view the associated order details.

Support for ragged hierarchies in reports, such as organizational and account charts.

Enhanced security for tabular models, including the ability to set permissions to help secure individual tables.

For more detailed information about Analysis Services in SQL Server v.Next CTP 1.1, see the Analysis Services Team Blog.

Key SQL Server v.Next on Windows and Linux CTP 1.1 database engine enhancements include:

Language and performance enhancements to natively compiled T-SQL modules, including support for OPENJSON, FOR JSON, JSON built ins as well as memory-optimized tables support for computed columns.

Improved the performance of updates to non-clustered columnstore indexes in the case when the row is in the delta store.

Batch mode queries now support “memory grant feedback loops,” which learn from memory used during query execution and adjusts on subsequent query executions; this can allow more queries to run on systems that are otherwise blocking on memory.

New T-SQL language features:

Introducing three new string functions: TRIM, CONCAT_WS, and TRANSLATE

BULK IMPORT supports CSV format and Azure Blob Storage as file source

STRING_AGG supports WITHIN GROUP (ORDER BY)s

In addition, we have added support for Red Hat 7.3 and Ubuntu 16.10 to SQL Server on Linux.

For additional detail, please visit What’s New in SQL Server v.Next, Release Notes and Linux documentation.

Download SQL Server v.Next CTP 1.1 preview today!

SQL Server v.Next brings the power of SQL Server to both Windows – and for the first time ever – Linux. SQL Server enables developers and organizations to build intelligent applications with industry-leading performance and security technologies using their preferred language and environment.

Try the preview of the next release of SQL Server today! Get started with the preview of SQL Server on Linux, macOS (via Docker) and Windows with our developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, RHEL and Ubuntu and quickly build an app in a programming language of your choice.

Install on Red Hat Enterprise Linux

Install on Ubuntu Linux

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

Download the preview for Windows

Create a SQL Server on Linux virtual machine in Azure

Install on SUSE Linux Enterprise Server (coming soon)

Visit the SQL Server v.Next webpage to learn more. To experience the new, exciting features in SQL Server v.Next and our rapid release model, download the preview on Linux and Windows and start evaluating the impact these new innovations can have for your business. Have questions? Join the discussion of the new SQL Server v.Next capabilities at MSDN. If you run into an issue or would like to make a suggestion, you can let us know at Connect. We look forward to hearing from you!
Click to expand...

Source: https://blogs.technet.microsoft.com/...-now-available

:)

PhoneRowssive · Dec 16, 2016

Make Visual Studio 2013 connect to SQL Server 2016 RC0

Hi, Everyone! I recently downloaded and installed SQL Server 2016 RC0. When I tried to connect the Visual Studio 2013 to SQL Server 2016 RC0, the connection succeeded, but the data in the database was not available. VS 2013 prompted that an incompatible
version of SQL Server was detect. It is OK when I connect VS 2015 to SQL Server 2016 RC0 with the SQL Server Data Tool 2015. If a tool is also needed for VS 2013, how can I find it on Microsoft's website?

DRobinson_099 · Dec 16, 2016

Win 10 low memory error

Increased RAM from 8GB to 32GB and still received low memory errors on a newly acquired ZBook.

Ran ProcMon and found that MS SQL Server 2015 was sucking all the RAM without returning any.

I uninstalled SQL Server 2015 and went back to SQL Server 2008. Now I no longer receive the low-memory errors which were occurring daily.

I cannot vouch for other versions of SQL server and exactly which versions eat memory other than SQL Server 2015.

Windows 10: SQL Server next version Community Technology Preview 1.1 now available

SQL Server next version Community Technology Preview 1.1 now available

SQL Server next version Community Technology Preview 1.1 now available

SQL Server next version Community Technology Preview 1.1 now available - Similar Threads - SQL Server next

Visual Studio 2019 v16.9 and v16.10 Preview 1 now available

PowerShellGet 3.0 Preview 1 now available

PowerShell 7.1 Preview 1 now available

SQL Server next version CTP 1.3 now available

SQL Server 2016 Service Pack 1 generally available

SQL Server 2017 now generally available

SQL Server next version CTP 1.2 now available

Cumulative Update #1 for SQL Server 2016 SP1

Feature Pack 1 for SharePoint Server 2016 now available