I've edited the question to state Management Studio 2016.

As Grant mentioned, this has nothing to do with SQL Server versions, but the tools version. However, since these were linked prior...

Sean Redmond (12/13/2016)

---

A senior developer who recently left our company expressed the opinion to me that the DBAs should be in charge of the Data Access Layer.

He was very definite...

Markus (12/14/2016)

---

GeorgeCopeland (12/13/2016)

---

The release cadence may be increasing but the issues remain the same. I recommend upgrading vigorously, say 3-6 months after a release so there is enough time to...

Fingers crossed. The projections have me losing, but hopefully Rodgers, KC, and Crabtree can do something for me since I lost my main RB.

Charles Kincaid (12/11/2016)

---

One possible downside of the fast release pace is the expense of upgrading. Paying new license fee each year or two is going to be very unattractive...

Haven't seen this, either. I would think that it's similar to what you'd do for on-premise for a restore to the same instance. If it's a DR to another instance,...

I was thinking that, or a TVP that takes a list of IDs and then joins to the...

https://voiceofthedba.com/2016/12/13/t-sql-tuesday-85-cross-version-restores/

and

https://msdn.microsoft.com/en-us/library/ms186858.aspx

Are you looking for general ideas here?

I'd make sure your backups are working well and meeting your RPO/RTO for each db. Script out logins, linked servers and jobs to be...

Ah, apologies. My fault. Didn't fix the answer correctly.

should be ok now

Friday, hectic day as I get ready for SQL in the City next week and a flight across the water on Sunday.

Then I'm off for a week, so if I'm...

Yeah, I think the initial note I got a couple weekw said that TDE would be included, but I realized this week it wasn't. Forgot to correct things.

Fixed and points...

Feels like an order of magnitude too high (at least) to me. I'd say $10,000 a year for 1TB, or maybe 10TB, not 100GB.

There aren't good tools here. You can use Xe/trace/distributed reply to gather a workload and replay it, but I'd do that against a test instance before applying patches.

Really you should...

Testing has uncovered a few UI issues, and with people leaving for the holidays, we are delaying this upgrade until early Jan.