When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes). This means a lot of sitting around … Continue reading →
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am writing a blog about it, will be able to solve it in no time (a big benefit of blogging is to never … Continue reading →
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must use our own. Usually that is preferred anyway, as we have all the software and tools installed and … Continue reading →
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a website, or pulled from SQL Profiler, that is difficult to understand because it’s not formatted? Well, there are a couple … Continue reading →
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever to count all the rows in a table? I had this problem when I would sometimes run counts on a … Continue reading →