Access your Pro+ Content below.
Catching up with Master Data Management products
This article is part of the November 2010, Vol. 4 issue of SQL Server Insider
Have you ever been in that conference room during that meeting—when different managers are battling it out over widely-divergent sets of numbers that all allegedly came from the same place? In the data-saturated world of businesses, that situation is becoming all too common. The variations don’t just come from different interpretations of the same data; it is different people coming up with entirely different sets of data for what should be the exact same business function. Not only is this frustrating, it’s also dangerous. The focus on business intelligence (BI) has many companies scrambling to get their management dashboards in place. Companies want to see data in intuitive, simplified forms. However, until fairly recently, there wasn’t a big focus on the quality of the data in those systems. The old saying of “Garbage in, garbage out” is more applicable than ever as businesses attempt to eke out every possible advantage by using the data at their disposal. In our thirst for data, however, we may have generated a bit too much ...
Features in this issue
SQL Server 2008 R2 hosts the Master Data Services feature, which can help businesses standardize sets of data. Microsoft didn’t quite let MDS gestate long enough, though, and it lacks a few crucial qualities.
When used properly, the robust business intelligence stack in SQL Server 2008 R2 helps companies run more efficiently. Are you getting the most out of your BI?
SQL Server 2008's data collector feature automates the collection of critical performance data, which DBAs can then analyze using brand new SSMS reports.