Browse by Tags

Tagged Content List
  • Blog Post: What's New in Master Data Services - SQL2016 CTP2.2(July) Release

    SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 In CTP2.2 MDS introduced following changes: 1. Custom Indexes You can create a non-clustered index on one attribute (single index...
  • Blog Post: Security Improvements

    Super User Functional permission: In the previous release, whoever install the MDS originally, is the server admin. The user will have user id 0. There is no easy way to transfer server admin from one user to the other. It will require DB admin go the user table and change SID on user id 0. There is...
  • Blog Post: Deprecated: Explicit Hierarchies and Collections

    The SQL Server 2016 version of Master Data Services deprecates Explicit Hierarchies (EH) and Collection and all related components. Members that before were modeled as Consolidated (EH parent) and Collection member types will henceforth be modeled as Leaf members in Derived Hierarchies (DH). This is...
  • Blog Post: Troubleshooting logging improvement

    Troubleshooting logging improvement In the SQL Server 2016, we did logging improvement to improve the debug ability and make the troubleshooting easier. 1.        Tracing setting in the web.config     < sources >       <!...
  • Blog Post: Transactions, Validation Issue and Staging table cleanup

    Transactions, Validation Issue and Staging table cleanup: Master Data Services previous versions didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes these tables can grow exponentially and...
  • Blog Post: What's New in SQL2016 CTP2 Release

    SQL Server 2016 CTP2 -- Now Available for public download.  In CTP2 release, there are many new MDS features.  What’s New for MDS   Improved Performance Performance improvements enable you to create larger models, load data more efficiently, and get better overall performance. This includes...
  • Blog Post: How to cleanup transaction logs, Validation issues and Staging tables

    Master Data Services till recently didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes over the period these tables can grow exponentially and lead to performance degradation and storage...
  • Blog Post: Exporting Master Data White Paper Published

    Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. But how do you export that master data from MDS into your systems? The "Exporting Master Data from Master Data Services" white paper at http://msdn.microsoft...
  • Blog Post: Downloading and Installing SQL Server 2008 R2 Master Data Services (MDS) Cumulative Updates

    (This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team) Recently, we released the first cumulative update (CU) for Master Data Services (MDS) . This blog entry explains how to download and install that CU, as well as subsequent CUs for MDS. Each Master Data Services (MDS...
  • Blog Post: Installing and Configuring Master Data Services 2008 R2 November CTP

    (this post was contributed by Matt Anderson, Senior Software Engineer on the MDS team) Master Data Services (MDS) is now available as part of the November CTP of Microsoft® SQL Server® 2008 R2! An overview of MDS can be found on the product home page and documentation is available in SQL Server...
  • Blog Post: Welcome to the SQL Server Master Data Services Team Blog!

    We are hard at work putting the finishing touches on our first release of SQL Server Master Data Services (MDS). We will ship as part of SQL Server 2008 R2, and, already we are getting valuable feedback about our November CTP . Thanks to those of you who have downloaded MDS and provided feedback via...
Page 1 of 1 (11 items)