I was eagerly awaiting the new Release Preview of Windows 8 as I was hoping it would address some of the shortcomings with respect to the Microsoft BI Stack and Windows 8 that I blogged about before. One of the new features introduced in to the IE 10 was Flash support. I have not read … Continue reading PowerView in Windows 8 Release Preview
Tag: Master Data Services
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
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
Hello world!
Welcome to my site... starting out with an obligatory Hello World!... I decided to name this site AQTInsight.. or phonetically, acute insight... or a cute insight... all of these work... and I also came up with a logo
business intelligist 