I was able to change the columns from nchar to int, no more trailing spaces 🙂

The lookup is on the table

SQL Server must be running under a domain account, NT Service isn't one.

Asides that, for Kerberos there must be a separate SPN if you want it to...

Then try to split into more files, 20 Jobs get scripted out like instantly here, maybe try less than 180 Jobs at a time, say 30 or 60 so you...

msdb can only be copied over if servers are on the same patch level.

As an alternative you can go to the Jobs, in Object Explorer Details you can...

Well, you should differentiate between 24/7 Remote Monitoring which is what "Pythian" is offering, which usually involves one central number for the customer to call when things go wrong etc....

Could something like DBAReports be of use for you?

Yes, create the user on the Primary, create the Login on the Secondary with SID from the Primary.

Yo don't have to run a Cluster in Active / Passive configuration, you can run MSSQL in Active / Active Configurations aswell as long as your application supports it. Asides...

So what does that Registry Key have as value in that FullTextDefaultPath?
Most likely the path does not point towards your SQL2014 Installation but your 2008R2 which was upgraded...

If you need a domain for your Windows Failover Cluster mostly depends on your OS Version: If it's 2016 you don't need a domain, older versions do require an Active...

I was hired to mainly solve some Performance Issues until End of this year. Ofcourse I solved the biggest issues within 3 weeks. I still have work to do but...

I can give you some hints regarding working as a DBA freelancing, let's start with your list first.
1. mostly yes, small companies neither as they usually have some kind...

With every new customer asides looking at their Performance issues first thing I check and ask 'Why?' Are the SQL Server Version and Edition.

One of my customers...