I have a nightly SQL Agent job that aggregates backup information from system views to power a Power BI dashboard that the DBA's review periodically for database backup failures. It is actually a PowerShell job that runs every night in parallel to collect the data from hundreds of instances (both SQL Server and Oracle). As … Continue reading SQL Server: Fix: Transaction (Process ID) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction
Necessity is the mother of new PowerShell code :-)! Today, I received an email request to get the list of all indexes in a given TableName but the requester did not specify the DatabaseName although the SQL InstanceName was specified. It would be too easy to ask the person for the DBName and script it … Continue reading PowerShell & SQL Server: Search & Find Indexes By SchemaName, TableName, IndexName Or ColumnName Across Instances/DB’s
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.
As we pipe stuff through a pipeline, we may have the need to add/remove/rename columns. These three operations are easy to do. Remove/Add/Rename Remove: Here we remove all attributes returned from Get-Process except Handles and ProcessName by not selecting them Alternatively, you could use the ExcludeProperty parameter if you have to select everything except a … Continue reading PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically
Nasty data-related errors: If you are looking to resolve one of these types of errors, you are in the right place. Please keep reading. ORA-01400: cannot insert NULL into (string) ORA-01401: inserted value too large for column ORA-02290: check constraint (string.string) violated ORA-02291: integrity constraint (string.string) violated - parent key not found ORA-02292: integrity constraint … Continue reading Oracle – Find A Needle In The Hay Stack – How To Pinpoint Data Errors Like “ORA-12899: value too large for column”