Master Data Services Employees Sample Model

Posted by Davide Mauri on SQL Blog See other posts from SQL Blog or by Davide Mauri
Published on Mon, 03 May 2010 09:17:40 GMT Indexed on 2010/05/03 9:28 UTC
Read the original article Hit count: 522

Filed under:

2008 R2

|

Master Data Management

|

Master Data Services

|

mdm

|

mds

|

SQL Server

I’ve been playing with Master Data Services quite a lot in those last days and I’m also monitoring the web for all available resources on it.

Today I’ve found this freshly released sample available on MSDN Code Gallery:

SQL Server Master Data Services Employee Sample Model
http://code.msdn.microsoft.com/SSMDSEmployeeSample

This sample shows how Recursive Hierarchies can be modeled in order to represent a typical organizational chart scenario where a self-relationship exists on the Employee entity.

Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

© SQL Blog or respective owner

Related posts about 2008 R2

SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
Creating an ASP.NET Database using MS SQL 2008 in Visual Web Developer 2008

as seen on ASP Free - Search for 'ASP Free'
This article illustrates how to create a database in ASP.NET. We ll be using Microsoft SQL Server 2 8 and developing it in Visual Web Developer Express 2 8. Given the importance of databases to most websites nowadays you should find this information useful when building just about any website… >>> More
Introducing SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics… >>> More
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
Marcin Policht shows you how to install and configure SQL Server 2008 and 2008 R2 Integration Services. >>> More
Windows Server 2008 / SQL 2008 Licensing for Authenticated Web Application

as seen on Server Fault - Search for 'Server Fault'
Hello, I'm trying to crunch some numbers to see what the software costs involved are for hosting an application we are developing. Users will not be anonymous - they will need to log in. SQL Server 2008: SQL Server licensing is easy - it will be licensed per-processor. No real fuss there. The… >>> More

Related posts about Master Data Management

How to enable telnet with port 3306 during Master to master replication on MySQL Server

as seen on Server Fault - Search for 'Server Fault'
I am trying to do Master to Master Replication in Windows Server 2008. I am successfully able to replicate all the database of Master 1 to Master 2. But I am unable to replicate the changes made on Master 2 to Master 1. Later on I found that, I can telnet to Master 1 from Master 2 with port 3306 but… >>> More
ModSecurity compile error on nginx

as seen on Server Fault - Search for 'Server Fault'
I'm trying to install ModSecurity on nginx with the following instructions : wget https://github.com/SpiderLabs/ModSecurity/archive/master.zip unzip master cd ModSecurity-master ./autogen.sh ./configure --enable-standalone-module And i got the following error : Checking plataform... Identified… >>> More
mysql master-master setup as a way to simply master-slave promotion

as seen on Server Fault - Search for 'Server Fault'
I'm trying to see if the following plan is viable. Goal here is to be able to do HA (uptime) and not necessarily for load -- writes are fine on one MySQL 5.5 server (with innodb) but not really possible when the database is down. Currently, I have a master-slave replication setup which works fine… >>> More
timetable in a jTable

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create a timetable in a jTable. For the top row it will display from monday to sunday and the left colume will display the time of the day with 2h interval e.g 1st colume (0000 - 0200), 2nd colume (0200 - 0400) .... And if i click a button the timing will change from 2h interval to 1h interval… >>> More
Difference between Master Page and MVC View Master page

as seen on Stack Overflow - Search for 'Stack Overflow'
Please check below screen shot. What is main difference between Master Page and MVC View Master page. When I should use Master page and when I should use MVC View Master page. Thanks. >>> More