Author Archives: Jens Vestergaard

Filtering SQL Agent Jobs

I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Microsoft Visual Studio is unable to load this document

This issue has actually been on my TODO list for quite some time. Now I had to go back to an old SSIS package and do some changes, I got reminded of how annoying this bug is. The scenario is … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Did someone restart the server over night?

Sometimes, when you are running lenghty integration jobs over night, you get in the office the next morning, and may be surprised that nothing has completed. And actually nothing is running anymore. Today was such a Day for me. Last night … Continue reading

Posted in Programming | Tagged , | Leave a comment

Run your cubes in Warp Speed – Really Really Fast!

So, finally Microsoft came up with a new feature for the MOLAP part of Analysis Services. The community has been hungering for updates ever since the new kid Tabular came around. Now it apears that the SQL Server team has … Continue reading

Posted in Programming | Tagged , , | 1 Comment

How to Process Multiple Dimensions via BIDS and SSMS

This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading

Posted in Programming | Tagged , , | 1 Comment