-
Why I don’t think powerpivot will be a success
Just returned from the sharepoint 2009 conference, I’m really excited about all the new BI stuff. One of the things I’m really excited about is powerpivot. As you might have guessed from the title, I’m going to elaborate on why I don’t think powerpivot will be a success, in the sense I don’t think it… Continue reading
-
Error: Could not get a list of SSIS packages from the project.
When I was working with a SSIS project at a customer, I got the following error. Error: Could not get a list of SSIS packages from the project. I had CreateDeploymentUtility=true. That error description apparently indicate, that there is an error in the dtproj file. The solution: Set CreateDeploymentUtility=false, and then build the project again.… Continue reading
-
Start SQL server from the command line
SQL server can be started and stoped from the command line like this: Start: net start mssqlserver Stop: net stop mssqlserver The same goes for Analysis Services. Start: net start “SQL Server Analysis Services (MSSQLSERVER)” Stop: net Stop “SQL Server Analysis Services (MSSQLSERVER)” Continue reading
-
New web page
I just created a new web page. The site is in Danish, and it is a running site, where you can see statistics about yourself and compare yourself to other runners. You can see the site here: www.perfmon.dk or here: www.performancemonitor.dk Since the site is in danish, and don’t cover anything technical, it don’t really… Continue reading
-
Reporting services – Slow first hit
After reporting services have been idle for a time, the next hit on it can be extremely slow. This is, as with every other RS problem, an IIS thing. The problem is that when the IIS is not getting any traffic, it “goes to sleep”, to clear up memory for other applications. That is nice,… Continue reading
-
Derived column IF expression
I can never remember the SSIS if syntax in the derived column control, so Just so I can remember it myself 🙂 The syntax is like this: (compare) ? true : false So if x equals 5 and y equals 1, then this will return x (x>y)?x:y Continue reading
-
Maximum request length exceeded
When I was trying to deploy a report to the report server today, I got the following error message: There was an exception running the extensions specified in the config file. —> Maximum request length exceeded. First I was a bit surprised, because a report project doesn’t come with a config file. I turned out,… Continue reading
-
Not permitted to change tables in MS SQL server 2008?
When I started playing around with SQL server 2008, and tried to edit at table I just created, I often got an error sounding something like this: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that… Continue reading
-
Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object
I’ve been working a little with MS Analysis services lately. Yesterday I came across this error message: Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object.” The error message is self explaining. I did indeed have more than… Continue reading
