If you are on Enterprise Edition for SSRS - then you can add the new reporting services server in a scale-out deployment.  Configure the new server to use the existing...

There is also the schema changes report available - that shows not only changes to tables but will also show changes to any objects and who made the change.  However,...

Why would you do that?  That would just mean rerunning this code over and over until all rows matching the criteria have been deleted.  What purpose would that serve?

I have already put code in place to block the NULL values for some of the Attributes, not sure why is was ever code to allow those into the...

The steps you outlined are correct - that process will allow for patching with minimal interruption.

This is a basic template for a batch delete/update/insert process:

Declare @rowsAffected int = 1
      , @batchSize int = 50000;  --increase/decrease as...

What is the purpose of the AG node?  I am assuming that the FCI cluster is primary - SERVER3 is an AG secondary, and that secondary is set to asynch...

Ola's utility - and many procedures that were built to do the same thing - will have a post-step after an index reorganize that updates the statistics.  So either a...

That is expected - the /netonly credentials will be used for that connection even though it shows your local windows credentials.

Not much we can go on - would help if you showed the code that is causing the issue.

I am not sure I understand the request - what are you trying to accomplish?  Can you be more specific?

There is the option of filtering the dataset, which you can...

No - but I ask again.  Have...

If the user owns a schema - then they will be able to create objects in that schema unless explicitly denied (and I am not sure if that can be...

One of the reasons you would not want to loop over a list of tables is the fact that you have now serialized the extract and load process.  Using separate...

If you run your alternate function without a where clause or group by - does it return any data?  If it does return data - does it return data where...