SQL Server 2017

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

  • 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

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

  • 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

Blogs

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances

By

By Steve Bolton …………Each group of distance measures surveyed in this segment of the...

Read the latest Blogs

Forums

SSRS SQL account to connect install

By Siten0308

Hello, I am installing SSRS, and I want to use SSRS for the credentials...

using the same logic across multiple servers/dbs

By jonathan.crawford

We have five different report servers, with 13 or so different databases, all with...

How to see the source SELECT statement of views?

By imani_technology

I don't have permissions to right click\design views or to script the views.  Is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers