Browse by Tags

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 have been made to MDS: Improved Master Data Manager...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-30-2011
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 also. Collections are essentially managed lists...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-07-2011
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 course delivered by Chris in February. I’ll be delivering...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-01-2011
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. In order to enter, all you need to do is follow @AdatisBI...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 09-13-2011
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 of what’s possible in the Excel Add-in. Excel...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-25-2011
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 used to manage the master data in your organisation...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-22-2011
A Pattern To Load Data to Master Data Services via SSIS–Part 2

Introduction This is the second part of a series of blog posts intended to show a way to load data in to MDS via SSIS. In part 1 we have loaded the staging tables with new members and attributes for several entities. In this blog post we are going to extend the SSIS package with tasks to move the data...

Posted to Neil Dobner's Blog (Weblog) by Neil Dobner on 08-18-2011
A Pattern To Load Data to Master Data Services via SSIS

Part 1 Introduction Loading new members to a MDS entity will be a common requirement in all MDS implementations. In these blog posts I am going to walk you through building an SSIS package that performs the following processes: Load new members and attributes to several entities via staging tables Validate...

Posted to Neil Dobner's Blog (Weblog) by Neil Dobner on 07-14-2011
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 to highlight in particular John McAllister’s session...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 05-27-2011
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 (I certainly didn’t), Packt operate something called...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 04-01-2011

Page 1 of 2 (19 items) 1 2 Next >