Using named parameters is also a good time to strongly type cast them, that let's someone know real quick if they've entered a value that's not expected.

Adding the filter for file size should be straight forward, just pipe it through a Where-Object before the ForEach

Get-ChildItem "C:\Temp\*.csv" | Where-Object {$_.Length -gt 0}

Hmm.... SSIS is decent for a tool that's essentially included free with SQL Server(compared to say Oracle's nothing), but it's obviously not something that has a super high priority put...

That's interesting what you said, Brian, about you company not typically rolling back a release even with a bug, unless the bug is really egregious. Because we release seldom,...

The most important step is to understand the point at which you can actually roll back.  That might be anytime, for example if you've just changed some text or a...

Seems to be working fine for me?  Execute Process Task waits for the process to complete, then depending on the return code you can branch to a...

I don't disagree with this comment, but... There is a precedence constraint between this task and the unzip task. Why would the Execute Process task mark "successful"...

First step just add some simple file logging to the powershell script, just a hello at the start and good by eat the end to a temp file.  That will...

That makes sense, I was curious since we're using stock jira/confluence, so it's mostly just for an information store and communications not really process oriented.

On premise means we can limit access a lot better and we have control of the backups and the raw data (filesystem and database).  Plus on premise (Server) is...

And all this makes me wonder what value you're actually getting with on premise Jira vs just using the hosted option.

Well SQL server has decided it's cheaper to use another index to run the query then do the key lookup for whatever other fields it needs.  And clustered indexes are...

Well the #temp tables will be created with the database default collation so that will cause it to be out of sync.  Is there a reason you can't change the...

Well is the script trying to do joins between the two databases?

That's hilarious. I wonder if the salary is entry level.

Nah, this is basic knowledge people should be born with, so intern.