Try defining $password as:

$password = "ge56hSW7U" | ConvertTo-SecureString -AsPlainText -Force

and then just using the variable when creating the object.

Personally I would be inclined not to have the password in the...

The following gives an outline:

Practical Statistics for Data Scientists by Peter Bruce

If the results are important consult with a statistician/mathematician.

https://www.experts-exchange.com/articles/13216/Migrating-your-Access-Queries-to-SQL-Server-Transact-SQL.html

Running Robocopy from the SQL Agent works fine.

You need to create a proxy with rights to both the backup directory and the share:

USE [msdb]

GO

CREATE CREDENTIAL YourBackupUser WITH IDENTITY = 'YourDomain\YourBackupUser'

,SECRET...

https://itsalljustelectrons.blogspot.com/2016/09/Enhanced-TSQL-Error-Handling-With-Extended-Events.html

Indexes should be designed with the whole system in mind, not just a single query.

Most third party applications that I come across have there own import routines. It may be worth doing some research to see if the app you are using has import...

https://www.brentozar.com/archive/category/production-database-administration/dba-training-plan/

I mainly monitor waits and latencies using code developed from the following to provide baselines:

http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/

If you have the money then a professional monitoring tool will provide more information. eg

https://www.red-gate.com/products/dba/sql-monitor/

https://www.sentryone.com/products/sentryone-platform/sql-sentry/sql-server-performance-monitoring

1. I think distributed transactions will only work between two instances of SQL Server.

2. The code should be SELECT CaseType, Status FROM inserted not SELECT CaseType, Status FROM [dbo].[tblCaseType].

3. It...

It looks as though you want to export blobs. I would do this quickly with powershell, something like:

https://andyspecht.github.io/2017-06-23-extracting-images/

Thanks Sue. This sound like a good idea; I will look into it.

Thanks for the information.
I already have agent alerts for errors 823, 824, 825 and 832 but regularly checking suspect_pages is a good idea I will look at.
My experience...