Posts Tagged ‘SQL Server’

Congratulations to Microsoft for being named 2012 Channel Champion for Business Intelligence Software by CRN. CRN provides news, analysis and perspective for VARs and Technology Integrators. Both SharePoint and SQL Server are Gartner Magic Quadrant technologies. From the article by Rick Whiting Microsoft (NSDQ:MSFT) was tops in this year’s Business Intelligence Software category, besting competitors SAP (NYSE:SAP), […]

Having been in consulting for over 18 years, I am often asked by business owners or senior management how they can deliver solutions that are faster and better. They also want world-class products that captivate the customer, in addition to better predictability in the solutions delivered. I have found a way to have repeatable success […]

I just finished reading the results of an interview I gave earlier this week to technology webzine www.CRN.com regarding the pending release of SQL Server. I was interested to know which parts of my 30 minute discussion with the technical writer would make it into the article. I was happy to see that the writer […]

So I just read the recently published BI magic quadrant analysis from Gartner and noticed a slight adjustment in the bubbles. The Microsoft BI platform continues to increase along the ‘Completeness of Vision’ axis (X), but the ‘Ability to Execute’ measure (Y-axis) slipped a notch and I wanted to know why. After reading the ‘Strengths’ […]

I was demoing the Microsoft BI stack to a client the other day and although PerformancePoint, PowerPivot and Power View showed well as always, I was amazed that the Q&A session gravitated back to the same old questions that I always hear. “Well what about Oracle?” “Have the BI tools made it out of the […]

Written by Andrew Holowaty – National Microsoft BI Practice

I wanted to share my experience with the new features of Mobile Entrée and how to leverage your existing Microsoft Business Intelligence investments as a starting point to building out the mobile platform. Mike Burger posted earlier regarding Mobile Entrée (found here). He stated the fact that it can integrate with SharePoint and render reports […]

In a world where data is collected for almost everything, companies often find they have trouble figuring out what to do with it. Theoretically companies could report on all their data, however, the larger the dataset gets the more money it will take to setup the infrastructure to support it. For most companies, especially those […]

If you happen to install PowerPivot on a SharePoint server that has prior SQL Server installation (SQL engine, Analysis Services, Reporting Services etc.) you will run into problems.   You may see error that the installation was unable to register Microsoft.AnalysisServices.SharePoint.Integration.dll assembly. Or if you are really lucky, you may get by far more helpful […]

It is almost impossible to have a conversation about Business Intelligence these days without talking about mobility. Mobile internet and data consumption is growing rapidly and it doesn’t look like that is going to change any time soon. There are many mobility options to choose from but not all of them work on all mobile […]

Problem: During one of my projects I found that the SSAS query log table seemed to be periodically getting truncated. I would notice this because I would run some queries against the cube, watch them get logged into the logging table, and then a few hours later they would be gone! I could not figure […]

Have you ever used the SSAS out of the box functionality to log queries? This can be used to see how many queries are run, how long each query runs, and which users are running the queries. If not, check out this blog for a description of some dashboards that can be created from this […]