Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2014

Master Data Services for the Beginner Part 04

 

Introduction

In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on extracting data from Master Data Services, via views.

Getting started

We start off by bringing up the Master Data Manager in the normal manner.

Once again, my link… Read more

0 comments, 408 reads

Posted in Simon Says on 29 January 2014

Master Data Services for the Beginner Part 03

 

Introduction

In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very loosely compared to a database, an entity to a table and attributes to the fields of a table.

Today we are going to load the raw data(member) into… Read more

0 comments, 1,791 reads

Posted in Simon Says on 28 January 2014

Master Data Services for the Beginner Part 02

 

Introduction

In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with Microsoft SQL Server Master Data Services.
In this part of the discussions we are going to discuss Entities and Attributes and the members that make up our data. Read more

2 comments, 2,269 reads

Posted in Simon Says on 27 January 2014

Master Data Services for the Beginner Part 01

 

Introduction

About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with the product in SQL Server 2008 R2 but (like others did) found it very awkward to work with and difficult to understand. Microsoft has done a super job… Read more

2 comments, 1,144 reads

Posted in Simon Says on 26 January 2014

Master Data Services Disaster Recovery Challenges

 

Introduction

While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative data, disaster recovery from the failure of a model or the MDS database itself can be a challenge to say the least.

The main challenge comes NOT with… Read more

0 comments, 357 reads

Posted in Simon Says on 25 January 2014

SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!

 

Introduction

A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting up of a nightly batch process to update a Master Data Services 2014 application that I have recently created for our finance department.

This is fine and dandy,… Read more

0 comments, 682 reads

Posted in Simon Says on 2 January 2014