One of the greatest strengths of SharePoint as it pertains to the world of Microsoft Business Intelligence is its ability to bring together various components of the Microsoft BI stack into a seemless user experience. When it works, it works great, however, when it does not quite work, it gets very annoying.. Recently, I was … Continue reading Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard
Tag: SQL Server 2012
Column Store indexes – performance tuning and best practices
great article about Column store indexes and best practices around them
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
SQL Server 2012 and Hadoop
Seems to get a lot of attention from Microsoft. Richard Chin who is leading the SQL Server businesses for Microsoft had a long talk about it at the launch event. With a host of great features coming out in this release (MDS, DQS, PowerView just to name a few) of SQL Server, it seems a little … Continue reading SQL Server 2012 and Hadoop
xVelocity
Microsoft is re-branding its Vertipaq in-memory engine that is currently used in PowerPivot and naming it xVelocity. That's hardly worth a blog entry per se.. Howerver, and this is big, xVelocity now is added to both Analysis Services AND Database engines... Supposedly, this technology incrases preformance of the existing relational queries by 10-100... I will … Continue reading xVelocity
business intelligist 