They used to be absolutely good things to do a really long time ago (2005 and older) when upgrades were really interesting beasts and hardware was "weak" and really hard...

+1 on Steve's recommendation for side-by-side upgrade (aka migrate).

Assuming you've done all the necessary prep work and verified your app, tools, scripts, etc... will work with 2016, SxS upgrades...

Adding to Erland's tidbits:

3) Having a meaningful name for the owner is useful in some environments. In the simple scenario, a single name like Erland's works great. You always know...

If you must have all or nothing for the entire dataset per ETL operation, an explicit transaction wrapping the bulk copy/load gives you that control (instead of batch level). Also,...

Gail Wanabee (12/2/2016)

---

Michael, I responded to part of your suggestions in another post, want to complete it here.

The vendor won't tell us a lot about their hyper-convergence solution; it's patented,...

If it really is raw disks/partitions, please get them to explain why and what data do they have to back their "why".

In the days where server disks spun at 7200rpm...

If you really want to separate the data provider and data consumer, perhaps using asymmetric keys is the better solution? That way, those that enter/update data encrypt using the PubKey...

This may sound weird but if you go through the SQL Server for the Oracle DBA class by Microsoft, you'll actually be able to learn quite a lot, including some...

krypto69, your description fits StretchDB's scenario very nicely. However, as Karen indicated, Azure Pack doesn't have all services available with the public Azure service. Many of them are temporary, that...