There's some tutorials & videos at

http://sqlserverpedia.com/wiki/SQL_Server_Analysis_Services_Section

Not much newer than SQL2005 (some on Excel 2007), but most of it applies to any SQL version.

On a similar functionality, has anyone here used InMage and can comment on it?

I had a visit from an InMage sales rep yesterday, & it looks like it does the...

I've got all but my most recent jobs without holding any certs, and it didn't hold me back -- the experience won the job. On the latest employer however,...

To add another aspect to the PK vs. clustered discussion:

For .Net development, the DAL (data access layer) generators I've encountered (Subsonic .Net and NetTiers) force a PK -- unique...

As shown in this QOTD, adding/subtracting a number from a date is adding/subtracting that many whole days.

Is this standard behavior, or is this undocumented behavior that could change...

It's a long shot, but simple enough to try: clear your procedure cache (assuming that your system can take the hit for recompilations).

I once dealt with a similar issue. ...

Data-driven subscription is my reason for the upgrade. All other components are already at enterprise, and when I went to start using SSRS on the cluster I was unpleasantly...

In the environments I've worked in, Compliance is the system/company controls & procedures put in place because regulations (like SOX or HIPAA) and company policy demand it.

After a review (official...

You're right, it is a generalization. Like I said, "In my experiences and in the Minneapolis market". I don't intend to speak for anyone else or any other...

At current employer, SSRS 2005 & 2008 - better suited to an audience that prefers exporting to Excel & spinning the data from there. I'm using 2008 Express with...

I've used the DNS aliases with great success.

Why I like them:

1. As already stated, you can move your DB without changing any application.

2. Absolutely use it with test...

We're only loading through the Lucene (.net) API.

For what it's worth, we're also looking at dtSearch. Same concept for feeding data.

Advantages: testing shows full build in 20% of...

The data is getting laid out in a denormalized form so it can be put into an external indexer (Lucene) for web sites to use for term searches.

There's a lot...

Very nice! It's working and performs well.

I'll have to try this in similar places using functions and CTEs, and see what performs better.

I can end my week on a...

I can work with this idea. I'm not great with XML so the XML piece didn't occur to me.

This introduces a new problem:

I have a value like "Pasta &...