of days specified in the RETENTION_WINDOW setting of the SSIS catalog. Note that this script was created using SQL Server 2017 (14.0.3048.4). Depending on the SQL Server version, the table and/or ...
Model a mini-datawarehouse (with the fact table and dimension tables) to store the collected data for analysis (star / snowflake model) Create an SSIS project allowing to integrate all this data, ...
Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...
IS Support executing SSIS Package from file system in MI Agent Job. Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration ...