dcsimg

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

  • Understand your options for workload automation. In this IT Central Station report, real Workload Automation (WLA) users discuss their experiences with WLA tools and the functionality they find most useful for meeting IT and business requirements.    Learn how you can:   • Extend the value of WLA through simple, cost-effective integration • Improve user productivity with templates, self-service, and unified visibility • Discover and resolve scheduling issues quickly …

  • Global data deduplication provides important benefits over traditional deduplication processes because it removes redundant data through entire enterprises, not just single devices. Global deduplication increases the data deduplication ratio — the size of the original data measured against the size of the data store after redundancies are removed. This helps reduce the amount of storage required at a time when businesses face exponential storage growth. This eBook explores the chief benefits of global …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.