Jeff Moden (10/7/2015)
My problem with "new and improved" software is that the software vendor frequently decides to no longer support features that are actually incredibly useful. To wit, it may be "new" but it's not always "improved" for anyone except the software vendor.A great example of this is the newer date/time datatypes they came out with in 2008, which has much less functionality than DATETIME. If they ever decide to get rid of the DATETIME data-type, then I will make a pork-chop run on Redmond. 😉 And deciding to no longer support the very old sp_MakeWeb task was a real killer for me when than little goodie was first announced. SSIS isn't the answer to everything! :sick:
Agree on the first point. I sometimes hate the changes that remove old stuff I use.
On datetime, that's never leaving. It's in so much code, that I can't ever see this being removed.