Tag: Database Troubleshooting

SQL Server In-Place Upgrade Failed: Wait on the Database Engine Recovery Handle Failed

A few weeks ago I was performing an in-place upgrade from SQL Server 2014 to SQL Server 2017. I followed each and every pre-check before performing an in-place upgrade, but got an  error message at the end of the installation….

Read More >

How to fix SSIS deployment error “please create a master key”

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error: The error is succinct and direct to the point: “Please create a master key in the database or…

Read More >

RDP Issue – CredSSP encryption Oracle remediation

Introduction We have recently had some issues accessing a few client servers and found it is related to a Windows security update that was released earlier in May 2018. The problem is when you try to RDP to a server…

Read More >

Cursor: Pin S Wait on X in the Top 5 Wait Events

When a new cursor is given to Oracle to execute, it first needs to check if there is already such cursor in the Shared Pool, so we will not need to go to the expensive process of a hard parsing it again. To check this quickly, a hash value is generated from the text of the SQL .

Read More >