SQL Server 2017 RC1 Available

WEBINAR: On-demand Event

Unleash Your DevOps Strategy by Synchronizing Application and Database Changes REGISTER >

The launch of a release candidate is generally an indicator that a product is complete and the final bugs are being worked out. This week Microsoft made available SQL Server 2017 RC1, which can be downloaded now. You can find SQL Server 2017 downloads for Linux, macOS, Windows, Docker and Azure on the Microsoft site at:

https://www.microsoft.com/en-us/sql-server/sql-server-2017#resources

Some of the features added to SQL Server 2017 include support for Linux at higher levels, graph data processing, adaptive query processing, in-database analytics using Python or R, active Directory Authentication support, enhancements to Machine Learning Services , Dynamic Management Views in SQL Server Analysis Services (SSAS), Always on for SQL Server Integration Services (SSIS) on Windows Server, and more.

One of the goals for the new product was to have SQL Server 2017 run on any public or private cloud infrastructure. With the support for containers, SQL Server 2017 is able to better support Continuous Integration/Continuous Deployment (CI/CD) scenarios. This all fits within the objective of positioning SQL Server to work for DevOps.

If you are working in a DevOp environment with SQL Server, then there are a number of tools you’ll be able to tap into from Microsoft. This includes the Visual Studio SQL Server Data Tools for doing the CI/CD as well as using the Redgate Data Tools that Microsoft had aligned with recently. You can also use the msql-scripter to generate scripts for database objects in SQL Server as well as in Azure data stores. The sqlcmd is now available for Linux, Windows, and the macOS so you can enter commands and such at the command prompt. Finally, bcp is also available on Linux, Windows and the macOS to copy files in specific formats.

The following is a Channel9 video showing some of the SQL Server Data Tools that you’ll be able to use in the DevOps pipeline:



Blog Categories

Blog Archives

Comments

  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Thanks to the pervasive use of virtualization, hybrid cloud, and software–defined architectures — enterprise IT infrastructures are impossibly complex. Performance monitoring solutions are critical for enabling IT teams to identify key bottlenecks and emergent issues, for understanding which workloads are more demanding in terms of resource contention, and for cost effective capacity and resource planning. Read this IDC Customer Spotlight for a glimpse into real–world implementations and use …

  • Are you weighing the benefits of cloud storage versus on-premises storage? If so, the right answer might be to use both — a mix of on-premises and public cloud services with data mobility between the two platforms. Hybrid has piqued interest as more organizations look to the public cloud to augment their on-premises data management. Analyst firm IDC predicts that by 2018, 85% of enterprises will operate in a multi-cloud environment. Check out this easy-to-absorb infographic to explore five reasons to …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date