About
This blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.Search
Categories
- Conference (21)
- Development (208)
- Security (17)
- Test (32)
- Tooling (166)
- Uncategorized (168)
Most used tags
Tag Archives: powershell
Automate changes in SSIS packages
We use Sql Server Integration Services (SSIS) for importing and exporting data. The number of SSIS packages is stil growing and on writing this post we have 35 of them. Changing the database connectionstring for development means opening and editing … Continue reading
Parse IIS logs with powershell
With the log4j CVE we’re checking our IIS logs in detail. To automate this we’ve created a powershell script that parses the logs and provides query access. Below a script that searches for 502 responses and prints the fields we … Continue reading
Lift and shift SSIS package
We use Sql Server Integration Services (SSIS) to import text files into our database. The dtsx files are deployed into the MSDB on the Sql Server. Everything works well with deployment with a powershell DSC script. But times change and … Continue reading
Webdeploy connectionstrings to xTokenize
We have an asp.net webapplication (full framework) and deploy it using release manager. The bits are in an artifact that is created during build with the contents of the webdeploy zip and a powershell desired state configuration (dsc) script to … Continue reading
Posted in Uncategorized
Tagged Build, deployment, DSC, powershell, release management, web deploy
Leave a comment
Update SEQ with Powershell DSC
We user Powershell Desired State Configuration (DSC) to install everything. A new installation could be done to a clean machine or by removing existing software prior to installing it. Below is part of the script we use. Now we want … Continue reading