Microsoft has a solution for centralized data management.
It's called MDS or Master Data Services.
It allows data to be stored in a separate database with Models, Entities and Attributes.
A Model is basically a database schema. An Entity is a table. And Attributes are fields.
can import your data through staging tables. You truncate the table,
load your data and execute a Stored Procedure to upload the data. Once
verified the data is available.
You can also create Views to access the data. And you can scan your data using the online website.
Another cool feature is a downloadable plug in for Microsoft Excel which allows Inserts, Updates and Deletes via Excel.
go through all this? To have a centralized storage location for
specific data to be maintained by end users or database developers.
longer do we store employee information in 9 different places, making
reporting difficult and inaccurate. Now we have a single source of data
to query against and populate the data warehouse.
Here's a quick link to get you started: http://msdn.microsoft.com/en-us/sqlserver/ff943581.aspx
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
This blog post is in no way an attempt to steal other people's work. It's basically an conglomeration of notes from research I did...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...