Thanks

??

I appreciate everyone's help as always. I ran couple of performance reports and found memory pressure. After a little bit of digging the culprit was the OS memory. It is...

will do. thanks again

Thank you! will create audits , I would not prefer extended events as it might cause little burden on sql server. Let me know if that is not the case?

Hi my friend, 

I was in your shoes 1 year ago and just studying is not going to help. Try to setup lab or please practice and practice.  
Let...

I figured it out that I might have to install integration services again.

Yes, SSRS  and we have plan on using others like polybase. 

Thanks.

I am sorry if it was not clear. Yes I can surely great new post. Happy new year!

maintenance plan was changed and because I see the differentail backup was for only user db's but it has been set to all db's which failed the job. I looked...

Thank you for the advice.

The SQL Server is 2016 version.
 Enterprise Edition: Core-based Licensing (64-bit)

Big Thank you! for taking time to respond of your busy schedule. Let me start working on your advice.

Sure, I will research about the SSISDB. 
Couple things:
Since now the migration is complete, I see there was sql agent previously on ( old system) and new instance...

Wow!. I get a bigger picture now. One of the other things I will be doing is to create SSISDB and wondering which we would need that?

In addition to automation do you recommend any books or strategy which helps in moving towards senior dba?