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.

I can see an ambiguous pronoun in there (bad Steve). Corrected

djackson 22568 (12/8/2016)

---

How about this?

Develop a project plan that includes either writing new code, modifying code or both. Come up with a few specific tasks that fit. Then...

RIP, Mr Camps from last year,

RIP, Mr Glenn, today