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

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 about Session Materials to Download: Master Data Management with SQL Server 2012[…]

Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday

Hi folks, I proud to announce that I will speak in the SQL Saturday #237 Charlotte BI Edition Which will run in 19th of October 2013 in Charlotte, North Carolina  In this session I will speak on one of my favorite topics which is Design and implementation architecture for Inferred Dimension Members with SSIS and Read more about Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday[…]

Deep Dive into Security Schema of Master Data Services Database

Master Data Services provides data governance and reference data management as part of SQL Server product. There is a security mechanism in MDS that provides robust role based security and authorization for domain accounts and groups. Security on data also can be applied on Model level, entity, or even in row level. Security in MDS Read more about Deep Dive into Security Schema of Master Data Services Database[…]

MDS: Deploy Master Data Services Model with Data From One Server to Another

In a multi environment system which you might have Development, UAT and Production for your master data services, the requirement for transfer MDS models across different master data services will be sensible. sometimes you just need to transfer model structure (metadata) from one server to another, but in some situations you will need to have a Read more about MDS: Deploy Master Data Services Model with Data From One Server to Another[…]

Speaking about Master Data Services

Hi folks, I’ll speak about Master Data Services at Microsoft Venue in Auckland on 9th of October of 2012. Session Topic and description: Managing Reference Data with Master Data Services In most of companies there are some reference data which are in use from different applications and databases, This reference data should be consistent and Read more about Speaking about Master Data Services[…]