THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » master data services   (RSS)
Showing page 1 of 2 (20 total posts)
  • 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) or on a list of attributes (composite ...
    Posted to Master Data Services Team (Weblog) by mattande on July 23, 2015
  • 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 lead to performance degradation and storage ...
    Posted to Master Data Services Team (Weblog) by mattande on June 2, 2015
  • Performance and Scale Improvement in SQL Server 2016

    Overall performance and scale Improvement We have made significant improvement on performance from backend database, middle tier services to frontend UI including both WebUI and Excel UI. The performance is improved on all scenarios, especially on the master data loading, while the server side CPU and memory will be lower than previous ...
    Posted to Master Data Services Team (Weblog) by mattande on June 2, 2015
  • 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 no easy to have multiple server admins or give ...
    Posted to Master Data Services Team (Weblog) by mattande on June 2, 2015
  • 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 made possible by new DH ...
    Posted to Master Data Services Team (Weblog) by mattande on June 2, 2015
  • 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>       <!-- Adjust the switch value to control the types ...
    Posted to Master Data Services Team (Weblog) by mattande on June 2, 2015
  • 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 ...
    Posted to Master Data Services Team (Weblog) by mattande on May 27, 2015
  • 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 space issues. To overcome this problem ...
    Posted to Master Data Services Team (Weblog) by mattande on April 14, 2015
  • Data Quality and Master Data Management Resources

    Many companies or organizations do regular data cleansing. When you cleanse the data, the data quality goes up to some higher level. The data quality level is determined by the amount of work invested in the cleansing. As time passes, the data quality deteriorates, and you need to repeat the cleansing process. If you spend an equal amount of ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on October 14, 2013
  • Conferences in the next months

    Next months look full of interesting conferences and I’ll be speaking in several of those. I’ll be speaking at the following ones: SQL DAYS 17 – 18 September 2013, Germany http://www.sqldays.net/ SQL Saturday 260 Milano 8 October 2013, Italy http://www.sqlsaturday.com/260/eventhome.aspx SQL PASS Nordic 4 – 6 November 2013, ...
    Posted to Davide Mauri (Weblog) by manowar on August 29, 2013
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement