(apologies for the double post, post never confirmed)

We're the brave souls going first 🙂 New applications are being tested and launched on SQL 2016, so there's not much data there to begin with. Our second...

DBA Pete (5/4/2016)

Thanks for the script.

Note that it does not cover Availability Group database backups.

Ola Hallengren's maintenance solution places these backups in a separate folder for each Availability Group.

Regards,

DBA...

Hugo Kornelis (4/7/2016)

Nor should you. In production code, I would always write out the explicit intent instead...

Looked up the differing length comparison before answering, still got it wrong, but for a silly reason. Learned something, so thank you 🙂

Thanks for posing the question!

It seems SELECT is quite a bit more forgiving than SET. Changing the code in this question to use SET @LV = (SELECT) gives an...

One thing I did not see mentioned in any of the comments advocating one method or another was regarding data loss. Clustering is still the only method available that...

It's definitely a nice feature to have, however, it seems to me it will have a very narrow use in that you're limited by the fact that the scope for...