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

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 SQL Server 2012 Data Alerts

Data alerts is one of the most exciting new features of SQL Server 2012 that allows users set up alerts based on Reporting Services reports.  These alerts generate email notifications bases on the query parameters specified.  Several things need to be configured in order to enable this functionality: Report Datasources must use stored user credentials..

Continue reading

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

Consumerization of Business Intelligence

This is a topic that will get a lot of coverage on my blog.  I am planning to do some research on Business Intelligence maturity models.  There are plenty of articles written on this subject, however, these articles are usually scoped to a state of Business Intelligence in a specific company. The topic is not

Continue reading

…a long rant on Business Intelligence

This will one day evolve into an article, or a book, or an engaging conversation over a beer or two. For now, I just want to sketch out a few things that have been occupying my brain for the last few weeks… so here are a couple of angles to consider: Business Intelligence is not

Continue reading

colummstore compression for analysis services

Microsoft is claiming that xVelocity technology will be available across SQL Server database engine, PowerPivot AND Analysis Services… This technology works great for the first two, however, I couldn’t find anything on column store for the Analysis Services…. This would be a huge new improvement for SSAS…