If you've set up the credentials on the server, then you should be all set to run the backups. The documentation here is pretty clear.

A view does not stay in memory at all. Unless, you're simply calling SELECT * from the view. A view is just a query. The query that calls that view...

And yeah, total agreement on ignoring the list of required technologies. That stuff is a nightmare.

Story time:

Leaving my previous employer after 10 years (all good with them, I just wanted...

As you said certificates don't replace experience. My intention is very much to a) to add to my knowledge in a way I can demonstrate b) to genuinally add...

I did something similar once. We had a version table. Everything did an insert to the version table to get a version ID, then that ID was used across all...

Let's be clear, opinions all stink and this is very much my opinion.

You're going too broad. SSAS, SSRS, SSIS, data warehousing and Azure (which, all by itself, ENORMOUS topic) is...

A day late, but testing, as always, is going to be your bestest buddy. I'm not aware of any fundamental issues in the move from 2014 to 2019. You're already...

The key difference between openquery and a linked server query is where the query processing occurs. In a linked query, all the processing occurs locally. In an openquery, the processing...

Seriously? An official, company-wide mandate to DB coders to use this?...

John,

Lots of employers will still sponsor training. However, it's not like it used to be. But even the old days weren't what we remember. I worked for a consulting firm...

Eric, first, thanks for the kind words. Second, while I'm not unemployed currently (and fingers crossed, "currently" lasts another 10 years), I do feel your pain. I'm also 57 and...

A couple of things. First, you don't need both. If you set the compatibility mode to 110, you get the legacy cardinality estimation engine. No need to also set that....

Good luck on it.

One point, document the time you spend on building & maintaining monitoring. Time absolutely is money. It's time you could be spending elsewhere on much more important...

Ah, cool.

No, I'm not aware of any way you can do anything with data within the VMs other than what is normally provided. You'd have to move to RDS to...

To "get around licensing"?

No. You either have a licensed instance installed on a VM, or, you use the AWS RDS SQL Server instance, and the cost of RDS includes the...