in case anyone hits this issue down the road, I found this article very useful.

https://ruslanmv.com/blog/How-to-connect-MySQL-Server-with-AWS-Glue

thanks Eddie, I've no issues paying for a subscription service, as long as it has a good quality library of lectures. I know when we had it at work a...

Hi Phil, apologies, I thought I did. I guess you cant hear the voices in my head 😉question from you - "Wouldn't this scenario (ie, PK exists, but other...

Thanks for all the replies gents.
The full flow of information is as follows :
1. Read the file in to initial load table, assign each file a batch ID

No date created or modified on the data. Primary key is combined from 2 columns but any of up to 80 columns could change driving the need for a new...

dbcc shrinkfile / dbcc shrinkdatabase always work great for me when I need to frag an index 😉

Hi just on the SSIS point I don't think the SSIS version has to match the SQL version. so maybe a check for multiple reg keys is in order for...

https://msdn.microsoft.com/en-us/library/ms175905(v=sql.110).aspx

where I've seen this before is a sneaky maintenance plan where the DB is shrunk making redundant the lovely reindexing work carried out before the shrink.

What could be worth doing...

If you have space you could rebuild your indexes onto new files / file groups and simply drop the old files (bar the PRIMARY file) once the reindex has migrated...