Is there much of a difference between single server and scale out? Or having SSRS separate from the engine? If so, maybe better to have separate articles. If it's just...

Hmmm, OK. I tried this:

CREATE LOGIN JoeDBA with password = 'xxx'
GO
GRANT ALTER ANY DATABASE TO JoeDBA

I then opened a new window, logging...

Gah, not sure what I was thinking. Must have gotten distracted as I was moving the code over. Corrected. The answer and explanation should be 0####

There have been reports from some people, others reported no change. I suspect this is workload dependent.

SQL in the City today, if you have time: https://www.youtube.com/watch?v=0qyMutBkZsg

Do you mean add a second instance? Is the first instance still there? Are you licensing by cores? If so, you can add new instances.

This appears after failover is complete? I would double check all the configuration and make sure every database you expect is in the AG. Make sure the database is not...

Should be the same procedure for the cluster. I avoid restoring master unless I really need it, preferring to move over the logins/linkedservers/etc if necessary.

Let us know if...

Never seen this, but not a deep SSIS guy. I'll ask a few others.

Sean is correct, you have asked a vague question.

A covering index includes all the information needed for a query. This means the columns in the SELECT list, as...

I've been in this position as well. People give me stuff because they know I'll do it better, even if it's outside my area. Automated some staff termination stuff to...