You...

Strong recommendation, if you're upgrading from 2012, don't go to 2014. Go straight to 2016. There are a lot of reasons for this, but I'll give you one big one....

Everyone,

Thanks for all the wonderful feedback. I appreciate the discussion.

I will add one point to the editorial. I'm not a fan of how Microsoft handles their...

Reinforcing what Gail said and adding one more wrinkle. The nice thing about the side-by-side install is that you can use log shipping to set up a  process that will...

There just isn't a single answer here that's going to satisfy all situations. I've maintained systems that had statistics maintenance running anywhere from weekly to daily to, for one table...

Absolutely directly.

Slower and fewer CPUs mean less processing power. Less memory means more disk I/O to process data. Slower and fewer disks means slower disk reads and writes....

You have to look at the T-SQL within the extended event. There isn't a tool out there that captures metrics by table. Any given query or batch can be hitting...

I'm not aware of something inherent in 2016 that would make that run slower. You are going to be dealing with the new cardinality estimation engine (at lease when the...

It sounds like your machine is completely underpowered. You need memory. I/O implies disk, but it includes reads and writes to memory plus reads and writes to disk. If you...

Connecting from ADO in Powershell should be the same as VBA. I use the full server name provided: xxx.database.windows.net. That ought to work for you. You will need to make...