RESTORE DATABASE name

WITH REPLACE, --if it's there already

MOVE 'file' TO 'x:\newfile.mdf',

MOVE 'log' TO 'z:\newlogfile.ldf'

Automate this.

However, I think Phil pointed out an excellent question, should development be occurring on a production...

Not necessarily replication. I'm very hesitant to ever suggest using that technology because it just doesn't get adequate support from Microsoft. No, instead, if you can write once and then...

Grant,

what would be a short checklist

of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...

Grant,

what would be a short checklist

of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...

It doesn't...

It's not always about performance. My company has largely stopped buying servers (I think, one in the last 6-7 years). Instead, we're hosting most things on VMs online, or in...

I'd focus on the queries to see what's causing the pain. Document it for the vendor. Also, maybe a judicious index or a plan guide could fix the issue. Capture...

By secondary I assume you mean a differential? Or maybe you mean a file or filegroup backup. If the first thing, nope. You're stuck without the primary backup. If the...

There's not enough information here to go on. We could be looking at all sorts of things from bad or missing indexes, out of date statistics, blocking and locking, to...

You are in a tough spot. Most organizations, like you, don't have adequate IT experience and knowledge to manage development well, assuming you get a good contractor who isn't out...

Sorry. That was meant as a joke. Apologies.

Both? I mean if we're going for clarity. Although, if I see xxTable as a parameters defined data type, I'm going to assume something custom.

Online trading didn't kill financial advisers, prefab construction didn't kill architects, TV dinners didn't kill professional chefs, blogging didn't kill journalism, NoSQL didn't kill SQL, and DaaS won't kill...

I've been saying this for years. Take CosmosDB. No DBA needed. However, there is an HA/DR aspect to it. There is the need for performance tuning. There is a need...

You're looking a fully customized CRM solution built from scratch? Yeah, a few months, at least, to deliver that. However, weeks to start releasing code to you if they're doing...