Not trying to be a wise guy...are your PROD and DEV environments not the same version?

That is interesting to know!

Even though it worked for you, you may want to review Microsoft's documentation on upgrades (for SSRS) - both in-place and migration.

Hope...

I read through the comments on this thread and hopefully haven't missed anything.  I don't think you can restore an SSRS database up to a newer version.  This is what...

Hey Mike,

It sounds like you have what you need, but I was wondering about virtualization.  Does your shop virtualize SQL Servers?

Hey Duran,

I may not be understanding your situation correctly, but it sounds like XML would solve your problem.  I would have a procedure feed your parameter.  The procedure...

Hey Ron,

Sorry I missed the email notification on your post.  Here is an example of what worked for me.

=IIF(Aggregate(Fields!RM_Total_Distinct2.Value) = 0, 0,...

Came here today to answer a question and learned something instead!  Thanks Eric.  I think most of my fact tables are Transaction Grain, but I'm excited to go into the...

So funny to see this post today!  Just yesterday I had what may be the same problem.  I have a Tabular model where I am aggregating a distinct count.  In...

Hey Paul,

Thanks for the posting!

You said, "Although not an substitute for a proper disaster recovery plan, Point-in-Time Restore is a great feature of the new SQL Azure Service...

Hey Paul,

What happens in a disaster recovery scenario where you lose msdb? Are your restore scripts only going to be as current as the backup history in msdb? ...

Thanks ajay 44186!!

Are you saying you just want to shred the XML and insert the data into the tables?

Thanks Grant! I appreciate the help. So would you say that polling isn't necessarily a bad idea in and of itself?

P.S. Your books have been a huge help!...

I currently work in a very small shop with a limited HA/DR plan. I have been looking at the options to enhance our plan and AlwaysOn seems really cool....

Great post! Sure would like to have the book! 🙂

select p.ID, p.PC

from (

select

m.ID, a10.PC

, ROW_NUMBER() over (partition by m.AN, m.ID order by case when a10.ED is null...