Johan Machielse

RSS JohanMachielse
558 punten
Avanade
11 juli 2011

IntroductionCDC (Change Data Capture) captures data changes caused by DML (Data Manipulation Language) statements like inserts, updates, and deletions and makes it possible to archive data changes without any additional programming. Thes... lees verder >
Blog: 10 januari 2012
Master Data Management (MDM) is a set of processes and tools and in the release of SQL Server 2008 R2 (SS2008R2) Microsoft has added such a tool to manage master data, namely Master Data Services (MDS). In SQL Server 2012 (SS2012), MDS w... lees verder >
 
Wildcard: 17 december 2011
Because of my experience and knowledge about Master Data Services I have been asked to review the book Microsoft SQL Server 2008 R2 Master Data Services. Looking at the authors’ names (Ian who wrote the preface is the founder of Master... lees verder >
Blog: 3 oktober 2011
IntroductionThe Silverlight PivotViewer control is a very powerfull control that visualizes a lot of data at once. The user is able to filter the data and get insight in this data very easily. The data used for the viewer consists of a c... lees verder >
Blog: 10 augustus 2011
IntroductionMaster Data Services ships with SQL Server 2008 R2, which installs the web based Master Data Manager where business users can maintain their master data. One of the major complaints that business users have about the Mas... lees verder >
Blog: 4 augustus 2011
IntroductionThe first version of Master Data Services shipped with SQL Server 2008 R2. We all know that a first version of a Microsoft product has some shortcomings and needs some improvements to get more mature, which is also true for t... lees verder >
Blog: 8 juli 2011
IntroductionPermissions are set in the Master Data Manager and define what a user/group is able to do in the Master Data Manager Web application. The users and groups are defined locally or in Active Directory (AD) and can be restricted ... lees verder >
Blog: 8 juli 2011
IntroductionWithin MDS business rules are used to enforce data integrity, completeness and accuracy. A business rule consists of conditions and actions, which can be chosen from a predefined list. In some cases the standard conditions an... lees verder >
Blog: 7 juli 2011
IntroductionIn the article "Master Data Services: Find your way through the MDS database schema" we have read and updated attribute values by accessing the MDS database directly via T-SQL. Using the direct approach your code could b... lees verder >
Blog: 7 juli 2011
Introduction A Master Data Services database consists of a lot of tables where information is stored about models, entities, attributes, hierarchies, business rules, permissions, etc. In this article I will focus on the tables and views... lees verder >
Blog: 7 juli 2011
Weergave resultaten 1-10 (van 15)
 |<  < 1 - 2  >  >|