I also favor migration.  What we have done to address the issue with applications referencing the server name or even the IP address is to keep the same name and...

Right.  What I'm suggesting is that you use...

Sorry to hear about the problems you're having with Service Broker.  I tried Service Broker for a limited use-case a few years back after being introduced to it during an...

Maybe because Microsoft wants you to use the Integration Services Catalog 😉  (joking of course)

Are you using the Integration Services Catalog?

Hey Kyle,

It sounds like you could be crafting a report that ends up performing poorly (i.e. renders slowly).  I'd recommend you consider how to get down to just...

I had to remove the field I had in Series Groups to get it to work.

I was able to duplicate this problem.

Check this out - https://www.experts-exchange.com/questions/28601392/SSRS-2008-R2-Line-Chart-Add-Calculated-Series-option-is-missing.html

I always try creativity and look for a different option before moving in a drastically different direction.  Hope you find a good solution without too much headache 🙂

If you are looking at a Multi-Dimensional cube in Excel and hover over something with these properties, you get a nice pop-up with those additional values.  Is that what you...

Data Driven Subscriptions were Reason #1 we first transition to Enterprise Edition.  I've been using them for years now.  How you are applying them now is one great example of...

Cool post!  I've never tried restoring from Enterprise to Standard.  Just confirmed that I was able to restore without any issues (from 2012 Enterprise to 2014 Standard). 
SELECT feature_name...

Where there is a FK constraint, you must DELETE FROM instead of TRUNCATE.

Glad you found that!

Still may be a good idea to think about getting both environments to the same version.

Wow, lots here!

First, tons of differences between 2000 and 2016.  You should get schooled up first.  If at all possible, get a certification ASAP.  The cert process has...