Jeremy Kashel's Blog

Browse by Tags

All Tags » MDS (RSS)
Debug Custom MDS Workflows
The custom MDS workflows, AKA External Action Business Rules or custom MDS assemblies, are one of the more advanced features of MDS. They allow you to extend the standard MDS business rules by getting MDS to fire Entity Member member data at an external...
Unique Values in Master Data Services
I’ve been doing quite a few demos and Proof of Concept (POC) projects recently for MDS. Understandably there are always a raft of questions that come up during demos and POCs, one of which recently was “how do I ensure that this attribute’s value is unique...
Master Data Services SQL Server 2012 Vs 2008 R2
I’ve given quite a few MDS demos recently and one question I seem to get asked often is “What features does MDS 2012 have compared to MDS 2008R2?”. As its happened quite a few times, I thought it would be a good idea to put a quick post together to explain...
Matching with Master Data Services, DQS and SSIS
If you have an MDM requirement to consolidate multiple sources of Master Data together into a single golden record, then you have a few different ways to achieve this on the Microsoft platform. This blog post gives an overview of the different ways that...
Master Data Services in SQL Server 2012 RC0
There’s been a whole host of changes to MDS in the SQL Server 2012 RC (Release Candidate) 0 that came out the other week. This blog post gives an overview of the changes, before diving into detail on a few of them. At a high level, the following changes...
Managing SSAS Named Sets with Master Data Services Collections
Master Data Services Collections are probably not the first feature that come to mind when you think of the MDS product. The hierarchies and member grids tend to be the core functionality, but as this post will hopefully show, MDS Collections are useful...
Master Data Services Training in the UK
This is just a quick post to announce a range of SQL Server training courses, organised (and in some cases delivered) by Chris Webb . To start off there’s a SQL Server course delivered by Christian Bolton in December, followed by an Analysis Services...
Master Data Services Kindle Contest
This is a quick blog post to announce that Adatis are running a contest in conjunction with Packt around Master Data Services. The winner will receive an Amazon   Kindle pre-loaded with our Microsoft SQL Server 2008 R2 Master Data Services book....
Master Data Services Excel Add-in
Master Data Services in SQL Server Denali now includes an Excel add-in that allows MDS users to add and update data that exists within Master Data Services. For those of you that haven’t had a chance to download the latest CTP, this post gives an overview...
Master Data Services Training
As I’m sure you’ve seen, registration for SQLBits 9 – Query Across the Mersey is now open. This time around I’ll be running a deep-dive training day with Tim Kent on Master Data Services. This will be a full day of training, showing you how MDS can be...
Master Data Services in SQL Server Denali
If you didn’t make it to Tech Ed in North America last week, then you can download session recordings and take part in the labs at the Tech Ed site here . The session recordings are also available for streaming or download on Channel 9 . Today I wanted...
New Master Data Services Book
For the past seven months, Adatis have been working on new book for Master Data Services. The book, titled SQL Server 2008 R2 Master Data Services, will be published by Packt Publishing and will be released on 30th June. For those of you who don’t know...
Explicit Hierarchies Vs Recursive Hierarchies in MDS
Derived Hierarchies in Master Data Services are hierarchies created from the domain-based attribute relationships between entities, as explained in the following documentation , resulting in a fixed-depth hierarchy. A less obvious feature is that they...
Handling of NULLs and Blanks in MDS Business Rules
For any given entity in Master Data Services, its only the Code attribute that cannot be left blank when entering data in the front end or via the MDS staging tables. For any of the other attributes, you can then use the MDS business rules to enforce...
Master Data Services – Business Rules and the Notification Interval
For your Master Data services business rules that have a validation action, a notification, if you’ve set one up, will be sent if the rule condition gets satisfied. I’ve noticed a quirk to the way that the notifications are sent – I was getting unexpected...
More Posts Next page »