Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

This is one of those obscure errors that has no answer on the Web. I ran into this error trying to migrate an Oracle table to SQL Server (one of many). The issue seemed to be only with certain rows of this table as it migrated majority of the data without issues. Below is the … Continue reading Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

Advertisements

PowerShell: Resolve Partial File Paths To Full Paths

My Use-case: I am building a continuous integration tool using PowerShell for deploying scripts/database files (like .sql, .rdl, .xmla etc) to SQL Server/Oracle with all the bells and whistles (over a hundred PowerShell functions so far 🙂 ). It needed a file path resolution functionality that is somewhat flexible. I decided to share the file … Continue reading PowerShell: Resolve Partial File Paths To Full Paths

PowerShell: Resolve partial computer names, CNAME’s & IP Addresses to concrete Host name / IP

One can refer to a host by several means. Where I am at, we generously use CNAME's to point to host to insulate the applications from having to change when then hostname changes. For example, if the hostname for Dev SQL Server is ddxumapDEV, then we might have a cname entry that says "Dev-SQL". All … Continue reading PowerShell: Resolve partial computer names, CNAME’s & IP Addresses to concrete Host name / IP