Oh do learn Powershell. Don Jones is who I learned from. I can heartily recommend him. Great person. Great teacher.

In general, what you're doing here is attempting to treat SQL like it's a regular, functional, or object oriented language. It's not. SQL is declarative. Don't attempt to control the...

The pluralsight stuff is on demand, so you could still pursue it.

Another plug for the Accidental DBA book. It's a little long in the tooth, but the info in it...

Probably the stuff produced by the SQLSkills team for Pluralsight would be worth checking out. Not sure of the cost. I just know I trust the source. Otherwise, there...

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...