https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

As I am sure you are aware, extensive testing, including stress testing, is key to any migration. Personally I would be loathed to put any critical production systems on a...

It is a lot easier to get recent backups from the tables in msdb:

Can't Restore DB – SQLServerCentral Forums

I have had a similar problem with Install-Module. What I installed only seemed to work correctly from VSCode so I gave up using the ISE. As I will soon be...

Some basics of version control can be found here:

https://www.sqlservercentral.com/books/sql-server-source-control-basics

Git is also worth looking at and integrates with Azure Data Sudio:

https://www.w3schools.com/git/

Even saving files on OneDrive can help as it...

You are going to have to read up on this yourself as it is too involved for a post.

Personally I would not have a SP acting across two databases with...

More information is required. What is the error etc. When using Service Broker you will have to monitor it in case it stops throws errors etc. You should get out...

These are backups taken using the SQL Server VSS Writer service which was presumably invoked by whatever backup software your infrastructure team are using to back up servers. If you...

• This reply was modified 1 year, 6 months ago by  Ken McKelvey.

The combination of [Item No_], [Variant Code], in BBI$Barcodes, is obviously not unique so you have to find some way to make it unique. eg If BBI$Barcodes has a DateAdded...

1. Set your db compatability to 110 (SQL2012)
2. Enable Query Store and let your app run for a few days.
3. Set your db compatability to 150 (SQL2019)
4. Wait a bit...

In SQL Server UTF-8 collation is only available with SQL2019.

With SQL2016,  you might be able to get away with importing into a varchar with a French collation. (eg French_100_CI_AI)...

You will get a quicker reply if you post consumable test data:

CREATE TABLE #t
(
   emp_id int NOT NULL
   ,check_in datetime NOT NULL
 ...

• This reply was modified 1 year, 6 months ago by  Ken McKelvey.
• This reply was modified 1 year, 6 months ago by  Ken McKelvey.

It is difficult to tell exactly what you are doing but a trigger on a log table sounds a bad idea. All the triggers will be within the transaction so...

• This reply was modified 1 year, 6 months ago by  Ken McKelvey.
• This reply was modified 1 year, 6 months ago by  Ken McKelvey.

I am not sure about SSIS but, assuming your object is a DataTable, try SqlBulkCopy:

https://www.howtosolutions.net/2016/07/dotnet-save-datatable-into-database-table/

I am confused. You say you are using EFS which I would expect to be used by Linix but you then mention C: which would be used by Windows. I...