Category Archives: Quick Tip

SSAS development quick tip

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

Posted in Quick Tip, SQLServerPedia Syndication, SSAS | 1 Comment

Preventing projects from deploying when debugging a SSIS package

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

Posted in Quick Tip, SQLServerPedia Syndication, SSIS, Visual Studio 2008 | Leave a comment

How to Run Programs as a Domain User from a Non-domain Computer

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 setup the … Continue reading

Posted in Quick Tip, SQLServerPedia Syndication | 1 Comment

Dirty looking SQL, MDX, or DAX? Clean it up

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

Posted in DAX, MDX, Quick Tip, SQL Server, SQLServerPedia Syndication | 1 Comment

A quicker way than using count(*)

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

Posted in Quick Tip, SQL Server, SQLServerPedia Syndication | Leave a comment