Change Set and Approval Workflow in MDS 2016

Posted by on Dec 8, 2015 in MDS | 3 Comments

One of the interesting features of Master Data Services 2016 is Change Set and Require Approval. In prior versions of MDS when you apply a change and publish that change automatically take place in the entity and records. However in the new MDS in SQL Server 2016 you can create a Change Set of your ...

Read More

MDS 2016: What’s New in CTP 2.2

Posted by on Aug 4, 2015 in MDS, SQL Server 2016 | One Comment

On Late May when CTP 2.0 of SQL Server 2016 published, I’ve wrote a blog post about What’s New in MDS 2016. Recently CTP 2.2 has been published, and I’ve seen some new features again added to MDS. In this post I’ll explain new features of MDS 2016 CTP 2.2 which are; Entity Sync SCD ...

Read More

What’s New in MDS of SQL Server 2016

Posted by on May 28, 2015 in MDS, SQL Server 2016 | 6 Comments

SQL Server 2016 CTP 2 released almost a day ago, and I’ve had a chance to install it and play with Master Data Services to see what changes has been made in this product. Master Data Services is a service of SQL Server first released in SQL Server 2008R2, and enhanced in SQL Server 2012. ...

Read More

SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges

Posted by on May 24, 2014 in ETL, MDS, Presentations, SSIS | No Comments

I am honored that I will speak in SQL Saturday 316 Christchurch on 14th of June 2014. Presentation topic is : ETL Architecture for Solving Data Warehouse Challenges presentation Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis ...

Read More

ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in ComCamp 2014 in Auckland about Solution Architecture for Inferred Dimension Members with SSIS and MDS. Here is session Title, Description, and presentation file; Title: Solution Architecture for Inferred Dimension Members with SSIS and MDS Description: Data Warehouses are heavily in use nowadays in most of businesses around ...

Read More

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher ...

Read More

Master Data Services Software Requirements

Posted by on Jan 2, 2014 in MDS | No Comments

  In this blog posts I explain what is required for master data services to be configured on a windows (server or client) machine. Required features would be listed and how to install would be discussed in detail. Master Data Services (MDS) is part of SQL Server 2008 R2 or higher. so you would require ...

Read More

Session Materials to Download: Master Data Management with SQL Server 2012

Posted by on Nov 25, 2013 in MDS, Presentations | No Comments

Thanks for all attendees in my session about Master Data Management with SQL Server 2012 as part of NetCom Learning free webinars. In this session below contents covered: Creating Entities for reference data Relationship between entities Business Rules and their usages User Interfaces for working with Master Data Services Hierarchies Integration Views for using in ...

Read More