Tags » Master Data Services

Microsoft SQL Server 2016 Ignites Master Data Services

MS SQL Server 2016 promises some key updates for Master Data Services including sharing entities between models, publishing multiple versions of data in the same subscription view, and increased functionality in the Excel add-in. 75 more words

Business Intelligence

Master Data Management with SQL Server: A Primer – Part 2

In my previous post I wrote about the need for master data management (MDM), and what SQL Server offers as a solution. In this post I’ll explore SQL Server’s MDM offering with a simple example, to get to know the product. 1,027 more words


Master Data Management with SQL Server: A Primer – Part 1

Organizations, especially those that have multiple departments, and those with heterogeneous software systems in place often have a problem. This problem is synonymous, as in Pinal Dave’s… 767 more words

Master Data Management

Microsoft Updates MDS Plug-in for Excel

New updates are focused on performance. You can download the latest version here. Although the title states it’s for SQL Server 2014, the plug-in also works with SQL Server 2012.

Excel And Excel Services

MDS Versions, Flags and Subscriptions

Recently I collaborated with Andrew Milner in a scenario in MDS SQL 2012 to provide the client the ability to with between multiple Versions and Flags via Subscription Views. 756 more words

How to restore your MDS database on a different domain/server and fix the “Access Denied” error

This has happened to me a few times now and every single time I had to spend quite a bit of time sifting through the blogs looking for answers. 260 more words

Master Data Services

MDS - Entity's Staging Table Rename

Hi !

Many times I found that when I create entity ,I forgot to change the name of staging table and then sometimes when I change the entity name I also need to make staging table naming same as my entity name. 84 more words

Business Intelligence