Working with Master Data Services in SQL Server 2019

[@user-kakatya]

Thanks a lot Muhammad! Very helpful and well explained!

[@lookaheadtothegreens3877]

Your videos are very helpful. Thank you @Analytica Learning!

[@analyticalearning7408]

Thank you @LookAheadToTheGreens. Glad you found it helpful.

[@luciasantana569]

wow, excelent, thank you!!

[@analyticalearning7408]

Glad you liked it!

[@penuganthisriharish1182]

Your videos and the content is very useful. Could you please share a vide on "How to make a golden record with duplicate / incorrect Customer Master data using MDS tool "

[@TheJourneyNeverStops]

That was nice video and may i ask you a doubt like how can we show an entity as default entity in the Explorer .

[@penuganthisriharish1182]

Is MDS will only work on SQL Enterprise Edition? Any alternate option?

[@rajeshjangir6000]

How can we impliment member level user permission. Can we hide specific member data(row) from a perticular user ? Please create a video on hierarchy level and member level permission with small example.

[@analyticalearning7408]

Hello Rajesh. I had built and tested solution last night. Will record and upload video today :)

[@rajeshjangir6000]

@@analyticalearning7408 Thank you sir.👍👍

[@AliTwaij]

nice thankyou

[@analyticalearning7408]

Welcome 😊

[@AliTwaij]

Can we easily upgrade from MDS 2016 to the latest? What are the issues involved? thankyou

[@analyticalearning7408]

It depends upon the complexity of Database Architecture. A single server-based architecture will be easy to upgrade compared to multiServer environment. However, I shall record the upgrade video and post on my channel soon.

[@sahulhameed132]

What is the replacement MDS in the Microsoft product, and is it still supported? I eagerly await your response. Thank you in advance.

[@analyticalearning7408]

Microsoft is supporting MDS in 2022 version. In fact, I am recording a video to show the installation and configuration process with SQL Server 2022. Will post the link shortly. Thank you Sahul :)

[@rajeshjangir6000]

Can we use trigger while row update in MDS

[@analyticalearning7408]

Hi Raj. MDS has its own database which contains corresponding stored procedures for insertion. Therefore, you can define triggers while updating rows in MDS. However, It is strongly discourage to change any object with MDS. Hope, it makes sense. Thank you. I have shown MDS database in the following video. kzbin.info/www/bejne/jHmqZomch9Clqbc

[@rajeshjangir6000]

Thanks 🙏🙏

[@amirgurru]

@@rajeshjangir6000 kzbin.info/www/bejne/qKTahGiagLyIp9k