Month: Sep 2020

Cleaning Up with PowerShell

Post author By Andy B.
Post date Sep 27, 2020
No Comments on Cleaning Up with PowerShell

Data has a tendency to grow and every now and again needs some pruning. Flat files can be a big offender, particularly if you’re looking at transactional data or a backup repository for example. If you’re looking to script this process for cleaning up then PowerShell may be a great choice. It’s freely available, quick […]

SQL Server SSIS

Tidying up the SSIS Database

Post author By Andy B.
Post date Sep 20, 2020
No Comments on Tidying up the SSIS Database

If we’re running SQL Server Integration Services (SSIS) then it’s database is the wonderful place where we store our packages ready for execution and the lovely logs we can interrogate when those packages inevitably break (of course not, our code is perfect, right?) This database is all well and good in a fresh environment however […]