SQL Server 2017 RC1 Available

WEBINAR:
On-Demand

Application Security Testing: An Integral Part of DevOps


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!

  • You must have javascript enabled in order to post comments.

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

Top White Papers and Webcasts

  • This study investigates the differences between manual versus automated lifecycle management. Finding organizations that rely on a manual onboarding and offboarding processes have prolonged project timelines, increased costs, and heightened security risks.   In addition, IDG’s QuickPulse Survey, looks at streamlining with automated provisioning, policies, workflows, and reporting, where possible, to close these gaps and meet compliance requirements such as PII and HIPPA.     Okta …

  • Now there’s an innovative new way to move enterprise applications to the public cloud while actually reducing risks and trade‐offs. It’s called multicloud storage, and it’s an insanely simple, reliable, secure way to deploy your enterprise apps in the cloud and also move them between clouds and on‐ premises infrastructure, with no vendor lock‐in. Multicloud storage allows you to simplify your infrastructure, meet your service‐level agreements, and save a bundle.

Most Popular Programming Stories

More for Developers

RSS Feeds

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