SQL Server 2017

SQL Server 2017 Build List

• by Steve Jones

• SQLServerCentral.com

• SQL Server 2017

• Article

A list of builds for SQL Server 2017.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2018-12-18

3,359 reads

• Discuss

Logshipping to SQL Server on Linux

• by Evgeny Garaev

• SQLServerCentral.com

• SQL Server 2017

• Article

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (5)

Log in or register to rate

2020-06-25 (first published: 2018-06-05)

1,657 reads

• Discuss

SQL Server 2017 for Linux First Impressions

• by Evgeny Garaev

• SQLServerCentral.com

• SQL Server 2017

• Article

Microsoft has released a version of SQL Server 2017 for Linux.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

Log in or register to rate

2018-03-26

2,240 reads

• Discuss

Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3

• by Additional Articles

• MSSQLTips.com

• SQL Server 2017

• Article

In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.

2018-02-02

3,045 reads

Create Size-based Backups for SQL Server 2017

• by Additional Articles

• MSSQLTips.com

• SQL Server 2017

• Article

Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.

2018-01-02

3,457 reads

Cascading Update and Delete for SQL Server 2017 Temporal Tables

• by Additional Articles

• MSSQLTips.com

• SQL Server 2017

• Article

Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.

2017-12-25

3,228 reads

Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant

• by Additional Articles

• Database Journal

• SQL Server 2017

• Article

You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.

2017-12-19

3,471 reads

How Much Data Has Changed Since Your Last Full Backup

• by Additional Articles

• Database Journal

• SQL Server 2017

• Article

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.

2017-12-08

3,696 reads

9 New Features with SQL Server 2017

• by Additional Articles

• Database Journal

• SQL Server 2017

• Article

Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.

2017-10-23

5,498 reads

SQL Graph Objects in SQL Server 2017: the Good and the Bad

• by Additional Articles

• SimpleTalk

• SQL Server 2017

• Article

Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These can be difficult to do in relational databases and even trickier to report on. Until now, we have had the choice of doing it awkwardly in SQL Server or having an ancillary database to tackle this type of task. SQL Server 2017 will be bringing graph capabilities to the product but will these features prove to be good enough to allow us to dispense with specialised Graph databases? Dennes Torres decided to find out.

2017-09-07

3,818 reads