SQL Server 2016 Master Data Services Entity Sync and Hierarchy Management

Download this episode

Download Video

Description

This week's episode of Data Exposed welcomes Brent McBride, a Senior Software Engineer on the SQL Server team for Master Data Services. Today, Brent joins us to show us what's new with Master Data Services SQL Server 2016.

Brent begins the show by explaining and defining what Master Data is in SQL Server and how Master Data Services helps users manage their master data. From there Brent jumps right in and shows us the new features of Master Data Services in SQL Server 2016. The first demo is Entity Sync, a one-way and repeatable synchronization between entity versions as well as the ability to make a one-time copy of data. Brent also demonstrates model dependencies through domain based attribute which acts much like a foreign key.

Lastly, Brent shows us some of the enhancements to the hierarchy explorer. One of the big changes is the ability to see the members that don't participate in the hierarchy via a new node in the explorer called Unused, and the ability move things back and forth between the unused and the hierarchy, apply and show many to many relationships, and also apply member security.

Great new features added to Master Data Services, so if you are diehard MDS user then this video is for you!

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.