• SQL Server Performance by Query Type

    The SQL Server 2100 parameter limit is a pain to code around when selecting lots of rows by ID and using batches of parameterized queries doesn't seem to perform very well.

    This performance study shows that you should definitely stop using batched parameterized queries for selecting rows by ID. They should be replaced with a temporary table approach for large batches, or constructed SQL strings if temporary tables prove unworkable.

    Read More
  • Period "to date" Equations in 2.8

    In version 2.8 there's a new equation you can use for calculated metrics called “Period to Date.” You can use this to create metrics with values based on rolling sums of other metrics’ values or thresholds. For example:

    TD(Quarterly,123)
    would result in a quarter-to-date sum for metric 123's actual value.

    Read More
  • Increase Dashboard Text Size in 2.8

    The default dashboard text object size used to be fairly small.

    Read More
  • When you're adding objects to a dashboard, the first step is to select the organization of the object that you want to add. In version 2.8 We now start with the organization where your dashboard is located, which makes building dashboards much easier.

    Read More
  • Are you a recent college grad looking to land that awesome job selling software? Are you an experienced marketing manager looking to make a big career move? Maybe you’re a rock-star developer, looking for the perfect job.

    Read More