Eleven Challenges in Unifying Reference Data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Poole » Eleven Challenges in Unifying Reference Data

Eleven Challenges in Unifying Reference Data

Rate Topic

Display Mode

Topic Options

Author

Message

David.Poole

Posted Wednesday, December 19, 2012 11:31 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:16 PM
Points: 2,749, Visits: 1,405

Comments posted to this topic are about the item Eleven Challenges in Unifying Reference Data

LinkedIn Profile

Post #1398790

Mike Dougherty-384281

Posted Thursday, December 20, 2012 8:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 198, Visits: 677

great article. I liked the story it told. I imagine anyone who has been through it before recognized a lot of the issues you mentioned. Anyone who hasn't done it already should view it as a roadmap with carefully labeled potholes/pitfalls.

I wonder if anyone else read this title in their email subject as "Elven challenges..."? I was initially expecting Middle-Earth DBA building a single grand lookup table. :)

Post #1399004

David.Poole

Posted Thursday, December 20, 2012 8:41 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:16 PM
Points: 2,749, Visits: 1,405

I wonder if anyone else read this title in their email subject as "Elven challenges..."?

I to am being pestered to take the kids to see The Hobbit!

I suspect that, if pushed, the development community would describe DBAs as data orcs Wink

LinkedIn Profile

Post #1399019

gavwat

Posted Thursday, December 20, 2012 3:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 11:36 PM
Points: 4, Visits: 41

Thank you for sharing such a detailed and well-explained solution.

Quick question: At the time did you evaluate SQL Server Master Data Services (MDS) as an option for your Reference Data requirements and have you subsequently looked at the possibilities around Reference Data in SQL Server's Data Quality Services (DQS)?

Post #1399124

David.Poole

Posted Thursday, December 20, 2012 4:27 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:16 PM
Points: 2,749, Visits: 1,405

I've been to a few presentations on DQS and to be honest it looks like a version 1.0 product. It seems to be a question of shifting your data to the service which given the size of the data would be impractical. The last two SQL Bits sessions on DQS looked interesting but didn't give me a light-bulb moment.

I haven't had the chance to look at Master Data Services yet but it is on my radar.

LinkedIn Profile

Post #1399128

Jeff Moden

Posted Saturday, December 22, 2012 10:08 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

SPAM reported.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1399729

Neha05

Posted Monday, December 24, 2012 11:20 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55

Nice article

Post #1399939

« Prev Topic | Next Topic »

Permissions