If you have been working with PowerShell and SQL Server for a while now, you know that it is not difficult to capture the PRINT statement output as VERBOSE output (which can then be redirected to a variable or file). You also know that it is not too difficult to run SQL in parallel against … Continue reading PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!
Month: March 2018
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.
Oracle: Clone An User With PL/SQL – Tablespace Quotas, Role Grants/Default Role, Object Grants And System Grants
As an Oracle DBA, you are very likely to get requests somewhat like this: Create an account for Sam Hill. The privileges should look exactly like Rob Nixon. If you are not into automating everything, your first instinct would be to fire-up an IDE like Toad or SQL Developer and script out the source user, … Continue reading Oracle: Clone An User With PL/SQL – Tablespace Quotas, Role Grants/Default Role, Object Grants And System Grants
SQL Jana 