New updates are focused on performance. You can download the latest version here. Although the title states it's for SQL Server 2014, the plug-in also works with SQL Server 2012.
Category: Master Data Services
How to restore your MDS database on a different domain/server and fix the “Access Denied” error
This has happened to me a few times now and every single time I had to spend quite a bit of time sifting through the blogs looking for answers. So I finally decided to document it for myself here. These are the steps: Go ahead and restore the MDS database on the server of your … Continue reading How to restore your MDS database on a different domain/server and fix the “Access Denied” error
SAP vs. Microsoft, Information Assets vs. End User Experience positioning
If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle … Continue reading SAP vs. Microsoft, Information Assets vs. End User Experience positioning
Loading data in MDS programmatically
As I demo MDS, there is one question that is asked pretty often - "Do I have to use the Import Wizard to pull the data from the Stage table into the MDS table?". Microsoft made this a little bit confusing so I am going to explain how Stage sync can be initiated programmatically. There … Continue reading Loading data in MDS programmatically
How to create Sharepoint workflow for MDS
Microsoft Master Data Services is one of the most exciting new features of SQL Server 2012. Technically, the V1 of the product was introduced with SQL Server 2008 R2, but to be completely honest, it did not get much acceptance. In my prognostication, this will drastically change with the V2 of the product. There are two … Continue reading How to create Sharepoint workflow for MDS
How to expose Master Data Services in SharePoint
I have been hacking around this for a while trying to expose MDS web application in SharePoint. Apparently, the trick to remove the non-functional UI elements is to use hosted=true query parameter as in http://MDSWebAPP:PortNumber/MDS/Explorer/AttributeSL.aspx?MID=10&VID=23&EID=44&hosted=true#/ExplorerEntity?MID=10&VID=23&EID=44&hosted=true you can find more details on how to do it here
Free technical book “Introducing Microsoft SQL Server 2012” is available for download
The book can be downloaded in PDF , mobi (Kindle) or epub (sony reader) formats... The book does a really good job introducing such new features of Microsoft SQL Server as Data Quality Services, Master Data Services, PowerView and BI Semantic Model.. and it's free, definitely a good idea to make it part of your technical library. If this sounds like too good of a … Continue reading Free technical book “Introducing Microsoft SQL Server 2012” is available for download
Configuring Security for Microsoft Master Data Services in SQL Server 2012
I spent quite a bit of time today troubleshooting a very annoying issue with MDS, which turned out to be a total user error. For the longest time I could not figure out why my MDS users could not connect to my MDS models. The confusion stems from the fact that even though you can … Continue reading Configuring Security for Microsoft Master Data Services in SQL Server 2012
Drillable charts in Mcrosoft Office 15
I believe that Microsoft has delivered a very solid release with SQL Server 2012. I love MDS V2, I am giddy with excitement about columnstore indexes (still trying to hunt down any hints that would substantiate the claimed availability of this technology for Analysis Services), I think that PowerView will be a huge success, although … Continue reading Drillable charts in Mcrosoft Office 15
Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services
Not sure if anybody is using Microsoft Virtual Academy.. if you are not - you should... What's the compelling event? Well, 7 freshly minted modules have just been posted for our perusal: Developing and Managing a BI Semantic Model Configuring and Securing Complex BI Applications in SharePoint Enriching your BI Semantic Models with Data Analysis … Continue reading Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services