Category Archives: Quick Tip

SSAS development quick tip

Posted on April 9, 2012 by

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 | Leave a comment

Preventing projects from deploying when debugging a SSIS package

Posted on September 2, 2011 by

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

Posted on August 3, 2011 by

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 | Leave a comment

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

Posted on May 11, 2011 by

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(*)

Posted on May 9, 2011 by

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