We are using LiteSpeed for backup compression and restore) and Foglight (with performance analysis add-on) for Performance Analysis. So far are quite happy with both tools.

Maybe your server was over utilized at that time and you exceeded number of Max Threads. See if changing “ThreadPool \ Process \ MaxThreads” and “ThreadPool \ Query \ MaxThreads”...

Start performing Diff backup

It happens rarely in UAT, when different teams are applying their scripts automatically overnight, without knowing what the other team is doing or for any other reason.

So in those cases...

Not for the Prod env of course. But for Dev or UAT, when Database can be easily restored from the backup, it...

We have similar process, when we copy full backup on the weekend and diff backup(s) on the weekdays...

I know. I was using that for non-production data

I am using abs function:

WHERE ABS(DATEDIFF(DAY, @prev_date, @end_date))...

Second Grant. We use RedGate SQL Compare and Data Compare for over 4 years and it allows us do a lot of things you cannot do with a script.

for 'future' databases-create a user in a Model DB and every time you create a new database, that user will be there.

I used to run it using a set of sp_OACreate\sp_OAMethod procedures. I don't have my procedure around, since I didn't use for the last few years, but I am sure...

Make a backup of your fragmeted DB before running reindex. So every time you will need to test your script, run a restore and then run your script

You can't say that!

You defentely spent your time and money wisely, since you invested in yourself.

All you have to do now is to come up with a sound plan...

There are certain rules which you have to follow if you want to achieve the desired outcome.

Also there is a difference between immigration and getting a job in US. Please...

You want to move out from Russia or just want to work in US?

I don’t think that dealing with a one or two agencies will do any good for you....