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 3 (23 total posts)
  • SQL Server 2017 Integration Services Cookbook

    I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name would be SSIS 2016 / 2017 Cookbook. Besides detailed guidelines how to use the 2016 version, you ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 14, 2017
  • MDS 2016 Installation on Windows Server 2012 R2

    This is a tip that should help installing SQL Server 2016 (tested on CTP33, RC2 and RC3) Master Data Services. The documentation is pretty old and incomplete (I already sent the feedback). The page “Web Application Requirements (Master Data Services)” (https://msdn.microsoft.com/en-us/library/ee633744.aspx) should be seriously updated. First of ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 27, 2016
  • DevWeek 2016 BI in SQL Server 2016 Workshop Setup

    I got some questions about virtual machine / notebook setup for my Business Intelligence in SQL Server 2016 DevWeek post-conference workshop. I am writing this blog because I want to spread this information as quickly as possible. There will be no labs during the seminar, no time for this. However, I will make all of the code available. ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 15, 2016
  • Hands On Labs for Master Data Services

    Are you curious what Master Data Services is all about? Or are you looking to quickly develop a Master Data Services solution? Or are you interested in trying out the new features in SQL Server 2016? If you answered yes to any of these questions, we now have couple of Hands On Labs published for you to use. They ...
    Posted to Master Data Services Team (Weblog) by mattande on February 18, 2016
  • Master Data Services - SQL2016 CTP3.2(December) is Released

      In SQL Server 2016 CTP3.2 release, MDS is introducing following features. Purge Soft Deleted Members You can now purge (permanently delete) all soft-deleted members in a model version. Deleting a member only deactivates, or soft-deletes, the member. For more information, see Purge Version Members (Master Data Services). Change ...
    Posted to Master Data Services Team (Weblog) by mattande on December 17, 2015
  • What's New in Master Data Services - SQL2016 CTP3 (Oct) Release

     In SQL Server 2016 CTP3 release, MDS is introducing following features. Change Sets You can use change sets to save pending changes to an entity, and you can view and modify pending changes. If the entity requires approval for changes, you must save the pending changes into a change set and submit for approval by the administrator. For ...
    Posted to Master Data Services Team (Weblog) by mattande on October 30, 2015
  • What's New in Master Data Services - SQL2016 CTP2.4 (Sep) Release

    SQL Server 2016 Community Technology Preview 2.4 is publicly released and the latest SQL Server bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. MDS Excel Add-in can be found at : https://www.microsoft.com/en-us/download/details.aspx?id=47343 In CTP2.4 MDS introduced feature to extend Business Rules ...
    Posted to Master Data Services Team (Weblog) by mattande on October 15, 2015
  • 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: Custom Indexes You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), ...
    Posted to Master Data Services Team (Weblog) by mattande on July 23, 2015
  • What's New in Master Data Services - SQL2016 CTP2 (May) Release

    SQL Server 2016 Community Technology Preview 2 is publicly released and the latest SQL Server bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. Improved Performance and Scale We have made significant improvement on performance from backend database, middle tier services to frontend UI including ...
    Posted to Master Data Services Team (Weblog) by mattande on June 5, 2015
  • Deprecated in SQL 2016: 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
1 2 3 Next >
Privacy Statement