+1 - no pun intended.

+1

I admit this one confused me a little. I wasn't sure whether the PowerView add in was enabled at this point, so I assumed it wasn't and chose...

Thanks for the question. I learned something new today.

+1 - thanks for the refresher.

This technique works well enough, I've used this in production code against SQL 2008 R2. However, not sure if this works in 2005 or prior versions.

Andre Ranieri

@sqlinseattle

Very helpful Hugo. Thanks for the clarification.

Andre @sqlinseattle

It makes it hard to go onsite with a customer that's still using SQL 2005. That, and I keep forgetting at first why Intellisense isn't working.

Original question didn't mention 1) minimum requirement and 2) Express Edition.

I chose none of the above due to the recommended minimum 4GB for all non-Express editions.

Did you find any white papers or information on this topic? I'm involved with planning a BI system upgrade from SQL 2005 to 2012, and trying to find MSDN...

I have a slightly different scenario - SCOM informed me that the user database volume in one of our test environment SQL servers is down to 8 GB free space....

Congrats to all the winners!

Andre

This example uses T-SQL windowing to calculate the median price for a bundle of services in one particular service line. I use windowing functions all the time to...

I started as an IT generalist before gradually migrating to a development role then SQL data specialist and DBA. I still have a keen interest in storage and...

Adding all rights is ok for my sandbox environment, but what is the best practice for assigning rights and permissions to SSAS in a production environment?

What are people doing out...